http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_table.q.out b/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_table.q.out index 370900f..6936b5f 100644 --- a/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_table.q.out +++ b/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_table.q.out @@ -1982,14 +1982,14 @@ POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_var PREHOOK: query: -- -- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), STRING -- -CREATE TABLE table_change_numeric_group_string_group_floating_string(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) +CREATE TABLE table_change_numeric_group_string_group_floating_string(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table_change_numeric_group_string_group_floating_string POSTHOOK: query: -- -- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), STRING -- -CREATE TABLE table_change_numeric_group_string_group_floating_string(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) +CREATE TABLE table_change_numeric_group_string_group_floating_string(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_string @@ -2024,10 +2024,10 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string #### A masked pattern was here #### insert_num c1 c2 c3 b -1 -23866739993.000000000000000000 753.7028 -3651.672121 original -2 -10.300000000000000000 -2.0 -29.0764 original -3 -832222222.000000000000000000 255.0 4957.0 original -4 847492223.000000000000000000 0.0 20435.0 original +1 -2.38667407E10 753.7028 -3651.672121000000000000 original +2 -10.3 -2.0 -29.076400000000000000 original +3 -8.3222221E8 255.0 4957.000000000000000000 original +4 8.4749222E8 0.0 20435.000000000000000000 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_floating_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS @@ -2081,25 +2081,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: table_change_numeric_group_string_group_floating_string - Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: insert_num (type: int), c1 (type: string), c2 (type: string), c3 (type: string), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + - Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -2120,11 +2120,11 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string #### A masked pattern was here #### insert_num c1 c2 c3 b -1 -23866739993.000000000000000000 753.7028 -3651.672121 original +1 -2.38667407E10 753.7028 -3651.672121000000000000 original 10 17 90000 754072151 new -2 -10.300000000000000000 -2.0 -29.0764 original -3 -832222222.000000000000000000 255.0 4957.0 original -4 847492223.000000000000000000 0.0 20435.0 original +2 -10.3 -2.0 -29.076400000000000000 original +3 -8.3222221E8 255.0 4957.000000000000000000 original +4 8.4749222E8 0.0 20435.000000000000000000 original 5 30.774 20.31 46114.284799488 new 6 -66475.561431 52927714 7203778961 new 7 256 32768 31889 new @@ -2139,16 +2139,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_string PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR -- -CREATE TABLE table_change_numeric_group_string_group_floating_char(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) +CREATE TABLE table_change_numeric_group_string_group_floating_char(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table_change_numeric_group_string_group_floating_char POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR -- -CREATE TABLE table_change_numeric_group_string_group_floating_char(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) +CREATE TABLE table_change_numeric_group_string_group_floating_char(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_char @@ -2183,10 +2183,10 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char #### A masked pattern was here #### insert_num c1 c2 c3 b -1 -23866739993.000000000000000000 753.7028 -3651.672121 original -2 -10.300000000000000000 -2.0 -29.0764 original -3 9000000000.000000000000000000 -255.0 4957.0 original -4 -999999999999.000000000000000000 0.0 20435.0 original +1 -2.38667407E10 753.7028 -3651.672121000000000000 original +2 -10.3 -2.0 -29.076400000000000000 original +3 8.9999995E9 -255.0 4957.000000000000000000 original +4 -1.0E12 0.0 20435.000000000000000000 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_floating_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS @@ -2240,25 +2240,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: table_change_numeric_group_string_group_floating_char - Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: insert_num (type: int), c1 (type: char(50)), c2 (type: char(50)), c3 (type: char(50)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + - Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: char(50)), _col2 (type: char(50)), _col3 (type: char(50)), _col4 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: char(50)), VALUE._col1 (type: char(50)), VALUE._col2 (type: char(50)), VALUE._col3 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -2279,11 +2279,11 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char #### A masked pattern was here #### insert_num c1 c2 c3 b -1 -23866739993.000000000000000000 753.7028 -3651.672121 original +1 -2.38667407E10 753.7028 -3651.672121000000000000 original 10 17 90000 754072151 new -2 -10.300000000000000000 -2.0 -29.0764 original -3 9000000000.000000000000000000 -255.0 4957.0 original -4 -999999999999.000000000000000000 0.0 20435.0 original +2 -10.3 -2.0 -29.076400000000000000 original +3 8.9999995E9 -255.0 4957.000000000000000000 original +4 -1.0E12 0.0 20435.000000000000000000 original 5 30.774 20.31 46114.284799488 new 6 -66475.561431 52927714 7203778961 new 7 256 32768 31889 new @@ -2298,16 +2298,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_char PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR truncation +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR truncation -- -CREATE TABLE table_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) +CREATE TABLE table_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table_change_numeric_group_string_group_floating_char_trunc POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR truncation +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR truncation -- -CREATE TABLE table_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) +CREATE TABLE table_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_char_trunc @@ -2342,10 +2342,10 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char_trunc #### A masked pattern was here #### insert_num c1 c2 c3 b -1 -23866739993.000000000000000000 753.7028 -3651.672121 original -2 -10.300000000000000000 -2.0 -29.0764 original -3 832222222.000000000000000000 -255.0 4957.0 original -4 847492223.000000000000000000 0.0 20435.0 original +1 -2.38667407E10 753.7028 -3651.672121000000000000 original +2 -10.3 -2.0 -29.076400000000000000 original +3 8.3222221E8 -255.0 4957.000000000000000000 original +4 8.4749222E8 0.0 20435.000000000000000000 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_floating_char_trunc replace columns (insert_num int, c1 CHAR(7), c2 CHAR(7), c3 CHAR(7), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS @@ -2399,25 +2399,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: table_change_numeric_group_string_group_floating_char_trunc - Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: insert_num (type: int), c1 (type: char(7)), c2 (type: char(7)), c3 (type: char(7)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + - Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: char(7)), _col2 (type: char(7)), _col3 (type: char(7)), _col4 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: char(7)), VALUE._col1 (type: char(7)), VALUE._col2 (type: char(7)), VALUE._col3 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -2438,11 +2438,11 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char_trunc #### A masked pattern was here #### insert_num c1 c2 c3 b -1 -238667 753.702 -3651.6 original +1 -2.3866 753.702 -3651.6 original 10 17 90000 7540721 new -2 -10.300 -2.0 -29.076 original -3 8322222 -255.0 4957.0 original -4 8474922 0.0 20435.0 original +2 -10.3 -2.0 -29.076 original +3 8.32222 -255.0 4957.00 original +4 8.47492 0.0 20435.0 original 5 30.774 20.31 46114.2 new 6 -66475. 5292771 7203778 new 7 256 32768 31889 new @@ -2457,14 +2457,14 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char_trunc POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_char_trunc PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR -- CREATE TABLE table_change_numeric_group_string_group_floating_varchar(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR -- CREATE TABLE table_change_numeric_group_string_group_floating_varchar(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) POSTHOOK: type: CREATETABLE @@ -2616,16 +2616,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR truncation +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR truncation -- -CREATE TABLE table_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) +CREATE TABLE table_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar_trunc POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR truncation +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR truncation -- -CREATE TABLE table_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) +CREATE TABLE table_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar_trunc @@ -2660,10 +2660,10 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar_trunc #### A masked pattern was here #### insert_num c1 c2 c3 b -1 -23866739993.000000000000000000 753.7028 -3651.672121 original -2 -10.300000000000000000 -2.0 -29.0764 original -3 9000000000.000000000000000000 -255.0 4957.0 original -4 -999999999999.000000000000000000 0.0 20435.0 original +1 -2.38667407E10 753.7028 -3651.672121000000000000 original +2 -10.3 -2.0 -29.076400000000000000 original +3 8.9999995E9 -255.0 4957.000000000000000000 original +4 -1.0E12 0.0 20435.000000000000000000 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... alter table table_change_numeric_group_string_group_floating_varchar_trunc replace columns (insert_num int, c1 VARCHAR(7), c2 VARCHAR(7), c3 VARCHAR(7), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS @@ -2717,25 +2717,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: table_change_numeric_group_string_group_floating_varchar_trunc - Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: insert_num (type: int), c1 (type: varchar(7)), c2 (type: varchar(7)), c3 (type: varchar(7)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + - Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: varchar(7)), _col2 (type: varchar(7)), _col3 (type: varchar(7)), _col4 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: varchar(7)), VALUE._col1 (type: varchar(7)), VALUE._col2 (type: varchar(7)), VALUE._col3 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 - Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -2756,11 +2756,11 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar_trunc #### A masked pattern was here #### insert_num c1 c2 c3 b -1 -238667 753.702 -3651.6 original +1 -2.3866 753.702 -3651.6 original 10 17 90000 7540721 new -2 -10.300 -2.0 -29.076 original -3 9000000 -255.0 4957.0 original -4 -999999 0.0 20435.0 original +2 -10.3 -2.0 -29.076 original +3 8.99999 -255.0 4957.00 original +4 -1.0E12 0.0 20435.0 original 5 30.774 20.31 46114.2 new 6 -66475. 5292771 7203778 new 7 256 32768 31889 new @@ -3266,7 +3266,7 @@ PREHOOK: query: ---------------------------------------------------------------- -- -- -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, FLOAT, DOUBLE, DECIMAL) -- CREATE TABLE table_change_lower_to_higher_numeric_group_tinyint(insert_num int, c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, b STRING) PREHOOK: type: CREATETABLE @@ -3277,7 +3277,7 @@ POSTHOOK: query: --------------------------------------------------------------- -- -- -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, FLOAT, DOUBLE, DECIMAL) -- CREATE TABLE table_change_lower_to_higher_numeric_group_tinyint(insert_num int, c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, b STRING) POSTHOOK: type: CREATETABLE @@ -3322,12 +3322,12 @@ insert_num c1 c2 c3 c4 c5 c6 b 3 NULL NULL NULL NULL NULL NULL original 4 100 100 100 100 100 100 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 FLOAT, c5 DOUBLE, c6 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_tinyint POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 FLOAT, c5 DOUBLE, c6 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_tinyint @@ -3379,18 +3379,18 @@ STAGE PLANS: alias: table_change_lower_to_higher_numeric_group_tinyint Statistics: Num rows: 4 Data size: 118 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: insert_num (type: int), c1 (type: smallint), c2 (type: int), c3 (type: bigint), c4 (type: decimal(38,18)), c5 (type: float), c6 (type: double), b (type: string) + expressions: insert_num (type: int), c1 (type: smallint), c2 (type: int), c3 (type: bigint), c4 (type: float), c5 (type: double), c6 (type: decimal(38,18)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 4 Data size: 118 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Statistics: Num rows: 4 Data size: 118 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: decimal(38,18)), _col5 (type: float), _col6 (type: double), _col7 (type: string) + value expressions: _col1 (type: smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: decimal(38,18)), _col7 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: smallint), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: decimal(38,18)), VALUE._col4 (type: float), VALUE._col5 (type: double), VALUE._col6 (type: string) + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: smallint), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: float), VALUE._col4 (type: double), VALUE._col5 (type: decimal(38,18)), VALUE._col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 4 Data size: 118 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -3416,16 +3416,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint #### A masked pattern was here #### insert_num c1 c2 c3 c4 c5 c6 b -1 45 45 45 45.000000000000000000 45.0 45.0 original -10 17 90000 754072151 95.000000000000000000 20.0 18.0 new -2 -2 -2 -2 -2.000000000000000000 -2.0 -2.0 original +1 45 45 45 45.0 45.0 45.000000000000000000 original +10 17 90000 754072151 95.0 20.0 18.000000000000000000 new +2 -2 -2 -2 -2.0 -2.0 -2.000000000000000000 original 3 NULL NULL NULL NULL NULL NULL original -4 100 100 100 100.000000000000000000 100.0 100.0 original -5 774 2031 200 12.000000000000000000 99.0 0.0 new -6 NULL 52927714 7203778961 8.000000000000000000 7.0 6.0 new -7 256 32768 31889 300.000000000000000000 444.0 506.0 new -8 5555 40000 -719017797 45.000000000000000000 55.0 65.0 new -9 100 5000 5443 22.000000000000000000 2.0 -2.0 new +4 100 100 100 100.0 100.0 100.000000000000000000 original +5 774 2031 200 12.0 99.0 0.000000000000000000 new +6 NULL 52927714 7203778961 8.0 7.0 6.000000000000000000 new +7 256 32768 31889 300.0 444.0 506.000000000000000000 new +8 5555 40000 -719017797 45.0 55.0 65.000000000000000000 new +9 100 5000 5443 22.0 2.0 -2.000000000000000000 new PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_tinyint PREHOOK: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint @@ -3435,14 +3435,14 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_tinyint PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, DECIMAL, FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, FLOAT, DOUBLE, DECIMAL) -- CREATE TABLE table_change_lower_to_higher_numeric_group_smallint(insert_num int, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint, b STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_smallint POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, DECIMAL, FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, FLOAT, DOUBLE, DECIMAL) -- CREATE TABLE table_change_lower_to_higher_numeric_group_smallint(insert_num int, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint, b STRING) POSTHOOK: type: CREATETABLE @@ -3486,12 +3486,12 @@ insert_num c1 c2 c3 c4 c5 b 3 -5000 -5000 -5000 -5000 -5000 original 4 100 100 100 100 100 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 decimal(38,18), c4 FLOAT, c5 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 FLOAT, c4 DOUBLE, c5 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_smallint POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 decimal(38,18), c4 FLOAT, c5 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 FLOAT, c4 DOUBLE, c5 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_smallint @@ -3542,18 +3542,18 @@ STAGE PLANS: alias: table_change_lower_to_higher_numeric_group_smallint Statistics: Num rows: 4 Data size: 130 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: insert_num (type: int), c1 (type: int), c2 (type: bigint), c3 (type: decimal(38,18)), c4 (type: float), c5 (type: double), b (type: string) + expressions: insert_num (type: int), c1 (type: int), c2 (type: bigint), c3 (type: float), c4 (type: double), c5 (type: decimal(38,18)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 4 Data size: 130 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Statistics: Num rows: 4 Data size: 130 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: decimal(38,18)), _col4 (type: float), _col5 (type: double), _col6 (type: string) + value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: double), _col5 (type: decimal(38,18)), _col6 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: decimal(38,18)), VALUE._col3 (type: float), VALUE._col4 (type: double), VALUE._col5 (type: string) + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: float), VALUE._col3 (type: double), VALUE._col4 (type: decimal(38,18)), VALUE._col5 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6 Statistics: Num rows: 4 Data size: 130 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -3579,16 +3579,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint #### A masked pattern was here #### insert_num c1 c2 c3 c4 c5 b -1 2031 2031 2031.000000000000000000 2031.0 2031.0 original -10 17 90000 754072151.000000000000000000 95.0 20.0 new -2 -2 -2 -2.000000000000000000 -2.0 -2.0 original -3 -5000 -5000 -5000.000000000000000000 -5000.0 -5000.0 original -4 100 100 100.000000000000000000 100.0 100.0 original -5 774 2031 200.000000000000000000 12.0 99.0 new -6 561431 52927714 7203778961.000000000000000000 8.0 7.0 new -7 256 32768 31889.000000000000000000 300.0 444.0 new -8 5555 40000 -719017797.000000000000000000 45.0 55.0 new -9 100 5000 5443.000000000000000000 22.0 2.0 new +1 2031 2031 2031.0 2031.0 2031.000000000000000000 original +10 17 90000 7.5407213E8 95.0 20.000000000000000000 new +2 -2 -2 -2.0 -2.0 -2.000000000000000000 original +3 -5000 -5000 -5000.0 -5000.0 -5000.000000000000000000 original +4 100 100 100.0 100.0 100.000000000000000000 original +5 774 2031 200.0 12.0 99.000000000000000000 new +6 561431 52927714 7.2037791E9 8.0 7.000000000000000000 new +7 256 32768 31889.0 300.0 444.000000000000000000 new +8 5555 40000 -7.1901779E8 45.0 55.000000000000000000 new +9 100 5000 5443.0 22.0 2.000000000000000000 new PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_smallint PREHOOK: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint @@ -3598,14 +3598,14 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_smallint PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, DECIMAL, FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, FLOAT, DOUBLE, DECIMAL) -- CREATE TABLE table_change_lower_to_higher_numeric_group_int(insert_num int, c1 int, c2 int, c3 int, c4 int, b STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_int POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, DECIMAL, FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, FLOAT, DOUBLE, DECIMAL) -- CREATE TABLE table_change_lower_to_higher_numeric_group_int(insert_num int, c1 int, c2 int, c3 int, c4 int, b STRING) POSTHOOK: type: CREATETABLE @@ -3648,12 +3648,12 @@ insert_num c1 c2 c3 c4 b 3 -5000 -5000 -5000 -5000 original 4 52927714 52927714 52927714 52927714 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 decimal(38,18), c3 FLOAT, c4 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 FLOAT, c3 DOUBLE, c4 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_int PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_int POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 decimal(38,18), c3 FLOAT, c4 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 FLOAT, c3 DOUBLE, c4 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_int POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_int @@ -3703,18 +3703,18 @@ STAGE PLANS: alias: table_change_lower_to_higher_numeric_group_int Statistics: Num rows: 4 Data size: 132 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: insert_num (type: int), c1 (type: bigint), c2 (type: decimal(38,18)), c3 (type: float), c4 (type: double), b (type: string) + expressions: insert_num (type: int), c1 (type: bigint), c2 (type: float), c3 (type: double), c4 (type: decimal(38,18)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 4 Data size: 132 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Statistics: Num rows: 4 Data size: 132 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: bigint), _col2 (type: decimal(38,18)), _col3 (type: float), _col4 (type: double), _col5 (type: string) + value expressions: _col1 (type: bigint), _col2 (type: float), _col3 (type: double), _col4 (type: decimal(38,18)), _col5 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: bigint), VALUE._col1 (type: decimal(38,18)), VALUE._col2 (type: float), VALUE._col3 (type: double), VALUE._col4 (type: string) + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: bigint), VALUE._col1 (type: float), VALUE._col2 (type: double), VALUE._col3 (type: decimal(38,18)), VALUE._col4 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 4 Data size: 132 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -3740,16 +3740,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_int #### A masked pattern was here #### insert_num c1 c2 c3 c4 b -1 2031 2031.000000000000000000 2031.0 2031.0 original -10 17 90000.000000000000000000 7.5407213E8 95.0 new -2 -2 -2.000000000000000000 -2.0 -2.0 original -3 -5000 -5000.000000000000000000 -5000.0 -5000.0 original -4 52927714 52927714.000000000000000000 5.2927712E7 5.2927714E7 original -5 774 2031.000000000000000000 200.0 12.0 new -6 561431 52927714.000000000000000000 7.2037791E9 8.0 new -7 256 32768.000000000000000000 31889.0 300.0 new -8 5555 40000.000000000000000000 -7.1901779E8 45.0 new -9 100 5000.000000000000000000 5443.0 22.0 new +1 2031 2031.0 2031.0 2031.000000000000000000 original +10 17 90000.0 7.54072151E8 95.000000000000000000 new +2 -2 -2.0 -2.0 -2.000000000000000000 original +3 -5000 -5000.0 -5000.0 -5000.000000000000000000 original +4 52927714 5.2927712E7 5.2927714E7 52927714.000000000000000000 original +5 774 2031.0 200.0 12.000000000000000000 new +6 561431 5.2927712E7 7.203778961E9 8.000000000000000000 new +7 256 32768.0 31889.0 300.000000000000000000 new +8 5555 40000.0 -7.19017797E8 45.000000000000000000 new +9 100 5000.0 5443.0 22.000000000000000000 new PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_int PREHOOK: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_int @@ -3759,14 +3759,14 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_int POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_int PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (DECIMAL, FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (FLOAT, DOUBLE, DECIMAL) -- CREATE TABLE table_change_lower_to_higher_numeric_group_bigint(insert_num int, c1 bigint, c2 bigint, c3 bigint, b STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (DECIMAL, FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (FLOAT, DOUBLE, DECIMAL) -- CREATE TABLE table_change_lower_to_higher_numeric_group_bigint(insert_num int, c1 bigint, c2 bigint, c3 bigint, b STRING) POSTHOOK: type: CREATETABLE @@ -3808,12 +3808,12 @@ insert_num c1 c2 c3 b 3 -5000 -5000 -5000 original 4 52927714 52927714 52927714 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 FLOAT, c2 DOUBLE, c3 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 FLOAT, c2 DOUBLE, c3 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint @@ -3862,18 +3862,18 @@ STAGE PLANS: alias: table_change_lower_to_higher_numeric_group_bigint Statistics: Num rows: 4 Data size: 127 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: insert_num (type: int), c1 (type: decimal(38,18)), c2 (type: float), c3 (type: double), b (type: string) + expressions: insert_num (type: int), c1 (type: float), c2 (type: double), c3 (type: decimal(38,18)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 4 Data size: 127 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Statistics: Num rows: 4 Data size: 127 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: decimal(38,18)), _col2 (type: float), _col3 (type: double), _col4 (type: string) + value expressions: _col1 (type: float), _col2 (type: double), _col3 (type: decimal(38,18)), _col4 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: decimal(38,18)), VALUE._col1 (type: float), VALUE._col2 (type: double), VALUE._col3 (type: string) + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: float), VALUE._col1 (type: double), VALUE._col2 (type: decimal(38,18)), VALUE._col3 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 4 Data size: 127 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -3899,16 +3899,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint #### A masked pattern was here #### insert_num c1 c2 c3 b -1 7203778961.000000000000000000 7.2037791E9 7.203778961E9 original -10 17.000000000000000000 90000.0 7.54072151E8 new -2 -2.000000000000000000 -2.0 -2.0 original -3 -5000.000000000000000000 -5000.0 -5000.0 original -4 52927714.000000000000000000 5.2927712E7 5.2927714E7 original -5 774.000000000000000000 2031.0 200.0 new -6 561431.000000000000000000 5.2927712E7 7.203778961E9 new -7 256.000000000000000000 32768.0 31889.0 new -8 5555.000000000000000000 40000.0 -7.19017797E8 new -9 100.000000000000000000 5000.0 5443.0 new +1 7.2037791E9 7.203778961E9 7203778961.000000000000000000 original +10 17.0 90000.0 754072151.000000000000000000 new +2 -2.0 -2.0 -2.000000000000000000 original +3 -5000.0 -5000.0 -5000.000000000000000000 original +4 5.2927712E7 5.2927714E7 52927714.000000000000000000 original +5 774.0 2031.0 200.000000000000000000 new +6 561431.0 5.2927714E7 7203778961.000000000000000000 new +7 256.0 32768.0 31889.000000000000000000 new +8 5555.0 40000.0 -719017797.000000000000000000 new +9 100.0 5000.0 5443.000000000000000000 new PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_bigint PREHOOK: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint @@ -3918,47 +3918,47 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (FLOAT, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, c2 float, b STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default -PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal +PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (FLOAT, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, c2 float, b STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default -POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal -PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_decimal +POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float +PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float values (1, -29.0764, -29.0764, 'original'), (2, 753.7028, 753.7028, 'original'), (3, -5000, -5000, 'original'), (4, 52927714, 52927714, 'original') PREHOOK: type: QUERY PREHOOK: Input: default@values__tmp__table__49 -PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal -POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_decimal +PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float +POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float values (1, -29.0764, -29.0764, 'original'), (2, 753.7028, 753.7028, 'original'), (3, -5000, -5000, 'original'), (4, 52927714, 52927714, 'original') POSTHOOK: type: QUERY POSTHOOK: Input: default@values__tmp__table__49 -POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.b SIMPLE [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c1 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c2 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.insert_num EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.b SIMPLE [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col4, type:string, comment:), ] +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c1 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c2 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.insert_num EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 -PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num +PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num PREHOOK: type: QUERY -PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal +PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num +POSTHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num POSTHOOK: type: QUERY -POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal +POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float #### A masked pattern was here #### insert_num c1 c2 b 1 -29.0764 -29.0764 original @@ -3966,16 +3966,16 @@ insert_num c1 c2 b 3 -5000.0 -5000.0 original 4 5.2927712E7 5.2927712E7 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING) +alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS -PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal -PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal +PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float +PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING) +alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS -POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal -POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal -PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_decimal +POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float +POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float +PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float values (5, '7.74', '22.3', 'new'), (6, '56.1431', '90.9', 'new'), (7, '2.56', '25.6', 'new'), @@ -3984,8 +3984,8 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_dec (10, '1.7', '17.8888', 'new') PREHOOK: type: QUERY PREHOOK: Input: default@values__tmp__table__50 -PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal -POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_decimal +PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float +POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float values (5, '7.74', '22.3', 'new'), (6, '56.1431', '90.9', 'new'), (7, '2.56', '25.6', 'new'), @@ -3994,17 +3994,17 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_de (10, '1.7', '17.8888', 'new') POSTHOOK: type: QUERY POSTHOOK: Input: default@values__tmp__table__50 -POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ] +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 _col3 PREHOOK: query: explain -select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num +select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num +select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num POSTHOOK: type: QUERY Explain STAGE DEPENDENCIES: @@ -4016,7 +4016,7 @@ STAGE PLANS: Map Reduce Map Operator Tree: TableScan - alias: table_change_lower_to_higher_numeric_group_decimal + alias: table_change_lower_to_higher_numeric_group_float Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: insert_num (type: int), c1 (type: double), c2 (type: decimal(38,18)), b (type: string) @@ -4047,13 +4047,13 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num +PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num PREHOOK: type: QUERY -PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal +PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num +POSTHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num POSTHOOK: type: QUERY -POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal +POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float #### A masked pattern was here #### insert_num c1 c2 b 1 -29.0764 -29.076400000000000000 original @@ -4066,55 +4066,55 @@ insert_num c1 c2 b 7 2.56 25.600000000000000000 new 8 555.5 55.550000000000000000 new 9 10.0 0.100000000000000000 new -PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_decimal +PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_float PREHOOK: type: DROPTABLE -PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal -PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal -POSTHOOK: query: drop table table_change_lower_to_higher_numeric_group_decimal +PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float +PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float +POSTHOOK: query: drop table table_change_lower_to_higher_numeric_group_float POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal -POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal +POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float +POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float PREHOOK: query: -- -- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_double(insert_num int, c1 double, b STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default -PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float +PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_double POSTHOOK: query: -- -- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_double(insert_num int, c1 double, b STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default -POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float -PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float +POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_double +PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_double values (1, -29.0764, 'original'), (2, 753.7028, 'original'), (3, -5000, 'original'), (4, 52927714, 'original') PREHOOK: type: QUERY PREHOOK: Input: default@values__tmp__table__51 -PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float -POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float +PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_double +POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_double values (1, -29.0764, 'original'), (2, 753.7028, 'original'), (3, -5000, 'original'), (4, 52927714, 'original') POSTHOOK: type: QUERY POSTHOOK: Input: default@values__tmp__table__51 -POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.b SIMPLE [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c1 EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.insert_num EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_double +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.b SIMPLE [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.c1 EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.insert_num EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 -PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num +PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num PREHOOK: type: QUERY -PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float +PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_double #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num +POSTHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num POSTHOOK: type: QUERY -POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float +POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_double #### A masked pattern was here #### insert_num c1 b 1 -29.0764 original @@ -4122,16 +4122,16 @@ insert_num c1 b 3 -5000.0 original 4 5.2927714E7 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING) +alter table table_change_lower_to_higher_numeric_group_double replace columns (insert_num int, c1 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS -PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float -PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float +PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_double +PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_double POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING) +alter table table_change_lower_to_higher_numeric_group_double replace columns (insert_num int, c1 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS -POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float -POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float -PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float +POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_double +POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_double +PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_double values (5, '774', 'new'), (6, '561431', 'new'), (7, '256', 'new'), @@ -4140,8 +4140,8 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_flo (10, '17', 'new') PREHOOK: type: QUERY PREHOOK: Input: default@values__tmp__table__52 -PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float -POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float +PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_double +POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_double values (5, '774', 'new'), (6, '561431', 'new'), (7, '256', 'new'), @@ -4150,16 +4150,16 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_fl (10, '17', 'new') POSTHOOK: type: QUERY POSTHOOK: Input: default@values__tmp__table__52 -POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.b SIMPLE [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c1 EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.insert_num EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_double +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.b SIMPLE [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col3, type:string, comment:), ] +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.c1 EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.insert_num EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col1, type:string, comment:), ] _col0 _col1 _col2 PREHOOK: query: explain -select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num +select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num PREHOOK: type: QUERY POSTHOOK: query: explain -select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num +select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num POSTHOOK: type: QUERY Explain STAGE DEPENDENCIES: @@ -4171,7 +4171,7 @@ STAGE PLANS: Map Reduce Map Operator Tree: TableScan - alias: table_change_lower_to_higher_numeric_group_float + alias: table_change_lower_to_higher_numeric_group_double Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: insert_num (type: int), c1 (type: decimal(38,18)), b (type: string) @@ -4202,13 +4202,13 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num +PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num PREHOOK: type: QUERY -PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float +PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_double #### A masked pattern was here #### -POSTHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num +POSTHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num POSTHOOK: type: QUERY -POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float +POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_double #### A masked pattern was here #### insert_num c1 b 1 -29.076400000000000000 original @@ -4221,11 +4221,11 @@ insert_num c1 b 7 256.000000000000000000 new 8 5555.000000000000000000 new 9 100.000000000000000000 new -PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_float +PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_double PREHOOK: type: DROPTABLE -PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float -PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float -POSTHOOK: query: drop table table_change_lower_to_higher_numeric_group_float +PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_double +PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_double +POSTHOOK: query: drop table table_change_lower_to_higher_numeric_group_double POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float -POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float +POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_double +POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_double
http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/selectindate.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/selectindate.q.out b/ql/src/test/results/clientpositive/selectindate.q.out index defebe3..1e6fbb3 100644 --- a/ql/src/test/results/clientpositive/selectindate.q.out +++ b/ql/src/test/results/clientpositive/selectindate.q.out @@ -58,8 +58,8 @@ POSTHOOK: query: SELECT * FROM datetest WHERE dValue IN ('2000-03-22','2001-03-2 POSTHOOK: type: QUERY POSTHOOK: Input: default@datetest #### A masked pattern was here #### -2000-03-22 1 2001-03-22 2 +2000-03-22 1 PREHOOK: query: drop table datetest PREHOOK: type: DROPTABLE PREHOOK: Input: default@datetest http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/show_create_table_db_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/show_create_table_db_table.q.out b/ql/src/test/results/clientpositive/show_create_table_db_table.q.out index 8d3049b..f75bb10 100644 --- a/ql/src/test/results/clientpositive/show_create_table_db_table.q.out +++ b/ql/src/test/results/clientpositive/show_create_table_db_table.q.out @@ -58,6 +58,11 @@ OUTPUTFORMAT LOCATION #### A masked pattern was here #### TBLPROPERTIES ( + 'COLUMN_STATS_ACCURATE'='{\"BASIC_STATS\":\"true\"}', + 'numFiles'='0', + 'numRows'='0', + 'rawDataSize'='0', + 'totalSize'='0', #### A masked pattern was here #### PREHOOK: query: SHOW CREATE TABLE tmp_feng.tmp_showcrt2 PREHOOK: type: SHOW_CREATETABLE @@ -79,6 +84,11 @@ OUTPUTFORMAT LOCATION #### A masked pattern was here #### TBLPROPERTIES ( + 'COLUMN_STATS_ACCURATE'='{\"BASIC_STATS\":\"true\"}', + 'numFiles'='0', + 'numRows'='0', + 'rawDataSize'='0', + 'totalSize'='0', #### A masked pattern was here #### PREHOOK: query: SHOW CREATE TABLE tmp_feng.tmp_showcrt3 PREHOOK: type: SHOW_CREATETABLE http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/spark/join0.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/spark/join0.q.out b/ql/src/test/results/clientpositive/spark/join0.q.out deleted file mode 100644 index ab569f5..0000000 --- a/ql/src/test/results/clientpositive/spark/join0.q.out +++ /dev/null @@ -1,236 +0,0 @@ -Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Work 'Reducer 2' is a cross product -PREHOOK: query: -- SORT_QUERY_RESULTS - -EXPLAIN -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -PREHOOK: type: QUERY -POSTHOOK: query: -- SORT_QUERY_RESULTS - -EXPLAIN -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Spark - Edges: - Reducer 2 <- Map 1 (PARTITION-LEVEL SORT, 1), Map 4 (PARTITION-LEVEL SORT, 1) - Reducer 3 <- Reducer 2 (PARTITION-LEVEL SORT, 2) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (key < 10) (type: boolean) - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Map 4 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (key < 10) (type: boolean) - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Reducer 2 - Reduce Operator Tree: - Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 27556 Data size: 612872 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) - sort order: ++++ - Statistics: Num rows: 27556 Data size: 612872 Basic stats: COMPLETE Column stats: NONE - Reducer 3 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 27556 Data size: 612872 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 27556 Data size: 612872 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Work 'Reducer 2' is a cross product -PREHOOK: query: EXPLAIN FORMATTED -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN FORMATTED -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -POSTHOOK: type: QUERY -#### A masked pattern was here #### -Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Work 'Reducer 2' is a cross product -PREHOOK: query: SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 2 val_2 -0 val_0 2 val_2 -0 val_0 2 val_2 -0 val_0 4 val_4 -0 val_0 4 val_4 -0 val_0 4 val_4 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 8 val_8 -0 val_0 8 val_8 -0 val_0 8 val_8 -0 val_0 9 val_9 -0 val_0 9 val_9 -0 val_0 9 val_9 -2 val_2 0 val_0 -2 val_2 0 val_0 -2 val_2 0 val_0 -2 val_2 2 val_2 -2 val_2 4 val_4 -2 val_2 5 val_5 -2 val_2 5 val_5 -2 val_2 5 val_5 -2 val_2 8 val_8 -2 val_2 9 val_9 -4 val_4 0 val_0 -4 val_4 0 val_0 -4 val_4 0 val_0 -4 val_4 2 val_2 -4 val_4 4 val_4 -4 val_4 5 val_5 -4 val_4 5 val_5 -4 val_4 5 val_5 -4 val_4 8 val_8 -4 val_4 9 val_9 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 2 val_2 -5 val_5 2 val_2 -5 val_5 2 val_2 -5 val_5 4 val_4 -5 val_5 4 val_4 -5 val_5 4 val_4 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 8 val_8 -5 val_5 8 val_8 -5 val_5 8 val_8 -5 val_5 9 val_9 -5 val_5 9 val_9 -5 val_5 9 val_9 -8 val_8 0 val_0 -8 val_8 0 val_0 -8 val_8 0 val_0 -8 val_8 2 val_2 -8 val_8 4 val_4 -8 val_8 5 val_5 -8 val_8 5 val_5 -8 val_8 5 val_5 -8 val_8 8 val_8 -8 val_8 9 val_9 -9 val_9 0 val_0 -9 val_9 0 val_0 -9 val_9 0 val_0 -9 val_9 2 val_2 -9 val_9 4 val_4 -9 val_9 5 val_5 -9 val_9 5 val_5 -9 val_9 5 val_5 -9 val_9 8 val_8 -9 val_9 9 val_9
