PREHOOK: query: CREATE TABLE list_bucket_single (key STRING, value STRING) SKEWED BY (key) ON ('1','5','6') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@list_bucket_single POSTHOOK: query: CREATE TABLE list_bucket_single (key STRING, value STRING) SKEWED BY (key) ON ('1','5','6') POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@list_bucket_single PREHOOK: query: CREATE TABLE list_bucket_single_2 (key STRING, value STRING) SKEWED BY (key) ON ((1),(5),(6)) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@list_bucket_single_2 POSTHOOK: query: CREATE TABLE list_bucket_single_2 (key STRING, value STRING) SKEWED BY (key) ON ((1),(5),(6)) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@list_bucket_single_2 PREHOOK: query: CREATE TABLE list_bucket_multiple (col1 STRING, col2 int, col3 STRING) SKEWED BY (col1, col2) ON (('s1',1), ('s3',3), ('s13',13), ('s78',78)) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@list_bucket_multiple POSTHOOK: query: CREATE TABLE list_bucket_multiple (col1 STRING, col2 int, col3 STRING) SKEWED BY (col1, col2) ON (('s1',1), ('s3',3), ('s13',13), ('s78',78)) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@list_bucket_multiple PREHOOK: query: describe formatted list_bucket_single_2 PREHOOK: type: DESCTABLE PREHOOK: Input: default@list_bucket_single_2 POSTHOOK: query: describe formatted list_bucket_single_2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucket_single_2 # col_name data_type comment key string value 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: [] Skewed Columns: [key] Skewed Values: [[1], [5], [6]] Storage Desc Params: serialization.format 1 PREHOOK: query: describe formatted list_bucket_single PREHOOK: type: DESCTABLE PREHOOK: Input: default@list_bucket_single POSTHOOK: query: describe formatted list_bucket_single POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucket_single # col_name data_type comment key string value 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: [] Skewed Columns: [key] Skewed Values: [[1], [5], [6]] Storage Desc Params: serialization.format 1 PREHOOK: query: describe formatted list_bucket_multiple PREHOOK: type: DESCTABLE PREHOOK: Input: default@list_bucket_multiple POSTHOOK: query: describe formatted list_bucket_multiple POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucket_multiple # col_name data_type comment col1 string col2 int col3 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: [] Skewed Columns: [col1, col2] Skewed Values: [[s1, 1], [s3, 3], [s13, 13], [s78, 78]] Storage Desc Params: serialization.format 1 PREHOOK: query: drop table list_bucket_single PREHOOK: type: DROPTABLE PREHOOK: Input: default@list_bucket_single PREHOOK: Output: default@list_bucket_single POSTHOOK: query: drop table list_bucket_single POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@list_bucket_single POSTHOOK: Output: default@list_bucket_single PREHOOK: query: drop table list_bucket_multiple PREHOOK: type: DROPTABLE PREHOOK: Input: default@list_bucket_multiple PREHOOK: Output: default@list_bucket_multiple POSTHOOK: query: drop table list_bucket_multiple POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@list_bucket_multiple POSTHOOK: Output: default@list_bucket_multiple PREHOOK: query: drop table list_bucket_single_2 PREHOOK: type: DROPTABLE PREHOOK: Input: default@list_bucket_single_2 PREHOOK: Output: default@list_bucket_single_2 POSTHOOK: query: drop table list_bucket_single_2 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@list_bucket_single_2 POSTHOOK: Output: default@list_bucket_single_2