PREHOOK: query: describe srcpart PREHOOK: type: DESCTABLE POSTHOOK: query: describe srcpart POSTHOOK: type: DESCTABLE key string default value string default ds string None hr string None # Partition Information # col_name data_type comment ds string None hr string None PREHOOK: query: describe srcpart.key PREHOOK: type: DESCTABLE POSTHOOK: query: describe srcpart.key POSTHOOK: type: DESCTABLE key string from deserializer PREHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12') PREHOOK: type: DESCTABLE POSTHOOK: query: describe srcpart PARTITION(ds='2008-04-08', hr='12') POSTHOOK: type: DESCTABLE key string default value string default ds string None hr string None # Partition Information # col_name data_type comment ds string None hr string None PREHOOK: query: describe extended srcpart PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended srcpart POSTHOOK: type: DESCTABLE key string default value string default ds string None hr string None # Partition Information # col_name data_type comment ds string None hr string None #### A masked pattern was here #### PREHOOK: query: describe extended srcpart.key PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended srcpart.key POSTHOOK: type: DESCTABLE key string from deserializer PREHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12') PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended srcpart PARTITION(ds='2008-04-08', hr='12') POSTHOOK: type: DESCTABLE key string default value string default ds string None hr string None # Partition Information # col_name data_type comment ds string None hr string None #### A masked pattern was here #### PREHOOK: query: describe formatted srcpart PREHOOK: type: DESCTABLE POSTHOOK: query: describe formatted srcpart POSTHOOK: type: DESCTABLE # col_name data_type comment key string default value string default # Partition Information # col_name data_type comment ds string None hr string None # 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: numFiles 4 numPartitions 4 numRows 0 rawDataSize 0 totalSize 23248 #### 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 POSTHOOK: query: describe formatted srcpart.key POSTHOOK: type: DESCTABLE # col_name data_type comment key string from deserializer PREHOOK: query: describe formatted srcpart PARTITION(ds='2008-04-08', hr='12') PREHOOK: type: DESCTABLE POSTHOOK: query: describe formatted srcpart PARTITION(ds='2008-04-08', hr='12') POSTHOOK: type: DESCTABLE # col_name data_type comment key string default value string default # Partition Information # col_name data_type comment ds string None hr string None # 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: numFiles 1 numRows 0 rawDataSize 0 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 POSTHOOK: query: create table srcpart_serdeprops like srcpart POSTHOOK: type: CREATETABLE 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 POSTHOOK: query: describe formatted srcpart_serdeprops POSTHOOK: type: DESCTABLE # col_name data_type comment key string default value string default # Partition Information # col_name data_type comment ds string None hr string None # 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