hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From omal...@apache.org
Subject [22/43] hive git commit: HIVE-16787 Fix itests in branch-2.2
Date Thu, 20 Jul 2017 20:09:40 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/schema_evol_orc_nonvec_mapwork_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/schema_evol_orc_nonvec_mapwork_part.q.out b/ql/src/test/results/clientpositive/schema_evol_orc_nonvec_mapwork_part.q.out
index 68300ab..3243214 100644
--- a/ql/src/test/results/clientpositive/schema_evol_orc_nonvec_mapwork_part.q.out
+++ b/ql/src/test/results/clientpositive/schema_evol_orc_nonvec_mapwork_part.q.out
@@ -2042,16 +2042,16 @@ POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc
 POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc
 PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), STRING
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), STRING
 --
-CREATE TABLE part_change_numeric_group_string_group_floating_string(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_string(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@part_change_numeric_group_string_group_floating_string
 POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), STRING
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), STRING
 --
-CREATE TABLE part_change_numeric_group_string_group_floating_string(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_string(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_string
@@ -2088,10 +2088,10 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	b
-1	1	-23866739993.000000000000000000	753.7028	-3651.672121	original
-2	1	-10.300000000000000000	-2.0	-29.0764	original
-3	1	-832222222.000000000000000000	255.0	4957.0	original
-4	1	847492223.000000000000000000	0.0	20435.0	original
+1	1	-2.38667407E10	753.7028	-3651.672121000000000000	original
+2	1	-10.3	-2.0	-29.076400000000000000	original
+3	1	-8.3222221E8	255.0	4957.000000000000000000	original
+4	1	8.4749222E8	0.0	20435.000000000000000000	original
 PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_floating_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
@@ -2193,11 +2193,11 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string@
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	b
-1	1	-23866739993	753.7028	-3651.672121	original
+1	1	-2.38667407E10	753.7028	-3651.672121	original
 10	1	17	90000	754072151	new
 2	1	-10.3	-2.0	-29.0764	original
-3	1	-832222222	255.0	4957.0	original
-4	1	847492223	0.0	20435.0	original
+3	1	-8.3222221E8	255.0	4957	original
+4	1	8.4749222E8	0.0	20435	original
 5	2	30.774	20.31	46114.284799488	new
 6	2	-66475.561431	52927714	7203778961	new
 7	2	256	32768	31889	new
@@ -2212,16 +2212,16 @@ POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string
 POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_string
 PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR
 --
-CREATE TABLE part_change_numeric_group_string_group_floating_char(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_char(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@part_change_numeric_group_string_group_floating_char
 POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR
 --
-CREATE TABLE part_change_numeric_group_string_group_floating_char(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_char(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_char
@@ -2258,10 +2258,10 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	b
-1	1	-23866739993.000000000000000000	753.7028	-3651.672121	original
-2	1	-10.300000000000000000	-2.0	-29.0764	original
-3	1	9000000000.000000000000000000	-255.0	4957.0	original
-4	1	-999999999999.000000000000000000	0.0	20435.0	original
+1	1	-2.38667407E10	753.7028	-3651.672121000000000000	original
+2	1	-10.3	-2.0	-29.076400000000000000	original
+3	1	8.9999995E9	-255.0	4957.000000000000000000	original
+4	1	-1.0E12	0.0	20435.000000000000000000	original
 PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_floating_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
@@ -2363,11 +2363,11 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char@pa
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	b
-1	1	-23866739993                                      	753.7028                                          	-3651.672121                                      	original
+1	1	-2.38667407E10                                    	753.7028                                          	-3651.672121                                      	original
 10	1	17                                                	90000                                             	754072151                                         	new
 2	1	-10.3                                             	-2.0                                              	-29.0764                                          	original
-3	1	9000000000                                        	-255.0                                            	4957.0                                            	original
-4	1	-999999999999                                     	0.0                                               	20435.0                                           	original
+3	1	8.9999995E9                                       	-255.0                                            	4957                                              	original
+4	1	-1.0E12                                           	0.0                                               	20435                                             	original
 5	2	30.774                                            	20.31                                             	46114.284799488                                   	new
 6	2	-66475.561431                                     	52927714                                          	7203778961                                        	new
 7	2	256                                               	32768                                             	31889                                             	new
@@ -2382,16 +2382,16 @@ POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char
 POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_char
 PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR truncation
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR truncation
 --
-CREATE TABLE part_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@part_change_numeric_group_string_group_floating_char_trunc
 POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR truncation
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR truncation
 --
-CREATE TABLE part_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_char_trunc
@@ -2428,10 +2428,10 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_tr
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	b
-1	1	-23866739993.000000000000000000	753.7028	-3651.672121	original
-2	1	-10.300000000000000000	-2.0	-29.0764	original
-3	1	832222222.000000000000000000	-255.0	4957.0	original
-4	1	847492223.000000000000000000	0.0	20435.0	original
+1	1	-2.38667407E10	753.7028	-3651.672121000000000000	original
+2	1	-10.3	-2.0	-29.076400000000000000	original
+3	1	8.3222221E8	-255.0	4957.000000000000000000	original
+4	1	8.4749222E8	0.0	20435.000000000000000000	original
 PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_floating_char_trunc replace columns (insert_num int, c1 CHAR(7), c2 CHAR(7), c3 CHAR(7), b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
@@ -2533,11 +2533,11 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_tr
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	b
-1	1	-238667	753.702	-3651.6	original
+1	1	-2.3866	753.702	-3651.6	original
 10	1	17     	90000  	7540721	new
 2	1	-10.3  	-2.0   	-29.076	original
-3	1	8322222	-255.0 	4957.0 	original
-4	1	8474922	0.0    	20435.0	original
+3	1	8.32222	-255.0 	4957   	original
+4	1	8.47492	0.0    	20435  	original
 5	2	30.774 	20.31  	46114.2	new
 6	2	-66475.	5292771	7203778	new
 7	2	256    	32768  	31889  	new
@@ -2552,14 +2552,14 @@ POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc
 POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_char_trunc
 PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR
 --
 CREATE TABLE part_change_numeric_group_string_group_floating_varchar(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@part_change_numeric_group_string_group_floating_varchar
 POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR
 --
 CREATE TABLE part_change_numeric_group_string_group_floating_varchar(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
 POSTHOOK: type: CREATETABLE
@@ -2722,16 +2722,16 @@ POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar
 POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_varchar
 PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR truncation
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR truncation
 --
-CREATE TABLE part_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@part_change_numeric_group_string_group_floating_varchar_trunc
 POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR truncation
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR truncation
 --
-CREATE TABLE part_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_varchar_trunc
@@ -2768,10 +2768,10 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	b
-1	1	-23866739993.000000000000000000	753.7028	-3651.672121	original
-2	1	-10.300000000000000000	-2.0	-29.0764	original
-3	1	9000000000.000000000000000000	-255.0	4957.0	original
-4	1	-999999999999.000000000000000000	0.0	20435.0	original
+1	1	-2.38667407E10	753.7028	-3651.672121000000000000	original
+2	1	-10.3	-2.0	-29.076400000000000000	original
+3	1	8.9999995E9	-255.0	4957.000000000000000000	original
+4	1	-1.0E12	0.0	20435.000000000000000000	original
 PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
 alter table part_change_numeric_group_string_group_floating_varchar_trunc replace columns (insert_num int, c1 VARCHAR(7), c2 VARCHAR(7), c3 VARCHAR(7), b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
@@ -2873,11 +2873,11 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar
 POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	b
-1	1	-238667	753.702	-3651.6	original
+1	1	-2.3866	753.702	-3651.6	original
 10	1	17	90000	7540721	new
 2	1	-10.3	-2.0	-29.076	original
-3	1	9000000	-255.0	4957.0	original
-4	1	-999999	0.0	20435.0	original
+3	1	8.99999	-255.0	4957	original
+4	1	-1.0E12	0.0	20435	original
 5	2	30.774	20.31	46114.2	new
 6	2	-66475.	5292771	7203778	new
 7	2	256	32768	31889	new
@@ -3417,7 +3417,7 @@ PREHOOK: query: ----------------------------------------------------------------
 --
 --
 --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, FLOAT, DOUBLE, DECIMAL)
 --
 CREATE TABLE part_change_lower_to_higher_numeric_group_tinyint(insert_num int, c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, b STRING) PARTITIONED BY(part INT)
 PREHOOK: type: CREATETABLE
@@ -3428,7 +3428,7 @@ POSTHOOK: query: ---------------------------------------------------------------
 --
 --
 --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, FLOAT, DOUBLE, DECIMAL)
 --
 CREATE TABLE part_change_lower_to_higher_numeric_group_tinyint(insert_num int, c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, b STRING) PARTITIONED BY(part INT)
 POSTHOOK: type: CREATETABLE
@@ -3475,12 +3475,12 @@ insert_num	part	c1	c2	c3	c4	c5	c6	b
 3	1	NULL	NULL	NULL	NULL	NULL	NULL	original
 4	1	100	100	100	100	100	100	original
 PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 FLOAT, c5 DOUBLE, c6 decimal(38,18), b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint
 PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_tinyint
 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 FLOAT, c5 DOUBLE, c6 decimal(38,18), b STRING)
 POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_tinyint
@@ -3541,17 +3541,17 @@ STAGE PLANS:
             alias: part_change_lower_to_higher_numeric_group_tinyint
             Statistics: Num rows: 10 Data size: 1838 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: insert_num (type: int), part (type: int), c1 (type: smallint), c2 (type: int), c3 (type: bigint), c4 (type: decimal(38,18)), c5 (type: float), c6 (type: double), b (type: string)
+              expressions: insert_num (type: int), part (type: int), c1 (type: smallint), c2 (type: int), c3 (type: bigint), c4 (type: float), c5 (type: double), c6 (type: decimal(38,18)), b (type: string)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
               Statistics: Num rows: 10 Data size: 1838 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
                 key expressions: _col0 (type: int)
                 sort order: +
                 Statistics: Num rows: 10 Data size: 1838 Basic stats: COMPLETE Column stats: NONE
-                value expressions: _col1 (type: int), _col2 (type: smallint), _col3 (type: int), _col4 (type: bigint), _col5 (type: decimal(38,18)), _col6 (type: float), _col7 (type: double), _col8 (type: string)
+                value expressions: _col1 (type: int), _col2 (type: smallint), _col3 (type: int), _col4 (type: bigint), _col5 (type: float), _col6 (type: double), _col7 (type: decimal(38,18)), _col8 (type: string)
       Reduce Operator Tree:
         Select Operator
-          expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: decimal(38,18)), VALUE._col5 (type: float), VALUE._col6 (type: double), VALUE._col7 (type: string)
+          expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: float), VALUE._col5 (type: double), VALUE._col6 (type: decimal(38,18)), VALUE._col7 (type: string)
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
           Statistics: Num rows: 10 Data size: 1838 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
@@ -3581,16 +3581,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint@part=
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	b
-1	1	45	45	45	45.000000000000000000	45.0	45.0	original
-10	1	17	90000	754072151	95.000000000000000000	20.0	18.0	new
-2	1	-2	-2	-2	-2.000000000000000000	-2.0	-2.0	original
+1	1	45	45	45	45.0	45.0	45.000000000000000000	original
+10	1	17	90000	754072151	95.0	20.0	18.000000000000000000	new
+2	1	-2	-2	-2	-2.0	-2.0	-2.000000000000000000	original
 3	1	NULL	NULL	NULL	NULL	NULL	NULL	original
-4	1	100	100	100	100.000000000000000000	100.0	100.0	original
-5	2	774	2031	200	12.000000000000000000	99.0	0.0	new
-6	2	NULL	52927714	7203778961	8.000000000000000000	7.0	6.0	new
-7	2	256	32768	31889	300.000000000000000000	444.0	506.0	new
-8	2	5555	40000	-719017797	45.000000000000000000	55.0	65.0	new
-9	1	100	5000	5443	22.000000000000000000	2.0	-2.0	new
+4	1	100	100	100	100.0	100.0	100.000000000000000000	original
+5	2	774	2031	200	12.0	99.0	0.000000000000000000	new
+6	2	NULL	52927714	7203778961	8.0	7.0	6.000000000000000000	new
+7	2	256	32768	31889	300.0	444.0	506.000000000000000000	new
+8	2	5555	40000	-719017797	45.0	55.0	65.000000000000000000	new
+9	1	100	5000	5443	22.0	2.0	-2.000000000000000000	new
 PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_tinyint
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint
@@ -3600,14 +3600,14 @@ POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_tinyint
 PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, FLOAT, DOUBLE, DECIMAL)
 --
 CREATE TABLE part_change_lower_to_higher_numeric_group_smallint(insert_num int, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint, b STRING) PARTITIONED BY(part INT)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_smallint
 POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, FLOAT, DOUBLE, DECIMAL)
 --
 CREATE TABLE part_change_lower_to_higher_numeric_group_smallint(insert_num int, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint, b STRING) PARTITIONED BY(part INT)
 POSTHOOK: type: CREATETABLE
@@ -3653,12 +3653,12 @@ insert_num	part	c1	c2	c3	c4	c5	b
 3	1	-5000	-5000	-5000	-5000	-5000	original
 4	1	100	100	100	100	100	original
 PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 decimal(38,18), c4 FLOAT, c5 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 FLOAT, c4 DOUBLE, c5 decimal(38,18), b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint
 PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_smallint
 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 decimal(38,18), c4 FLOAT, c5 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 FLOAT, c4 DOUBLE, c5 decimal(38,18), b STRING)
 POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_smallint
@@ -3717,17 +3717,17 @@ STAGE PLANS:
             alias: part_change_lower_to_higher_numeric_group_smallint
             Statistics: Num rows: 10 Data size: 1826 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: insert_num (type: int), part (type: int), c1 (type: int), c2 (type: bigint), c3 (type: decimal(38,18)), c4 (type: float), c5 (type: double), b (type: string)
+              expressions: insert_num (type: int), part (type: int), c1 (type: int), c2 (type: bigint), c3 (type: float), c4 (type: double), c5 (type: decimal(38,18)), b (type: string)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
               Statistics: Num rows: 10 Data size: 1826 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
                 key expressions: _col0 (type: int)
                 sort order: +
                 Statistics: Num rows: 10 Data size: 1826 Basic stats: COMPLETE Column stats: NONE
-                value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: bigint), _col4 (type: decimal(38,18)), _col5 (type: float), _col6 (type: double), _col7 (type: string)
+                value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: decimal(38,18)), _col7 (type: string)
       Reduce Operator Tree:
         Select Operator
