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:45 UTC
[11/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/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