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