-          expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: decimal(38,18)), VALUE._col4 (type: float), VALUE._col5 (type: double), VALUE._col6 (type: string)
+          expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: float), VALUE._col4 (type: double), VALUE._col5 (type: decimal(38,18)), VALUE._col6 (type: string)
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
           Statistics: Num rows: 10 Data size: 1826 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
@@ -3757,16 +3757,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint@part
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	b
-1	1	2031	2031	2031.000000000000000000	2031.0	2031.0	original
-10	1	17	90000	754072151.000000000000000000	95.0	20.0	new
-2	1	-2	-2	-2.000000000000000000	-2.0	-2.0	original
-3	1	-5000	-5000	-5000.000000000000000000	-5000.0	-5000.0	original
-4	1	100	100	100.000000000000000000	100.0	100.0	original
-5	2	774	2031	200.000000000000000000	12.0	99.0	new
-6	2	561431	52927714	7203778961.000000000000000000	8.0	7.0	new
-7	2	256	32768	31889.000000000000000000	300.0	444.0	new
-8	2	5555	40000	-719017797.000000000000000000	45.0	55.0	new
-9	1	100	5000	5443.000000000000000000	22.0	2.0	new
+1	1	2031	2031	2031.0	2031.0	2031.000000000000000000	original
+10	1	17	90000	7.5407213E8	95.0	20.000000000000000000	new
+2	1	-2	-2	-2.0	-2.0	-2.000000000000000000	original
+3	1	-5000	-5000	-5000.0	-5000.0	-5000.000000000000000000	original
+4	1	100	100	100.0	100.0	100.000000000000000000	original
+5	2	774	2031	200.0	12.0	99.000000000000000000	new
+6	2	561431	52927714	7.2037791E9	8.0	7.000000000000000000	new
+7	2	256	32768	31889.0	300.0	444.000000000000000000	new
+8	2	5555	40000	-7.1901779E8	45.0	55.000000000000000000	new
+9	1	100	5000	5443.0	22.0	2.000000000000000000	new
 PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_smallint
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint
@@ -3776,14 +3776,14 @@ POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_smallint
 PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, FLOAT, DOUBLE, DECIMAL)
 --
 CREATE TABLE part_change_lower_to_higher_numeric_group_int(insert_num int, c1 int, c2 int, c3 int, c4 int, b STRING) PARTITIONED BY(part INT)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_int
 POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, FLOAT, DOUBLE, DECIMAL)
 --
 CREATE TABLE part_change_lower_to_higher_numeric_group_int(insert_num int, c1 int, c2 int, c3 int, c4 int, b STRING) PARTITIONED BY(part INT)
 POSTHOOK: type: CREATETABLE
