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
