http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out index 71d7e16..23ec5f4 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out @@ -224,13 +224,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -269,13 +267,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # 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/list_bucket_dml_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out index 8e20ff1..1e01ca3 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out @@ -238,13 +238,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -281,13 +279,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -665,13 +661,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -708,13 +702,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # 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/list_bucket_dml_7.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out index 58bf240..eea69ff 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out @@ -238,13 +238,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -281,13 +279,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -665,13 +661,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -708,13 +702,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # 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/list_bucket_dml_8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out index b38d332..0215f5d 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out @@ -238,13 +238,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -281,13 +279,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -334,13 +330,11 @@ POSTHOOK: query: desc formatted list_bucketing_dynamic_part partition (ds='2008- POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_dynamic_part # 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/list_bucket_dml_9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out b/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out index 624e3ac..fdc7a3e 100644 --- a/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out @@ -234,13 +234,11 @@ POSTHOOK: query: desc formatted list_bucketing_static_part partition (ds='2008-0 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_static_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -608,13 +606,11 @@ POSTHOOK: query: desc formatted list_bucketing_static_part partition (ds='2008-0 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@list_bucketing_static_part # 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/list_bucket_query_multiskew_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out index 17c7afe..a1f225c 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_1.q.out @@ -31,13 +31,11 @@ POSTHOOK: query: describe formatted fact_daily PARTITION (ds = '1', hr='4') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@fact_daily # 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/list_bucket_query_multiskew_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out index afba625..0ad2ff5 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out @@ -31,13 +31,11 @@ POSTHOOK: query: describe formatted fact_daily PARTITION (ds = '1', hr='4') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@fact_daily # 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/list_bucket_query_multiskew_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out index 3ff221d..02fc314 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out @@ -27,13 +27,11 @@ POSTHOOK: query: describe formatted fact_daily PARTITION (ds = '1', hr='1') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@fact_daily # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -87,13 +85,11 @@ POSTHOOK: query: describe formatted fact_daily PARTITION (ds = '1', hr='2') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@fact_daily # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - ds string hr string @@ -152,13 +148,11 @@ POSTHOOK: query: describe formatted fact_daily PARTITION (ds = '1', hr='3') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@fact_daily # 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/list_bucket_query_oneskew_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out index fd87cf0..1076df5 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out @@ -85,12 +85,10 @@ POSTHOOK: query: describe formatted fact_daily PARTITION (ds = '1') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@fact_daily # col_name data_type comment - x int # Partition Information # col_name data_type comment - ds string # Detailed Partition Information http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out index 37f5484..876434f 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out @@ -87,13 +87,11 @@ POSTHOOK: query: describe formatted fact_daily PARTITION (ds = '1') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@fact_daily # col_name data_type comment - x int y string # Partition Information # col_name data_type comment - ds string # Detailed Partition Information http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out index e3b6513..9d30759 100644 --- a/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out +++ b/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out @@ -102,14 +102,12 @@ POSTHOOK: query: describe formatted fact_daily PARTITION (ds = '1') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@fact_daily # col_name data_type comment - x int y string z string # Partition Information # col_name data_type comment - ds string # Detailed Partition Information http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/alter_merge_2_orc.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/alter_merge_2_orc.q.out b/ql/src/test/results/clientpositive/llap/alter_merge_2_orc.q.out index caa41b2..0829057 100644 --- a/ql/src/test/results/clientpositive/llap/alter_merge_2_orc.q.out +++ b/ql/src/test/results/clientpositive/llap/alter_merge_2_orc.q.out @@ -26,7 +26,6 @@ ts string # Partition Information # col_name data_type comment - ds string ts string http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/alter_merge_stats_orc.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/alter_merge_stats_orc.q.out b/ql/src/test/results/clientpositive/llap/alter_merge_stats_orc.q.out index 0d5ba01..2b069ec 100644 --- a/ql/src/test/results/clientpositive/llap/alter_merge_stats_orc.q.out +++ b/ql/src/test/results/clientpositive/llap/alter_merge_stats_orc.q.out @@ -78,7 +78,6 @@ POSTHOOK: query: desc formatted src_orc_merge_test_stat POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_orc_merge_test_stat # col_name data_type comment - key int value string @@ -129,7 +128,6 @@ POSTHOOK: query: desc formatted src_orc_merge_test_stat POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_orc_merge_test_stat # col_name data_type comment - key int value string @@ -226,13 +224,11 @@ POSTHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_orc_merge_test_part_stat # col_name data_type comment - key int value string # Partition Information # col_name data_type comment - ds string # Detailed Partition Information @@ -275,13 +271,11 @@ POSTHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_orc_merge_test_part_stat # col_name data_type comment - key int value string # Partition Information # col_name data_type comment - ds string # Detailed Partition Information @@ -332,13 +326,11 @@ POSTHOOK: query: desc formatted src_orc_merge_test_part_stat partition (ds='2011 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_orc_merge_test_part_stat # col_name data_type comment - key int value string # Partition Information # col_name data_type comment - ds string # Detailed Partition Information http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out b/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out index 6369dd3..9fbc404 100644 --- a/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out +++ b/ql/src/test/results/clientpositive/llap/autoColumnStats_1.q.out @@ -47,7 +47,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 @@ -124,7 +123,6 @@ POSTHOOK: query: describe formatted a POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@a # col_name data_type comment - key string default value string default @@ -159,7 +157,6 @@ POSTHOOK: query: describe formatted b POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@b # col_name data_type comment - key string default value string default @@ -244,7 +241,6 @@ POSTHOOK: query: describe formatted a POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@a # col_name data_type comment - key string default value string default @@ -279,7 +275,6 @@ POSTHOOK: query: describe formatted b POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@b # col_name data_type comment - key string default value string default @@ -338,7 +333,6 @@ POSTHOOK: query: describe formatted src_multi2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_multi2 # col_name data_type comment - key string default value string default @@ -502,12 +496,10 @@ POSTHOOK: query: describe formatted alter5 partition (dt='a') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@alter5 # col_name data_type comment - col1 string # Partition Information # col_name data_type comment - dt string # Detailed Partition Information @@ -544,12 +536,10 @@ POSTHOOK: query: describe formatted alter5 partition (dt='a') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@alter5 # col_name data_type comment - col1 string # Partition Information # col_name data_type comment - dt string # Detailed Partition Information @@ -625,13 +615,11 @@ POSTHOOK: query: describe formatted src_stat_part PARTITION(partitionId=1) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_stat_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - partitionid int # Detailed Partition Information @@ -676,13 +664,11 @@ POSTHOOK: query: describe formatted src_stat_part PARTITION(partitionId=2) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_stat_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - partitionid int # Detailed Partition Information @@ -815,13 +801,11 @@ POSTHOOK: query: describe formatted tab_part partition (ds='2008-04-08') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@tab_part # col_name data_type comment - key int value string # Partition Information # col_name data_type comment - ds string # Detailed Partition Information @@ -876,13 +860,11 @@ POSTHOOK: query: describe formatted tab partition (ds='2008-04-08') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@tab # col_name data_type comment - key int value string # Partition Information # col_name data_type comment - ds string # Detailed Partition Information @@ -933,13 +915,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 @@ -1005,13 +985,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 @@ -1068,13 +1046,11 @@ POSTHOOK: query: desc formatted nzhang_part14 PARTITION(ds='2010-03-03', hr='12' 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 @@ -1149,13 +1125,11 @@ POSTHOOK: query: desc formatted nzhang_part14 PARTITION(ds='2010-03-03', hr='12' 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/llap/autoColumnStats_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out b/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out index a61eafa..104c25f 100644 --- a/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out +++ b/ql/src/test/results/clientpositive/llap/autoColumnStats_2.q.out @@ -47,7 +47,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 @@ -123,9 +122,18 @@ PREHOOK: Input: default@a POSTHOOK: query: describe formatted a key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@a -# 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\"}} PREHOOK: query: describe formatted b key PREHOOK: type: DESCTABLE @@ -133,9 +141,18 @@ PREHOOK: Input: default@b POSTHOOK: query: describe formatted b key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@b -# 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\"}} PREHOOK: query: from src insert overwrite table a select * @@ -162,7 +179,6 @@ POSTHOOK: query: describe formatted a POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@a # col_name data_type comment - key string default value string default @@ -197,7 +213,6 @@ POSTHOOK: query: describe formatted b POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@b # col_name data_type comment - key string default value string default @@ -231,9 +246,18 @@ PREHOOK: Input: default@b POSTHOOK: query: describe formatted b key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@b -# 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\"}} PREHOOK: query: describe formatted b value PREHOOK: type: DESCTABLE @@ -241,9 +265,18 @@ PREHOOK: Input: default@b POSTHOOK: query: describe formatted b value POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@b -# 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.812 7 HL from deserializer +col_name value +data_type string +min +max +num_nulls 0 +distinct_count 309 +avg_col_len 6.812 +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\"}} PREHOOK: query: insert into table b select NULL, NULL from src limit 10 PREHOOK: type: QUERY @@ -261,9 +294,18 @@ PREHOOK: Input: default@b POSTHOOK: query: describe formatted b key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@b -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -key string 10 309 2.812 3 HL from deserializer +col_name key +data_type string +min +max +num_nulls 10 +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\"}} PREHOOK: query: describe formatted b value PREHOOK: type: DESCTABLE @@ -271,9 +313,18 @@ PREHOOK: Input: default@b POSTHOOK: query: describe formatted b value POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@b -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -value string 10 309 6.812 7 HL from deserializer +col_name value +data_type string +min +max +num_nulls 10 +distinct_count 309 +avg_col_len 6.812 +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\"}} PREHOOK: query: insert into table b(value) select key+100000 from src limit 10 PREHOOK: type: QUERY @@ -291,9 +342,18 @@ PREHOOK: Input: default@b POSTHOOK: query: describe formatted b key POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@b -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -key string 20 309 2.812 3 HL from deserializer +col_name key +data_type string +min +max +num_nulls 20 +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\"}} PREHOOK: query: describe formatted b value PREHOOK: type: DESCTABLE @@ -301,9 +361,18 @@ PREHOOK: Input: default@b POSTHOOK: query: describe formatted b value POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@b -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -value string 10 319 8.0 8 HL from deserializer +col_name value +data_type string +min +max +num_nulls 10 +distinct_count 319 +avg_col_len 8.0 +max_col_len 8 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}} PREHOOK: query: drop table src_multi2 PREHOOK: type: DROPTABLE @@ -336,7 +405,6 @@ POSTHOOK: query: describe formatted src_multi2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_multi2 # col_name data_type comment - key string default value string default @@ -502,12 +570,10 @@ POSTHOOK: query: describe formatted alter5 partition (dt='a') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@alter5 # col_name data_type comment - col1 string # Partition Information # col_name data_type comment - dt string # Detailed Partition Information @@ -549,12 +615,10 @@ POSTHOOK: query: describe formatted alter5 partition (dt='a') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@alter5 # col_name data_type comment - col1 string # Partition Information # col_name data_type comment - dt string # Detailed Partition Information @@ -631,12 +695,10 @@ POSTHOOK: query: describe formatted alter5 partition (dt='a') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@alter5 # col_name data_type comment - col1 string # Partition Information # col_name data_type comment - dt string # Detailed Partition Information @@ -673,12 +735,10 @@ POSTHOOK: query: describe formatted alter5 partition (dt='a') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@alter5 # col_name data_type comment - col1 string # Partition Information # col_name data_type comment - dt string # Detailed Partition Information @@ -752,13 +812,11 @@ POSTHOOK: query: describe formatted src_stat_part PARTITION(partitionId=1) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_stat_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - partitionid int # Detailed Partition Information @@ -803,13 +861,11 @@ POSTHOOK: query: describe formatted src_stat_part PARTITION(partitionId=2) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@src_stat_part # col_name data_type comment - key string value string # Partition Information # col_name data_type comment - partitionid int # Detailed Partition Information @@ -942,13 +998,11 @@ POSTHOOK: query: describe formatted tab_part partition (ds='2008-04-08') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@tab_part # col_name data_type comment - key int value string # Partition Information # col_name data_type comment - ds string # Detailed Partition Information @@ -1003,13 +1057,11 @@ POSTHOOK: query: describe formatted tab partition (ds='2008-04-08') POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@tab # col_name data_type comment - key int value string # Partition Information # col_name data_type comment - ds string # Detailed Partition Information @@ -1060,13 +1112,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 @@ -1132,13 +1182,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 @@ -1195,13 +1243,11 @@ POSTHOOK: query: desc formatted nzhang_part14 PARTITION(ds='2010-03-03', hr='12' 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 @@ -1276,13 +1322,11 @@ POSTHOOK: query: desc formatted nzhang_part14 PARTITION(ds='2010-03-03', hr='12' 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/llap/bucket5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket5.q.out b/ql/src/test/results/clientpositive/llap/bucket5.q.out index 0b5a14d..2357623 100644 --- a/ql/src/test/results/clientpositive/llap/bucket5.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket5.q.out @@ -503,7 +503,6 @@ POSTHOOK: query: DESC FORMATTED bucketed_table POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@bucketed_table # col_name data_type comment - key int value string http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out b/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out index 1c6ab8c..98c1e48 100644 --- a/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out +++ b/ql/src/test/results/clientpositive/llap/bucket_groupby.q.out @@ -18,7 +18,6 @@ ds string # Partition Information # col_name data_type comment - ds string #### A masked pattern was here #### @@ -154,7 +153,6 @@ ds string # Partition Information # col_name data_type comment - ds string #### A masked pattern was here #### @@ -1121,7 +1119,6 @@ ds string # Partition Information # col_name data_type comment - ds string #### A masked pattern was here #### @@ -1427,7 +1424,6 @@ ds string # Partition Information # col_name data_type comment - ds string #### A masked pattern was here #### http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out b/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out index 434f739..c60a5be 100644 --- a/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.q.out +++ b/ql/src/test/results/clientpositive/llap/columnStatsUpdateForStatsOptimizer_1.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 @@ -203,7 +201,6 @@ POSTHOOK: query: desc formatted calendar POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendar # col_name data_type comment - year int month int @@ -269,7 +266,6 @@ POSTHOOK: query: desc formatted calendar POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendar # col_name data_type comment - year int month int @@ -448,7 +444,6 @@ POSTHOOK: query: desc formatted calendar POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendar # col_name data_type comment - year int month int @@ -583,7 +578,6 @@ POSTHOOK: query: desc formatted calendar POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendar # col_name data_type comment - year int month int @@ -656,12 +650,10 @@ POSTHOOK: query: desc formatted calendarp partition (p=1) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendarp # col_name data_type comment - year int # Partition Information # col_name data_type comment - p int # Detailed Partition Information @@ -777,12 +769,10 @@ POSTHOOK: query: desc formatted calendarp partition (p=1) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendarp # col_name data_type comment - year int # Partition Information # col_name data_type comment - p int # Detailed Partition Information @@ -836,12 +826,10 @@ POSTHOOK: query: desc formatted calendarp partition (p=1) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@calendarp # col_name data_type comment - year int # Partition Information # col_name data_type comment - p int # Detailed Partition Information @@ -959,7 +947,6 @@ POSTHOOK: query: desc formatted t POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@t # col_name data_type comment - key string value string @@ -1001,7 +988,6 @@ POSTHOOK: query: desc formatted t POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@t # col_name data_type comment - key string value string http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/column_names_with_leading_and_trailing_spaces.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/column_names_with_leading_and_trailing_spaces.q.out b/ql/src/test/results/clientpositive/llap/column_names_with_leading_and_trailing_spaces.q.out index 345434f..2b87d50 100644 --- a/ql/src/test/results/clientpositive/llap/column_names_with_leading_and_trailing_spaces.q.out +++ b/ql/src/test/results/clientpositive/llap/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/llap/column_table_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/column_table_stats.q.out b/ql/src/test/results/clientpositive/llap/column_table_stats.q.out index 9aad454..f073720 100644 --- a/ql/src/test/results/clientpositive/llap/column_table_stats.q.out +++ b/ql/src/test/results/clientpositive/llap/column_table_stats.q.out @@ -25,7 +25,6 @@ POSTHOOK: query: desc formatted s POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@s # col_name data_type comment - key string default value string default @@ -204,7 +203,6 @@ POSTHOOK: query: desc formatted s POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@s # col_name data_type comment - key string default value string default @@ -277,13 +275,11 @@ POSTHOOK: query: desc formatted spart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -530,13 +526,11 @@ POSTHOOK: query: desc formatted spart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -572,13 +566,11 @@ POSTHOOK: query: desc formatted spart PARTITION(ds='2008-04-08', hr=11) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -612,13 +604,11 @@ POSTHOOK: query: desc formatted spart PARTITION(ds='2008-04-08', hr=12) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -694,13 +684,11 @@ POSTHOOK: query: desc formatted spart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -947,13 +935,11 @@ POSTHOOK: query: desc formatted spart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -989,13 +975,11 @@ POSTHOOK: query: desc formatted spart PARTITION(ds='2008-04-08', hr=11) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -1029,13 +1013,11 @@ POSTHOOK: query: desc formatted spart PARTITION(ds='2008-04-08', hr=12) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -1111,13 +1093,11 @@ POSTHOOK: query: desc formatted spart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -1312,13 +1292,11 @@ POSTHOOK: query: desc formatted spart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -1353,13 +1331,11 @@ POSTHOOK: query: desc formatted spart PARTITION(ds='2008-04-08', hr=11) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -1393,13 +1369,11 @@ POSTHOOK: query: desc formatted spart PARTITION(ds='2008-04-08', hr=12) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # 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/llap/column_table_stats_orc.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out b/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out index c719976..4bc5b39 100644 --- a/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out +++ b/ql/src/test/results/clientpositive/llap/column_table_stats_orc.q.out @@ -25,7 +25,6 @@ POSTHOOK: query: desc formatted s POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@s # col_name data_type comment - key string default value string default @@ -206,7 +205,6 @@ POSTHOOK: query: desc formatted s POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@s # col_name data_type comment - key string default value string default @@ -273,13 +271,11 @@ POSTHOOK: query: desc formatted spart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -520,13 +516,11 @@ POSTHOOK: query: desc formatted spart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -562,13 +556,11 @@ POSTHOOK: query: desc formatted spart PARTITION(ds='2008-04-08', hr=11) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -602,13 +594,11 @@ POSTHOOK: query: desc formatted spart PARTITION(ds='2008-04-08', hr=12) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -678,13 +668,11 @@ POSTHOOK: query: desc formatted spart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -876,13 +864,11 @@ POSTHOOK: query: desc formatted spart POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -918,13 +904,11 @@ POSTHOOK: query: desc formatted spart PARTITION(ds='2008-04-08', hr=11) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string @@ -958,13 +942,11 @@ POSTHOOK: query: desc formatted spart PARTITION(ds='2008-04-08', hr=12) POSTHOOK: type: DESCTABLE POSTHOOK: Input: default@spart # col_name data_type comment - key string default value string default # Partition Information # col_name data_type comment - ds string hr string