@@ -3828,12 +3828,12 @@ insert_num	part	c1	c2	c3	c4	b
 3	1	-5000	-5000	-5000	-5000	original
 4	1	52927714	52927714	52927714	52927714	original
 PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 decimal(38,18), c3 FLOAT, c4 DOUBLE,  b STRING)
+alter table part_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 FLOAT, c3 DOUBLE, c4 decimal(38,18), b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_int
 PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_int
 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 decimal(38,18), c3 FLOAT, c4 DOUBLE,  b STRING)
+alter table part_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 FLOAT, c3 DOUBLE, c4 decimal(38,18), b STRING)
 POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_int
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_int
@@ -3890,17 +3890,17 @@ STAGE PLANS:
             alias: part_change_lower_to_higher_numeric_group_int
             Statistics: Num rows: 10 Data size: 1786 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: insert_num (type: int), part (type: int), c1 (type: bigint), c2 (type: decimal(38,18)), c3 (type: float), c4 (type: double), b (type: string)
+              expressions: insert_num (type: int), part (type: int), c1 (type: bigint), c2 (type: float), c3 (type: double), c4 (type: decimal(38,18)), b (type: string)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
               Statistics: Num rows: 10 Data size: 1786 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
                 key expressions: _col0 (type: int)
                 sort order: +
                 Statistics: Num rows: 10 Data size: 1786 Basic stats: COMPLETE Column stats: NONE
