You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2017/10/10 00:51:40 UTC
[06/61] [abbrv] hive git commit: HIVE-17519: Transpose column stats
display (Zoltan Haindrich, reviewed by Ashutosh Chauhan and Vineet Garg)
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/columnstats_part_coltype.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/columnstats_part_coltype.q.out b/ql/src/test/results/clientpositive/llap/columnstats_part_coltype.q.out
index 9368514..72f9aa2 100644
--- a/ql/src/test/results/clientpositive/llap/columnstats_part_coltype.q.out
+++ b/ql/src/test/results/clientpositive/llap/columnstats_part_coltype.q.out
@@ -80,18 +80,36 @@ PREHOOK: Input: default@partcolstats
POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=2, part='partA') key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-key int 27 484 0 20 HL from deserializer
+col_name key
+data_type int
+min 27
+max 484
+num_nulls 0
+distinct_count 20
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=2, part='partA') value
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@partcolstats
POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=2, part='partA') value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
-# 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 20 6.8 7 HL from deserializer
+col_name value
+data_type string
+min
+max
+num_nulls 0
+distinct_count 20
+avg_col_len 6.8
+max_col_len 7
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=2, part='partB') key
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@partcolstats
@@ -99,7 +117,6 @@ POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02'
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
# col_name data_type comment
-
key int from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=2, part='partB') value
PREHOOK: type: DESCTABLE
@@ -108,7 +125,6 @@ POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02'
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
# col_name data_type comment
-
value string from deserializer
PREHOOK: query: analyze table partcolstats partition (ds=date '2015-04-02', hr=2, part) compute statistics for columns
PREHOOK: type: QUERY
@@ -134,18 +150,36 @@ PREHOOK: Input: default@partcolstats
POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=2, part='partB') key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-key int 27 484 0 20 HL from deserializer
+col_name key
+data_type int
+min 27
+max 484
+num_nulls 0
+distinct_count 20
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=2, part='partB') value
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@partcolstats
POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=2, part='partB') value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
-# 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 20 6.8 7 HL from deserializer
+col_name value
+data_type string
+min
+max
+num_nulls 0
+distinct_count 20
+avg_col_len 6.8
+max_col_len 7
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=3, part='partA') key
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@partcolstats
@@ -153,7 +187,6 @@ POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02'
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
# col_name data_type comment
-
key int from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=3, part='partA') value
PREHOOK: type: DESCTABLE
@@ -162,7 +195,6 @@ POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02'
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
# col_name data_type comment
-
value string from deserializer
PREHOOK: query: analyze table partcolstats partition (ds=date '2015-04-02', hr, part) compute statistics for columns
PREHOOK: type: QUERY
@@ -192,18 +224,36 @@ PREHOOK: Input: default@partcolstats
POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=3, part='partA') key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-key int 27 495 0 30 HL from deserializer
+col_name key
+data_type int
+min 27
+max 495
+num_nulls 0
+distinct_count 30
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=3, part='partA') value
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@partcolstats
POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-02', hr=3, part='partA') value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
-# 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 30 6.833333333333333 7 HL from deserializer
+col_name value
+data_type string
+min
+max
+num_nulls 0
+distinct_count 30
+avg_col_len 6.833333333333333
+max_col_len 7
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partA') key
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@partcolstats
@@ -211,7 +261,6 @@ POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03'
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
# col_name data_type comment
-
key int from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partA') value
PREHOOK: type: DESCTABLE
@@ -220,7 +269,6 @@ POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03'
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
# col_name data_type comment
-
value string from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partB') key
PREHOOK: type: DESCTABLE
@@ -229,7 +277,6 @@ POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03'
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
# col_name data_type comment
-
key int from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partB') value
PREHOOK: type: DESCTABLE
@@ -238,7 +285,6 @@ POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03'
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
# col_name data_type comment
-
value string from deserializer
PREHOOK: query: analyze table partcolstats partition (ds, hr, part) compute statistics for columns
PREHOOK: type: QUERY
@@ -276,36 +322,72 @@ PREHOOK: Input: default@partcolstats
POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partA') key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-key int 15 495 0 40 HL from deserializer
+col_name key
+data_type int
+min 15
+max 495
+num_nulls 0
+distinct_count 40
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partA') value
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@partcolstats
POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partA') value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
-# 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 40 6.825 7 HL from deserializer
+col_name value
+data_type string
+min
+max
+num_nulls 0
+distinct_count 40
+avg_col_len 6.825
+max_col_len 7
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partB') key
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@partcolstats
POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partB') key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-key int 15 495 0 58 HL from deserializer
+col_name key
+data_type int
+min 15
+max 495
+num_nulls 0
+distinct_count 58
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partB') value
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@partcolstats
POSTHOOK: query: describe formatted partcolstats partition (ds=date '2015-04-03', hr=3, part='partB') value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstats
-# 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 58 6.883333333333334 7 HL from deserializer
+col_name value
+data_type string
+min
+max
+num_nulls 0
+distinct_count 58
+avg_col_len 6.883333333333334
+max_col_len 7
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: drop table partcolstats
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@partcolstats
@@ -356,9 +438,18 @@ PREHOOK: Input: default@partcolstatsnum
POSTHOOK: query: describe formatted partcolstatsnum partition (tint=100, sint=1000, bint=1000000) value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstatsnum
-# 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 30 6.833333333333333 7 HL from deserializer
+col_name value
+data_type string
+min
+max
+num_nulls 0
+distinct_count 30
+avg_col_len 6.833333333333333
+max_col_len 7
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: drop table partcolstatsnum
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@partcolstatsnum
@@ -409,9 +500,18 @@ PREHOOK: Input: default@partcolstatsdec
POSTHOOK: query: describe formatted partcolstatsdec partition (decpart='1000.0001') value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstatsdec
-# 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 30 6.833333333333333 7 HL from deserializer
+col_name value
+data_type string
+min
+max
+num_nulls 0
+distinct_count 30
+avg_col_len 6.833333333333333
+max_col_len 7
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: drop table partcolstatsdec
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@partcolstatsdec
@@ -462,9 +562,18 @@ PREHOOK: Input: default@partcolstatschar
POSTHOOK: query: describe formatted partcolstatschar partition (varpart='part1', charpart='aaa') value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@partcolstatschar
-# 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 30 6.833333333333333 7 HL from deserializer
+col_name value
+data_type string
+min
+max
+num_nulls 0
+distinct_count 30
+avg_col_len 6.833333333333333
+max_col_len 7
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
PREHOOK: query: drop table partcolstatschar
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@partcolstatschar
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/ctas.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/ctas.q.out b/ql/src/test/results/clientpositive/llap/ctas.q.out
index fe492e4..1dd2dd1 100644
--- a/ql/src/test/results/clientpositive/llap/ctas.q.out
+++ b/ql/src/test/results/clientpositive/llap/ctas.q.out
@@ -142,7 +142,6 @@ POSTHOOK: query: describe formatted nzhang_CTAS1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@nzhang_ctas1
# col_name data_type comment
-
k string
value string
@@ -298,7 +297,6 @@ POSTHOOK: query: describe formatted nzhang_CTAS2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@nzhang_ctas2
# col_name data_type comment
-
key string
value string
@@ -454,7 +452,6 @@ POSTHOOK: query: describe formatted nzhang_CTAS3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@nzhang_ctas3
# col_name data_type comment
-
half_key double
conb string
@@ -518,7 +515,6 @@ POSTHOOK: query: describe formatted nzhang_CTAS3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@nzhang_ctas3
# col_name data_type comment
-
half_key double
conb string
@@ -675,7 +671,6 @@ POSTHOOK: query: describe formatted nzhang_CTAS4
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@nzhang_ctas4
# 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/deleteAnalyze.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/deleteAnalyze.q.out b/ql/src/test/results/clientpositive/llap/deleteAnalyze.q.out
index 18fdfd4..45b9af6 100644
--- a/ql/src/test/results/clientpositive/llap/deleteAnalyze.q.out
+++ b/ql/src/test/results/clientpositive/llap/deleteAnalyze.q.out
@@ -35,7 +35,6 @@ POSTHOOK: query: describe formatted testdeci2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@testdeci2
# col_name data_type comment
-
id int
amount decimal(10,3)
sales_tax decimal(10,3)
@@ -72,9 +71,18 @@ PREHOOK: Input: default@testdeci2
POSTHOOK: query: describe formatted testdeci2 amount
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@testdeci2
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-amount decimal(10,3) from deserializer
+col_name amount
+data_type decimal(10,3)
+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\"}
PREHOOK: query: analyze table testdeci2 compute statistics for columns
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out b/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out
index b47671b..2e62fb0 100644
--- a/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out
+++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_opt_vectorization.q.out
@@ -920,7 +920,6 @@ POSTHOOK: query: desc formatted over1k_part_orc partition(ds="foo",t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -928,7 +927,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -962,7 +960,6 @@ POSTHOOK: query: desc formatted over1k_part_orc partition(ds="foo",t="__HIVE_DEF
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -970,7 +967,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1004,7 +1000,6 @@ POSTHOOK: query: desc formatted over1k_part_limit_orc partition(ds="foo",t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_limit_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1012,7 +1007,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1046,7 +1040,6 @@ POSTHOOK: query: desc formatted over1k_part_limit_orc partition(ds="foo",t="__HI
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_limit_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1054,7 +1047,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1088,7 +1080,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_orc partition(t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1096,7 +1087,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -1129,7 +1119,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_orc partition(t="__HIVE_DEFAULT
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1137,7 +1126,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -1170,7 +1158,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort_orc partition(t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1178,7 +1165,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -1211,7 +1197,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort_orc partition(t="__HIVE_DE
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1219,7 +1204,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -1737,7 +1721,6 @@ POSTHOOK: query: desc formatted over1k_part2_orc partition(ds="foo",t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part2_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1745,7 +1728,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1779,7 +1761,6 @@ POSTHOOK: query: desc formatted over1k_part2_orc partition(ds="foo",t="__HIVE_DE
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part2_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1787,7 +1768,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1882,7 +1862,6 @@ POSTHOOK: query: desc formatted over1k_part2_orc partition(ds="foo",t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part2_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1890,7 +1869,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1924,7 +1902,6 @@ POSTHOOK: query: desc formatted over1k_part2_orc partition(ds="foo",t="__HIVE_DE
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part2_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1932,7 +1909,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -2194,7 +2170,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort2_orc partition(t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort2_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -2202,7 +2177,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -2235,7 +2209,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort2_orc partition(t="__HIVE_D
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort2_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -2243,7 +2216,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -2412,7 +2384,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort2_orc partition(t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort2_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -2420,7 +2391,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -2453,7 +2423,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort2_orc partition(t="__HIVE_D
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort2_orc
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -2461,7 +2430,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out
index 48896a7..5b80a32 100644
--- a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out
+++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization.q.out
@@ -877,7 +877,6 @@ POSTHOOK: query: desc formatted over1k_part partition(ds="foo",t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -885,7 +884,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -919,7 +917,6 @@ POSTHOOK: query: desc formatted over1k_part partition(ds="foo",t="__HIVE_DEFAULT
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -927,7 +924,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -961,7 +957,6 @@ POSTHOOK: query: desc formatted over1k_part_limit partition(ds="foo",t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_limit
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -969,7 +964,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1003,7 +997,6 @@ POSTHOOK: query: desc formatted over1k_part_limit partition(ds="foo",t="__HIVE_D
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_limit
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1011,7 +1004,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1045,7 +1037,6 @@ POSTHOOK: query: desc formatted over1k_part_buck partition(t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1053,7 +1044,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -1086,7 +1076,6 @@ POSTHOOK: query: desc formatted over1k_part_buck partition(t="__HIVE_DEFAULT_PAR
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1094,7 +1083,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -1127,7 +1115,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort partition(t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1135,7 +1122,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -1168,7 +1154,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort partition(t="__HIVE_DEFAUL
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1176,7 +1161,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -1694,7 +1678,6 @@ POSTHOOK: query: desc formatted over1k_part2 partition(ds="foo",t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part2
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1702,7 +1685,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1736,7 +1718,6 @@ POSTHOOK: query: desc formatted over1k_part2 partition(ds="foo",t="__HIVE_DEFAUL
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part2
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1744,7 +1725,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1839,7 +1819,6 @@ POSTHOOK: query: desc formatted over1k_part2 partition(ds="foo",t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part2
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1847,7 +1826,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -1881,7 +1859,6 @@ POSTHOOK: query: desc formatted over1k_part2 partition(ds="foo",t="__HIVE_DEFAUL
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part2
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -1889,7 +1866,6 @@ f float
# Partition Information
# col_name data_type comment
-
ds string
t tinyint
@@ -2151,7 +2127,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort2 partition(t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort2
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -2159,7 +2134,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -2192,7 +2166,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort2 partition(t="__HIVE_DEFAU
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort2
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -2200,7 +2173,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -2294,7 +2266,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort2 partition(t=27)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort2
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -2302,7 +2273,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
@@ -2335,7 +2305,6 @@ POSTHOOK: query: desc formatted over1k_part_buck_sort2 partition(t="__HIVE_DEFAU
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@over1k_part_buck_sort2
# col_name data_type comment
-
si smallint
i int
b bigint
@@ -2343,7 +2312,6 @@ f float
# Partition Information
# col_name data_type comment
-
t tinyint
# Detailed Partition Information
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out
index f4a0043..568ab65 100644
--- a/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out
+++ b/ql/src/test/results/clientpositive/llap/dynpart_sort_optimization2.q.out
@@ -184,13 +184,11 @@ POSTHOOK: query: desc formatted ss_part partition(ss_sold_date_sk=2452617)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -244,13 +242,11 @@ POSTHOOK: query: desc formatted ss_part partition(ss_sold_date_sk=2452638)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -416,13 +412,11 @@ POSTHOOK: query: desc formatted ss_part partition(ss_sold_date_sk=2452617)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -476,13 +470,11 @@ POSTHOOK: query: desc formatted ss_part partition(ss_sold_date_sk=2452638)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -664,13 +656,11 @@ POSTHOOK: query: desc formatted ss_part partition(ss_sold_date_sk=2452617)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -724,13 +714,11 @@ POSTHOOK: query: desc formatted ss_part partition(ss_sold_date_sk=2452638)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -894,13 +882,11 @@ POSTHOOK: query: desc formatted ss_part partition(ss_sold_date_sk=2452617)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -954,13 +940,11 @@ POSTHOOK: query: desc formatted ss_part partition(ss_sold_date_sk=2452638)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -1197,13 +1181,11 @@ POSTHOOK: query: desc formatted ss_part_orc partition(ss_sold_date_sk=2452617)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part_orc
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -1257,13 +1239,11 @@ POSTHOOK: query: desc formatted ss_part_orc partition(ss_sold_date_sk=2452638)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part_orc
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -1427,13 +1407,11 @@ POSTHOOK: query: desc formatted ss_part_orc partition(ss_sold_date_sk=2452617)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part_orc
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
@@ -1487,13 +1465,11 @@ POSTHOOK: query: desc formatted ss_part_orc partition(ss_sold_date_sk=2452638)
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@ss_part_orc
# col_name data_type comment
-
ss_net_paid_inc_tax float
ss_net_profit float
# Partition Information
# col_name data_type comment
-
ss_sold_date_sk int
# Detailed Partition Information
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/explainuser_1.q.out b/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
index 164eb0c..b9c6cd9 100644
--- a/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
+++ b/ql/src/test/results/clientpositive/llap/explainuser_1.q.out
@@ -34,7 +34,6 @@ ts string
# Partition Information
# col_name data_type comment
-
ds string
ts string