You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2016/11/08 17:11:26 UTC
[2/7] hive git commit: HIVE-15094: Fix test failures for 2.1.1 regarding schema evolution with DECIMAL types (Jesus Camacho Rodriguez, reviewed by Sergio Peña)
http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_mapwork_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_mapwork_part.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_mapwork_part.q.out
index 572dc0b..334d55e 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_mapwork_part.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_mapwork_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_mapwork_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_mapwork_table.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_mapwork_table.q.out
index 1f093a6..a3edfee 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_mapwork_table.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_orc_nonvec_mapwork_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
http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/tez/schema_evol_orc_vec_mapwork_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_orc_vec_mapwork_part.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_orc_vec_mapwork_part.q.out
index e58079d..03a973e 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_orc_vec_mapwork_part.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_orc_vec_mapwork_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 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=189)
+ Select Operator [SEL_7] (rows=10 width=168)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=189)
+ Select Operator [SEL_5] (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 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=99)
+ Select Operator [SEL_7] (rows=10 width=163)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=99)
+ Select Operator [SEL_5] (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_vec_mapwork_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_orc_vec_mapwork_table.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_orc_vec_mapwork_table.q.out
index 76a972a..98ebe2c 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_orc_vec_mapwork_table.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_orc_vec_mapwork_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 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=4 width=320)
+ Select Operator [SEL_7] (rows=4 width=104)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=4 width=320)
+ Select Operator [SEL_5] (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 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=4 width=100)
+ Select Operator [SEL_7] (rows=4 width=104)
Output:["_col0","_col1","_col2"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=4 width=100)
+ Select Operator [SEL_5] (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
http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_part.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_part.q.out
index 40c3f47..8d2fdde 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_part.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_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=33)
+ Select Operator [SEL_3] (rows=10 width=31)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=33)
+ Select Operator [SEL_1] (rows=10 width=31)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=10 width=31)
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
@@ -3830,9 +3830,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
@@ -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=14)
+ Select Operator [SEL_3] (rows=10 width=25)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=10 width=14)
+ Select Operator [SEL_1] (rows=10 width=25)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=10 width=14)
+ TableScan [TS_0] (rows=10 width=25)
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.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/tez/schema_evol_text_nonvec_mapwork_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_table.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_table.q.out
index f8f413c..0ca4c8f 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_table.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_text_nonvec_mapwork_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=59)
+ Select Operator [SEL_3] (rows=4 width=29)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE]
SHUFFLE [RS_2]
- Select Operator [SEL_1] (rows=4 width=59)
+ Select Operator [SEL_1] (rows=4 width=29)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=4 width=59)
+ TableScan [TS_0] (rows=4 width=29)
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
@@ -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
http://git-wip-us.apache.org/repos/asf/hive/blob/2e2b3d66/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_part.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_part.q.out
index cac8a9e..69a4fbc 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_part.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_part.q.out
@@ -3705,16 +3705,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
@@ -3750,17 +3750,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
@@ -3812,13 +3812,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=33)
+ Select Operator [SEL_7] (rows=10 width=31)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=33)
+ Select Operator [SEL_5] (rows=10 width=31)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=10 width=31)
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
@@ -3834,9 +3834,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
@@ -3853,16 +3853,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
@@ -3900,14 +3900,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
@@ -3957,13 +3957,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=14)
+ Select Operator [SEL_7] (rows=10 width=25)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=14)
+ Select Operator [SEL_5] (rows=10 width=25)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=10 width=14)
+ TableScan [TS_0] (rows=10 width=25)
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
@@ -3979,16 +3979,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/tez/schema_evol_text_vec_mapwork_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_table.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_table.q.out
index f74a754..eaa4730 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_table.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_table.q.out
@@ -3478,16 +3478,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
@@ -3521,17 +3521,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
@@ -3578,13 +3578,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=4 width=59)
+ Select Operator [SEL_7] (rows=4 width=29)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=4 width=59)
+ Select Operator [SEL_5] (rows=4 width=29)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=4 width=59)
+ TableScan [TS_0] (rows=4 width=29)
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
@@ -3596,16 +3596,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
@@ -3615,16 +3615,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
@@ -3660,14 +3660,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
@@ -3731,16 +3731,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_text_vecrow_mapwork_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_text_vecrow_mapwork_part.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_text_vecrow_mapwork_part.q.out
index 24600d9..954a4c4 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_text_vecrow_mapwork_part.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_text_vecrow_mapwork_part.q.out
@@ -3705,16 +3705,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
@@ -3750,17 +3750,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
@@ -3812,13 +3812,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=33)
+ Select Operator [SEL_7] (rows=10 width=31)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=33)
+ Select Operator [SEL_5] (rows=10 width=31)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=10 width=33)
+ TableScan [TS_0] (rows=10 width=31)
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
@@ -3834,9 +3834,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
@@ -3853,16 +3853,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
@@ -3900,14 +3900,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
@@ -3957,13 +3957,13 @@ Stage-0
Stage-1
Reducer 2 vectorized
File Output Operator [FS_8]
- Select Operator [SEL_7] (rows=10 width=14)
+ Select Operator [SEL_7] (rows=10 width=25)
Output:["_col0","_col1","_col2","_col3"]
<-Map 1 [SIMPLE_EDGE] vectorized
SHUFFLE [RS_6]
- Select Operator [SEL_5] (rows=10 width=14)
+ Select Operator [SEL_5] (rows=10 width=25)
Output:["_col0","_col1","_col2","_col3"]
- TableScan [TS_0] (rows=10 width=14)
+ TableScan [TS_0] (rows=10 width=25)
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
@@ -3979,16 +3979,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