-                value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: decimal(38,18)), _col4 (type: float), _col5 (type: double), _col6 (type: string)
+                value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: double), _col5 (type: decimal(38,18)), _col6 (type: string)
       Reduce Operator Tree:
         Select Operator
-          expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: decimal(38,18)), VALUE._col3 (type: float), VALUE._col4 (type: double), VALUE._col5 (type: string)
+          expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: float), VALUE._col3 (type: double), VALUE._col4 (type: decimal(38,18)), VALUE._col5 (type: string)
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
           Statistics: Num rows: 10 Data size: 1786 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
@@ -3930,16 +3930,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_int@part=1
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_int@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	b
-1	1	2031	2031.000000000000000000	2031.0	2031.0	original
-10	1	17	90000.000000000000000000	7.5407213E8	95.0	new
-2	1	-2	-2.000000000000000000	-2.0	-2.0	original
-3	1	-5000	-5000.000000000000000000	-5000.0	-5000.0	original
-4	1	52927714	52927714.000000000000000000	5.2927712E7	5.2927714E7	original
-5	2	774	2031.000000000000000000	200.0	12.0	new
-6	2	561431	52927714.000000000000000000	7.2037791E9	8.0	new
-7	2	256	32768.000000000000000000	31889.0	300.0	new
-8	2	5555	40000.000000000000000000	-7.1901779E8	45.0	new
-9	1	100	5000.000000000000000000	5443.0	22.0	new
+1	1	2031	2031.0	2031.0	2031.000000000000000000	original
+10	1	17	90000.0	7.54072151E8	95.000000000000000000	new
+2	1	-2	-2.0	-2.0	-2.000000000000000000	original
+3	1	-5000	-5000.0	-5000.0	-5000.000000000000000000	original
+4	1	52927714	5.2927712E7	5.2927714E7	52927714.000000000000000000	original
+5	2	774	2031.0	200.0	12.000000000000000000	new
+6	2	561431	5.2927712E7	7.203778961E9	8.000000000000000000	new
+7	2	256	32768.0	31889.0	300.000000000000000000	new
+8	2	5555	40000.0	-7.19017797E8	45.000000000000000000	new
+9	1	100	5000.0	5443.0	22.000000000000000000	new
 PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_int
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_int
@@ -3949,14 +3949,14 @@ POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_int
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_int
 PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (FLOAT, DOUBLE, DECIMAL)
 --
 CREATE TABLE part_change_lower_to_higher_numeric_group_bigint(insert_num int, c1 bigint, c2 bigint, c3 bigint, b STRING) PARTITIONED BY(part INT)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint
 POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (FLOAT, DOUBLE, DECIMAL)
 --
 CREATE TABLE part_change_lower_to_higher_numeric_group_bigint(insert_num int, c1 bigint, c2 bigint, c3 bigint, b STRING) PARTITIONED BY(part INT)
 POSTHOOK: type: CREATETABLE
