http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out b/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out index aac5bc2..f7f178a 100644 --- a/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out +++ b/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out @@ -3918,16 +3918,16 @@ 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: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(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 POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(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 @@ -3961,17 +3961,17 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### insert_num c1 c2 b -1 -29.076400000000000000 -29.076400000000000000 original -2 753.702800000000000000 753.702800000000000000 original -3 -5000.000000000000000000 -5000.000000000000000000 original -4 52927714.000000000000000000 52927714.000000000000000000 original +1 -29.0764 -29.0764 original +2 753.7028 753.7028 original +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 float, c2 double, b STRING) +alter table table_change_lower_to_higher_numeric_group_decimal 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 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table table_change_lower_to_higher_numeric_group_decimal 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 @@ -4017,25 +4017,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: table_change_lower_to_higher_numeric_group_decimal - Statistics: Num rows: 4 Data size: 238 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: insert_num (type: int), c1 (type: float), c2 (type: double), b (type: string) + expressions: insert_num (type: int), c1 (type: double), c2 (type: decimal(38,18)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 4 Data size: 238 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + - Statistics: Num rows: 4 Data size: 238 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: float), _col2 (type: double), _col3 (type: string) + Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE + value expressions: _col1 (type: double), _col2 (type: decimal(38,18)), _col3 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: float), VALUE._col1 (type: double), VALUE._col2 (type: string) + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: double), VALUE._col1 (type: decimal(38,18)), VALUE._col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 4 Data size: 238 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 4 Data size: 238 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -4056,16 +4056,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### insert_num c1 c2 b -1 -29.0764 -29.0764 original -10 1.7 17.8888 new -2 753.7028 753.7028 original -3 -5000.0 -5000.0 original -4 5.2927712E7 5.2927714E7 original -5 7.74 22.3 new -6 56.1431 90.9 new -7 2.56 25.6 new -8 555.5 55.55 new -9 10.0 0.1 new +1 -29.0764 -29.076400000000000000 original +10 1.7 17.888800000000000000 new +2 753.7028 753.702800000000000000 original +3 -5000.0 -5000.000000000000000000 original +4 5.2927712E7 52927712.000000000000000000 original +5 7.74 22.300000000000000000 new +6 56.1431 90.900000000000000000 new +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: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal @@ -4075,16 +4075,16 @@ 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 PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- 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 float, b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_float(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 POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- 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 float, b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_float(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 @@ -4120,14 +4120,14 @@ insert_num c1 b 1 -29.0764 original 2 753.7028 original 3 -5000.0 original -4 5.2927712E7 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 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_float 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 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_float 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 @@ -4174,18 +4174,18 @@ STAGE PLANS: alias: table_change_lower_to_higher_numeric_group_float Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: insert_num (type: int), c1 (type: double), b (type: string) + expressions: insert_num (type: int), c1 (type: decimal(38,18)), b (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: double), _col2 (type: string) + value expressions: _col1 (type: decimal(38,18)), _col2 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: double), VALUE._col1 (type: string) + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: decimal(38,18)), VALUE._col1 (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -4211,16 +4211,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float #### A masked pattern was here #### insert_num c1 b -1 -29.0764 original -10 17.0 new -2 753.7028 original -3 -5000.0 original -4 5.2927712E7 original -5 774.0 new -6 561431.0 new -7 256.0 new -8 5555.0 new -9 100.0 new +1 -29.076400000000000000 original +10 17.000000000000000000 new +2 753.702800000000000000 original +3 -5000.000000000000000000 original +4 52927714.000000000000000000 original +5 774.000000000000000000 new +6 561431.000000000000000000 new +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: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_part.q.out b/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_part.q.out index b53c373..fd737d7 100644 --- a/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_part.q.out +++ b/ql/src/test/results/clientpositive/schema_evol_text_vecrow_mapwork_part.q.out @@ -4145,16 +4145,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) PARTITIONED BY(part INT) +CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) PARTITIONED BY(part INT) +CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal @@ -4190,17 +4190,17 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1 #### A masked pattern was here #### insert_num part c1 b -1 1 -29.076400000000000000 original -2 1 753.702800000000000000 original -3 1 -5000.000000000000000000 original -4 1 52927714.000000000000000000 original +1 1 -29.0764 original +2 1 753.7028 original +3 1 -5000.0 original +4 1 5.2927712E7 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal @@ -4251,25 +4251,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: part_change_lower_to_higher_numeric_group_decimal - Statistics: Num rows: 10 Data size: 335 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 311 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: insert_num (type: int), part (type: int), c1 (type: float), b (type: string) + expressions: insert_num (type: int), part (type: int), c1 (type: double), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 10 Data size: 335 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 311 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + - Statistics: Num rows: 10 Data size: 335 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: float), _col3 (type: string) + Statistics: Num rows: 10 Data size: 311 Basic stats: COMPLETE Column stats: NONE + value expressions: _col1 (type: int), _col2 (type: double), _col3 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: float), VALUE._col2 (type: string) + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: double), VALUE._col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 10 Data size: 335 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 311 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 10 Data size: 335 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 311 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -4294,9 +4294,9 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part= POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=2 #### A masked pattern was here #### insert_num part c1 b -1 1 -29.0764 original -10 1 1.7 new -2 1 753.7028 original +1 1 -29.076400756835938 original +10 1 1.7000000476837158 new +2 1 753.7028198242188 original 3 1 -5000.0 original 4 1 5.2927712E7 original 5 2 7.74 new @@ -4313,16 +4313,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, b STRING) PARTITIONED BY(part INT) +CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) PARTITIONED BY(part INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, b STRING) PARTITIONED BY(part INT) +CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) PARTITIONED BY(part INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float @@ -4360,14 +4360,14 @@ insert_num part c1 b 1 1 -29.0764 original 2 1 753.7028 original 3 1 -5000.0 original -4 1 5.2927712E7 original +4 1 5.2927714E7 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float @@ -4416,25 +4416,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: part_change_lower_to_higher_numeric_group_float - Statistics: Num rows: 10 Data size: 148 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 250 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: insert_num (type: int), part (type: int), c1 (type: double), b (type: string) + expressions: insert_num (type: int), part (type: int), c1 (type: decimal(38,18)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 10 Data size: 148 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 250 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + - Statistics: Num rows: 10 Data size: 148 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: int), _col2 (type: double), _col3 (type: string) + Statistics: Num rows: 10 Data size: 250 Basic stats: COMPLETE Column stats: NONE + value expressions: _col1 (type: int), _col2 (type: decimal(38,18)), _col3 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: double), VALUE._col2 (type: string) + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: decimal(38,18)), VALUE._col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 10 Data size: 148 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 250 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 10 Data size: 148 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 10 Data size: 250 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -4459,16 +4459,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float@part=1 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float@part=2 #### A masked pattern was here #### insert_num part c1 b -1 1 -29.076400756835938 original -10 1 17.0 new -2 1 753.7028198242188 original -3 1 -5000.0 original -4 1 5.2927712E7 original -5 2 774.0 new -6 2 561431.0 new -7 2 256.0 new -8 2 5555.0 new -9 1 100.0 new +1 1 -29.076400000000000000 original +10 1 17.000000000000000000 new +2 1 753.702800000000000000 original +3 1 -5000.000000000000000000 original +4 1 52927714.000000000000000000 original +5 2 774.000000000000000000 new +6 2 561431.000000000000000000 new +7 2 256.000000000000000000 new +8 2 5555.000000000000000000 new +9 1 100.000000000000000000 new PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_float PREHOOK: type: DROPTABLE PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/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 561c128..370900f 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 @@ -3918,16 +3918,16 @@ 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: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(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 POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(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 @@ -3961,17 +3961,17 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### insert_num c1 c2 b -1 -29.076400000000000000 -29.076400000000000000 original -2 753.702800000000000000 753.702800000000000000 original -3 -5000.000000000000000000 -5000.000000000000000000 original -4 52927714.000000000000000000 52927714.000000000000000000 original +1 -29.0764 -29.0764 original +2 753.7028 753.7028 original +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 float, c2 double, b STRING) +alter table table_change_lower_to_higher_numeric_group_decimal 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 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table table_change_lower_to_higher_numeric_group_decimal 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 @@ -4017,25 +4017,25 @@ STAGE PLANS: Map Operator Tree: TableScan alias: table_change_lower_to_higher_numeric_group_decimal - Statistics: Num rows: 4 Data size: 238 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: insert_num (type: int), c1 (type: float), c2 (type: double), b (type: string) + expressions: insert_num (type: int), c1 (type: double), c2 (type: decimal(38,18)), b (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 4 Data size: 238 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + - Statistics: Num rows: 4 Data size: 238 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: float), _col2 (type: double), _col3 (type: string) + Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE + value expressions: _col1 (type: double), _col2 (type: decimal(38,18)), _col3 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: float), VALUE._col1 (type: double), VALUE._col2 (type: string) + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: double), VALUE._col1 (type: decimal(38,18)), VALUE._col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 4 Data size: 238 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 4 Data size: 238 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -4056,16 +4056,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### insert_num c1 c2 b -1 -29.0764 -29.0764 original -10 1.7 17.8888 new -2 753.7028 753.7028 original -3 -5000.0 -5000.0 original -4 5.2927712E7 5.2927714E7 original -5 7.74 22.3 new -6 56.1431 90.9 new -7 2.56 25.6 new -8 555.5 55.55 new -9 10.0 0.1 new +1 -29.0764 -29.076400000000000000 original +10 1.7 17.888800000000000000 new +2 753.7028 753.702800000000000000 original +3 -5000.0 -5000.000000000000000000 original +4 5.2927712E7 52927712.000000000000000000 original +5 7.74 22.300000000000000000 new +6 56.1431 90.900000000000000000 new +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: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal @@ -4075,16 +4075,16 @@ 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 PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- 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 float, b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_float(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 POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- 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 float, b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_float(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 @@ -4120,14 +4120,14 @@ insert_num c1 b 1 -29.0764 original 2 753.7028 original 3 -5000.0 original -4 5.2927712E7 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 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_float 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 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_float 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 @@ -4174,18 +4174,18 @@ STAGE PLANS: alias: table_change_lower_to_higher_numeric_group_float Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: insert_num (type: int), c1 (type: double), b (type: string) + expressions: insert_num (type: int), c1 (type: decimal(38,18)), b (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: double), _col2 (type: string) + value expressions: _col1 (type: decimal(38,18)), _col2 (type: string) Execution mode: vectorized Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: double), VALUE._col1 (type: string) + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: decimal(38,18)), VALUE._col1 (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -4211,16 +4211,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float #### A masked pattern was here #### insert_num c1 b -1 -29.0764 original -10 17.0 new -2 753.7028 original -3 -5000.0 original -4 5.2927712E7 original -5 774.0 new -6 561431.0 new -7 256.0 new -8 5555.0 new -9 100.0 new +1 -29.076400000000000000 original +10 17.000000000000000000 new +2 753.702800000000000000 original +3 -5000.000000000000000000 original +4 52927714.000000000000000000 original +5 774.000000000000000000 new +6 561431.000000000000000000 new +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: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/tez/schema_evol_orc_acid_mapwork_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_orc_acid_mapwork_part.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_orc_acid_mapwork_part.q.out index fafad50..adc0154 100644 --- a/ql/src/test/results/clientpositive/tez/schema_evol_orc_acid_mapwork_part.q.out +++ b/ql/src/test/results/clientpositive/tez/schema_evol_orc_acid_mapwork_part.q.out @@ -2960,16 +2960,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal @@ -3005,17 +3005,17 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1 #### A masked pattern was here #### insert_num part c1 b -1 1 -29.076400000000000000 original -2 1 753.702800000000000000 original -3 1 -5000.000000000000000000 original -4 1 52927714.000000000000000000 original +1 1 -29.0764 original +2 1 753.7028 original +3 1 -5000.0 original +4 1 5.2927712E7 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal @@ -3081,16 +3081,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float @@ -3128,14 +3128,14 @@ insert_num part c1 b 1 1 -29.0764 original 2 1 753.7028 original 3 1 -5000.0 original -4 1 5.2927712E7 original +4 1 5.2927714E7 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float @@ -3180,16 +3180,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float@part=1 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float@part=2 #### A masked pattern was here #### insert_num part c1 b -1 1 -29.0764 original -10 1 17.0 new -2 1 753.7028 original -3 1 -5000.0 original -4 1 5.2927712E7 original -5 2 774.0 new -6 2 561431.0 new -7 2 256.0 new -8 2 5555.0 new -9 1 100.0 new +1 1 -29.076400000000000000 original +10 1 17.000000000000000000 new +2 1 753.702800000000000000 original +3 1 -5000.000000000000000000 original +4 1 52927714.000000000000000000 original +5 2 774.000000000000000000 new +6 2 561431.000000000000000000 new +7 2 256.000000000000000000 new +8 2 5555.000000000000000000 new +9 1 100.000000000000000000 new PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_float PREHOOK: type: DROPTABLE PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/tez/schema_evol_orc_acid_mapwork_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_orc_acid_mapwork_table.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_orc_acid_mapwork_table.q.out index e69e9bd..e497395 100644 --- a/ql/src/test/results/clientpositive/tez/schema_evol_orc_acid_mapwork_table.q.out +++ b/ql/src/test/results/clientpositive/tez/schema_evol_orc_acid_mapwork_table.q.out @@ -2692,16 +2692,16 @@ 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: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal @@ -2735,17 +2735,17 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### insert_num c1 c2 b -1 -29.076400000000000000 -29.076400000000000000 original -2 753.702800000000000000 753.702800000000000000 original -3 -5000.000000000000000000 -5000.000000000000000000 original -4 52927714.000000000000000000 52927714.000000000000000000 original +1 -29.0764 -29.0764 original +2 753.7028 753.7028 original +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 float, c2 double, b STRING) +alter table table_change_lower_to_higher_numeric_group_decimal 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 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table table_change_lower_to_higher_numeric_group_decimal 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 @@ -2783,16 +2783,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### insert_num c1 c2 b -1 -29.0764 -29.0764 original -10 1.7 17.8888 new -2 753.7028 753.7028 original -3 -5000.0 -5000.0 original -4 5.2927712E7 5.2927714E7 original -5 7.74 22.3 new -6 56.1431 90.9 new -7 2.56 25.6 new -8 555.5 55.55 new -9 10.0 0.1 new +1 -29.0764 -29.076400000000000000 original +10 1.7 17.888800000000000000 new +2 753.7028 753.702800000000000000 original +3 -5000.0 -5000.000000000000000000 original +4 5.2927712E7 52927712.000000000000000000 original +5 7.74 22.300000000000000000 new +6 56.1431 90.900000000000000000 new +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: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal @@ -2802,16 +2802,16 @@ 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 PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- 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 float, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default 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) +-- 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 float, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float @@ -2847,14 +2847,14 @@ insert_num c1 b 1 -29.0764 original 2 753.7028 original 3 -5000.0 original -4 5.2927712E7 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 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_float 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 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_float 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 @@ -2891,16 +2891,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float #### A masked pattern was here #### insert_num c1 b -1 -29.0764 original -10 17.0 new -2 753.7028 original -3 -5000.0 original -4 5.2927712E7 original -5 774.0 new -6 561431.0 new -7 256.0 new -8 5555.0 new -9 100.0 new +1 -29.076400000000000000 original +10 17.000000000000000000 new +2 753.702800000000000000 original +3 -5000.000000000000000000 original +4 52927714.000000000000000000 original +5 774.000000000000000000 new +6 561431.000000000000000000 new +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: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/tez/schema_evol_orc_acidvec_mapwork_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_orc_acidvec_mapwork_part.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_orc_acidvec_mapwork_part.q.out index abe001d..7ac4d1c 100644 --- a/ql/src/test/results/clientpositive/tez/schema_evol_orc_acidvec_mapwork_part.q.out +++ b/ql/src/test/results/clientpositive/tez/schema_evol_orc_acidvec_mapwork_part.q.out @@ -2960,16 +2960,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal @@ -3005,17 +3005,17 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1 #### A masked pattern was here #### insert_num part c1 b -1 1 -29.076400000000000000 original -2 1 753.702800000000000000 original -3 1 -5000.000000000000000000 original -4 1 52927714.000000000000000000 original +1 1 -29.0764 original +2 1 753.7028 original +3 1 -5000.0 original +4 1 5.2927712E7 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal, b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal, b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal @@ -3081,16 +3081,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) PARTITIONED BY(part INT) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float @@ -3128,14 +3128,14 @@ insert_num part c1 b 1 1 -29.0764 original 2 1 753.7028 original 3 1 -5000.0 original -4 1 5.2927712E7 original +4 1 5.2927714E7 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float @@ -3180,16 +3180,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float@part=1 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float@part=2 #### A masked pattern was here #### insert_num part c1 b -1 1 -29.0764 original -10 1 17.0 new -2 1 753.7028 original -3 1 -5000.0 original -4 1 5.2927712E7 original -5 2 774.0 new -6 2 561431.0 new -7 2 256.0 new -8 2 5555.0 new -9 1 100.0 new +1 1 -29.076400000000000000 original +10 1 17.000000000000000000 new +2 1 753.702800000000000000 original +3 1 -5000.000000000000000000 original +4 1 52927714.000000000000000000 original +5 2 774.000000000000000000 new +6 2 561431.000000000000000000 new +7 2 256.000000000000000000 new +8 2 5555.000000000000000000 new +9 1 100.000000000000000000 new PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_float PREHOOK: type: DROPTABLE PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/tez/schema_evol_orc_acidvec_mapwork_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_orc_acidvec_mapwork_table.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_orc_acidvec_mapwork_table.q.out index 8ce8794..01e6382 100644 --- a/ql/src/test/results/clientpositive/tez/schema_evol_orc_acidvec_mapwork_table.q.out +++ b/ql/src/test/results/clientpositive/tez/schema_evol_orc_acidvec_mapwork_table.q.out @@ -2692,16 +2692,16 @@ 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: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal @@ -2735,17 +2735,17 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### insert_num c1 c2 b -1 -29.076400000000000000 -29.076400000000000000 original -2 753.702800000000000000 753.702800000000000000 original -3 -5000.000000000000000000 -5000.000000000000000000 original -4 52927714.000000000000000000 52927714.000000000000000000 original +1 -29.0764 -29.0764 original +2 753.7028 753.7028 original +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 float, c2 double, b STRING) +alter table table_change_lower_to_higher_numeric_group_decimal 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 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table table_change_lower_to_higher_numeric_group_decimal 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 @@ -2783,16 +2783,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### insert_num c1 c2 b -1 -29.0764 -29.0764 original -10 1.7 17.8888 new -2 753.7028 753.7028 original -3 -5000.0 -5000.0 original -4 5.2927712E7 5.2927714E7 original -5 7.74 22.3 new -6 56.1431 90.9 new -7 2.56 25.6 new -8 555.5 55.55 new -9 10.0 0.1 new +1 -29.0764 -29.076400000000000000 original +10 1.7 17.888800000000000000 new +2 753.7028 753.702800000000000000 original +3 -5000.0 -5000.000000000000000000 original +4 5.2927712E7 52927712.000000000000000000 original +5 7.74 22.300000000000000000 new +6 56.1431 90.900000000000000000 new +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: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal @@ -2802,16 +2802,16 @@ 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 PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- 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 float, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default 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) +-- 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 float, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') +CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) clustered by (c1) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional'='true') POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float @@ -2847,14 +2847,14 @@ insert_num c1 b 1 -29.0764 original 2 753.7028 original 3 -5000.0 original -4 5.2927712E7 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 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_float 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 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_float 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 @@ -2891,16 +2891,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float #### A masked pattern was here #### insert_num c1 b -1 -29.0764 original -10 17.0 new -2 753.7028 original -3 -5000.0 original -4 5.2927712E7 original -5 774.0 new -6 561431.0 new -7 256.0 new -8 5555.0 new -9 100.0 new +1 -29.076400000000000000 original +10 17.000000000000000000 new +2 753.702800000000000000 original +3 -5000.000000000000000000 original +4 52927714.000000000000000000 original +5 774.000000000000000000 new +6 561431.000000000000000000 new +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: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_fetchwork_part.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_fetchwork_part.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_fetchwork_part.q.out index 762e5b3..908c32a 100644 --- a/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_fetchwork_part.q.out +++ b/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_fetchwork_part.q.out @@ -3701,16 +3701,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) PARTITIONED BY(part INT) +CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) PARTITIONED BY(part INT) +CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal @@ -3746,17 +3746,17 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1 #### A masked pattern was here #### insert_num part c1 b -1 1 -29.076400000000000000 original -2 1 753.702800000000000000 original -3 1 -5000.000000000000000000 original -4 1 52927714.000000000000000000 original +1 1 -29.0764 original +2 1 753.7028 original +3 1 -5000.0 original +4 1 5.2927712E7 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal @@ -3808,13 +3808,13 @@ Stage-0 Stage-1 Reducer 2 File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=189) + Select Operator [SEL_3] (rows=10 width=168) Output:["_col0","_col1","_col2","_col3"] <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=189) + Select Operator [SEL_1] (rows=10 width=168) Output:["_col0","_col1","_col2","_col3"] - TableScan [TS_0] (rows=10 width=189) + TableScan [TS_0] (rows=10 width=168) default@part_change_lower_to_higher_numeric_group_decimal,part_change_lower_to_higher_numeric_group_decimal,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","b"] PREHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num @@ -3849,16 +3849,16 @@ POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, b STRING) PARTITIONED BY(part INT) +CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) PARTITIONED BY(part INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL) -- -CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, b STRING) PARTITIONED BY(part INT) +CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING) PARTITIONED BY(part INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float @@ -3896,14 +3896,14 @@ insert_num part c1 b 1 1 -29.0764 original 2 1 753.7028 original 3 1 -5000.0 original -4 1 5.2927712E7 original +4 1 5.2927714E7 original PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float @@ -3953,13 +3953,13 @@ Stage-0 Stage-1 Reducer 2 File Output Operator [FS_4] - Select Operator [SEL_3] (rows=10 width=99) + Select Operator [SEL_3] (rows=10 width=163) Output:["_col0","_col1","_col2","_col3"] <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=10 width=99) + Select Operator [SEL_1] (rows=10 width=163) Output:["_col0","_col1","_col2","_col3"] - TableScan [TS_0] (rows=10 width=99) + TableScan [TS_0] (rows=10 width=163) default@part_change_lower_to_higher_numeric_group_float,part_change_lower_to_higher_numeric_group_float,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","b"] PREHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float order by insert_num @@ -3975,16 +3975,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float@part=1 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float@part=2 #### A masked pattern was here #### insert_num part c1 b -1 1 -29.0764 original -10 1 17.0 new -2 1 753.7028 original -3 1 -5000.0 original -4 1 5.2927712E7 original -5 2 774.0 new -6 2 561431.0 new -7 2 256.0 new -8 2 5555.0 new -9 1 100.0 new +1 1 -29.076400000000000000 original +10 1 17.000000000000000000 new +2 1 753.702800000000000000 original +3 1 -5000.000000000000000000 original +4 1 52927714.000000000000000000 original +5 2 774.000000000000000000 new +6 2 561431.000000000000000000 new +7 2 256.000000000000000000 new +8 2 5555.000000000000000000 new +9 1 100.000000000000000000 new PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_float PREHOOK: type: DROPTABLE PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_fetchwork_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_fetchwork_table.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_fetchwork_table.q.out index 466e4c8..245855f 100644 --- a/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_fetchwork_table.q.out +++ b/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_fetchwork_table.q.out @@ -3474,16 +3474,16 @@ 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: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(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 POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DECIMAL, (FLOAT, DOUBLE) +-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL) -- -CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 decimal(38,18), c2 decimal(38,18), b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(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 @@ -3517,17 +3517,17 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### insert_num c1 c2 b -1 -29.076400000000000000 -29.076400000000000000 original -2 753.702800000000000000 753.702800000000000000 original -3 -5000.000000000000000000 -5000.000000000000000000 original -4 52927714.000000000000000000 52927714.000000000000000000 original +1 -29.0764 -29.0764 original +2 753.7028 753.7028 original +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 float, c2 double, b STRING) +alter table table_change_lower_to_higher_numeric_group_decimal 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 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 float, c2 double, b STRING) +alter table table_change_lower_to_higher_numeric_group_decimal 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 @@ -3574,13 +3574,13 @@ Stage-0 Stage-1 Reducer 2 File Output Operator [FS_4] - Select Operator [SEL_3] (rows=4 width=320) + Select Operator [SEL_3] (rows=4 width=104) Output:["_col0","_col1","_col2","_col3"] <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=4 width=320) + Select Operator [SEL_1] (rows=4 width=104) Output:["_col0","_col1","_col2","_col3"] - TableScan [TS_0] (rows=4 width=320) + TableScan [TS_0] (rows=4 width=104) default@table_change_lower_to_higher_numeric_group_decimal,table_change_lower_to_higher_numeric_group_decimal,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","b"] PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num @@ -3592,16 +3592,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal #### A masked pattern was here #### insert_num c1 c2 b -1 -29.0764 -29.0764 original -10 1.7 17.8888 new -2 753.7028 753.7028 original -3 -5000.0 -5000.0 original -4 5.2927712E7 5.2927714E7 original -5 7.74 22.3 new -6 56.1431 90.9 new -7 2.56 25.6 new -8 555.5 55.55 new -9 10.0 0.1 new +1 -29.0764 -29.076400000000000000 original +10 1.7 17.888800000000000000 new +2 753.7028 753.702800000000000000 original +3 -5000.0 -5000.000000000000000000 original +4 5.2927712E7 52927712.000000000000000000 original +5 7.74 22.300000000000000000 new +6 56.1431 90.900000000000000000 new +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: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal @@ -3611,16 +3611,16 @@ 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 PREHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- 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 float, b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_float(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 POSTHOOK: query: -- --- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE) +-- 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 float, b STRING) +CREATE TABLE table_change_lower_to_higher_numeric_group_float(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 @@ -3656,14 +3656,14 @@ insert_num c1 b 1 -29.0764 original 2 753.7028 original 3 -5000.0 original -4 5.2927712E7 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 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_float 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 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ... -alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, b STRING) +alter table table_change_lower_to_higher_numeric_group_float 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 @@ -3709,13 +3709,13 @@ Stage-0 Stage-1 Reducer 2 File Output Operator [FS_4] - Select Operator [SEL_3] (rows=4 width=100) + Select Operator [SEL_3] (rows=4 width=104) Output:["_col0","_col1","_col2"] <-Map 1 [SIMPLE_EDGE] SHUFFLE [RS_2] - Select Operator [SEL_1] (rows=4 width=100) + Select Operator [SEL_1] (rows=4 width=104) Output:["_col0","_col1","_col2"] - TableScan [TS_0] (rows=4 width=100) + TableScan [TS_0] (rows=4 width=104) default@table_change_lower_to_higher_numeric_group_float,table_change_lower_to_higher_numeric_group_float,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","b"] PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num @@ -3727,16 +3727,16 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float #### A masked pattern was here #### insert_num c1 b -1 -29.0764 original -10 17.0 new -2 753.7028 original -3 -5000.0 original -4 5.2927712E7 original -5 774.0 new -6 561431.0 new -7 256.0 new -8 5555.0 new -9 100.0 new +1 -29.076400000000000000 original +10 17.000000000000000000 new +2 753.702800000000000000 original +3 -5000.000000000000000000 original +4 52927714.000000000000000000 original +5 774.000000000000000000 new +6 561431.000000000000000000 new +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: type: DROPTABLE PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float