http://git-wip-us.apache.org/repos/asf/hive/blob/38a594f3/ql/src/test/results/clientpositive/alter_table_column_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/alter_table_column_stats.q.out b/ql/src/test/results/clientpositive/alter_table_column_stats.q.out index b93e9de..a648335 100644 --- a/ql/src/test/results/clientpositive/alter_table_column_stats.q.out +++ b/ql/src/test/results/clientpositive/alter_table_column_stats.q.out @@ -88,7 +88,6 @@ POSTHOOK: query: describe formatted statsdb1.testtable0 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable0 # col_name data_type comment - col1 int col2 string col3 string @@ -123,9 +122,18 @@ PREHOOK: Input: statsdb1@testtable0 POSTHOOK: query: describe formatted statsdb1.testtable0 col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 10 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 10 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\",\"col3\":\"true\"}} PREHOOK: query: describe formatted statsdb1.testtable0 col2 PREHOOK: type: DESCTABLE @@ -133,9 +141,18 @@ PREHOOK: Input: statsdb1@testtable0 POSTHOOK: query: describe formatted statsdb1.testtable0 col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\",\"col3\":\"true\"}} PREHOOK: query: describe formatted statsdb1.testtable0 col3 PREHOOK: type: DESCTABLE @@ -143,9 +160,18 @@ PREHOOK: Input: statsdb1@testtable0 POSTHOOK: query: describe formatted statsdb1.testtable0 col3 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col3 string 0 1 4.0 4 HL from deserializer +col_name col3 +data_type string +min +max +num_nulls 0 +distinct_count 1 +avg_col_len 4.0 +max_col_len 4 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\",\"col3\":\"true\"}} PREHOOK: query: alter table statsdb1.testtable0 rename to statsdb1.testtable1 PREHOOK: type: ALTERTABLE_RENAME @@ -163,7 +189,6 @@ POSTHOOK: query: describe formatted statsdb1.testtable1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 # col_name data_type comment - col1 int col2 string col3 string @@ -199,9 +224,18 @@ PREHOOK: Input: statsdb1@testtable1 POSTHOOK: query: describe formatted statsdb1.testtable1 col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 10 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 10 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\",\"col3\":\"true\"}} PREHOOK: query: describe formatted statsdb1.testtable1 col2 PREHOOK: type: DESCTABLE @@ -209,9 +243,18 @@ PREHOOK: Input: statsdb1@testtable1 POSTHOOK: query: describe formatted statsdb1.testtable1 col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\",\"col3\":\"true\"}} PREHOOK: query: describe formatted statsdb1.testtable1 col3 PREHOOK: type: DESCTABLE @@ -219,9 +262,18 @@ PREHOOK: Input: statsdb1@testtable1 POSTHOOK: query: describe formatted statsdb1.testtable1 col3 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col3 string 0 1 4.0 4 HL from deserializer +col_name col3 +data_type string +min +max +num_nulls 0 +distinct_count 1 +avg_col_len 4.0 +max_col_len 4 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\",\"col3\":\"true\"}} PREHOOK: query: alter table testtable1 replace columns (col1 int, col2 string, col4 string) PREHOOK: type: ALTERTABLE_REPLACECOLS @@ -238,7 +290,6 @@ POSTHOOK: query: describe formatted statsdb1.testtable1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 # col_name data_type comment - col1 int col2 string col4 string @@ -274,9 +325,18 @@ PREHOOK: Input: statsdb1@testtable1 POSTHOOK: query: describe formatted statsdb1.testtable1 col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 10 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 10 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\"}} PREHOOK: query: describe formatted statsdb1.testtable1 col2 PREHOOK: type: DESCTABLE @@ -284,9 +344,18 @@ PREHOOK: Input: statsdb1@testtable1 POSTHOOK: query: describe formatted statsdb1.testtable1 col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\"}} PREHOOK: query: describe formatted statsdb1.testtable1 col4 PREHOOK: type: DESCTABLE @@ -294,9 +363,18 @@ PREHOOK: Input: statsdb1@testtable1 POSTHOOK: query: describe formatted statsdb1.testtable1 col4 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col4 string from deserializer +col_name col4 +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\"}} PREHOOK: query: alter table testtable1 change col1 col1 string PREHOOK: type: ALTERTABLE_RENAMECOL @@ -313,7 +391,6 @@ POSTHOOK: query: describe formatted statsdb1.testtable1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 # col_name data_type comment - col1 string col2 string col4 string @@ -349,9 +426,18 @@ PREHOOK: Input: statsdb1@testtable1 POSTHOOK: query: describe formatted statsdb1.testtable1 col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 -# 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\":{\"col2\":\"true\"}} PREHOOK: query: describe formatted statsdb1.testtable1 col2 PREHOOK: type: DESCTABLE @@ -359,9 +445,18 @@ PREHOOK: Input: statsdb1@testtable1 POSTHOOK: query: describe formatted statsdb1.testtable1 col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col2\":\"true\"}} PREHOOK: query: describe formatted statsdb1.testtable1 col4 PREHOOK: type: DESCTABLE @@ -369,9 +464,18 @@ PREHOOK: Input: statsdb1@testtable1 POSTHOOK: query: describe formatted statsdb1.testtable1 col4 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col4 string from deserializer +col_name col4 +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\":{\"col2\":\"true\"}} PREHOOK: query: alter table statsdb1.testtable1 rename to statsdb2.testtable2 PREHOOK: type: ALTERTABLE_RENAME @@ -389,7 +493,6 @@ POSTHOOK: query: describe formatted statsdb2.testtable2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testtable2 # col_name data_type comment - col1 string col2 string col4 string @@ -425,9 +528,18 @@ PREHOOK: Input: statsdb2@testtable2 POSTHOOK: query: describe formatted statsdb2.testtable2 col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testtable2 -# 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\":{\"col2\":\"true\"}} PREHOOK: query: describe formatted statsdb2.testtable2 col2 PREHOOK: type: DESCTABLE @@ -435,9 +547,18 @@ PREHOOK: Input: statsdb2@testtable2 POSTHOOK: query: describe formatted statsdb2.testtable2 col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testtable2 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col2\":\"true\"}} PREHOOK: query: describe formatted statsdb2.testtable2 col4 PREHOOK: type: DESCTABLE @@ -445,9 +566,18 @@ PREHOOK: Input: statsdb2@testtable2 POSTHOOK: query: describe formatted statsdb2.testtable2 col4 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testtable2 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col4 string from deserializer +col_name col4 +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\":{\"col2\":\"true\"}} PREHOOK: query: analyze table testpart0 compute statistics for columns PREHOOK: type: QUERY @@ -468,14 +598,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart0 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart0 # col_name data_type comment - col1 int col2 string col3 string # Partition Information # col_name data_type comment - part string # Detailed Table Information @@ -510,14 +638,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part1' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart0 # col_name data_type comment - col1 int col2 string col3 string # Partition Information # col_name data_type comment - part string # Detailed Partition Information @@ -549,27 +675,54 @@ PREHOOK: Input: statsdb1@testpart0 POSTHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part1') col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 10 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 10 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part1') col2 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart0 POSTHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part1') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part1') col3 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart0 POSTHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part1') col3 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col3 string 0 1 4.0 4 HL from deserializer +col_name col3 +data_type string +min +max +num_nulls 0 +distinct_count 1 +avg_col_len 4.0 +max_col_len 4 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part2') PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart0 @@ -577,14 +730,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part2' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart0 # col_name data_type comment - col1 int col2 string col3 string # Partition Information # col_name data_type comment - part string # Detailed Partition Information @@ -616,27 +767,54 @@ PREHOOK: Input: statsdb1@testpart0 POSTHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part2') col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 20 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 20 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part2') col2 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart0 POSTHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part2') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 20 6.8 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 20 +avg_col_len 6.8 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part2') col3 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart0 POSTHOOK: query: describe formatted statsdb1.testpart0 partition (part = 'part2') col3 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col3 string 0 1 4.0 4 HL from deserializer +col_name col3 +data_type string +min +max +num_nulls 0 +distinct_count 1 +avg_col_len 4.0 +max_col_len 4 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: alter table statsdb1.testpart0 rename to statsdb1.testpart1 PREHOOK: type: ALTERTABLE_RENAME PREHOOK: Input: statsdb1@testpart0 @@ -653,14 +831,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 int col2 string col3 string # Partition Information # col_name data_type comment - part string # Detailed Table Information @@ -696,14 +872,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part1' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 int col2 string col3 string # Partition Information # col_name data_type comment - part string # Detailed Partition Information @@ -735,27 +909,54 @@ PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part1') col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 10 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 10 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part1') col2 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part1') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part1') col3 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part1') col3 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col3 string 0 1 4.0 4 HL from deserializer +col_name col3 +data_type string +min +max +num_nulls 0 +distinct_count 1 +avg_col_len 4.0 +max_col_len 4 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 @@ -763,14 +964,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 int col2 string col3 string # Partition Information # col_name data_type comment - part string # Detailed Partition Information @@ -802,27 +1001,54 @@ PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 20 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 20 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col2 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 20 6.8 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 20 +avg_col_len 6.8 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col3 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col3 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col3 string 0 1 4.0 4 HL from deserializer +col_name col3 +data_type string +min +max +num_nulls 0 +distinct_count 1 +avg_col_len 4.0 +max_col_len 4 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: alter table statsdb1.testpart1 partition (part = 'part1') rename to partition (part = 'part11') PREHOOK: type: ALTERTABLE_RENAMEPART PREHOOK: Input: statsdb1@testpart1 @@ -840,14 +1066,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 int col2 string col3 string # Partition Information # col_name data_type comment - part string # Detailed Table Information @@ -883,14 +1107,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 int col2 string col3 string # Partition Information # col_name data_type comment - part string # Detailed Partition Information @@ -922,27 +1144,54 @@ PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 10 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 10 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col2 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col3 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col3 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col3 string 0 1 4.0 4 HL from deserializer +col_name col3 +data_type string +min +max +num_nulls 0 +distinct_count 1 +avg_col_len 4.0 +max_col_len 4 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 @@ -950,14 +1199,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 int col2 string col3 string # Partition Information # col_name data_type comment - part string # Detailed Partition Information @@ -989,27 +1236,54 @@ PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 20 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 20 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col2 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 20 6.8 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 20 +avg_col_len 6.8 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col3 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col3 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col3 string 0 1 4.0 4 HL from deserializer +col_name col3 +data_type string +min +max +num_nulls 0 +distinct_count 1 +avg_col_len 4.0 +max_col_len 4 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: alter table statsdb1.testpart1 replace columns (col1 int, col2 string, col4 string) cascade PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: statsdb1@testpart1 @@ -1029,14 +1303,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 int col2 string col4 string # Partition Information # col_name data_type comment - part string # Detailed Table Information @@ -1072,14 +1344,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 int col2 string col4 string # Partition Information # col_name data_type comment - part string # Detailed Partition Information @@ -1111,18 +1381,36 @@ PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 10 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 10 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col2 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col4 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 @@ -1130,7 +1418,6 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col4 string from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') PREHOOK: type: DESCTABLE @@ -1139,14 +1426,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 int col2 string col4 string # Partition Information # col_name data_type comment - part string # Detailed Partition Information @@ -1178,18 +1463,36 @@ PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 20 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 20 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col2 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 20 6.8 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 20 +avg_col_len 6.8 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col4 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 @@ -1197,7 +1500,6 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col4 string from deserializer PREHOOK: query: alter table statsdb1.testpart1 change column col1 col1 string cascade PREHOOK: type: ALTERTABLE_RENAMECOL @@ -1218,14 +1520,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 string col2 string col4 string # Partition Information # col_name data_type comment - part string # Detailed Table Information @@ -1261,14 +1561,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 string col2 string col4 string # Partition Information # col_name data_type comment - part string # Detailed Partition Information @@ -1301,7 +1599,6 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 string from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col2 PREHOOK: type: DESCTABLE @@ -1309,9 +1606,18 @@ PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11') col4 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 @@ -1319,7 +1625,6 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part11 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col4 string from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') PREHOOK: type: DESCTABLE @@ -1328,14 +1633,12 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 string col2 string col4 string # Partition Information # col_name data_type comment - part string # Detailed Partition Information @@ -1368,7 +1671,6 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col1 string from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col2 PREHOOK: type: DESCTABLE @@ -1376,9 +1678,18 @@ PREHOOK: Input: statsdb1@testpart1 POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 20 6.8 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 20 +avg_col_len 6.8 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2') col4 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb1@testpart1 @@ -1386,7 +1697,6 @@ POSTHOOK: query: describe formatted statsdb1.testpart1 partition (part = 'part2' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testpart1 # col_name data_type comment - col4 string from deserializer PREHOOK: query: alter table statsdb1.testpart1 rename to statsdb2.testpart2 PREHOOK: type: ALTERTABLE_RENAME @@ -1404,14 +1714,12 @@ POSTHOOK: query: describe formatted statsdb2.testpart2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testpart2 # col_name data_type comment - col1 string col2 string col4 string # Partition Information # col_name data_type comment - part string # Detailed Table Information @@ -1447,7 +1755,6 @@ POSTHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part11 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testpart2 # col_name data_type comment - col1 string from deserializer PREHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part11') col2 PREHOOK: type: DESCTABLE @@ -1455,9 +1762,18 @@ PREHOOK: Input: statsdb2@testpart2 POSTHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part11') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testpart2 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part11') col4 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb2@testpart2 @@ -1465,7 +1781,6 @@ POSTHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part11 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testpart2 # col_name data_type comment - col4 string from deserializer PREHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part2') col1 PREHOOK: type: DESCTABLE @@ -1474,7 +1789,6 @@ POSTHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part2' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testpart2 # col_name data_type comment - col1 string from deserializer PREHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part2') col2 PREHOOK: type: DESCTABLE @@ -1482,9 +1796,18 @@ PREHOOK: Input: statsdb2@testpart2 POSTHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part2') col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testpart2 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 20 6.8 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 20 +avg_col_len 6.8 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer PREHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part2') col4 PREHOOK: type: DESCTABLE PREHOOK: Input: statsdb2@testpart2 @@ -1492,7 +1815,6 @@ POSTHOOK: query: describe formatted statsdb2.testpart2 partition (part = 'part2' POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb2@testpart2 # col_name data_type comment - col4 string from deserializer PREHOOK: query: use statsdb2 PREHOOK: type: SWITCHDATABASE @@ -1628,7 +1950,6 @@ POSTHOOK: query: describe formatted statsdb1.testtable0 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable0 # col_name data_type comment - col1 int col2 string col3 string @@ -1663,9 +1984,18 @@ PREHOOK: Input: statsdb1@testtable0 POSTHOOK: query: describe formatted statsdb1.testtable0 col1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col1 int 27 484 0 10 HL from deserializer +col_name col1 +data_type int +min 27 +max 484 +num_nulls 0 +distinct_count 10 +avg_col_len +max_col_len +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\",\"col3\":\"true\"}} PREHOOK: query: describe formatted statsdb1.testtable0 col2 PREHOOK: type: DESCTABLE @@ -1673,9 +2003,18 @@ PREHOOK: Input: statsdb1@testtable0 POSTHOOK: query: describe formatted statsdb1.testtable0 col2 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col2 string 0 10 6.7 7 HL from deserializer +col_name col2 +data_type string +min +max +num_nulls 0 +distinct_count 10 +avg_col_len 6.7 +max_col_len 7 +num_trues +num_falses +bitVector HL +comment from deserializer COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"col1\":\"true\",\"col2\":\"true\",\"col3\":\"true\"}} PREHOOK: query: describe formatted statsdb1.testtable0 col3 PREHOOK: type: DESCTABLE @@ -1683,9 +2022,18 @@ PREHOOK: Input: statsdb1@testtable0 POSTHOOK: query: describe formatted statsdb1.testtable0 col3 POSTHOOK: type: DESCTABLE POSTHOOK: Input: statsdb1@testtable0 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment bitVector - -col3 string 0 1 4.0 4 HL from deserializer +col_name col3 +data_type string +min
<TRUNCATED>