http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/analyze_tbl_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/analyze_tbl_part.q.out b/ql/src/test/results/clientpositive/analyze_tbl_part.q.out index a7a2220..0f38045 100644 --- a/ql/src/test/results/clientpositive/analyze_tbl_part.q.out +++ b/ql/src/test/results/clientpositive/analyze_tbl_part.q.out @@ -48,9 +48,18 @@ PREHOOK: Input: default@src_stat_part POSTHOOK: query: describe formatted src_stat_part PARTITION(partitionId=1) key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_stat_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -key string 0 16 1.72 3 HL from deserializer +col_name key +data_type string +min +max +num_nulls 0 +distinct_count 16 +avg_col_len 1.72 +max_col_len 3 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: ANALYZE TABLE src_stat_part partition (partitionId) COMPUTE STATISTICS for columns key, value PREHOOK: type: QUERY PREHOOK: Input: default@src_stat_part @@ -69,18 +78,36 @@ PREHOOK: Input: default@src_stat_part POSTHOOK: query: describe formatted src_stat_part PARTITION(partitionId=1) key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_stat_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -key string 0 16 1.72 3 HL from deserializer +col_name key +data_type string +min +max +num_nulls 0 +distinct_count 16 +avg_col_len 1.72 +max_col_len 3 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted src_stat_part PARTITION(partitionId=2) value PREHOOK: type: DESCTABLE PREHOOK: Input: default@src_stat_part POSTHOOK: query: describe formatted src_stat_part PARTITION(partitionId=2) value POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_stat_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -value string 0 19 4.92 7 HL from deserializer +col_name value +data_type string +min +max +num_nulls 0 +distinct_count 19 +avg_col_len 4.92 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: create table src_stat_string_part(key string, value string) partitioned by (partitionName string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/authorization_index.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/authorization_index.q.out b/ql/src/test/results/clientpositive/authorization_index.q.out index adc02ad..87486b3 100644 --- a/ql/src/test/results/clientpositive/authorization_index.q.out +++ b/ql/src/test/results/clientpositive/authorization_index.q.out @@ -20,7 +20,6 @@ POSTHOOK: query: desc formatted default__t1_t1_index__ POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@default__t1_t1_index__ # col_name data_type comment - a int _bucketname string _offsets array<bigint> http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/autoColumnStats_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/autoColumnStats_3.q.out b/ql/src/test/results/clientpositive/autoColumnStats_3.q.out index 2f70095..c6527a9 100644 --- a/ql/src/test/results/clientpositive/autoColumnStats_3.q.out +++ b/ql/src/test/results/clientpositive/autoColumnStats_3.q.out @@ -25,7 +25,6 @@ POSTHOOK: query: describe formatted src_multi1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_multi1 # col_name data_type comment - key string default value string default @@ -70,7 +69,6 @@ POSTHOOK: query: describe formatted src_multi1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_multi1 # col_name data_type comment - key string default value string default @@ -119,13 +117,11 @@ POSTHOOK: query: describe formatted nzhang_part14 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@nzhang_part14 # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -191,13 +187,11 @@ POSTHOOK: query: desc formatted nzhang_part14 partition(ds='1', hr='3') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@nzhang_part14 # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -241,13 +235,11 @@ POSTHOOK: query: desc formatted nzhang_part14 partition(ds='1', hr='3') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@nzhang_part14 # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -281,13 +273,11 @@ POSTHOOK: query: desc formatted nzhang_part14 partition(ds='2', hr='1') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@nzhang_part14 # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -351,13 +341,11 @@ POSTHOOK: query: desc formatted nzhang_part14 partition(ds='1', hr='3') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@nzhang_part14 # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -391,13 +379,11 @@ POSTHOOK: query: desc formatted nzhang_part14 partition(ds='2', hr='1') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@nzhang_part14 # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/autoColumnStats_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/autoColumnStats_4.q.out b/ql/src/test/results/clientpositive/autoColumnStats_4.q.out index 7a5f8b4..9155733 100644 --- a/ql/src/test/results/clientpositive/autoColumnStats_4.q.out +++ b/ql/src/test/results/clientpositive/autoColumnStats_4.q.out @@ -13,7 +13,6 @@ POSTHOOK: query: desc formatted acid_dtt POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@acid_dtt # col_name data_type comment - a int b varchar(128) @@ -187,7 +186,6 @@ POSTHOOK: query: desc formatted acid_dtt POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@acid_dtt # col_name data_type comment - a int b varchar(128) @@ -231,7 +229,6 @@ POSTHOOK: query: desc formatted acid_dtt POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@acid_dtt # col_name data_type comment - a int b varchar(128) http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/autoColumnStats_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/autoColumnStats_5.q.out b/ql/src/test/results/clientpositive/autoColumnStats_5.q.out index 1298d98..cc4d32b 100644 --- a/ql/src/test/results/clientpositive/autoColumnStats_5.q.out +++ b/ql/src/test/results/clientpositive/autoColumnStats_5.q.out @@ -154,13 +154,11 @@ POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@partitioned1 col_name data_type comment # col_name data_type comment - a int b string # Partition Information # col_name data_type comment - part int # Detailed Partition Information @@ -192,10 +190,19 @@ PREHOOK: Input: default@partitioned1 POSTHOOK: query: desc formatted partitioned1 partition(part=1) a POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@partitioned1 -col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitvector -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -a int 1 4 0 4 HL from deserializer +col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses bitvector comment +col_name a +data_type int +min 1 +max 4 +num_nulls 0 +distinct_count 4 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: alter table partitioned1 add columns(c int, d string) PREHOOK: type: ALTERTABLE_ADDCOLS PREHOOK: Input: default@partitioned1 @@ -212,13 +219,11 @@ POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@partitioned1 col_name data_type comment # col_name data_type comment - a int b string # Partition Information # col_name data_type comment - part int # Detailed Partition Information @@ -394,7 +399,6 @@ POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@partitioned1 col_name data_type comment # col_name data_type comment - a int b string c int @@ -402,7 +406,6 @@ d string # Partition Information # col_name data_type comment - part int # Detailed Partition Information @@ -434,10 +437,19 @@ PREHOOK: Input: default@partitioned1 POSTHOOK: query: desc formatted partitioned1 partition(part=2) c POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@partitioned1 -col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitvector -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -c int 10 40 0 4 HL from deserializer +col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses bitvector comment +col_name c +data_type int +min 10 +max 40 +num_nulls 0 +distinct_count 4 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: explain insert into table partitioned1 partition(part=1) values(5, 'new', 100, 'hundred'),(6, 'new', 200, 'two hundred') PREHOOK: type: QUERY POSTHOOK: query: explain insert into table partitioned1 partition(part=1) values(5, 'new', 100, 'hundred'),(6, 'new', 200, 'two hundred') @@ -588,13 +600,11 @@ POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@partitioned1 col_name data_type comment # col_name data_type comment - a int b string # Partition Information # col_name data_type comment - part int # Detailed Partition Information @@ -626,17 +636,35 @@ PREHOOK: Input: default@partitioned1 POSTHOOK: query: desc formatted partitioned1 partition(part=1) a POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@partitioned1 -col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitvector -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -a int 1 6 0 6 HL from deserializer +col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses bitvector comment +col_name a +data_type int +min 1 +max 6 +num_nulls 0 +distinct_count 6 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: desc formatted partitioned1 partition(part=1) c PREHOOK: type: DESCTABLE PREHOOK: Input: default@partitioned1 POSTHOOK: query: desc formatted partitioned1 partition(part=1) c POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@partitioned1 -col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitvector -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -c int 100 200 0 2 HL from deserializer +col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses bitvector comment +col_name c +data_type int +min 100 +max 200 +num_nulls 0 +distinct_count 2 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/autoColumnStats_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/autoColumnStats_8.q.out b/ql/src/test/results/clientpositive/autoColumnStats_8.q.out index c913d97..9d22aeb 100644 --- a/ql/src/test/results/clientpositive/autoColumnStats_8.q.out +++ b/ql/src/test/results/clientpositive/autoColumnStats_8.q.out @@ -29,7 +29,6 @@ hr string # Partition Information # col_name data_type comment - ds string hr string http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/autoColumnStats_9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/autoColumnStats_9.q.out b/ql/src/test/results/clientpositive/autoColumnStats_9.q.out index fda71e0..c6d12fa 100644 --- a/ql/src/test/results/clientpositive/autoColumnStats_9.q.out +++ b/ql/src/test/results/clientpositive/autoColumnStats_9.q.out @@ -216,7 +216,6 @@ POSTHOOK: query: desc formatted dest_j1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@dest_j1 # col_name data_type comment - key int value string @@ -250,9 +249,18 @@ PREHOOK: Input: default@dest_j1 POSTHOOK: query: desc formatted dest_j1 key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@dest_j1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -key int 0 498 0 309 HL from deserializer +col_name key +data_type int +min 0 +max 498 +num_nulls 0 +distinct_count 309 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}} PREHOOK: query: desc formatted dest_j1 value PREHOOK: type: DESCTABLE @@ -260,7 +268,16 @@ PREHOOK: Input: default@dest_j1 POSTHOOK: query: desc formatted dest_j1 value POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@dest_j1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -value string 0 309 6.834630350194552 7 HL from deserializer +col_name value +data_type string +min +max +num_nulls 0 +distinct_count 309 +avg_col_len 6.834630350194552 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}} http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/avro_add_column3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/avro_add_column3.q.out b/ql/src/test/results/clientpositive/avro_add_column3.q.out index 2c8bd20..aaacb1a 100644 --- a/ql/src/test/results/clientpositive/avro_add_column3.q.out +++ b/ql/src/test/results/clientpositive/avro_add_column3.q.out @@ -69,7 +69,6 @@ part int # Partition Information # col_name data_type comment - part int PREHOOK: query: SELECT * FROM doctors_copy PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/avro_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/avro_decimal.q.out b/ql/src/test/results/clientpositive/avro_decimal.q.out index a9ce51b..b093a22 100644 --- a/ql/src/test/results/clientpositive/avro_decimal.q.out +++ b/ql/src/test/results/clientpositive/avro_decimal.q.out @@ -32,9 +32,18 @@ PREHOOK: Input: default@dec POSTHOOK: query: DESC FORMATTED `dec` value POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@dec -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -value decimal(8,4) -12.25 234.79 0 10 HL from deserializer +col_name value +data_type decimal(8,4) +min -12.25 +max 234.79 +num_nulls 0 +distinct_count 10 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"value\":\"true\"}} PREHOOK: query: DROP TABLE IF EXISTS avro_dec PREHOOK: type: DROPTABLE http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/avro_decimal_native.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/avro_decimal_native.q.out b/ql/src/test/results/clientpositive/avro_decimal_native.q.out index 822882e..abf5937 100644 --- a/ql/src/test/results/clientpositive/avro_decimal_native.q.out +++ b/ql/src/test/results/clientpositive/avro_decimal_native.q.out @@ -36,9 +36,18 @@ PREHOOK: Input: default@dec POSTHOOK: query: DESC FORMATTED `dec` value POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@dec -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -value decimal(8,4) -12.25 234.79 0 10 HL from deserializer +col_name value +data_type decimal(8,4) +min -12.25 +max 234.79 +num_nulls 0 +distinct_count 10 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"value\":\"true\"}} PREHOOK: query: DROP TABLE IF EXISTS avro_dec PREHOOK: type: DROPTABLE http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out b/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out index ea0d7c1..7626a73 100644 --- a/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out +++ b/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out @@ -86,14 +86,12 @@ POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@episodes_partitioned col_name data_type comment # col_name data_type comment - title string episode title air_date string initial date doctor int main actor playing the Doctor in episode # Partition Information # col_name data_type comment - doctor_pt int # Detailed Table Information @@ -197,7 +195,6 @@ POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@episodes_partitioned col_name data_type comment # col_name data_type comment - title string episode title air_date string initial date doctor int main actor playing the Doctor in episode @@ -205,7 +202,6 @@ value int default value # Partition Information # col_name data_type comment - doctor_pt int # Detailed Table Information http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/beeline/escape_comments.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/beeline/escape_comments.q.out b/ql/src/test/results/clientpositive/beeline/escape_comments.q.out index aa26c57..9e17935 100644 --- a/ql/src/test/results/clientpositive/beeline/escape_comments.q.out +++ b/ql/src/test/results/clientpositive/beeline/escape_comments.q.out @@ -84,13 +84,11 @@ PREHOOK: Input: escape_comments_db@escape_comments_tbl1 POSTHOOK: query: describe formatted escape_comments_tbl1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: escape_comments_db@escape_comments_tbl1 -# col_name data_type comment - NULL NULL +# col_name data_type comment col1 string a\nb'; NULL NULL # Partition Information NULL NULL -# col_name data_type comment - NULL NULL +# col_name data_type comment p1 string a\nb NULL NULL # Detailed Table Information NULL NULL @@ -148,8 +146,7 @@ col1 string a\nb'; p1 string a\nb NULL NULL # Partition Information NULL NULL -# col_name data_type comment - NULL NULL +# col_name data_type comment p1 string a\nb PREHOOK: query: show create table escape_comments_view1 PREHOOK: type: SHOW_CREATETABLE @@ -164,8 +161,7 @@ PREHOOK: Input: escape_comments_db@escape_comments_view1 POSTHOOK: query: describe formatted escape_comments_view1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: escape_comments_db@escape_comments_view1 -# col_name data_type comment - NULL NULL +# col_name data_type comment col1 string a\nb NULL NULL # Detailed Table Information NULL NULL @@ -196,8 +192,6 @@ PREHOOK: type: SHOWINDEXES POSTHOOK: query: show formatted index on escape_comments_tbl1 POSTHOOK: type: SHOWINDEXES idx_name tab_name col_names idx_tab_name idx_type comment - NULL NULL NULL NULL NULL - NULL NULL NULL NULL NULL index2 escape_comments_tbl1 col1 escape_comments_db__escape_comments_tbl1_index2__ compact a\nb PREHOOK: query: drop database escape_comments_db cascade PREHOOK: type: DROPDATABASE http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/bitvector.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/bitvector.q.out b/ql/src/test/results/clientpositive/bitvector.q.out index 96550ce..1e0284f 100644 --- a/ql/src/test/results/clientpositive/bitvector.q.out +++ b/ql/src/test/results/clientpositive/bitvector.q.out @@ -4,7 +4,16 @@ PREHOOK: Input: default@src POSTHOOK: query: desc formatted src key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -key string 0 309 2.812 3 HL from deserializer +col_name key +data_type string +min +max +num_nulls 0 +distinct_count 309 +avg_col_len 2.812 +max_col_len 3 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}} http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/colstats_all_nulls.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/colstats_all_nulls.q.out b/ql/src/test/results/clientpositive/colstats_all_nulls.q.out index 9efab75..b56ad7f 100644 --- a/ql/src/test/results/clientpositive/colstats_all_nulls.q.out +++ b/ql/src/test/results/clientpositive/colstats_all_nulls.q.out @@ -41,9 +41,18 @@ PREHOOK: Input: default@all_nulls POSTHOOK: query: describe formatted all_nulls a POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@all_nulls -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -a bigint 0 0 5 1 HL from deserializer +col_name a +data_type bigint +min 0 +max 0 +num_nulls 5 +distinct_count 1 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"b\":\"true\",\"c\":\"true\"}} PREHOOK: query: describe formatted all_nulls b PREHOOK: type: DESCTABLE @@ -51,9 +60,18 @@ PREHOOK: Input: default@all_nulls POSTHOOK: query: describe formatted all_nulls b POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@all_nulls -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -b double 0.0 0.0 5 1 HL from deserializer +col_name b +data_type double +min 0.0 +max 0.0 +num_nulls 5 +distinct_count 1 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"b\":\"true\",\"c\":\"true\"}} PREHOOK: query: drop table all_nulls PREHOOK: type: DROPTABLE http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/columnStatsUpdateForStatsOptimizer_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/columnStatsUpdateForStatsOptimizer_2.q.out b/ql/src/test/results/clientpositive/columnStatsUpdateForStatsOptimizer_2.q.out index 4e430b3..0d78ea2 100644 --- a/ql/src/test/results/clientpositive/columnStatsUpdateForStatsOptimizer_2.q.out +++ b/ql/src/test/results/clientpositive/columnStatsUpdateForStatsOptimizer_2.q.out @@ -25,7 +25,6 @@ POSTHOOK: query: desc formatted calendar POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendar # col_name data_type comment - year int month int @@ -68,7 +67,6 @@ POSTHOOK: query: desc formatted calendar POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendar # col_name data_type comment - year int month int @@ -157,7 +155,6 @@ POSTHOOK: query: desc formatted calendar POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendar # col_name data_type comment - year1 int month int @@ -279,7 +276,6 @@ POSTHOOK: query: desc formatted calendar POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendar # col_name data_type comment - year1 int month int http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/column_names_with_leading_and_trailing_spaces.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/column_names_with_leading_and_trailing_spaces.q.out b/ql/src/test/results/clientpositive/column_names_with_leading_and_trailing_spaces.q.out index 345434f..2b87d50 100644 --- a/ql/src/test/results/clientpositive/column_names_with_leading_and_trailing_spaces.q.out +++ b/ql/src/test/results/clientpositive/column_names_with_leading_and_trailing_spaces.q.out @@ -13,7 +13,6 @@ POSTHOOK: query: desc formatted space POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@space # col_name data_type comment - left string middle string right string @@ -48,9 +47,18 @@ PREHOOK: Input: default@space POSTHOOK: query: desc formatted space ` left` POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@space -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - - left string from deserializer +col_name left +data_type string +min +max +num_nulls +distinct_count +avg_col_len +max_col_len +num_trues +num_falses +bitVector +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\" left\":\"true\",\" middle \":\"true\",\"right \":\"true\"}} PREHOOK: query: insert into space values ("1", "2", "3") PREHOOK: type: QUERY @@ -67,9 +75,18 @@ PREHOOK: Input: default@space POSTHOOK: query: desc formatted space ` left` POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@space -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - - left string 0 1 1.0 1 HL from deserializer +col_name left +data_type string +min +max +num_nulls 0 +distinct_count 1 +avg_col_len 1.0 +max_col_len 1 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\" left\":\"true\",\" middle \":\"true\",\"right \":\"true\"}} PREHOOK: query: select * from space PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/column_pruner_multiple_children.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/column_pruner_multiple_children.q.out b/ql/src/test/results/clientpositive/column_pruner_multiple_children.q.out index c480422..66ff79f 100644 --- a/ql/src/test/results/clientpositive/column_pruner_multiple_children.q.out +++ b/ql/src/test/results/clientpositive/column_pruner_multiple_children.q.out @@ -139,7 +139,6 @@ POSTHOOK: query: desc formatted DEST1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@dest1 # col_name data_type comment - key int value string @@ -173,9 +172,18 @@ PREHOOK: Input: default@dest1 POSTHOOK: query: desc formatted DEST1 key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@dest1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -key int 10 10 0 1 HL from deserializer +col_name key +data_type int +min 10 +max 10 +num_nulls 0 +distinct_count 1 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}} PREHOOK: query: desc formatted DEST1 value PREHOOK: type: DESCTABLE @@ -183,7 +191,16 @@ PREHOOK: Input: default@dest1 POSTHOOK: query: desc formatted DEST1 value POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@dest1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -value string 0 1 4.0 4 HL from deserializer +col_name value +data_type string +min +max +num_nulls 0 +distinct_count 1 +avg_col_len 4.0 +max_col_len 4 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}} http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/columnstats_infinity.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/columnstats_infinity.q.out b/ql/src/test/results/clientpositive/columnstats_infinity.q.out index 23ca486..777345c 100644 --- a/ql/src/test/results/clientpositive/columnstats_infinity.q.out +++ b/ql/src/test/results/clientpositive/columnstats_infinity.q.out @@ -72,7 +72,6 @@ POSTHOOK: query: desc formatted table_change_numeric_group_string_group_floating POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string_group # col_name data_type comment - insert_num int c1 decimal(38,18) c2 float @@ -130,7 +129,6 @@ POSTHOOK: query: desc formatted table_change_numeric_group_string_group_floating POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string_group # col_name data_type comment - insert_num int c1 decimal(38,18) c2 float @@ -250,7 +248,6 @@ POSTHOOK: query: desc formatted table_change_numeric_group_string_group_floating POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string_group # col_name data_type comment - insert_num int c1 decimal(38,18) c2 float http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/columnstats_partlvl.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/columnstats_partlvl.q.out b/ql/src/test/results/clientpositive/columnstats_partlvl.q.out index 1e1c55d..08f1709 100644 --- a/ql/src/test/results/clientpositive/columnstats_partlvl.q.out +++ b/ql/src/test/results/clientpositive/columnstats_partlvl.q.out @@ -509,18 +509,36 @@ PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted Employee_Part partition (employeeSalary=2000.0) employeeID POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeID int 16 34 1 12 HL from deserializer +col_name employeeID +data_type int +min 16 +max 34 +num_nulls 1 +distinct_count 12 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted Employee_Part partition (employeeSalary=2000.0) employeeName PREHOOK: type: DESCTABLE PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted Employee_Part partition (employeeSalary=2000.0) employeeName POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeName string 1 12 4.3076923076923075 6 HL from deserializer +col_name employeeName +data_type string +min +max +num_nulls 1 +distinct_count 12 +avg_col_len 4.3076923076923075 +max_col_len 6 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: explain analyze table Employee_Part compute statistics for columns PREHOOK: type: QUERY @@ -598,18 +616,36 @@ PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted Employee_Part partition(employeeSalary=2000.0) employeeID POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeID int 16 34 1 12 HL from deserializer +col_name employeeID +data_type int +min 16 +max 34 +num_nulls 1 +distinct_count 12 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted Employee_Part partition(employeeSalary=4000.0) employeeID PREHOOK: type: DESCTABLE PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted Employee_Part partition(employeeSalary=4000.0) employeeID POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeID int 16 34 1 12 HL from deserializer +col_name employeeID +data_type int +min 16 +max 34 +num_nulls 1 +distinct_count 12 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: explain analyze table Employee_Part compute statistics for columns PREHOOK: type: QUERY @@ -679,9 +715,18 @@ PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted Employee_Part employeeID POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeID int 16 34 2 12 HL from deserializer +col_name employeeID +data_type int +min 16 +max 34 +num_nulls 2 +distinct_count 12 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"employeeid\":\"true\",\"employeename\":\"true\"}} PREHOOK: query: create database if not exists dummydb PREHOOK: type: CREATEDATABASE @@ -711,9 +756,18 @@ PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted default.Employee_Part partition (employeeSalary=2000.0) employeeID POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeID int 16 34 1 12 HL from deserializer +col_name employeeID +data_type int +min 16 +max 34 +num_nulls 1 +distinct_count 12 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"employeeid\":\"true\",\"employeename\":\"true\"}} PREHOOK: query: analyze table default.Employee_Part compute statistics for columns PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out b/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out index 0739b49..a626597 100644 --- a/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out +++ b/ql/src/test/results/clientpositive/columnstats_partlvl_dp.q.out @@ -141,9 +141,18 @@ PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted Employee_Part partition (employeeSalary='4000.0', country='USA') employeeName POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeName string 0 7 5.142857142857143 6 HL from deserializer +col_name employeeName +data_type string +min +max +num_nulls 0 +distinct_count 7 +avg_col_len 5.142857142857143 +max_col_len 6 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: explain analyze table Employee_Part partition (employeeSalary='2000.0') compute statistics for columns employeeID PREHOOK: type: QUERY @@ -221,18 +230,36 @@ PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted Employee_Part partition (employeeSalary='2000.0', country='USA') employeeID POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeID int 16 34 1 12 HL from deserializer +col_name employeeID +data_type int +min 16 +max 34 +num_nulls 1 +distinct_count 12 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted Employee_Part partition (employeeSalary='2000.0', country='UK') employeeID PREHOOK: type: DESCTABLE PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted Employee_Part partition (employeeSalary='2000.0', country='UK') employeeID POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeID int 16 31 0 7 HL from deserializer +col_name employeeID +data_type int +min 16 +max 31 +num_nulls 0 +distinct_count 7 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: explain analyze table Employee_Part partition (employeeSalary) compute statistics for columns employeeID PREHOOK: type: QUERY @@ -318,9 +345,18 @@ PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted Employee_Part partition (employeeSalary='3000.0', country='UK') employeeID POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeID int 16 34 1 12 HL from deserializer +col_name employeeID +data_type int +min 16 +max 34 +num_nulls 1 +distinct_count 12 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: explain analyze table Employee_Part partition (employeeSalary,country) compute statistics for columns PREHOOK: type: QUERY @@ -406,9 +442,18 @@ PREHOOK: Input: default@employee_part POSTHOOK: query: describe formatted Employee_Part partition (employeeSalary='3500.0', country='UK') employeeName POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee_part -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeName string 0 12 5.142857142857143 6 HL from deserializer +col_name employeeName +data_type string +min +max +num_nulls 0 +distinct_count 12 +avg_col_len 5.142857142857143 +max_col_len 6 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: drop table Employee PREHOOK: type: DROPTABLE POSTHOOK: query: drop table Employee @@ -481,9 +526,18 @@ PREHOOK: Input: default@employee POSTHOOK: query: describe formatted Employee partition (employeeSalary='3500.0', country='UK') employeeName POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeName string 0 12 5.142857142857143 6 HL from deserializer +col_name employeeName +data_type string +min +max +num_nulls 0 +distinct_count 12 +avg_col_len 5.142857142857143 +max_col_len 6 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/employee2.dat" INTO TABLE Employee partition(employeeSalary='3000.0', country='USA') PREHOOK: type: LOAD #### A masked pattern was here #### @@ -528,9 +582,18 @@ PREHOOK: Input: default@employee POSTHOOK: query: describe formatted Employee partition (employeeSalary='3000.0', country='USA') employeeName POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeName string 0 12 5.142857142857143 6 HL from deserializer +col_name employeeName +data_type string +min +max +num_nulls 0 +distinct_count 12 +avg_col_len 5.142857142857143 +max_col_len 6 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: alter table Employee add columns (c int ,d string) PREHOOK: type: ALTERTABLE_ADDCOLS PREHOOK: Input: default@employee @@ -564,24 +627,51 @@ PREHOOK: Input: default@employee POSTHOOK: query: describe formatted Employee partition (employeeSalary='6000.0', country='UK') employeeName POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -employeeName string 0 9 4.777777777777778 6 HL from deserializer +col_name employeeName +data_type string +min +max +num_nulls 0 +distinct_count 9 +avg_col_len 4.777777777777778 +max_col_len 6 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted Employee partition (employeeSalary='6000.0', country='UK') c PREHOOK: type: DESCTABLE PREHOOK: Input: default@employee POSTHOOK: query: describe formatted Employee partition (employeeSalary='6000.0', country='UK') c POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -c int 2000 4000 0 3 HL from deserializer +col_name c +data_type int +min 2000 +max 4000 +num_nulls 0 +distinct_count 3 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted Employee partition (employeeSalary='6000.0', country='UK') d PREHOOK: type: DESCTABLE PREHOOK: Input: default@employee POSTHOOK: query: describe formatted Employee partition (employeeSalary='6000.0', country='UK') d POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@employee -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -d string 0 2 2.4444444444444446 3 HL from deserializer +col_name d +data_type string +min +max +num_nulls 0 +distinct_count 2 +avg_col_len 2.4444444444444446 +max_col_len 3 +num_trues +num_falses +bitVector HL +comment from deserializer