@@ -4000,12 +4000,12 @@ insert_num	part	c1	c2	c3	b
 3	1	-5000	-5000	-5000	original
 4	1	52927714	52927714	52927714	original
 PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 FLOAT, c2 DOUBLE, c3 decimal(38,18), b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint
 PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint
 POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 FLOAT, c2 DOUBLE, c3 decimal(38,18), b STRING)
 POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint
@@ -4060,17 +4060,17 @@ STAGE PLANS:
             alias: part_change_lower_to_higher_numeric_group_bigint
             Statistics: Num rows: 10 Data size: 1770 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: insert_num (type: int), part (type: int), c1 (type: decimal(38,18)), c2 (type: float), c3 (type: double), b (type: string)
+              expressions: insert_num (type: int), part (type: int), c1 (type: float), c2 (type: double), c3 (type: decimal(38,18)), b (type: string)
               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
               Statistics: Num rows: 10 Data size: 1770 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
                 key expressions: _col0 (type: int)
                 sort order: +
                 Statistics: Num rows: 10 Data size: 1770 Basic stats: COMPLETE Column stats: NONE
-                value expressions: _col1 (type: int), _col2 (type: decimal(38,18)), _col3 (type: float), _col4 (type: double), _col5 (type: string)
+                value expressions: _col1 (type: int), _col2 (type: float), _col3 (type: double), _col4 (type: decimal(38,18)), _col5 (type: string)
       Reduce Operator Tree:
         Select Operator
