PREHOOK: query: describe srcpart PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe srcpart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string default value string default ds string hr string # Partition Information # col_name data_type comment ds string hr string PREHOOK: query: describe srcpart.key PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe srcpart.key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string from deserializer PREHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12') PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string default value string default ds string hr string # Partition Information # col_name data_type comment ds string hr string PREHOOK: query: describe `srcpart` PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe `srcpart` POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string default value string default ds string hr string # Partition Information # col_name data_type comment ds string hr string PREHOOK: query: describe `srcpart`.`key` PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe `srcpart`.`key` POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string from deserializer PREHOOK: query: describe `srcpart` PARTITION(ds='2008-04-08', hr='12') PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe `srcpart` PARTITION(ds='2008-04-08', hr='12') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string default value string default ds string hr string # Partition Information # col_name data_type comment ds string hr string PREHOOK: query: describe extended srcpart PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe extended srcpart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string default value string default ds string hr string # Partition Information # col_name data_type comment ds string hr string #### A masked pattern was here #### PREHOOK: query: describe extended srcpart.key PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe extended srcpart.key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string from deserializer PREHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12') PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string default value string default ds string hr string # Partition Information # col_name data_type comment ds string hr string #### A masked pattern was here #### PREHOOK: query: describe extended `srcpart` PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe extended `srcpart` POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string default value string default ds string hr string # Partition Information # col_name data_type comment ds string hr string #### A masked pattern was here #### PREHOOK: query: describe extended `srcpart`.`key` PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe extended `srcpart`.`key` POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string from deserializer PREHOOK: query: describe extended `srcpart` PARTITION(ds='2008-04-08', hr='12') PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe extended `srcpart` PARTITION(ds='2008-04-08', hr='12') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart key string default value string default ds string hr string # Partition Information # col_name data_type comment ds string hr string #### A masked pattern was here #### PREHOOK: query: describe formatted srcpart PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe formatted srcpart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart # col_name data_type comment key string default value string default # Partition Information # col_name data_type comment ds string hr string # Detailed Table Information Database: default #### A masked pattern was here #### Protect Mode: None Retention: 0 #### A masked pattern was here #### Table Type: MANAGED_TABLE Table Parameters: #### A masked pattern was here #### # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe InputFormat: org.apache.hadoop.mapred.TextInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 PREHOOK: query: describe formatted srcpart.key PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe formatted srcpart.key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart # col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment key string from deserializer PREHOOK: query: describe formatted srcpart PARTITION(ds='2008-04-08', hr='12') PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe formatted srcpart PARTITION(ds='2008-04-08', hr='12') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart # col_name data_type comment key string default value string default # Partition Information # col_name data_type comment ds string hr string # Detailed Partition Information Partition Value: [2008-04-08, 12] Database: default Table: srcpart #### A masked pattern was here #### Protect Mode: None #### A masked pattern was here #### Partition Parameters: COLUMN_STATS_ACCURATE true numFiles 1 numRows 500 rawDataSize 5312 totalSize 5812 #### A masked pattern was here #### # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe InputFormat: org.apache.hadoop.mapred.TextInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 PREHOOK: query: describe formatted `srcpart` PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe formatted `srcpart` POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart # col_name data_type comment key string default value string default # Partition Information # col_name data_type comment ds string hr string # Detailed Table Information Database: default #### A masked pattern was here #### Protect Mode: None Retention: 0 #### A masked pattern was here #### Table Type: MANAGED_TABLE Table Parameters: #### A masked pattern was here #### # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe InputFormat: org.apache.hadoop.mapred.TextInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 PREHOOK: query: describe formatted `srcpart`.`key` PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe formatted `srcpart`.`key` POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart # col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment key string from deserializer PREHOOK: query: describe formatted `srcpart` PARTITION(ds='2008-04-08', hr='12') PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart POSTHOOK: query: describe formatted `srcpart` PARTITION(ds='2008-04-08', hr='12') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart # col_name data_type comment key string default value string default # Partition Information # col_name data_type comment ds string hr string # Detailed Partition Information Partition Value: [2008-04-08, 12] Database: default Table: srcpart #### A masked pattern was here #### Protect Mode: None #### A masked pattern was here #### Partition Parameters: COLUMN_STATS_ACCURATE true numFiles 1 numRows 500 rawDataSize 5312 totalSize 5812 #### A masked pattern was here #### # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe InputFormat: org.apache.hadoop.mapred.TextInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 PREHOOK: query: create table srcpart_serdeprops like srcpart PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@srcpart_serdeprops POSTHOOK: query: create table srcpart_serdeprops like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@srcpart_serdeprops PREHOOK: query: alter table srcpart_serdeprops set serdeproperties('xyz'='0') PREHOOK: type: ALTERTABLE_SERDEPROPERTIES PREHOOK: Input: default@srcpart_serdeprops PREHOOK: Output: default@srcpart_serdeprops POSTHOOK: query: alter table srcpart_serdeprops set serdeproperties('xyz'='0') POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES POSTHOOK: Input: default@srcpart_serdeprops POSTHOOK: Output: default@srcpart_serdeprops PREHOOK: query: alter table srcpart_serdeprops set serdeproperties('pqrs'='1') PREHOOK: type: ALTERTABLE_SERDEPROPERTIES PREHOOK: Input: default@srcpart_serdeprops PREHOOK: Output: default@srcpart_serdeprops POSTHOOK: query: alter table srcpart_serdeprops set serdeproperties('pqrs'='1') POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES POSTHOOK: Input: default@srcpart_serdeprops POSTHOOK: Output: default@srcpart_serdeprops PREHOOK: query: alter table srcpart_serdeprops set serdeproperties('abcd'='2') PREHOOK: type: ALTERTABLE_SERDEPROPERTIES PREHOOK: Input: default@srcpart_serdeprops PREHOOK: Output: default@srcpart_serdeprops POSTHOOK: query: alter table srcpart_serdeprops set serdeproperties('abcd'='2') POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES POSTHOOK: Input: default@srcpart_serdeprops POSTHOOK: Output: default@srcpart_serdeprops PREHOOK: query: alter table srcpart_serdeprops set serdeproperties('A1234'='3') PREHOOK: type: ALTERTABLE_SERDEPROPERTIES PREHOOK: Input: default@srcpart_serdeprops PREHOOK: Output: default@srcpart_serdeprops POSTHOOK: query: alter table srcpart_serdeprops set serdeproperties('A1234'='3') POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES POSTHOOK: Input: default@srcpart_serdeprops POSTHOOK: Output: default@srcpart_serdeprops PREHOOK: query: describe formatted srcpart_serdeprops PREHOOK: type: DESCTABLE PREHOOK: Input: default@srcpart_serdeprops POSTHOOK: query: describe formatted srcpart_serdeprops POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@srcpart_serdeprops # col_name data_type comment key string default value string default # Partition Information # col_name data_type comment ds string hr string # Detailed Table Information Database: default #### A masked pattern was here #### Protect Mode: None Retention: 0 #### A masked pattern was here #### Table Type: MANAGED_TABLE Table Parameters: #### A masked pattern was here #### # Storage Information SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe InputFormat: org.apache.hadoop.mapred.TextInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: A1234 3 abcd 2 pqrs 1 serialization.format 1 xyz 0 PREHOOK: query: drop table srcpart_serdeprops PREHOOK: type: DROPTABLE PREHOOK: Input: default@srcpart_serdeprops PREHOOK: Output: default@srcpart_serdeprops POSTHOOK: query: drop table srcpart_serdeprops POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@srcpart_serdeprops POSTHOOK: Output: default@srcpart_serdeprops