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:44 UTC
[10/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/columnstats_tbllvl.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out b/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out
index bcab71a..f51ff4c 100644
--- a/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out
+++ b/ql/src/test/results/clientpositive/columnstats_tbllvl.q.out
@@ -285,9 +285,18 @@ PREHOOK: Input: default@uservisits_web_text_none
POSTHOOK: query: describe formatted UserVisits_web_text_none destURL
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
-
-destURL string 0 55 48.945454545454545 96 HL from deserializer
+col_name destURL
+data_type string
+min
+max
+num_nulls 0
+distinct_count 55
+avg_col_len 48.945454545454545
+max_col_len 96
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"adrevenue\":\"true\",\"avgtimeonsite\":\"true\",\"ccode\":\"true\",\"desturl\":\"true\",\"lcode\":\"true\",\"skeyword\":\"true\",\"sourceip\":\"true\",\"useragent\":\"true\",\"visitdate\":\"true\"}}
PREHOOK: query: describe formatted UserVisits_web_text_none adRevenue
PREHOOK: type: DESCTABLE
@@ -295,9 +304,18 @@ PREHOOK: Input: default@uservisits_web_text_none
POSTHOOK: query: describe 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\",\"ccode\":\"true\",\"desturl\":\"true\",\"lcode\":\"true\",\"skeyword\":\"true\",\"sourceip\":\"true\",\"useragent\":\"true\",\"visitdate\":\"true\"}}
PREHOOK: query: describe formatted UserVisits_web_text_none avgTimeOnSite
PREHOOK: type: DESCTABLE
@@ -305,9 +323,18 @@ PREHOOK: Input: default@uservisits_web_text_none
POSTHOOK: query: describe 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\",\"ccode\":\"true\",\"desturl\":\"true\",\"lcode\":\"true\",\"skeyword\":\"true\",\"sourceip\":\"true\",\"useragent\":\"true\",\"visitdate\":\"true\"}}
PREHOOK: query: CREATE TABLE empty_tab(
a int,
@@ -414,9 +441,18 @@ PREHOOK: Input: default@uservisits_web_text_none
POSTHOOK: query: describe formatted default.UserVisits_web_text_none destURL
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
-
-destURL string 0 55 48.945454545454545 96 HL from deserializer
+col_name destURL
+data_type string
+min
+max
+num_nulls 0
+distinct_count 55
+avg_col_len 48.945454545454545
+max_col_len 96
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"adrevenue\":\"true\",\"avgtimeonsite\":\"true\",\"ccode\":\"true\",\"desturl\":\"true\",\"lcode\":\"true\",\"skeyword\":\"true\",\"sourceip\":\"true\",\"useragent\":\"true\",\"visitdate\":\"true\"}}
PREHOOK: query: CREATE TABLE UserVisits_in_dummy_db (
sourceIP string,
@@ -707,9 +743,18 @@ PREHOOK: Input: dummydb@uservisits_in_dummy_db
POSTHOOK: query: describe formatted dummydb.UserVisits_in_dummy_db destURL
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: dummydb@uservisits_in_dummy_db
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-destURL string 0 55 48.945454545454545 96 HL from deserializer
+col_name destURL
+data_type string
+min
+max
+num_nulls 0
+distinct_count 55
+avg_col_len 48.945454545454545
+max_col_len 96
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"adrevenue\":\"true\",\"avgtimeonsite\":\"true\",\"ccode\":\"true\",\"desturl\":\"true\",\"lcode\":\"true\",\"skeyword\":\"true\",\"sourceip\":\"true\",\"useragent\":\"true\",\"visitdate\":\"true\"}}
PREHOOK: query: describe formatted dummydb.UserVisits_in_dummy_db adRevenue
PREHOOK: type: DESCTABLE
@@ -717,9 +762,18 @@ PREHOOK: Input: dummydb@uservisits_in_dummy_db
POSTHOOK: query: describe formatted dummydb.UserVisits_in_dummy_db adRevenue
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: dummydb@uservisits_in_dummy_db
-# 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\",\"ccode\":\"true\",\"desturl\":\"true\",\"lcode\":\"true\",\"skeyword\":\"true\",\"sourceip\":\"true\",\"useragent\":\"true\",\"visitdate\":\"true\"}}
PREHOOK: query: describe formatted dummydb.UserVisits_in_dummy_db avgTimeOnSite
PREHOOK: type: DESCTABLE
@@ -727,9 +781,18 @@ PREHOOK: Input: dummydb@uservisits_in_dummy_db
POSTHOOK: query: describe formatted dummydb.UserVisits_in_dummy_db avgTimeOnSite
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: dummydb@uservisits_in_dummy_db
-# 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\",\"ccode\":\"true\",\"desturl\":\"true\",\"lcode\":\"true\",\"skeyword\":\"true\",\"sourceip\":\"true\",\"useragent\":\"true\",\"visitdate\":\"true\"}}
PREHOOK: query: drop table dummydb.UserVisits_in_dummy_db
PREHOOK: type: DROPTABLE
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/combine3.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/combine3.q.out b/ql/src/test/results/clientpositive/combine3.q.out
index d84a7ba..c508166 100644
--- a/ql/src/test/results/clientpositive/combine3.q.out
+++ b/ql/src/test/results/clientpositive/combine3.q.out
@@ -51,7 +51,6 @@ hr string
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -69,7 +68,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/compustat_avro.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/compustat_avro.q.out b/ql/src/test/results/clientpositive/compustat_avro.q.out
index db20bef..cdf9d36 100644
--- a/ql/src/test/results/clientpositive/compustat_avro.q.out
+++ b/ql/src/test/results/clientpositive/compustat_avro.q.out
@@ -30,9 +30,18 @@ PREHOOK: Input: default@testavro
POSTHOOK: query: describe formatted testAvro col1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@testavro
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-col1 string from deserializer
+col_name col1
+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\":{\"col1\":\"true\",\"col2\":\"true\",\"col3\":\"true\",\"col4\":\"true\",\"col5\":\"true\",\"col6\":\"true\"}}
PREHOOK: query: analyze table testAvro compute statistics for columns col1,col3
PREHOOK: type: QUERY
@@ -48,7 +57,16 @@ PREHOOK: Input: default@testavro
POSTHOOK: query: describe formatted testAvro col1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@testavro
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-col1 string 0 0 0.0 0 from deserializer
+col_name col1
+data_type string
+min
+max
+num_nulls 0
+distinct_count 0
+avg_col_len 0.0
+max_col_len 0
+num_trues
+num_falses
+bitVector
+comment from deserializer
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\",\"col3\":\"true\",\"col4\":\"true\",\"col5\":\"true\",\"col6\":\"true\"}}
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/compute_stats_date.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/compute_stats_date.q.out b/ql/src/test/results/clientpositive/compute_stats_date.q.out
index 7043d52..1e6de61 100644
--- a/ql/src/test/results/clientpositive/compute_stats_date.q.out
+++ b/ql/src/test/results/clientpositive/compute_stats_date.q.out
@@ -109,9 +109,18 @@ PREHOOK: Input: default@tab_date
POSTHOOK: query: describe formatted tab_date fl_date
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@tab_date
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-fl_date date 2000-11-20 2010-10-29 0 19 HL from deserializer
+col_name fl_date
+data_type date
+min 2000-11-20
+max 2010-10-29
+num_nulls 0
+distinct_count 19
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"fl_date\":\"true\"}}
PREHOOK: query: alter table tab_date update statistics for column fl_date set ('numDVs'='19', 'highValue'='2015-01-01', 'lowValue'='0')
PREHOOK: type: ALTERTABLE_UPDATETABLESTATS
@@ -123,7 +132,16 @@ PREHOOK: Input: default@tab_date
POSTHOOK: query: describe formatted tab_date fl_date
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@tab_date
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-fl_date date 1970-01-01 2015-01-01 0 19 HL from deserializer
+col_name fl_date
+data_type date
+min 1970-01-01
+max 2015-01-01
+num_nulls 0
+distinct_count 19
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"COLUMN_STATS\":{\"fl_date\":\"true\"}}
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/confirm_initial_tbl_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/confirm_initial_tbl_stats.q.out b/ql/src/test/results/clientpositive/confirm_initial_tbl_stats.q.out
index 10dbd24..a900194 100644
--- a/ql/src/test/results/clientpositive/confirm_initial_tbl_stats.q.out
+++ b/ql/src/test/results/clientpositive/confirm_initial_tbl_stats.q.out
@@ -14,9 +14,18 @@ PREHOOK: Input: default@src
POSTHOOK: query: describe 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\"}}
PREHOOK: query: describe extended src1
PREHOOK: type: DESCTABLE
@@ -34,9 +43,18 @@ PREHOOK: Input: default@src1
POSTHOOK: query: describe formatted src1 value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@src1
-# 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
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"key\":\"true\",\"value\":\"true\"}}
PREHOOK: query: describe extended src_json
PREHOOK: type: DESCTABLE
@@ -53,9 +71,18 @@ PREHOOK: Input: default@src_json
POSTHOOK: query: describe formatted src_json json
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@src_json
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-json string 0 1 644.0 644 HL from deserializer
+col_name json
+data_type string
+min
+max
+num_nulls 0
+distinct_count 1
+avg_col_len 644.0
+max_col_len 644
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"json\":\"true\"}}
PREHOOK: query: describe extended src_sequencefile
PREHOOK: type: DESCTABLE
@@ -73,9 +100,18 @@ PREHOOK: Input: default@src_sequencefile
POSTHOOK: query: describe formatted src_sequencefile value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@src_sequencefile
-# 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: describe extended srcbucket
PREHOOK: type: DESCTABLE
@@ -93,9 +129,18 @@ PREHOOK: Input: default@srcbucket
POSTHOOK: query: describe formatted srcbucket value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcbucket
-# 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 430 6.802 7 HL from deserializer
+col_name value
+data_type string
+min
+max
+num_nulls 0
+distinct_count 430
+avg_col_len 6.802
+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: describe extended srcbucket2
PREHOOK: type: DESCTABLE
@@ -113,9 +158,18 @@ PREHOOK: Input: default@srcbucket2
POSTHOOK: query: describe formatted srcbucket2 value
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@srcbucket2
-# 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: describe extended srcpart
PREHOOK: type: DESCTABLE
@@ -130,7 +184,6 @@ hr string
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -141,9 +194,18 @@ PREHOOK: Input: default@srcpart
POSTHOOK: query: describe formatted srcpart PARTITION (ds="2008-04-09", hr="12") 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
PREHOOK: query: describe extended alltypesorc
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@alltypesorc
@@ -170,9 +232,18 @@ PREHOOK: Input: default@alltypesorc
POSTHOOK: query: describe formatted alltypesorc ctinyint
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@alltypesorc
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-ctinyint tinyint -64 62 3115 127 HL from deserializer
+col_name ctinyint
+data_type tinyint
+min -64
+max 62
+num_nulls 3115
+distinct_count 127
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"cbigint\":\"true\",\"cboolean1\":\"true\",\"cboolean2\":\"true\",\"cdouble\":\"true\",\"cfloat\":\"true\",\"cint\":\"true\",\"csmallint\":\"true\",\"cstring1\":\"true\",\"cstring2\":\"true\",\"ctimestamp1\":\"true\",\"ctimestamp2\":\"true\",\"ctinyint\":\"true\"}}
PREHOOK: query: describe formatted alltypesorc cfloat
PREHOOK: type: DESCTABLE
@@ -180,9 +251,18 @@ PREHOOK: Input: default@alltypesorc
POSTHOOK: query: describe formatted alltypesorc cfloat
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@alltypesorc
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-cfloat float -64.0 79.5530014038086 3115 131 HL from deserializer
+col_name cfloat
+data_type float
+min -64.0
+max 79.5530014038086
+num_nulls 3115
+distinct_count 131
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"cbigint\":\"true\",\"cboolean1\":\"true\",\"cboolean2\":\"true\",\"cdouble\":\"true\",\"cfloat\":\"true\",\"cint\":\"true\",\"csmallint\":\"true\",\"cstring1\":\"true\",\"cstring2\":\"true\",\"ctimestamp1\":\"true\",\"ctimestamp2\":\"true\",\"ctinyint\":\"true\"}}
PREHOOK: query: describe formatted alltypesorc ctimestamp1
PREHOOK: type: DESCTABLE
@@ -190,9 +270,18 @@ PREHOOK: Input: default@alltypesorc
POSTHOOK: query: describe formatted alltypesorc ctimestamp1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@alltypesorc
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-ctimestamp1 timestamp -30 31 3115 35 HL from deserializer
+col_name ctimestamp1
+data_type timestamp
+min -30
+max 31
+num_nulls 3115
+distinct_count 35
+avg_col_len
+max_col_len
+num_trues
+num_falses
+bitVector HL
+comment from deserializer
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"cbigint\":\"true\",\"cboolean1\":\"true\",\"cboolean2\":\"true\",\"cdouble\":\"true\",\"cfloat\":\"true\",\"cint\":\"true\",\"csmallint\":\"true\",\"cstring1\":\"true\",\"cstring2\":\"true\",\"ctimestamp1\":\"true\",\"ctimestamp2\":\"true\",\"ctinyint\":\"true\"}}
PREHOOK: query: describe formatted alltypesorc cboolean2
PREHOOK: type: DESCTABLE
@@ -200,7 +289,16 @@ PREHOOK: Input: default@alltypesorc
POSTHOOK: query: describe formatted alltypesorc cboolean2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@alltypesorc
-# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector
-
-cboolean2 boolean 3115 3983 5190 from deserializer
+col_name cboolean2
+data_type boolean
+min
+max
+num_nulls 3115
+distinct_count
+avg_col_len
+max_col_len
+num_trues 3983
+num_falses 5190
+bitVector
+comment from deserializer
COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"cbigint\":\"true\",\"cboolean1\":\"true\",\"cboolean2\":\"true\",\"cdouble\":\"true\",\"cfloat\":\"true\",\"cint\":\"true\",\"csmallint\":\"true\",\"cstring1\":\"true\",\"cstring2\":\"true\",\"ctimestamp1\":\"true\",\"ctimestamp2\":\"true\",\"ctinyint\":\"true\"}}
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/convert_enum_to_string.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/convert_enum_to_string.q.out b/ql/src/test/results/clientpositive/convert_enum_to_string.q.out
index b9b8324..d1d2f2e 100644
--- a/ql/src/test/results/clientpositive/convert_enum_to_string.q.out
+++ b/ql/src/test/results/clientpositive/convert_enum_to_string.q.out
@@ -46,5 +46,4 @@ b string
# Partition Information
# col_name data_type comment
-
b string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out b/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out
index f661c5d..e74be62 100644
--- a/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out
+++ b/ql/src/test/results/clientpositive/create_alter_list_bucketing_table1.q.out
@@ -15,7 +15,6 @@ POSTHOOK: query: describe formatted stored_as_dirs_multiple
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@stored_as_dirs_multiple
# col_name data_type comment
-
col1 string
col2 int
col3 string
@@ -62,7 +61,6 @@ POSTHOOK: query: describe formatted stored_as_dirs_multiple
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@stored_as_dirs_multiple
# col_name data_type comment
-
col1 string
col2 int
col3 string
@@ -109,7 +107,6 @@ POSTHOOK: query: describe formatted stored_as_dirs_multiple
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@stored_as_dirs_multiple
# col_name data_type comment
-
col1 string
col2 int
col3 string
@@ -164,7 +161,6 @@ POSTHOOK: query: describe formatted stored_as_dirs_single
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@stored_as_dirs_single
# col_name data_type comment
-
key string
value string
@@ -211,7 +207,6 @@ POSTHOOK: query: describe formatted stored_as_dirs_single
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@stored_as_dirs_single
# col_name data_type comment
-
key string
value string
@@ -257,7 +252,6 @@ POSTHOOK: query: describe formatted stored_as_dirs_single
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@stored_as_dirs_single
# col_name data_type comment
-
key string
value string
@@ -304,7 +298,6 @@ POSTHOOK: query: describe formatted stored_as_dirs_single_like
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@stored_as_dirs_single_like
# col_name data_type comment
-
key string
value string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_like.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_like.q.out b/ql/src/test/results/clientpositive/create_like.q.out
index a5c0c73..7c26a59 100644
--- a/ql/src/test/results/clientpositive/create_like.q.out
+++ b/ql/src/test/results/clientpositive/create_like.q.out
@@ -13,7 +13,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table1
# col_name data_type comment
-
a string
b string
@@ -56,7 +55,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table2
# col_name data_type comment
-
a string
b string
@@ -107,7 +105,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table3
# col_name data_type comment
-
a string
b string
@@ -342,7 +339,6 @@ POSTHOOK: query: DESCRIBE FORMATTED doctors
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@doctors
# col_name data_type comment
-
number int Order of playing the role
first_name string first name of actor playing role
last_name string last name of actor playing role
@@ -411,7 +407,6 @@ POSTHOOK: query: DESCRIBE FORMATTED doctors2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@doctors2
# col_name data_type comment
-
number int Order of playing the role
first_name string first name of actor playing role
last_name string last name of actor playing role
@@ -485,7 +480,6 @@ POSTHOOK: query: DESCRIBE FORMATTED LikePropertiedParquetTable
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@likepropertiedparquettable
# col_name data_type comment
-
a int
b string
@@ -529,7 +523,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table5
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table5
# col_name data_type comment
-
col1 int
col2 string
@@ -572,7 +565,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table6
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table6
# col_name data_type comment
-
col1 int
col2 string
@@ -625,7 +617,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table6
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table6
# col_name data_type comment
-
col1 int
col2 string
@@ -683,7 +674,6 @@ POSTHOOK: query: describe formatted orc_table_using_like
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@orc_table_using_like
# col_name data_type comment
-
time string
# Detailed Table Information
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_like2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_like2.q.out b/ql/src/test/results/clientpositive/create_like2.q.out
index 157c3c9..601b929 100644
--- a/ql/src/test/results/clientpositive/create_like2.q.out
+++ b/ql/src/test/results/clientpositive/create_like2.q.out
@@ -29,7 +29,6 @@ POSTHOOK: query: DESC FORMATTED table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table2
# col_name data_type comment
-
a int
b string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_like_tbl_props.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_like_tbl_props.q.out b/ql/src/test/results/clientpositive/create_like_tbl_props.q.out
index c242f3d..e324749 100644
--- a/ql/src/test/results/clientpositive/create_like_tbl_props.q.out
+++ b/ql/src/test/results/clientpositive/create_like_tbl_props.q.out
@@ -13,7 +13,6 @@ POSTHOOK: query: DESC FORMATTED test_table
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_table
# col_name data_type comment
-
key string default
value string default
@@ -57,7 +56,6 @@ POSTHOOK: query: DESC FORMATTED test_table1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_table1
# col_name data_type comment
-
key string default
value string default
@@ -101,7 +99,6 @@ POSTHOOK: query: DESC FORMATTED test_table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_table2
# col_name data_type comment
-
key string default
value string default
@@ -146,7 +143,6 @@ POSTHOOK: query: DESC FORMATTED test_table3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_table3
# col_name data_type comment
-
key string default
value string default
@@ -203,7 +199,6 @@ POSTHOOK: query: DESC FORMATTED test_table4
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@test_table4
# col_name data_type comment
-
key string
value string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_like_view.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_like_view.q.out b/ql/src/test/results/clientpositive/create_like_view.q.out
index 756934b..25b927b 100644
--- a/ql/src/test/results/clientpositive/create_like_view.q.out
+++ b/ql/src/test/results/clientpositive/create_like_view.q.out
@@ -37,7 +37,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table1
# col_name data_type comment
-
a string
b string
@@ -100,7 +99,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table2
# col_name data_type comment
-
a string
b string
@@ -159,7 +157,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table3
# col_name data_type comment
-
a string
b string
@@ -278,13 +275,11 @@ POSTHOOK: query: describe formatted table1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table1
# 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/create_or_replace_view.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_or_replace_view.q.out b/ql/src/test/results/clientpositive/create_or_replace_view.q.out
index 6cf1e5a..8383951 100644
--- a/ql/src/test/results/clientpositive/create_or_replace_view.q.out
+++ b/ql/src/test/results/clientpositive/create_or_replace_view.q.out
@@ -25,7 +25,6 @@ POSTHOOK: query: describe formatted vt.v
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: vt@v
# col_name data_type comment
-
key string
value string
ds string
@@ -110,13 +109,11 @@ POSTHOOK: query: describe formatted vt.v
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: vt@v
# col_name data_type comment
-
key string
value string
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -209,12 +206,10 @@ POSTHOOK: query: describe formatted vt.v
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: vt@v
# col_name data_type comment
-
value string
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -283,13 +278,11 @@ POSTHOOK: query: describe formatted vt.v
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: vt@v
# col_name data_type comment
-
key string
value string
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -381,13 +374,11 @@ POSTHOOK: query: describe formatted vt.v
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: vt@v
# 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/create_skewed_table1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_skewed_table1.q.out b/ql/src/test/results/clientpositive/create_skewed_table1.q.out
index df927a7..cc647a3 100644
--- a/ql/src/test/results/clientpositive/create_skewed_table1.q.out
+++ b/ql/src/test/results/clientpositive/create_skewed_table1.q.out
@@ -29,7 +29,6 @@ POSTHOOK: query: describe formatted list_bucket_single_2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@list_bucket_single_2
# col_name data_type comment
-
key string
value string
@@ -66,7 +65,6 @@ POSTHOOK: query: describe formatted list_bucket_single
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@list_bucket_single
# col_name data_type comment
-
key string
value string
@@ -103,7 +101,6 @@ POSTHOOK: query: describe formatted list_bucket_multiple
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@list_bucket_multiple
# col_name data_type comment
-
col1 string
col2 int
col3 string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_table_like_stats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_table_like_stats.q.out b/ql/src/test/results/clientpositive/create_table_like_stats.q.out
index bd559c0..f88c50c 100644
--- a/ql/src/test/results/clientpositive/create_table_like_stats.q.out
+++ b/ql/src/test/results/clientpositive/create_table_like_stats.q.out
@@ -17,7 +17,6 @@ POSTHOOK: query: desc formatted a
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@a
# col_name data_type comment
-
key string default
value string default
@@ -70,7 +69,6 @@ POSTHOOK: query: desc formatted a
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@a
# col_name data_type comment
-
key string default
value string default
@@ -122,13 +120,11 @@ POSTHOOK: query: desc formatted a
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@a
# col_name data_type comment
-
key string default
value string default
# Partition Information
# col_name data_type comment
-
ds string
hr string
@@ -180,13 +176,11 @@ POSTHOOK: query: desc formatted a
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@a
# col_name data_type comment
-
key string default
value string default
# Partition Information
# col_name data_type comment
-
ds string
hr string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_view.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_view.q.out b/ql/src/test/results/clientpositive/create_view.q.out
index 823b716..8763fdb 100644
--- a/ql/src/test/results/clientpositive/create_view.q.out
+++ b/ql/src/test/results/clientpositive/create_view.q.out
@@ -247,7 +247,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view1
# col_name data_type comment
-
value string
# Detailed Table Information
@@ -296,7 +295,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view2
# col_name data_type comment
-
key string
value string
@@ -344,7 +342,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view3
# col_name data_type comment
-
valoo string
# Detailed Table Information
@@ -393,7 +390,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view3
# col_name data_type comment
-
valoo string
# Detailed Table Information
@@ -739,7 +735,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view8
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view8
# col_name data_type comment
-
c string
# Detailed Table Information
@@ -817,7 +812,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view9
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view9
# col_name data_type comment
-
m int
# Detailed Table Information
@@ -895,7 +889,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view9
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view9
# col_name data_type comment
-
m int
# Detailed Table Information
@@ -963,7 +956,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view10
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view10
# col_name data_type comment
-
key string
value string
@@ -1040,7 +1032,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view11
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view11
# col_name data_type comment
-
boom int
# Detailed Table Information
@@ -1112,7 +1103,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view12
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view12
# col_name data_type comment
-
key string
value string
mycol int
@@ -1197,7 +1187,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view13
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view13
# col_name data_type comment
-
key int
# Detailed Table Information
@@ -1318,7 +1307,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view14
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view14
# col_name data_type comment
-
k1 string
v1 string
k2 string
@@ -1437,7 +1425,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view15
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view15
# col_name data_type comment
-
key string
value_count bigint
@@ -1523,7 +1510,6 @@ POSTHOOK: query: DESCRIBE FORMATTED view16
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@view16
# col_name data_type comment
-
value string
# Detailed Table Information
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_view_defaultformats.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_view_defaultformats.q.out b/ql/src/test/results/clientpositive/create_view_defaultformats.q.out
index 1ac20c2..71df2b2 100644
--- a/ql/src/test/results/clientpositive/create_view_defaultformats.q.out
+++ b/ql/src/test/results/clientpositive/create_view_defaultformats.q.out
@@ -37,7 +37,6 @@ POSTHOOK: query: describe formatted sfsrc
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@sfsrc
# col_name data_type comment
-
key string
value string
@@ -69,7 +68,6 @@ POSTHOOK: query: describe formatted rcsrc
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@rcsrc
# col_name data_type comment
-
key string
value string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_view_partitioned.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_view_partitioned.q.out b/ql/src/test/results/clientpositive/create_view_partitioned.q.out
index b1bf7d6..fc90317 100644
--- a/ql/src/test/results/clientpositive/create_view_partitioned.q.out
+++ b/ql/src/test/results/clientpositive/create_view_partitioned.q.out
@@ -42,7 +42,6 @@ value string
# Partition Information
# col_name data_type comment
-
value string
#### A masked pattern was here ####
@@ -57,12 +56,10 @@ POSTHOOK: query: DESCRIBE FORMATTED vp1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@vp1
# col_name data_type comment
-
key string
# Partition Information
# col_name data_type comment
-
value string
# Detailed Table Information
@@ -256,14 +253,12 @@ POSTHOOK: query: DESCRIBE FORMATTED vp2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@vp2
# col_name data_type comment
-
key string
value string
ds string
# Partition Information
# col_name data_type comment
-
hr string
# Detailed Table Information
@@ -375,12 +370,10 @@ POSTHOOK: query: DESCRIBE FORMATTED vp3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@vp3
# col_name data_type comment
-
k string
# Partition Information
# col_name data_type comment
-
v string
# Detailed Table Information
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_view_translate.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_view_translate.q.out b/ql/src/test/results/clientpositive/create_view_translate.q.out
index db9fd78..e574897 100644
--- a/ql/src/test/results/clientpositive/create_view_translate.q.out
+++ b/ql/src/test/results/clientpositive/create_view_translate.q.out
@@ -24,7 +24,6 @@ POSTHOOK: query: describe formatted v
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@v
# col_name data_type comment
-
key string
# Detailed Table Information
@@ -71,7 +70,6 @@ POSTHOOK: query: describe formatted w
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@w
# col_name data_type comment
-
key string
value string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/create_with_constraints.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/create_with_constraints.q.out b/ql/src/test/results/clientpositive/create_with_constraints.q.out
index 50a6d05..a675a0e 100644
--- a/ql/src/test/results/clientpositive/create_with_constraints.q.out
+++ b/ql/src/test/results/clientpositive/create_with_constraints.q.out
@@ -358,7 +358,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table1
# col_name data_type comment
-
a string
b string
@@ -400,7 +399,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table2
# col_name data_type comment
-
a string
b string
@@ -442,7 +440,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table3
# col_name data_type comment
-
x string
# Detailed Table Information
@@ -495,7 +492,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table4
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table4
# col_name data_type comment
-
x string
y string
@@ -556,7 +552,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table5
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table5
# col_name data_type comment
-
x string
# Detailed Table Information
@@ -603,7 +598,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table6
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table6
# col_name data_type comment
-
x string
y string
@@ -654,7 +648,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table7
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table7
# col_name data_type comment
-
a string
b string
@@ -696,7 +689,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table8
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table8
# col_name data_type comment
-
a string
b string
@@ -738,7 +730,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table9
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table9
# col_name data_type comment
-
a string
b string
@@ -780,7 +771,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table10
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table10
# col_name data_type comment
-
a string
b string
@@ -829,7 +819,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table11
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table11
# col_name data_type comment
-
a string
b string
c string
@@ -879,7 +868,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table12
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table12
# col_name data_type comment
-
a string
b string
@@ -922,7 +910,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table13
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table13
# col_name data_type comment
-
a string
b string
@@ -965,7 +952,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table14
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table14
# col_name data_type comment
-
a string
b string
@@ -1008,7 +994,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table15
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table15
# col_name data_type comment
-
a string
b string
@@ -1043,7 +1028,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table16
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table16
# col_name data_type comment
-
a string
b string
@@ -1078,7 +1062,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table17
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table17
# col_name data_type comment
-
a string
b string
@@ -1121,7 +1104,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table18
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table18
# col_name data_type comment
-
a string
b string
@@ -1252,7 +1234,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table2
# col_name data_type comment
-
a string
b string
@@ -1287,7 +1268,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table3
# col_name data_type comment
-
x string
# Detailed Table Information
@@ -1334,7 +1314,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table4
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table4
# col_name data_type comment
-
x string
y string
@@ -1383,7 +1362,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table6
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table6
# col_name data_type comment
-
x string
y string
@@ -1425,7 +1403,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table16
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table16
# col_name data_type comment
-
a string
b string
@@ -1460,7 +1437,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table18
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table18
# col_name data_type comment
-
a string
b string
@@ -1519,7 +1495,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table2
# col_name data_type comment
-
a string
b string
@@ -1561,7 +1536,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table3
# col_name data_type comment
-
x string
# Detailed Table Information
@@ -1614,7 +1588,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table6
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table6
# col_name data_type comment
-
x string
y string
@@ -1665,7 +1638,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table16
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table16
# col_name data_type comment
-
a string
b string
@@ -1701,7 +1673,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table18
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table18
# col_name data_type comment
-
a string
b string
@@ -1761,7 +1732,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table12
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table12
# col_name data_type comment
-
a string
b string
@@ -1808,7 +1778,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table13
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table13
# col_name data_type comment
-
a string
b string
@@ -1859,7 +1828,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table12
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@table12
# col_name data_type comment
-
a string
b string
@@ -1941,7 +1909,6 @@ POSTHOOK: query: DESCRIBE FORMATTED DbConstraint.Table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: dbconstraint@table2
# col_name data_type comment
-
a string
b string
@@ -2004,7 +1971,6 @@ POSTHOOK: query: DESCRIBE FORMATTED DbConstraint.Table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: dbconstraint@table2
# col_name data_type comment
-
a string
b string
@@ -2051,7 +2017,6 @@ POSTHOOK: query: DESCRIBE FORMATTED DbConstraint.Table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: dbconstraint@table2
# col_name data_type comment
-
a string
b string
@@ -2103,7 +2068,6 @@ POSTHOOK: query: DESCRIBE FORMATTED DbConstraint.Table2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: dbconstraint@table2
# col_name data_type comment
-
a string
b string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/ctas.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/ctas.q.out b/ql/src/test/results/clientpositive/ctas.q.out
index c1b0838..1764c6b 100644
--- a/ql/src/test/results/clientpositive/ctas.q.out
+++ b/ql/src/test/results/clientpositive/ctas.q.out
@@ -137,7 +137,6 @@ POSTHOOK: query: describe formatted nzhang_CTAS1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@nzhang_ctas1
# col_name data_type comment
-
k string
value string
@@ -288,7 +287,6 @@ POSTHOOK: query: describe formatted nzhang_CTAS2
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@nzhang_ctas2
# col_name data_type comment
-
key string
value string
@@ -439,7 +437,6 @@ POSTHOOK: query: describe formatted nzhang_CTAS3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@nzhang_ctas3
# col_name data_type comment
-
half_key double
conb string
@@ -503,7 +500,6 @@ POSTHOOK: query: describe formatted nzhang_CTAS3
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@nzhang_ctas3
# col_name data_type comment
-
half_key double
conb string
@@ -655,7 +651,6 @@ POSTHOOK: query: describe formatted nzhang_CTAS4
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@nzhang_ctas4
# col_name data_type comment
-
key string
value string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/ctas_colname.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/ctas_colname.q.out b/ql/src/test/results/clientpositive/ctas_colname.q.out
index 8d61c9d..795517d 100644
--- a/ql/src/test/results/clientpositive/ctas_colname.q.out
+++ b/ql/src/test/results/clientpositive/ctas_colname.q.out
@@ -85,7 +85,6 @@ POSTHOOK: query: describe formatted summary
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@summary
# col_name data_type comment
-
key string
value string
_c1 double
@@ -244,7 +243,6 @@ POSTHOOK: query: describe formatted x4
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@x4
# col_name data_type comment
-
key string
value string
rr int
@@ -435,7 +433,6 @@ POSTHOOK: query: describe formatted x5
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@x5
# col_name data_type comment
-
key string
value string
lead1 string
@@ -606,7 +603,6 @@ POSTHOOK: query: describe formatted x6
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@x6
# col_name data_type comment
-
key string
value string
_c1 double
@@ -757,7 +753,6 @@ POSTHOOK: query: describe formatted x7
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@x7
# col_name data_type comment
-
_col0 string
_col1 string
_c1 bigint
@@ -1191,7 +1186,6 @@ POSTHOOK: query: describe formatted x8
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@x8
# col_name data_type comment
-
_col0 string
_col1 string
_c1 bigint
@@ -1327,7 +1321,6 @@ POSTHOOK: query: describe formatted x9
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: default@x9
# col_name data_type comment
-
_c0 string
key string
http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out b/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out
index ed6d2bc..fe5cf87 100644
--- a/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out
+++ b/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out
@@ -125,7 +125,6 @@ POSTHOOK: query: DESCRIBE FORMATTED table_db1
POSTHOOK: type: DESCTABLE
POSTHOOK: Input: db1@table_db1
# col_name data_type comment
-
key string
value string