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:43 UTC
[09/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/database_location.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/database_location.q.out b/ql/src/test/results/clientpositive/database_location.q.out
index e4db000..a62ba2e 100644
--- a/ql/src/test/results/clientpositive/database_location.q.out
+++ b/ql/src/test/results/clientpositive/database_location.q.out
@@ -32,7 +32,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table_db1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: db1@table_db1
# col_name data_type comment
-
name string
value int
@@ -107,7 +106,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table_db2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: db2@table_db2
# col_name data_type comment
-
name string
value int
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out b/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out
index facd497..1d7206f 100644
--- a/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out
+++ b/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out
@@ -56,7 +56,6 @@ ds string
# Partition Information
# col_name data_type comment
-
ds string
PREHOOK: query: drop view V1
PREHOOK: type: DROPVIEW
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/decimal_serde.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/decimal_serde.q.out b/ql/src/test/results/clientpositive/decimal_serde.q.out
index e0f5c74..43f7ab8 100644
--- a/ql/src/test/results/clientpositive/decimal_serde.q.out
+++ b/ql/src/test/results/clientpositive/decimal_serde.q.out
@@ -105,7 +105,6 @@ POSTHOOK: query: describe formatted DECIMAL_RC
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@decimal_rc
# col_name data_type comment
-
key decimal(10,0)
value int
@@ -158,7 +157,6 @@ POSTHOOK: query: describe formatted DECIMAL_LAZY_COL
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@decimal_lazy_col
# col_name data_type comment
-
key decimal(10,0)
value int
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/decimal_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/decimal_stats.q.out b/ql/src/test/results/clientpositive/decimal_stats.q.out
index eacad98..9d7e750 100644
--- a/ql/src/test/results/clientpositive/decimal_stats.q.out
+++ b/ql/src/test/results/clientpositive/decimal_stats.q.out
@@ -46,9 +46,18 @@ PREHOOK: Input: default@decimal_1
POSTHOOK: query: desc formatted decimal_1 v
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@decimal_1
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-v decimal(10,0) 500 1 HL from deserializer
+col_name v
+data_type decimal(10,0)
+min
+max
+num_nulls 500
+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\":{\"t\":\"true\",\"u\":\"true\",\"v\":\"true\"}}
PREHOOK: query: explain select * from decimal_1 order by t limit 100
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/default_file_format.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/default_file_format.q.out b/ql/src/test/results/clientpositive/default_file_format.q.out
index 9e8d5ba..9eb7d2d 100644
--- a/ql/src/test/results/clientpositive/default_file_format.q.out
+++ b/ql/src/test/results/clientpositive/default_file_format.q.out
@@ -59,7 +59,6 @@ POSTHOOK: query: describe formatted t
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@t
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -93,7 +92,6 @@ POSTHOOK: query: describe formatted o
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@o
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -127,7 +125,6 @@ POSTHOOK: query: describe formatted io
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@io
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -161,7 +158,6 @@ POSTHOOK: query: describe formatted e
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@e
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -191,7 +187,6 @@ POSTHOOK: query: describe formatted i
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@i
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -225,7 +220,6 @@ POSTHOOK: query: describe formatted e2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@e2
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -359,7 +353,6 @@ POSTHOOK: query: describe formatted t
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@t
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -393,7 +386,6 @@ POSTHOOK: query: describe formatted o
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@o
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -427,7 +419,6 @@ POSTHOOK: query: describe formatted io
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@io
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -461,7 +452,6 @@ POSTHOOK: query: describe formatted e
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@e
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -493,7 +483,6 @@ POSTHOOK: query: describe formatted i
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@i
# col_name data_type comment
-
c int
# Detailed Table Information
@@ -527,7 +516,6 @@ POSTHOOK: query: describe formatted e2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@e2
# col_name data_type comment
-
c int
# Detailed Table Information
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/deleteAnalyze.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/deleteAnalyze.q.out b/ql/src/test/results/clientpositive/deleteAnalyze.q.out
index d3609f8..840f053 100644
--- a/ql/src/test/results/clientpositive/deleteAnalyze.q.out
+++ b/ql/src/test/results/clientpositive/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/desc_tbl_part_cols.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/desc_tbl_part_cols.q.out b/ql/src/test/results/clientpositive/desc_tbl_part_cols.q.out
index e874412..196f85b 100644
--- a/ql/src/test/results/clientpositive/desc_tbl_part_cols.q.out
+++ b/ql/src/test/results/clientpositive/desc_tbl_part_cols.q.out
@@ -19,7 +19,6 @@ d string
# Partition Information
# col_name data_type comment
-
c int
d string
PREHOOK: query: describe t1
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/describe_comment_indent.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/describe_comment_indent.q.out b/ql/src/test/results/clientpositive/describe_comment_indent.q.out
index 0049e2b..8da5949 100644
--- a/ql/src/test/results/clientpositive/describe_comment_indent.q.out
+++ b/ql/src/test/results/clientpositive/describe_comment_indent.q.out
@@ -41,7 +41,6 @@ POSTHOOK: query: DESCRIBE FORMATTED test_table
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_table
# col_name data_type comment
-
col1 int col1 one line comment
col2 string col2
two lines comment
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/describe_comment_nonascii.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/describe_comment_nonascii.q.out b/ql/src/test/results/clientpositive/describe_comment_nonascii.q.out
index 4483e88..a4d5127 100644
--- a/ql/src/test/results/clientpositive/describe_comment_nonascii.q.out
+++ b/ql/src/test/results/clientpositive/describe_comment_nonascii.q.out
@@ -37,7 +37,6 @@ POSTHOOK: query: DESCRIBE FORMATTED dummy
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@dummy
# col_name data_type comment
-
col1 string 한글_col1
col2 string 漢字_col2
col3 string わご_col3
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out b/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out
index d47e325..fe96d50 100644
--- a/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out
+++ b/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out
@@ -43,12 +43,10 @@ POSTHOOK: query: DESCRIBE FORMATTED view_partitioned PARTITION (value='val_86')
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view_partitioned
# col_name data_type comment
-
key string
# Partition Information
# col_name data_type comment
-
value string
# Detailed Partition Information
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/describe_syntax.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/describe_syntax.q.out b/ql/src/test/results/clientpositive/describe_syntax.q.out
index 16b7763..a0c6182 100644
--- a/ql/src/test/results/clientpositive/describe_syntax.q.out
+++ b/ql/src/test/results/clientpositive/describe_syntax.q.out
@@ -52,7 +52,6 @@ part string
# Partition Information
# col_name data_type comment
-
ds string
part string
PREHOOK: query: DESCRIBE EXTENDED t1
@@ -68,7 +67,6 @@ part string
# Partition Information
# col_name data_type comment
-
ds string
part string
@@ -80,13 +78,11 @@ POSTHOOK: query: DESCRIBE FORMATTED t1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: db1@t1
# col_name data_type comment
-
key1 int
value1 string
# Partition Information
# col_name data_type comment
-
ds string
part string
@@ -128,7 +124,6 @@ part string
# Partition Information
# col_name data_type comment
-
ds string
part string
PREHOOK: query: DESCRIBE EXTENDED db1.t1
@@ -144,7 +139,6 @@ part string
# Partition Information
# col_name data_type comment
-
ds string
part string
@@ -156,13 +150,11 @@ POSTHOOK: query: DESCRIBE FORMATTED db1.t1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: db1@t1
# col_name data_type comment
-
key1 int
value1 string
# Partition Information
# col_name data_type comment
-
ds string
part string
@@ -211,9 +203,18 @@ PREHOOK: Input: db1@t1
POSTHOOK: query: DESCRIBE FORMATTED t1 key1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: db1@t1
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-key1 int from deserializer
+col_name key1
+data_type int
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
COLUMN_STATS_ACCURATE {}
PREHOOK: query: DESCRIBE db1.t1 key1
PREHOOK: type: DESCTABLE
@@ -235,9 +236,18 @@ PREHOOK: Input: db1@t1
POSTHOOK: query: DESCRIBE FORMATTED db1.t1 key1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: db1@t1
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-key1 int from deserializer
+col_name key1
+data_type int
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
COLUMN_STATS_ACCURATE {}
PREHOOK: query: DESCRIBE t1 key1
PREHOOK: type: DESCTABLE
@@ -259,9 +269,18 @@ PREHOOK: Input: db1@t1
POSTHOOK: query: DESCRIBE FORMATTED t1 key1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: db1@t1
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-key1 int from deserializer
+col_name key1
+data_type int
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
COLUMN_STATS_ACCURATE {}
PREHOOK: query: DESCRIBE t1 PARTITION(ds='4', part='5')
PREHOOK: type: DESCTABLE
@@ -276,7 +295,6 @@ part string
# Partition Information
# col_name data_type comment
-
ds string
part string
PREHOOK: query: DESCRIBE EXTENDED t1 PARTITION(ds='4', part='5')
@@ -292,7 +310,6 @@ part string
# Partition Information
# col_name data_type comment
-
ds string
part string
@@ -304,13 +321,11 @@ POSTHOOK: query: DESCRIBE FORMATTED t1 PARTITION(ds='4', part='5')
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: db1@t1
# col_name data_type comment
-
key1 int
value1 string
# Partition Information
# col_name data_type comment
-
ds string
part string
@@ -350,7 +365,6 @@ part string
# Partition Information
# col_name data_type comment
-
ds string
part string
PREHOOK: query: DESCRIBE EXTENDED db1.t1 PARTITION(ds='4', part='5')
@@ -366,7 +380,6 @@ part string
# Partition Information
# col_name data_type comment
-
ds string
part string
@@ -378,13 +391,11 @@ POSTHOOK: query: DESCRIBE FORMATTED db1.t1 PARTITION(ds='4', part='5')
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: db1@t1
# col_name data_type comment
-
key1 int
value1 string
# Partition Information
# col_name data_type comment
-
ds string
part string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/describe_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/describe_table.q.out b/ql/src/test/results/clientpositive/describe_table.q.out
index 08f466e..8f7d0f6 100644
--- a/ql/src/test/results/clientpositive/describe_table.q.out
+++ b/ql/src/test/results/clientpositive/describe_table.q.out
@@ -11,7 +11,6 @@ hr string
# Partition Information
# col_name data_type comment
-
ds string
hr string
PREHOOK: query: describe srcpart key
@@ -34,7 +33,6 @@ hr string
# Partition Information
# col_name data_type comment
-
ds string
hr string
PREHOOK: query: describe `srcpart`
@@ -50,7 +48,6 @@ hr string
# Partition Information
# col_name data_type comment
-
ds string
hr string
PREHOOK: query: describe `srcpart` `key`
@@ -73,7 +70,6 @@ hr string
# Partition Information
# col_name data_type comment
-
ds string
hr string
PREHOOK: query: describe extended srcpart
@@ -89,7 +85,6 @@ hr string
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -114,7 +109,6 @@ hr string
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -132,7 +126,6 @@ hr string
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -157,7 +150,6 @@ hr string
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -169,13 +161,11 @@ POSTHOOK: query: describe formatted srcpart
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcpart
# col_name data_type comment
-
key string default
value string default
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -210,9 +200,18 @@ PREHOOK: Input: default@srcpart
POSTHOOK: query: describe formatted srcpart key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcpart
-# 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 {\"COLUMN_STATS\":{\"key\":\"true\"}}
PREHOOK: query: describe formatted srcpart PARTITION(ds='2008-04-08', hr='12')
PREHOOK: type: DESCTABLE
@@ -221,13 +220,11 @@ POSTHOOK: query: describe formatted srcpart PARTITION(ds='2008-04-08', hr='12')
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcpart
# col_name data_type comment
-
key string default
value string default
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -261,13 +258,11 @@ POSTHOOK: query: describe formatted `srcpart`
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcpart
# col_name data_type comment
-
key string default
value string default
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -302,9 +297,18 @@ PREHOOK: Input: default@srcpart
POSTHOOK: query: describe formatted `srcpart` `key`
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcpart
-# 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 {\"COLUMN_STATS\":{\"key\":\"true\"}}
PREHOOK: query: describe formatted `srcpart` PARTITION(ds='2008-04-08', hr='12')
PREHOOK: type: DESCTABLE
@@ -313,13 +317,11 @@ POSTHOOK: query: describe formatted `srcpart` PARTITION(ds='2008-04-08', hr='12'
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcpart
# col_name data_type comment
-
key string default
value string default
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -352,9 +354,18 @@ PREHOOK: Input: default@srcpart
POSTHOOK: query: describe formatted `srcpart` `ds`
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcpart
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-ds string 0 2 100.0 100
+col_name ds
+data_type string
+min
+max
+num_nulls 0
+distinct_count 2
+avg_col_len 100.0
+max_col_len 100
+num_trues
+num_falses
+bitVector
+comment
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"ds\":\"true\"}}
PREHOOK: query: describe formatted `srcpart` `hr`
PREHOOK: type: DESCTABLE
@@ -362,9 +373,18 @@ PREHOOK: Input: default@srcpart
POSTHOOK: query: describe formatted `srcpart` `hr`
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcpart
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-hr string 0 2 100.0 100
+col_name hr
+data_type string
+min
+max
+num_nulls 0
+distinct_count 2
+avg_col_len 100.0
+max_col_len 100
+num_trues
+num_falses
+bitVector
+comment
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"hr\":\"true\"}}
PREHOOK: query: create table srcpart_serdeprops like srcpart
PREHOOK: type: CREATETABLE
@@ -413,13 +433,11 @@ POSTHOOK: query: describe formatted srcpart_serdeprops
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcpart_serdeprops
# col_name data_type comment
-
key string default
value string default
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -534,7 +552,6 @@ name3 int
# Partition Information
# col_name data_type comment
-
name3 int
PREHOOK: query: DESCRIBE name1.name1 name2
PREHOOK: type: DESCTABLE
@@ -555,7 +572,6 @@ name3 int
# Partition Information
# col_name data_type comment
-
name3 int
PREHOOK: query: DESCRIBE name1.name2
PREHOOK: type: DESCTABLE
@@ -599,7 +615,6 @@ name3 int
# Partition Information
# col_name data_type comment
-
name3 int
PREHOOK: query: DESCRIBE name1 name2
PREHOOK: type: DESCTABLE
@@ -620,7 +635,6 @@ name3 int
# Partition Information
# col_name data_type comment
-
name3 int
PREHOOK: query: DESCRIBE name1.name1
PREHOOK: type: DESCTABLE
@@ -634,7 +648,6 @@ name3 int
# Partition Information
# col_name data_type comment
-
name3 int
PREHOOK: query: DESCRIBE name1.name1 name2
PREHOOK: type: DESCTABLE
@@ -655,7 +668,6 @@ name3 int
# Partition Information
# col_name data_type comment
-
name3 int
PREHOOK: query: DESCRIBE name2
PREHOOK: type: DESCTABLE
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out b/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out
index f17e7bd..65af3f8 100644
--- a/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out
+++ b/ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out
@@ -51,9 +51,18 @@ PREHOOK: Input: default@uservisits_web_text_none
POSTHOOK: query: desc formatted UserVisits_web_text_none sourceIP
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@uservisits_web_text_none
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-sourceIP string from deserializer
+col_name sourceIP
+data_type string
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
PREHOOK: query: explain
analyze table UserVisits_web_text_none compute statistics for columns sourceIP, avgTimeOnSite, adRevenue
PREHOOK: type: QUERY
@@ -242,9 +251,18 @@ PREHOOK: Input: default@uservisits_web_text_none
POSTHOOK: query: desc formatted UserVisits_web_text_none sourceIP
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@uservisits_web_text_none
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-sourceIP string 0 55 12.763636363636364 13 HL from deserializer
+col_name sourceIP
+data_type string
+min
+max
+num_nulls 0
+distinct_count 55
+avg_col_len 12.763636363636364
+max_col_len 13
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"adrevenue\":\"true\",\"avgtimeonsite\":\"true\",\"sourceip\":\"true\"}}
PREHOOK: query: desc formatted UserVisits_web_text_none avgTimeOnSite
PREHOOK: type: DESCTABLE
@@ -252,9 +270,18 @@ PREHOOK: Input: default@uservisits_web_text_none
POSTHOOK: query: desc formatted UserVisits_web_text_none avgTimeOnSite
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@uservisits_web_text_none
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-avgTimeOnSite int 1 9 0 9 HL from deserializer
+col_name avgTimeOnSite
+data_type int
+min 1
+max 9
+num_nulls 0
+distinct_count 9
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"adrevenue\":\"true\",\"avgtimeonsite\":\"true\",\"sourceip\":\"true\"}}
PREHOOK: query: desc formatted UserVisits_web_text_none adRevenue
PREHOOK: type: DESCTABLE
@@ -262,9 +289,18 @@ PREHOOK: Input: default@uservisits_web_text_none
POSTHOOK: query: desc formatted UserVisits_web_text_none adRevenue
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@uservisits_web_text_none
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-adRevenue float 13.099044799804688 492.98870849609375 0 55 HL from deserializer
+col_name adRevenue
+data_type float
+min 13.099044799804688
+max 492.98870849609375
+num_nulls 0
+distinct_count 55
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"adrevenue\":\"true\",\"avgtimeonsite\":\"true\",\"sourceip\":\"true\"}}
PREHOOK: query: CREATE TABLE empty_tab(
a int,
@@ -292,9 +328,18 @@ PREHOOK: Input: default@empty_tab
POSTHOOK: query: desc formatted empty_tab a
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@empty_tab
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-a int from deserializer
+col_name a
+data_type int
+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\":{\"a\":\"true\",\"b\":\"true\",\"c\":\"true\",\"d\":\"true\",\"e\":\"true\"}}
PREHOOK: query: explain
analyze table empty_tab compute statistics for columns a,b,c,d,e
@@ -361,9 +406,18 @@ PREHOOK: Input: default@empty_tab
POSTHOOK: query: desc formatted empty_tab a
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@empty_tab
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-a int 0 0 0 0 from deserializer
+col_name a
+data_type int
+min 0
+max 0
+num_nulls 0
+distinct_count 0
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"b\":\"true\",\"c\":\"true\",\"d\":\"true\",\"e\":\"true\"}}
PREHOOK: query: desc formatted empty_tab b
PREHOOK: type: DESCTABLE
@@ -371,9 +425,18 @@ PREHOOK: Input: default@empty_tab
POSTHOOK: query: desc formatted empty_tab b
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@empty_tab
-# 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 0 0 from deserializer
+col_name b
+data_type double
+min 0.0
+max 0.0
+num_nulls 0
+distinct_count 0
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"a\":\"true\",\"b\":\"true\",\"c\":\"true\",\"d\":\"true\",\"e\":\"true\"}}
PREHOOK: query: CREATE DATABASE test
PREHOOK: type: CREATEDATABASE
@@ -451,27 +514,54 @@ PREHOOK: Input: test@uservisits_web_text_none
POSTHOOK: query: desc formatted UserVisits_web_text_none sourceIP
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: test@uservisits_web_text_none
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-sourceIP string from deserializer
+col_name sourceIP
+data_type string
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
PREHOOK: query: desc formatted test.UserVisits_web_text_none sourceIP
PREHOOK: type: DESCTABLE
PREHOOK: Input: test@uservisits_web_text_none
POSTHOOK: query: desc formatted test.UserVisits_web_text_none sourceIP
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: test@uservisits_web_text_none
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-sourceIP string from deserializer
+col_name sourceIP
+data_type string
+min
+max
+num_nulls
+distinct_count
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector
+comment from deserializer
PREHOOK: query: desc formatted default.UserVisits_web_text_none sourceIP
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@uservisits_web_text_none
POSTHOOK: query: desc formatted default.UserVisits_web_text_none sourceIP
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@uservisits_web_text_none
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-sourceIP string 0 55 12.763636363636364 13 HL from deserializer
+col_name sourceIP
+data_type string
+min
+max
+num_nulls 0
+distinct_count 55
+avg_col_len 12.763636363636364
+max_col_len 13
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"adrevenue\":\"true\",\"avgtimeonsite\":\"true\",\"sourceip\":\"true\"}}
PREHOOK: query: analyze table UserVisits_web_text_none compute statistics for columns sKeyword
PREHOOK: type: QUERY
@@ -495,9 +585,18 @@ PREHOOK: Input: test@uservisits_web_text_none
POSTHOOK: query: desc formatted UserVisits_web_text_none sKeyword
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: test@uservisits_web_text_none
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-sKeyword string 0 54 7.872727272727273 19 HL from deserializer
+col_name sKeyword
+data_type string
+min
+max
+num_nulls 0
+distinct_count 54
+avg_col_len 7.872727272727273
+max_col_len 19
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"skeyword\":\"true\"}}
PREHOOK: query: desc formatted test.UserVisits_web_text_none sKeyword
PREHOOK: type: DESCTABLE
@@ -505,7 +604,16 @@ PREHOOK: Input: test@uservisits_web_text_none
POSTHOOK: query: desc formatted test.UserVisits_web_text_none sKeyword
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: test@uservisits_web_text_none
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-sKeyword string 0 54 7.872727272727273 19 HL from deserializer
+col_name sKeyword
+data_type string
+min
+max
+num_nulls 0
+distinct_count 54
+avg_col_len 7.872727272727273
+max_col_len 19
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"skeyword\":\"true\"}}
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/drop_partitions_filter.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/drop_partitions_filter.q.out b/ql/src/test/results/clientpositive/drop_partitions_filter.q.out
index 3075ab4..4f607da 100644
--- a/ql/src/test/results/clientpositive/drop_partitions_filter.q.out
+++ b/ql/src/test/results/clientpositive/drop_partitions_filter.q.out
@@ -19,7 +19,6 @@ d string
# Partition Information
# col_name data_type comment
-
c string
d string
PREHOOK: query: alter table ptestfilter add partition (c='US', d=1)
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out b/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out
index 92f9805..fd95b44 100644
--- a/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out
+++ b/ql/src/test/results/clientpositive/drop_partitions_filter2.q.out
@@ -19,7 +19,6 @@ d int
# Partition Information
# col_name data_type comment
-
c int
d int
PREHOOK: query: alter table ptestfilter add partition (c=1, d=1)
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out b/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out
index bfb4221..2ba9ec8 100644
--- a/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out
+++ b/ql/src/test/results/clientpositive/drop_partitions_filter3.q.out
@@ -19,7 +19,6 @@ d int
# Partition Information
# col_name data_type comment
-
c string
d int
PREHOOK: query: alter table ptestfilter add partition (c='1', d=1)
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/druid_basic1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/druid_basic1.q.out b/ql/src/test/results/clientpositive/druid_basic1.q.out
index 0ba61e5..91f79bb 100644
--- a/ql/src/test/results/clientpositive/druid_basic1.q.out
+++ b/ql/src/test/results/clientpositive/druid_basic1.q.out
@@ -17,7 +17,6 @@ POSTHOOK: query: DESCRIBE FORMATTED druid_table_1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@druid_table_1
# col_name data_type comment
-
__time timestamp from deserializer
robot string from deserializer
namespace string from deserializer
@@ -79,7 +78,6 @@ POSTHOOK: query: DESCRIBE FORMATTED druid_table_2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@druid_table_2
# col_name data_type comment
-
__time timestamp from deserializer
robot string from deserializer
namespace string from deserializer
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/druid_basic2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/druid_basic2.q.out b/ql/src/test/results/clientpositive/druid_basic2.q.out
index 2e9c340..5d6862c 100644
--- a/ql/src/test/results/clientpositive/druid_basic2.q.out
+++ b/ql/src/test/results/clientpositive/druid_basic2.q.out
@@ -17,7 +17,6 @@ POSTHOOK: query: DESCRIBE FORMATTED druid_table_1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@druid_table_1
# col_name data_type comment
-
__time timestamp from deserializer
robot string from deserializer
namespace string from deserializer
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/druid_intervals.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/druid_intervals.q.out b/ql/src/test/results/clientpositive/druid_intervals.q.out
index 433f15e..63f28d5 100644
--- a/ql/src/test/results/clientpositive/druid_intervals.q.out
+++ b/ql/src/test/results/clientpositive/druid_intervals.q.out
@@ -17,7 +17,6 @@ POSTHOOK: query: DESCRIBE FORMATTED druid_table_1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@druid_table_1
# col_name data_type comment
-
__time timestamp from deserializer
robot string from deserializer
namespace string from deserializer
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/druid_timeseries.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/druid_timeseries.q.out b/ql/src/test/results/clientpositive/druid_timeseries.q.out
index 0ce1abe..04db1e0 100644
--- a/ql/src/test/results/clientpositive/druid_timeseries.q.out
+++ b/ql/src/test/results/clientpositive/druid_timeseries.q.out
@@ -17,7 +17,6 @@ POSTHOOK: query: DESCRIBE FORMATTED druid_table_1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@druid_table_1
# col_name data_type comment
-
__time timestamp from deserializer
robot string from deserializer
namespace string from deserializer
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/druid_topn.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/druid_topn.q.out b/ql/src/test/results/clientpositive/druid_topn.q.out
index 052be15..5c31f85 100644
--- a/ql/src/test/results/clientpositive/druid_topn.q.out
+++ b/ql/src/test/results/clientpositive/druid_topn.q.out
@@ -17,7 +17,6 @@ POSTHOOK: query: DESCRIBE FORMATTED druid_table_1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@druid_table_1
# col_name data_type comment
-
__time timestamp from deserializer
robot string from deserializer
namespace string from deserializer
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/encrypted/encryption_insert_values.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/encrypted/encryption_insert_values.q.out b/ql/src/test/results/clientpositive/encrypted/encryption_insert_values.q.out
index e864588..9921abd 100644
--- a/ql/src/test/results/clientpositive/encrypted/encryption_insert_values.q.out
+++ b/ql/src/test/results/clientpositive/encrypted/encryption_insert_values.q.out
@@ -39,7 +39,6 @@ POSTHOOK: query: describe formatted values__tmp__table__1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@values__tmp__table__1
# col_name data_type comment
-
tmp_values_col1 string
tmp_values_col2 string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/encrypted/encryption_move_tbl.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/encrypted/encryption_move_tbl.q.out b/ql/src/test/results/clientpositive/encrypted/encryption_move_tbl.q.out
index 5ecf20d..ebe5085 100644
--- a/ql/src/test/results/clientpositive/encrypted/encryption_move_tbl.q.out
+++ b/ql/src/test/results/clientpositive/encrypted/encryption_move_tbl.q.out
@@ -59,9 +59,18 @@ PREHOOK: Input: default@encrypted_table
POSTHOOK: query: DESCRIBE FORMATTED encrypted_table key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@encrypted_table
-# 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: DESCRIBE FORMATTED encrypted_table value
PREHOOK: type: DESCTABLE
@@ -69,9 +78,18 @@ PREHOOK: Input: default@encrypted_table
POSTHOOK: query: DESCRIBE FORMATTED encrypted_table value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@encrypted_table
-# 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: ALTER TABLE default.encrypted_table RENAME TO encrypted_db.encrypted_table_2
PREHOOK: type: ALTERTABLE_RENAME
@@ -92,9 +110,18 @@ PREHOOK: Input: default@encrypted_table
POSTHOOK: query: DESCRIBE FORMATTED encrypted_table key
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@encrypted_table
-# 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: DESCRIBE FORMATTED encrypted_table value
PREHOOK: type: DESCTABLE
@@ -102,9 +129,18 @@ PREHOOK: Input: default@encrypted_table
POSTHOOK: query: DESCRIBE FORMATTED encrypted_table value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@encrypted_table
-# 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: ALTER TABLE default.encrypted_table RENAME TO default.plain_table
PREHOOK: type: ALTERTABLE_RENAME
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/escape_comments.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/escape_comments.q.out b/ql/src/test/results/clientpositive/escape_comments.q.out
index 42b9e01..ecd6331 100644
--- a/ql/src/test/results/clientpositive/escape_comments.q.out
+++ b/ql/src/test/results/clientpositive/escape_comments.q.out
@@ -85,13 +85,11 @@ POSTHOOK: query: describe formatted escape_comments_tbl1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: escape_comments_db@escape_comments_tbl1
# col_name data_type comment
-
col1 string a
b';
# Partition Information
# col_name data_type comment
-
p1 string a
b
@@ -153,7 +151,6 @@ p1 string a
# Partition Information
# col_name data_type comment
-
p1 string a
b
PREHOOK: query: show create table escape_comments_view1
@@ -170,7 +167,6 @@ POSTHOOK: query: describe formatted escape_comments_view1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: escape_comments_db@escape_comments_view1
# col_name data_type comment
-
col1 string a
b
@@ -202,8 +198,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
-
-
index2 escape_comments_tbl1 col1 escape_comments_db__escape_comments_tbl1_index2__ compact a
b
PREHOOK: query: drop database escape_comments_db cascade
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out b/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out
index 6273bbc..fe09241 100644
--- a/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out
+++ b/ql/src/test/results/clientpositive/exim_02_00_part_empty.q.out
@@ -62,7 +62,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_02_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_02_part.q.out b/ql/src/test/results/clientpositive/exim_02_part.q.out
index b98515f..cb2a593 100644
--- a/ql/src/test/results/clientpositive/exim_02_part.q.out
+++ b/ql/src/test/results/clientpositive/exim_02_part.q.out
@@ -76,7 +76,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_04_all_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_04_all_part.q.out b/ql/src/test/results/clientpositive/exim_04_all_part.q.out
index f7dfdf1..480f1ca 100644
--- a/ql/src/test/results/clientpositive/exim_04_all_part.q.out
+++ b/ql/src/test/results/clientpositive/exim_04_all_part.q.out
@@ -118,7 +118,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_04_evolved_parts.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_04_evolved_parts.q.out b/ql/src/test/results/clientpositive/exim_04_evolved_parts.q.out
index 86999f4..7cc8278 100644
--- a/ql/src/test/results/clientpositive/exim_04_evolved_parts.q.out
+++ b/ql/src/test/results/clientpositive/exim_04_evolved_parts.q.out
@@ -126,7 +126,6 @@ emp_state string 2-char code
# Partition Information
# col_name data_type comment
-
emp_country string 2-char code
emp_state string 2-char code
@@ -147,7 +146,6 @@ emp_state string 2-char code
# Partition Information
# col_name data_type comment
-
emp_country string 2-char code
emp_state string 2-char code
@@ -168,7 +166,6 @@ emp_state string 2-char code
# Partition Information
# col_name data_type comment
-
emp_country string 2-char code
emp_state string 2-char code
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_05_some_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_05_some_part.q.out b/ql/src/test/results/clientpositive/exim_05_some_part.q.out
index c35599f..b56e3a6 100644
--- a/ql/src/test/results/clientpositive/exim_05_some_part.q.out
+++ b/ql/src/test/results/clientpositive/exim_05_some_part.q.out
@@ -112,7 +112,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_06_one_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_06_one_part.q.out b/ql/src/test/results/clientpositive/exim_06_one_part.q.out
index 0ea6998..84ed946 100644
--- a/ql/src/test/results/clientpositive/exim_06_one_part.q.out
+++ b/ql/src/test/results/clientpositive/exim_06_one_part.q.out
@@ -109,7 +109,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out b/ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out
index b55a0bd..7450949 100644
--- a/ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out
+++ b/ql/src/test/results/clientpositive/exim_07_all_part_over_nonoverlap.q.out
@@ -144,7 +144,6 @@ emp_state string free-form text
# Partition Information
# col_name data_type comment
-
emp_country string iso code
emp_state string free-form text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out b/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out
index d71f36f..f4cf862 100644
--- a/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out
+++ b/ql/src/test/results/clientpositive/exim_09_part_spec_nonoverlap.q.out
@@ -152,7 +152,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_15_external_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_15_external_part.q.out b/ql/src/test/results/clientpositive/exim_15_external_part.q.out
index d24f18a..bd7bb6f 100644
--- a/ql/src/test/results/clientpositive/exim_15_external_part.q.out
+++ b/ql/src/test/results/clientpositive/exim_15_external_part.q.out
@@ -159,7 +159,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_18_part_external.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_18_part_external.q.out b/ql/src/test/results/clientpositive/exim_18_part_external.q.out
index 2ab4314..c7d11a0 100644
--- a/ql/src/test/results/clientpositive/exim_18_part_external.q.out
+++ b/ql/src/test/results/clientpositive/exim_18_part_external.q.out
@@ -117,7 +117,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_19_00_part_external_location.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_19_00_part_external_location.q.out b/ql/src/test/results/clientpositive/exim_19_00_part_external_location.q.out
index 625f91b..d617a1d 100644
--- a/ql/src/test/results/clientpositive/exim_19_00_part_external_location.q.out
+++ b/ql/src/test/results/clientpositive/exim_19_00_part_external_location.q.out
@@ -95,7 +95,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out b/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out
index 3ee28ce..e722113 100644
--- a/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out
+++ b/ql/src/test/results/clientpositive/exim_19_part_external_location.q.out
@@ -120,7 +120,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out b/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out
index e920fda..887e51c 100644
--- a/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out
+++ b/ql/src/test/results/clientpositive/exim_20_part_managed_location.q.out
@@ -120,7 +120,6 @@ emp_state string free text
# Partition Information
# col_name data_type comment
-
emp_country string two char iso code
emp_state string free text