-          expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: decimal(38,18)), VALUE._col2 (type: float), VALUE._col3 (type: double), VALUE._col4 (type: string)
+          expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: float), VALUE._col2 (type: double), VALUE._col3 (type: decimal(38,18)), VALUE._col4 (type: string)
           outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
           Statistics: Num rows: 10 Data size: 1770 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
@@ -4100,16 +4100,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint@part=1
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	b
-1	1	7203778961.000000000000000000	7.2037791E9	7.203778961E9	original
-10	1	17.000000000000000000	90000.0	7.54072151E8	new
-2	1	-2.000000000000000000	-2.0	-2.0	original
-3	1	-5000.000000000000000000	-5000.0	-5000.0	original
-4	1	52927714.000000000000000000	5.2927712E7	5.2927714E7	original
-5	2	774.000000000000000000	2031.0	200.0	new
-6	2	561431.000000000000000000	5.2927712E7	7.203778961E9	new
-7	2	256.000000000000000000	32768.0	31889.0	new
-8	2	5555.000000000000000000	40000.0	-7.19017797E8	new
-9	1	100.000000000000000000	5000.0	5443.0	new
+1	1	7.2037791E9	7.203778961E9	7203778961.000000000000000000	original
+10	1	17.0	90000.0	754072151.000000000000000000	new
+2	1	-2.0	-2.0	-2.000000000000000000	original
+3	1	-5000.0	-5000.0	-5000.000000000000000000	original
+4	1	5.2927712E7	5.2927714E7	52927714.000000000000000000	original
+5	2	774.0	2031.0	200.000000000000000000	new
+6	2	561431.0	5.2927714E7	7203778961.000000000000000000	new
+7	2	256.0	32768.0	31889.000000000000000000	new
+8	2	5555.0	40000.0	-719017797.000000000000000000	new
+9	1	100.0	5000.0	5443.000000000000000000	new
 PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_bigint
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint
@@ -4121,204 +4121,38 @@ 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: FLOAT, (DOUBLE, DECIMAL)
 --
-CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_lower_to_higher_numeric_group_float(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
+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, DECIMAL)
 --
-CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_lower_to_higher_numeric_group_float(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
-PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_decimal partition(part=1)
-    values (1, -29.0764, -29.0764, 'original'),
+POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float
+PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part=1)
+    values (1, -29.0764,  -29.0764, 'original'),
            (2, 753.7028, 753.7028, 'original'),
            (3, -5000, -5000, 'original'),
            (4, 52927714, 52927714, 'original')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__49
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_decimal partition(part=1)
-    values (1, -29.0764, -29.0764, 'original'),
+PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float@part=1
+POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part=1)
+    values (1, -29.0764,  -29.0764, 'original'),
            (2, 753.7028, 753.7028, 'original'),
            (3, -5000, -5000, 'original'),
            (4, 52927714, 52927714, 'original')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__49
-POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).b SIMPLE [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-_col0	_col1	_col2	_col3
-PREHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-POSTHOOK: type: QUERY
-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.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 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 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
-PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_decimal partition(part)
-    values (5, '7.74', '22.3', 'new', 2),
-           (6, '56.1431', '90.9', 'new', 2),
-           (7, '2.56', '25.6', 'new', 2),
-           (8, '555.5', '55.55', 'new', 2),
-           (9, '10.0', '0.100', 'new', 1),
-           (10, '1.7', '17.8888', 'new', 1)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__50
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_decimal partition(part)
-    values (5, '7.74', '22.3', 'new', 2),
-           (6, '56.1431', '90.9', 'new', 2),
-           (7, '2.56', '25.6', 'new', 2),
-           (8, '555.5', '55.55', 'new', 2),
-           (9, '10.0', '0.100', 'new', 1),
-           (10, '1.7', '17.8888', 'new', 1)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__50
-POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal@part=2
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=2).b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=2).c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=2).c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-_col0	_col1	_col2	_col3	_col4
-PREHOOK: query: explain
-select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-POSTHOOK: type: QUERY
-Explain
-STAGE DEPENDENCIES:
-  Stage-1 is a root stage
-  Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            alias: part_change_lower_to_higher_numeric_group_decimal
-            Statistics: Num rows: 10 Data size: 1682 Basic stats: COMPLETE Column stats: NONE
-            Select Operator
-              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: 1682 Basic stats: COMPLETE Column stats: NONE
-              Reduce Output Operator
-                key expressions: _col0 (type: int)
-                sort order: +
-                Statistics: Num rows: 10 Data size: 1682 Basic stats: COMPLETE Column stats: NONE
-                value expressions: _col1 (type: int), _col2 (type: double), _col3 (type: string)
-      Reduce Operator Tree:
-        Select Operator
-          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: 1682 Basic stats: COMPLETE Column stats: NONE
-          File Output Operator
-            compressed: false
-            Statistics: Num rows: 10 Data size: 1682 Basic stats: COMPLETE Column stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
-  Stage: Stage-0
-    Fetch Operator
-      limit: -1
-      Processor Tree:
-        ListSink
-
-PREHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=2
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-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
-3	1	-5000.0	original
-4	1	5.2927712E7	original
-5	2	7.74	new
-6	2	56.1431	new
-7	2	2.56	new
-8	2	555.5	new
-9	1	10.0	new
-PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: query: drop table part_change_lower_to_higher_numeric_group_decimal
-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: DOUBLE, (DECIMAL)
---
-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: DOUBLE, (DECIMAL)
---
-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
-PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part=1)
-    values (1, -29.0764, 'original'),
-           (2, 753.7028, 'original'),
-           (3, -5000, 'original'),
-           (4, 52927714, 'original')
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__51
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float@part=1
-POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part=1)
-    values (1, -29.0764, 'original'),
-           (2, 753.7028, 'original'),
-           (3, -5000, 'original'),
-           (4, 52927714, 'original')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__51
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float@part=1
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).b SIMPLE [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-_col0	_col1	_col2
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).b SIMPLE [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+_col0	_col1	_col2	_col3
 PREHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float order by insert_num
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float
@@ -4333,45 +4167,47 @@ insert_num	part	c1	b
 1	1	-29.0764	original
 2	1	753.7028	original
 3	1	-5000.0	original
-4	1	5.2927714E7	original
+4	1	5.2927712E7	original
 PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING)
+alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, c2 decimal(38,18), b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@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 decimal(38,18), b STRING)
+alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, c2 decimal(38,18), b STRING)
 POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float
 PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part)
-    values (5, '774', 'new', 2),
-           (6, '561431', 'new', 2),
-           (7, '256', 'new', 2),
-           (8, '5555', 'new', 2),
-           (9, '100', 'new', 1),
-           (10, '17',  'new', 1)
+    values (5, '774', '774', 'new', 2),
+           (6, '561431', '561431', 'new', 2),
+           (7, '256', '256', 'new', 2),
+           (8, '5555', '5555', 'new', 2),
+           (9, '100', '100', 'new', 1),
+           (10, '17', '17', 'new', 1)
 PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__52
+PREHOOK: Input: default@values__tmp__table__50
 PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float
 POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part)
-    values (5, '774', 'new', 2),
-           (6, '561431', 'new', 2),
-           (7, '256', 'new', 2),
-           (8, '5555', 'new', 2),
-           (9, '100', 'new', 1),
-           (10, '17',  'new', 1)
+    values (5, '774', '774', 'new', 2),
+           (6, '561431', '561431', 'new', 2),
+           (7, '256', '256', 'new', 2),
+           (8, '5555', '5555', 'new', 2),
+           (9, '100', '100', 'new', 1),
+           (10, '17', '17', 'new', 1)
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__52
+POSTHOOK: Input: default@values__tmp__table__50
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float@part=1
 POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float@part=2
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).b SIMPLE [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).b SIMPLE [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).c1 EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-_col0	_col1	_col2	_col3
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+_col0	_col1	_col2	_col3	_col4
 PREHOOK: query: explain
 select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float order by insert_num
 PREHOOK: type: QUERY
@@ -4389,24 +4225,24 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: part_change_lower_to_higher_numeric_group_float
-            Statistics: Num rows: 10 Data size: 1634 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 10 Data size: 1682 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: insert_num (type: int), part (type: int), c1 (type: decimal(38,18)), 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: 1634 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 10 Data size: 1682 Basic stats: COMPLETE Column stats: NONE
               Reduce Output Operator
                 key expressions: _col0 (type: int)
                 sort order: +
-                Statistics: Num rows: 10 Data size: 1634 Basic stats: COMPLETE Column stats: NONE
-                value expressions: _col1 (type: int), _col2 (type: decimal(38,18)), _col3 (type: string)
+                Statistics: Num rows: 10 Data size: 1682 Basic stats: COMPLETE Column stats: NONE
+                value expressions: _col1 (type: int), _col2 (type: double), _col3 (type: string)
       Reduce Operator Tree:
         Select Operator
-          expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: decimal(38,18)), 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: 1634 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 10 Data size: 1682 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 10 Data size: 1634 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 10 Data size: 1682 Basic stats: COMPLETE Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -4431,16 +4267,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.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
+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
 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


Mime
View raw message