hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From omal...@apache.org
Subject [07/43] hive git commit: HIVE-16787 Fix itests in branch-2.2
Date Thu, 20 Jul 2017 20:09:25 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_part_all_primitive.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_part_all_primitive.q.out b/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_part_all_primitive.q.out
index a670a3e..d2c9343 100644
--- a/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_part_all_primitive.q.out
+++ b/ql/src/test/results/clientpositive/tez/schema_evol_text_vec_mapwork_part_all_primitive.q.out
@@ -164,18 +164,20 @@ POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_various_various_tinyint
 PREHOOK: query: insert into table part_change_various_various_tinyint partition(part=1)
-    values(1, true, 2000, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 1000, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72909, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, 90000, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
+    values(1, true, 2000, 72909, 3244222, -29.0764, 470614135, 470614135, '129', '-128', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
+          (2, 0, -128, -48, -20, -9223372036854775808.0, -9223372036854775808.0, 9223372036854775807.0, '128', '-99', '40', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, -1, -129, 100, 499, -9223372036854775809.0, -9223372036854775809.0, 9223372036854775808.0, '128', '-99', '40', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, -72, -127, 127, 30.774, 127.561431, -106.561431, '90.284799488', '90.284799488', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 75, -38, 109.284799488 ,-128.75, 98.75, '120.4', '33.333', '0.45', '2002-05-10 05:29:48.990818073', 'original')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__4
 PREHOOK: Output: default@part_change_various_various_tinyint@part=1
 POSTHOOK: query: insert into table part_change_various_various_tinyint partition(part=1)
-    values(1, true, 2000, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 1000, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72909, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, 90000, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
+    values(1, true, 2000, 72909, 3244222, -29.0764, 470614135, 470614135, '129', '-128', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
+          (2, 0, -128, -48, -20, -9223372036854775808.0, -9223372036854775808.0, 9223372036854775807.0, '128', '-99', '40', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, -1, -129, 100, 499, -9223372036854775809.0, -9223372036854775809.0, 9223372036854775808.0, '128', '-99', '40', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, -72, -127, 127, 30.774, 127.561431, -106.561431, '90.284799488', '90.284799488', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 75, -38, 109.284799488 ,-128.75, 98.75, '120.4', '33.333', '0.45', '2002-05-10 05:29:48.990818073', 'original')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__4
 POSTHOOK: Output: default@part_change_various_various_tinyint@part=1
@@ -204,10 +206,11 @@ POSTHOOK: Input: default@part_change_various_various_tinyint
 POSTHOOK: Input: default@part_change_various_various_tinyint@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
-1	1	true	2000	72909	3244222	-29.0764	4.70614135E8	470614135.000000000000000000	-2999	-2999                    	-2999	0004-09-22 18:26:29.519542222	original
-2	1	true	1000	483777	-23866739993	-3651.672	46114.284799488	46114.284799488000000000		                         		2007-02-09 05:17:29.368756876	original
-3	1	false	NULL	3244222	-93222	30.774	-66475.561431	-66475.561431000000000000	1	1                        	1	6229-06-28 02:54:28.970117179	original
-4	1	true	NULL	754072151	3289094	46114.285	9250340.75	9250340.750000000000000000	5299	5299                     	5299	2002-05-10 05:29:48.990818073	original
+1	1	true	2000	72909	3244222	-29.0764	4.70614135E8	470614135.000000000000000000	129	-128                     	-2999	0004-09-22 18:26:29.519542222	original
+2	1	true	-128	-48	-20	-9.223372E18	-9.223372036854776E18	9223372036854775807.000000000000000000	128	-99                      	40	2007-02-09 05:17:29.368756876	original
+3	1	true	-129	100	499	-9.223372E18	-9.223372036854776E18	9223372036854775808.000000000000000000	128	-99                      	40	2007-02-09 05:17:29.368756876	original
+4	1	false	-72	-127	127	30.774	127.561431	-106.561431000000000000	90.284799488	90.284799488             	1	6229-06-28 02:54:28.970117179	original
+5	1	true	-90	75	-38	109.2848	-128.75	98.750000000000000000	120.4	33.333                   	0.45	2002-05-10 05:29:48.990818073	original
 PREHOOK: query: alter table part_change_various_various_tinyint replace columns (insert_num int, c1 TINYINT, c2 TINYINT, c3 TINYINT, c4 TINYINT, c5 TINYINT, c6 TINYINT, c7 TINYINT, c8 TINYINT, c9 TINYINT, c10 TINYINT, c11 TINYINT, b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_various_various_tinyint
@@ -217,12 +220,12 @@ POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_various_various_tinyint
 POSTHOOK: Output: default@part_change_various_various_tinyint
 PREHOOK: query: insert into table part_change_various_various_tinyint partition(part=2)
-    values (5, 23, 71, 127, 1, 131, -60, 68, -230, -182, 40, 93, 'new')
+    values (6, 23, 71, 127, 1, 131, -60, 68, -230, -182, 40, 93, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__5
 PREHOOK: Output: default@part_change_various_various_tinyint@part=2
 POSTHOOK: query: insert into table part_change_various_various_tinyint partition(part=2)
-    values (5, 23, 71, 127, 1, 131, -60, 68, -230, -182, 40, 93, 'new')
+    values (6, 23, 71, 127, 1, 131, -60, 68, -230, -182, 40, 93, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__5
 POSTHOOK: Output: default@part_change_various_various_tinyint@part=2
@@ -241,12 +244,12 @@ POSTHOOK: Lineage: part_change_various_various_tinyint PARTITION(part=2).c9 EXPR
 POSTHOOK: Lineage: part_change_various_various_tinyint PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__5)values__tmp__table__5.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: insert into table part_change_various_various_tinyint partition(part=1)
-    values (6, -248, 85, -126, -167, 91, 113, -28, -63, 0, 8, 237, 'new')
+    values (7, -120, 85, -126, -167, 91, 113, -28, -63, 0, 8, 237, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__6
 PREHOOK: Output: default@part_change_various_various_tinyint@part=1
 POSTHOOK: query: insert into table part_change_various_various_tinyint partition(part=1)
-    values (6, -248, 85, -126, -167, 91, 113, -28, -63, 0, 8, 237, 'new')
+    values (7, -120, 85, -126, -167, 91, 113, -28, -63, 0, 8, 237, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__6
 POSTHOOK: Output: default@part_change_various_various_tinyint@part=1
@@ -282,13 +285,13 @@ Stage-0
     Stage-1
       Reducer 2 vectorized
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=112)
+        Select Operator [SEL_7] (rows=7 width=119)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
         <-Map 1 [SIMPLE_EDGE] vectorized
           SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=6 width=112)
+            Select Operator [SEL_5] (rows=7 width=119)
               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=6 width=112)
+              TableScan [TS_0] (rows=7 width=119)
                 default@part_change_various_various_tinyint,part_change_various_various_tinyint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_tinyint order by insert_num
@@ -304,12 +307,13 @@ POSTHOOK: Input: default@part_change_various_various_tinyint@part=1
 POSTHOOK: Input: default@part_change_various_various_tinyint@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
-1	1	1	-48	-51	-66	-29	119	NULL	73	73	73	-43	original
-2	1	1	-24	-63	-25	-67	34	NULL	NULL	NULL	NULL	105	original
-3	1	0	NULL	-66	-38	30	85	NULL	1	1	1	84	original
-4	1	1	NULL	87	6	34	36	NULL	-77	-77	-77	60	original
-5	2	23	71	127	1	NULL	-60	68	NULL	NULL	40	93	new
-6	1	NULL	85	-126	NULL	91	113	-28	-63	0	8	NULL	new
+1	1	1	-48	-51	-66	-29	119	NULL	-127	-128	73	-43	original
+2	1	1	-128	-48	-20	0	0	NULL	-128	-99	40	105	original
+3	1	1	127	100	-13	0	0	NULL	-128	-99	40	105	original
+4	1	0	-72	-127	127	30	127	-106	90	NULL	1	84	original
+5	1	1	-90	75	-38	109	-128	98	120	NULL	NULL	60	original
+6	2	23	71	127	1	NULL	-60	68	NULL	NULL	40	93	new
+7	1	NULL	85	-126	NULL	91	113	-28	-63	0	8	NULL	new
 PREHOOK: query: drop table part_change_various_various_tinyint
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_various_various_tinyint
@@ -328,17 +332,19 @@ POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_various_various_smallint
 PREHOOK: query: insert into table part_change_various_various_smallint partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, -32768 , 32767, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '9000', '32767', '-32768', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, -127, -40000 , 32768, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '9000', '32767', '-32768', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 32422, -9322, 30.774, -6675.561431, -6675.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 7151, 3094, 30000.284799488 ,-9000.75, 0.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__7
 PREHOOK: Output: default@part_change_various_various_smallint@part=1
 POSTHOOK: query: insert into table part_change_various_various_smallint partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, -32768 , 32767, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '9000', '32767', '-32768', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, -127, -40000 , 32768, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '9000', '32767', '-32768', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 32422, -9322, 30.774, -6675.561431, -6675.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 7151, 3094, 30000.284799488 ,-9000.75, 0.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__7
 POSTHOOK: Output: default@part_change_various_various_smallint@part=1
@@ -368,9 +374,10 @@ POSTHOOK: Input: default@part_change_various_various_smallint@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	true	NULL	72909	3244222	-29.0764	4.70614135E8	470614135.000000000000000000	-2999	-2999                    	-2999	0004-09-22 18:26:29.519542222	original
-2	1	true	100	483777	-23866739993	-3651.672	46114.284799488	46114.284799488000000000		                         		2007-02-09 05:17:29.368756876	original
-3	1	false	72	3244222	-93222	30.774	-66475.561431	-66475.561431000000000000	1	1                        	1	6229-06-28 02:54:28.970117179	original
-4	1	true	-90	754072151	3289094	46114.285	9250340.75	9250340.750000000000000000	5299	5299                     	5299	2002-05-10 05:29:48.990818073	original
+2	1	true	100	-32768	32767	-3651.672	-9.223372036854776E18	9223372036854775807.000000000000000000	9000	32767                    	-32768	2007-02-09 05:17:29.368756876	original
+3	1	true	-127	-40000	32768	-3651.672	-9.223372036854776E18	9223372036854775808.000000000000000000	9000	32767                    	-32768	2007-02-09 05:17:29.368756876	original
+4	1	false	72	32422	-9322	30.774	-6675.561431	-6675.561431000000000000	1	1                        	1	6229-06-28 02:54:28.970117179	original
+5	1	true	-90	7151	3094	30000.285	-9000.75	0.750000000000000000	5299	5299                     	5299	2002-05-10 05:29:48.990818073	original
 PREHOOK: query: alter table part_change_various_various_smallint replace columns (insert_num int, c1 SMALLINT, c2 SMALLINT, c3 SMALLINT, c4 SMALLINT, c5 SMALLINT, c6 SMALLINT, c7 SMALLINT, c8 SMALLINT, c9 SMALLINT, c10 SMALLINT, c11 SMALLINT, b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_various_various_smallint
@@ -380,12 +387,12 @@ POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_various_various_smallint
 POSTHOOK: Output: default@part_change_various_various_smallint
 PREHOOK: query: insert into table part_change_various_various_smallint partition(part=2)
-    values (5, -30486, 15230, 3117, 1, -117, -7131, 20227, -24858, -28771, 46114, 72909, 'new')
+    values (6, -30486, 15230, 3117, 1, -117, -7131, 20227, -24858, -28771, 46114, 72909, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__8
 PREHOOK: Output: default@part_change_various_various_smallint@part=2
 POSTHOOK: query: insert into table part_change_various_various_smallint partition(part=2)
-    values (5, -30486, 15230, 3117, 1, -117, -7131, 20227, -24858, -28771, 46114, 72909, 'new')
+    values (6, -30486, 15230, 3117, 1, -117, -7131, 20227, -24858, -28771, 46114, 72909, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__8
 POSTHOOK: Output: default@part_change_various_various_smallint@part=2
@@ -404,12 +411,12 @@ POSTHOOK: Lineage: part_change_various_various_smallint PARTITION(part=2).c9 EXP
 POSTHOOK: Lineage: part_change_various_various_smallint PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__8)values__tmp__table__8.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: insert into table part_change_various_various_smallint partition(part=1)
-    values (6, -10542, -1805, -4844, 15507, 91, 22385, -28, -12268, 0, 66475, 774, 'new')
+    values (7, -10542, -1805, -4844, 15507, 91, 22385, -28, -12268, 0, 66475, 774, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__9
 PREHOOK: Output: default@part_change_various_various_smallint@part=1
 POSTHOOK: query: insert into table part_change_various_various_smallint partition(part=1)
-    values (6, -10542, -1805, -4844, 15507, 91, 22385, -28, -12268, 0, 66475, 774, 'new')
+    values (7, -10542, -1805, -4844, 15507, 91, 22385, -28, -12268, 0, 66475, 774, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__9
 POSTHOOK: Output: default@part_change_various_various_smallint@part=1
@@ -445,13 +452,13 @@ Stage-0
     Stage-1
       Reducer 2 vectorized
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=118)
+        Select Operator [SEL_7] (rows=7 width=126)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
         <-Map 1 [SIMPLE_EDGE] vectorized
           SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=6 width=118)
+            Select Operator [SEL_5] (rows=7 width=126)
               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=6 width=118)
+              TableScan [TS_0] (rows=7 width=126)
                 default@part_change_various_various_smallint,part_change_various_various_smallint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_smallint order by insert_num
@@ -468,11 +475,12 @@ POSTHOOK: Input: default@part_change_various_various_smallint@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	1	NULL	7373	-32578	-29	119	NULL	-2999	-2999	-2999	-11819	original
-2	1	1	100	25025	29415	-3651	-19422	NULL	NULL	NULL	NULL	29801	original
-3	1	0	72	-32578	-27686	30	-939	NULL	1	1	1	-8620	original
-4	1	1	-90	14935	12294	-19422	9764	NULL	5299	5299	5299	-17092	original
-5	2	-30486	15230	3117	1	-117	-7131	20227	-24858	-28771	NULL	NULL	new
-6	1	NULL	NULL	-4844	15507	91	22385	-28	-12268	0	NULL	NULL	new
+2	1	1	100	-32768	32767	-3651	0	NULL	9000	32767	-32768	29801	original
+3	1	1	-127	25536	-32768	-3651	0	NULL	9000	32767	-32768	29801	original
+4	1	0	72	32422	-9322	30	-6675	-6675	1	1	1	-8620	original
+5	1	1	-90	7151	3094	30000	-9000	0	5299	5299	5299	-17092	original
+6	2	-30486	15230	3117	1	-117	-7131	20227	-24858	-28771	NULL	NULL	new
+7	1	NULL	NULL	-4844	15507	91	22385	-28	-12268	0	NULL	NULL	new
 PREHOOK: query: drop table part_change_various_various_smallint
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_various_various_smallint
@@ -491,17 +499,19 @@ POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_various_various_int
 PREHOOK: query: insert into table part_change_various_various_int partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, 2147483647, -23866739993, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, 2147483648, -23866739993, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__10
 PREHOOK: Output: default@part_change_various_various_int@part=1
 POSTHOOK: query: insert into table part_change_various_various_int partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, 2147483647, -23866739993, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, 2147483648, -23866739993, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__10
 POSTHOOK: Output: default@part_change_various_various_int@part=1
@@ -531,9 +541,10 @@ POSTHOOK: Input: default@part_change_various_various_int@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	true	NULL	NULL	3244222	-29.0764	4.70614135E8	470614135.000000000000000000	-2999	-2999                    	-2999	0004-09-22 18:26:29.519542222	original
-2	1	true	100	NULL	-23866739993	-3651.672	46114.284799488	46114.284799488000000000		                         		2007-02-09 05:17:29.368756876	original
-3	1	false	72	NULL	-93222	30.774	-66475.561431	-66475.561431000000000000	1	1                        	1	6229-06-28 02:54:28.970117179	original
-4	1	true	-90	NULL	3289094	46114.285	9250340.75	9250340.750000000000000000	5299	5299                     	5299	2002-05-10 05:29:48.990818073	original
+2	1	true	100	NULL	-23866739993	-3651.672	-9.223372036854776E18	9223372036854775807.000000000000000000		                         		2007-02-09 05:17:29.368756876	original
+3	1	true	100	NULL	-23866739993	-3651.672	-9.223372036854776E18	9223372036854775808.000000000000000000		                         		2007-02-09 05:17:29.368756876	original
+4	1	false	72	NULL	-93222	30.774	-66475.561431	-66475.561431000000000000	1	1                        	1	6229-06-28 02:54:28.970117179	original
+5	1	true	-90	NULL	3289094	46114.285	9250340.75	9250340.750000000000000000	5299	5299                     	5299	2002-05-10 05:29:48.990818073	original
 PREHOOK: query: alter table part_change_various_various_int replace columns (insert_num int, c1 INT, c2 INT, c3 INT, c4 INT, c5 INT, c6 INT, c7 INT, c8 INT, c9 INT, c10 INT, c11 INT, b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_various_various_int
@@ -608,13 +619,13 @@ Stage-0
     Stage-1
       Reducer 2 vectorized
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=121)
+        Select Operator [SEL_7] (rows=7 width=130)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
         <-Map 1 [SIMPLE_EDGE] vectorized
           SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=6 width=121)
+            Select Operator [SEL_5] (rows=7 width=130)
               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=6 width=121)
+              TableScan [TS_0] (rows=7 width=130)
                 default@part_change_various_various_int,part_change_various_various_int,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_int order by insert_num
@@ -631,9 +642,10 @@ POSTHOOK: Input: default@part_change_various_various_int@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	1	NULL	NULL	3244222	-29	470614135	470614135	-2999	-2999	-2999	-1888628267	original
-2	1	1	100	NULL	1903063783	-3651	46114	46114	NULL	NULL	NULL	1171027049	original
-3	1	0	72	NULL	-93222	30	-66475	-66475	1	1	1	1272503892	original
-4	1	1	-90	NULL	3289094	46114	9250340	9250340	5299	5299	5299	1021033788	original
+2	1	1	100	NULL	1903063783	-3651	-2147483648	NULL	NULL	NULL	NULL	1171027049	original
+3	1	1	100	NULL	1903063783	-3651	-2147483648	NULL	NULL	NULL	NULL	1171027049	original
+4	1	0	72	NULL	-93222	30	-66475	-66475	1	1	1	1272503892	original
+5	1	1	-90	NULL	3289094	46114	9250340	9250340	5299	5299	5299	1021033788	original
 5	2	560930	-1281818	127	1	84269672	-60	27094665	-36016110	-182	3244222	561431	new
 6	1	NULL	NULL	NULL	-167	91	113	-164341325	-134237413	0	6229	NULL	new
 PREHOOK: query: drop table part_change_various_various_int
@@ -654,17 +666,19 @@ POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_various_various_bigint
 PREHOOK: query: insert into table part_change_various_various_bigint partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '1998287.3541', '1998287.3541', '1998287.3541', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '1998287.3541', '1998287.3541', '1998287.3541', '2002-05-10 05:29:48.990818073', 'original')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__13
 PREHOOK: Output: default@part_change_various_various_bigint@part=1
 POSTHOOK: query: insert into table part_change_various_various_bigint partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '1998287.3541', '1998287.3541', '1998287.3541', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '1998287.3541', '1998287.3541', '1998287.3541', '2002-05-10 05:29:48.990818073', 'original')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__13
 POSTHOOK: Output: default@part_change_various_various_bigint@part=1
@@ -694,9 +708,10 @@ POSTHOOK: Input: default@part_change_various_various_bigint@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	true	NULL	NULL	3244222	-29.0764	4.70614135E8	470614135.000000000000000000	-2999	-2999                    	-2999	0004-09-22 18:26:29.519542222	original
-2	1	true	100	NULL	NULL	-3651.672	46114.284799488	46114.284799488000000000		                         		2007-02-09 05:17:29.368756876	original
-3	1	false	72	NULL	-93222	30.774	-66475.561431	-66475.561431000000000000	1	1                        	1	6229-06-28 02:54:28.970117179	original
-4	1	true	-90	NULL	3289094	46114.285	9250340.75	9250340.750000000000000000	1998287.3541	1998287.3541             	1998287.3541	2002-05-10 05:29:48.990818073	original
+2	1	true	100	32767	NULL	-3651.672	-9.223372036854776E18	9223372036854775807.000000000000000000		                         		2007-02-09 05:17:29.368756876	original
+3	1	true	100	-32768	NULL	-3651.672	-9.223372036854776E18	9223372036854775808.000000000000000000		                         		2007-02-09 05:17:29.368756876	original
+4	1	false	72	NULL	-93222	30.774	-66475.561431	-66475.561431000000000000	1	1                        	1	6229-06-28 02:54:28.970117179	original
+5	1	true	-90	NULL	3289094	46114.285	9250340.75	9250340.750000000000000000	1998287.3541	1998287.3541             	1998287.3541	2002-05-10 05:29:48.990818073	original
 PREHOOK: query: alter table part_change_various_various_bigint replace columns (insert_num int, c1 BIGINT, c2 BIGINT, c3 BIGINT, c4 BIGINT, c5 BIGINT, c6 BIGINT, c7 BIGINT, c8 BIGINT, c9 BIGINT, c10 BIGINT, c11 BIGINT, b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_various_various_bigint
@@ -706,12 +721,12 @@ POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_various_various_bigint
 POSTHOOK: Output: default@part_change_various_various_bigint
 PREHOOK: query: insert into table part_change_various_various_bigint partition(part=2)
-    values (5, 5573199346255528403, 71, 151775655, 1, 131, -60, 6275638713485623898, -230, -695025, 519542222, -29.0764, 'new')
+    values (6, 5573199346255528403, 71, 151775655, 1, 131, -60, 6275638713485623898, -230, -695025, 519542222, -29.0764, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__14
 PREHOOK: Output: default@part_change_various_various_bigint@part=2
 POSTHOOK: query: insert into table part_change_various_various_bigint partition(part=2)
-    values (5, 5573199346255528403, 71, 151775655, 1, 131, -60, 6275638713485623898, -230, -695025, 519542222, -29.0764, 'new')
+    values (6, 5573199346255528403, 71, 151775655, 1, 131, -60, 6275638713485623898, -230, -695025, 519542222, -29.0764, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__14
 POSTHOOK: Output: default@part_change_various_various_bigint@part=2
@@ -730,12 +745,12 @@ POSTHOOK: Lineage: part_change_various_various_bigint PARTITION(part=2).c9 EXPRE
 POSTHOOK: Lineage: part_change_various_various_bigint PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__14)values__tmp__table__14.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: insert into table part_change_various_various_bigint partition(part=1)
-    values (6, -164341325, 9043162437544575070, -126, -6566204574741299000, 91, 113, -28, -63, 0, 3244222, -90, 'new')
+    values (7, -164341325, 9043162437544575070, -126, -6566204574741299000, 91, 113, -28, -63, 0, 3244222, -90, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__15
 PREHOOK: Output: default@part_change_various_various_bigint@part=1
 POSTHOOK: query: insert into table part_change_various_various_bigint partition(part=1)
-    values (6, -164341325, 9043162437544575070, -126, -6566204574741299000, 91, 113, -28, -63, 0, 3244222, -90, 'new')
+    values (7, -164341325, 9043162437544575070, -126, -6566204574741299000, 91, 113, -28, -63, 0, 3244222, -90, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__15
 POSTHOOK: Output: default@part_change_various_various_bigint@part=1
@@ -771,13 +786,13 @@ Stage-0
     Stage-1
       Reducer 2 vectorized
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=127)
+        Select Operator [SEL_7] (rows=7 width=135)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
         <-Map 1 [SIMPLE_EDGE] vectorized
           SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=6 width=127)
+            Select Operator [SEL_5] (rows=7 width=135)
               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=6 width=127)
+              TableScan [TS_0] (rows=7 width=135)
                 default@part_change_various_various_bigint,part_change_various_various_bigint,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_bigint order by insert_num
@@ -794,11 +809,12 @@ POSTHOOK: Input: default@part_change_various_various_bigint@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	1	NULL	NULL	3244222	-29	470614135	470614135	-2999	-2999	-2999	-62018170411	original
-2	1	1	100	NULL	NULL	-3651	46114	46114	NULL	NULL	NULL	1171027049	original
-3	1	0	72	NULL	-93222	30	-66475	-66475	1	1	1	134416490068	original
-4	1	1	-90	NULL	3289094	46114	9250340	9250340	1998287	NULL	NULL	1021033788	original
-5	2	5573199346255528403	71	151775655	1	131	-60	6275638713485623898	-230	-695025	519542222	-29	new
-6	1	NULL	NULL	-126	NULL	91	113	-28	-63	0	3244222	NULL	new
+2	1	1	100	32767	NULL	-3651	-9223372036854775808	9223372036854775807	NULL	NULL	NULL	1171027049	original
+3	1	1	100	-32768	NULL	-3651	-9223372036854775808	NULL	NULL	NULL	NULL	1171027049	original
+4	1	0	72	NULL	-93222	30	-66475	-66475	1	1	1	134416490068	original
+5	1	1	-90	NULL	3289094	46114	9250340	9250340	1998287	NULL	NULL	1021033788	original
+6	2	5573199346255528403	71	151775655	1	131	-60	6275638713485623898	-230	-695025	519542222	-29	new
+7	1	NULL	NULL	-126	NULL	91	113	-28	-63	0	3244222	NULL	new
 PREHOOK: query: drop table part_change_various_various_bigint
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_various_various_bigint
@@ -817,17 +833,19 @@ POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_various_various_float
 PREHOOK: query: insert into table part_change_various_various_float partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '2402.3', '2402.3', '2402.3', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '2402.3', '2402.3', '2402.3', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__16
 PREHOOK: Output: default@part_change_various_various_float@part=1
 POSTHOOK: query: insert into table part_change_various_various_float partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '2402.3', '2402.3', '2402.3', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '2402.3', '2402.3', '2402.3', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__16
 POSTHOOK: Output: default@part_change_various_various_float@part=1
@@ -857,9 +875,10 @@ POSTHOOK: Input: default@part_change_various_various_float@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	true	NULL	NULL	3244222	-29	4.70614135E8	470614135.000000000000000000	-2999	-2999                    	-2999	0004-09-22 18:26:29.519542222	original
-2	1	true	100	NULL	NULL	-3651	46114.284799488	46114.284799488000000000		                         		2007-02-09 05:17:29.368756876	original
-3	1	false	72	NULL	-93222	30	-66475.561431	-66475.561431000000000000	2402.3	2402.3                   	2402.3	6229-06-28 02:54:28.970117179	original
-4	1	true	-90	NULL	3289094	46114	9250340.75	9250340.750000000000000000	5299	5299                     	5299	2002-05-10 05:29:48.990818073	original
+2	1	true	100	32767	NULL	-3651	-9.223372036854776E18	9223372036854775807.000000000000000000		                         		2007-02-09 05:17:29.368756876	original
+3	1	true	100	-32768	NULL	-3651	-9.223372036854776E18	9223372036854775808.000000000000000000		                         		2007-02-09 05:17:29.368756876	original
+4	1	false	72	NULL	-93222	30	-66475.561431	-66475.561431000000000000	2402.3	2402.3                   	2402.3	6229-06-28 02:54:28.970117179	original
+5	1	true	-90	NULL	3289094	46114	9250340.75	9250340.750000000000000000	5299	5299                     	5299	2002-05-10 05:29:48.990818073	original
 PREHOOK: query: alter table part_change_various_various_float replace columns (insert_num int, c1 FLOAT, c2 FLOAT, c3 FLOAT, c4 FLOAT, c5 FLOAT, c6 FLOAT, c7 FLOAT, c8 FLOAT, c9 FLOAT, c10 FLOAT, c11 FLOAT, b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_various_various_float
@@ -869,12 +888,12 @@ POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_various_various_float
 POSTHOOK: Output: default@part_change_various_various_float
 PREHOOK: query: insert into table part_change_various_various_float partition(part=2)
-    values (5, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, -3651.67212, 46114.28, 'new')
+    values (6, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, -3651.67212, 46114.28, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__17
 PREHOOK: Output: default@part_change_various_various_float@part=2
 POSTHOOK: query: insert into table part_change_various_various_float partition(part=2)
-    values (5, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, -3651.67212, 46114.28, 'new')
+    values (6, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, -3651.67212, 46114.28, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__17
 POSTHOOK: Output: default@part_change_various_various_float@part=2
@@ -893,12 +912,12 @@ POSTHOOK: Lineage: part_change_various_various_float PARTITION(part=2).c9 EXPRES
 POSTHOOK: Lineage: part_change_various_various_float PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__17)values__tmp__table__17.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: insert into table part_change_various_various_float partition(part=1)
-    values (6, -1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -93222.200, 29.076, 'new')
+    values (7, -1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -93222.200, 29.076, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__18
 PREHOOK: Output: default@part_change_various_various_float@part=1
 POSTHOOK: query: insert into table part_change_various_various_float partition(part=1)
-    values (6, -1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -93222.200, 29.076, 'new')
+    values (7, -1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -93222.200, 29.076, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__18
 POSTHOOK: Output: default@part_change_various_various_float@part=1
@@ -934,13 +953,13 @@ Stage-0
     Stage-1
       Reducer 2 vectorized
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=127)
+        Select Operator [SEL_7] (rows=7 width=134)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
         <-Map 1 [SIMPLE_EDGE] vectorized
           SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=6 width=127)
+            Select Operator [SEL_5] (rows=7 width=134)
               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=6 width=127)
+              TableScan [TS_0] (rows=7 width=134)
                 default@part_change_various_various_float,part_change_various_various_float,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_float order by insert_num
@@ -957,11 +976,12 @@ POSTHOOK: Input: default@part_change_various_various_float@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	1.0	NULL	NULL	3244222.0	-29.0	4.70614144E8	4.70614144E8	-2999.0	-2999.0	-2999.0	-6.2018171E10	original
-2	1	1.0	100.0	NULL	NULL	-3651.0	46114.285	46114.285	NULL	NULL	NULL	1.17102707E9	original
-3	1	0.0	72.0	NULL	-93222.0	30.0	-66475.56	-66475.56	2402.3	2402.3	2402.3	1.3441649E11	original
-4	1	1.0	-90.0	NULL	3289094.0	46114.0	9250341.0	9250341.0	5299.0	5299.0	5299.0	1.02103379E9	original
-5	2	9.5396704E8	62.079155	718.78	1.0	203.19955	-60.0	6.2756385E18	-230.0	-695025.0	-3651.672	46114.28	new
-6	1	NULL	NULL	-4314.0	NULL	91.0	1698.95	-100.35978	-63.0	0.0	-93222.2	NULL	new
+2	1	1.0	100.0	32767.0	NULL	-3651.0	-9.223372E18	9.223372E18	NULL	NULL	NULL	1.17102707E9	original
+3	1	1.0	100.0	-32768.0	NULL	-3651.0	-9.223372E18	9.223372E18	NULL	NULL	NULL	1.17102707E9	original
+4	1	0.0	72.0	NULL	-93222.0	30.0	-66475.56	-66475.56	2402.3	2402.3	2402.3	1.3441649E11	original
+5	1	1.0	-90.0	NULL	3289094.0	46114.0	9250341.0	9250341.0	5299.0	5299.0	5299.0	1.02103379E9	original
+6	2	9.5396704E8	62.079155	718.78	1.0	203.19955	-60.0	6.2756385E18	-230.0	-695025.0	-3651.672	46114.28	new
+7	1	NULL	NULL	-4314.0	NULL	91.0	1698.95	-100.35978	-63.0	0.0	-93222.2	NULL	new
 PREHOOK: query: drop table part_change_various_various_float
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_various_various_float
@@ -980,17 +1000,19 @@ POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_various_various_double
 PREHOOK: query: insert into table part_change_various_various_double partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__19
 PREHOOK: Output: default@part_change_various_various_double@part=1
 POSTHOOK: query: insert into table part_change_various_various_double partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '-2999', '-2999', '-2999', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '5299', '5299', '5299', '2002-05-10 05:29:48.990818073', 'original')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__19
 POSTHOOK: Output: default@part_change_various_various_double@part=1
@@ -1020,9 +1042,10 @@ POSTHOOK: Input: default@part_change_various_various_double@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	true	NULL	NULL	3244222	-29	4.70614135E8	470614135.000000000000000000	-2999	-2999                    	-2999	0004-09-22 18:26:29.519542222	original
-2	1	true	100	NULL	NULL	-3651	46114.284799488	46114.284799488000000000		                         		2007-02-09 05:17:29.368756876	original
-3	1	false	72	NULL	-93222	30	-66475.561431	-66475.561431000000000000	1	1                        	1	6229-06-28 02:54:28.970117179	original
-4	1	true	-90	NULL	3289094	46114	9250340.75	9250340.750000000000000000	5299	5299                     	5299	2002-05-10 05:29:48.990818073	original
+2	1	true	100	32767	NULL	-3651	-9.223372036854776E18	9223372036854775807.000000000000000000		                         		2007-02-09 05:17:29.368756876	original
+3	1	true	100	-32768	NULL	-3651	-9.223372036854776E18	9223372036854775808.000000000000000000		                         		2007-02-09 05:17:29.368756876	original
+4	1	false	72	NULL	-93222	30	-66475.561431	-66475.561431000000000000	1	1                        	1	6229-06-28 02:54:28.970117179	original
+5	1	true	-90	NULL	3289094	46114	9250340.75	9250340.750000000000000000	5299	5299                     	5299	2002-05-10 05:29:48.990818073	original
 PREHOOK: query: alter table part_change_various_various_double replace columns (insert_num int, c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 DOUBLE, c6 DOUBLE, c7 DOUBLE, c8 DOUBLE, c9 DOUBLE, c10 DOUBLE, c11 DOUBLE, b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_various_various_double
@@ -1032,12 +1055,12 @@ POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_various_various_double
 POSTHOOK: Output: default@part_change_various_various_double
 PREHOOK: query: insert into table part_change_various_various_double partition(part=2)
-    values (5, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, 0.00007011717, 4.28479948, 'new')
+    values (6, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, 0.00007011717, 4.28479948, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__20
 PREHOOK: Output: default@part_change_various_various_double@part=2
 POSTHOOK: query: insert into table part_change_various_various_double partition(part=2)
-    values (5, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, 0.00007011717, 4.28479948, 'new')
+    values (6, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, 0.00007011717, 4.28479948, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__20
 POSTHOOK: Output: default@part_change_various_various_double@part=2
@@ -1056,12 +1079,12 @@ POSTHOOK: Lineage: part_change_various_various_double PARTITION(part=2).c9 EXPRE
 POSTHOOK: Lineage: part_change_various_various_double PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__20)values__tmp__table__20.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: insert into table part_change_various_various_double partition(part=1)
-    values (6, -1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -66475.0000008, -284799488.1, 'new')
+    values (7, -1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -66475.0000008, -284799488.1, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__21
 PREHOOK: Output: default@part_change_various_various_double@part=1
 POSTHOOK: query: insert into table part_change_various_various_double partition(part=1)
-    values (6, -1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -66475.0000008, -284799488.1, 'new')
+    values (7, -1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -66475.0000008, -284799488.1, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__21
 POSTHOOK: Output: default@part_change_various_various_double@part=1
@@ -1097,13 +1120,13 @@ Stage-0
     Stage-1
       Reducer 2 vectorized
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=135)
+        Select Operator [SEL_7] (rows=7 width=141)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
         <-Map 1 [SIMPLE_EDGE] vectorized
           SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=6 width=135)
+            Select Operator [SEL_5] (rows=7 width=141)
               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=6 width=135)
+              TableScan [TS_0] (rows=7 width=141)
                 default@part_change_various_various_double,part_change_various_various_double,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_double order by insert_num
@@ -1120,11 +1143,12 @@ POSTHOOK: Input: default@part_change_various_various_double@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	1.0	NULL	NULL	3244222.0	-29.0	4.70614135E8	4.70614135E8	-2999.0	-2999.0	-2999.0	-6.201817041048046E10	original
-2	1	1.0	100.0	NULL	NULL	-3651.0	46114.284799488	46114.284799488	NULL	NULL	NULL	1.1710270493687568E9	original
-3	1	0.0	72.0	NULL	-93222.0	30.0	-66475.561431	-66475.561431	1.0	1.0	1.0	1.3441649006897012E11	original
-4	1	1.0	-90.0	NULL	3289094.0	46114.0	9250340.75	9250340.75	5299.0	5299.0	5299.0	1.021033788990818E9	original
-5	2	9.53967041E8	62.07915395590135	718.78	1.0	203.199548118	-60.0	6.2756387134856243E18	-230.0	-695025.0	7.011717E-5	4.28479948	new
-6	1	NULL	NULL	-4314.0	NULL	91.0	1698.95	-100.3597812	-63.0	0.0	-66475.0000008	NULL	new
+2	1	1.0	100.0	32767.0	NULL	-3651.0	-9.223372036854776E18	9.223372036854776E18	NULL	NULL	NULL	1.1710270493687568E9	original
+3	1	1.0	100.0	-32768.0	NULL	-3651.0	-9.223372036854776E18	9.223372036854776E18	NULL	NULL	NULL	1.1710270493687568E9	original
+4	1	0.0	72.0	NULL	-93222.0	30.0	-66475.561431	-66475.561431	1.0	1.0	1.0	1.3441649006897012E11	original
+5	1	1.0	-90.0	NULL	3289094.0	46114.0	9250340.75	9250340.75	5299.0	5299.0	5299.0	1.021033788990818E9	original
+6	2	9.53967041E8	62.07915395590135	718.78	1.0	203.199548118	-60.0	6.2756387134856243E18	-230.0	-695025.0	7.011717E-5	4.28479948	new
+7	1	NULL	NULL	-4314.0	NULL	91.0	1698.95	-100.3597812	-63.0	0.0	-66475.0000008	NULL	new
 PREHOOK: query: drop table part_change_various_various_double
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_various_various_double
@@ -1143,17 +1167,19 @@ POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_various_various_decimal
 PREHOOK: query: insert into table part_change_various_various_decimal partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '--1551801.09502', '--1551801.09502', '--1551801.09502', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '2402.3', '2402.3', '2402.3', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '2402.3', '2402.3', '2402.3', '2002-05-10 05:29:48.990818073', 'original')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__22
 PREHOOK: Output: default@part_change_various_various_decimal@part=1
 POSTHOOK: query: insert into table part_change_various_various_decimal partition(part=1)
     values(1, -2999, 200, 72909, 3244222, -29.0764, 470614135, 470614135, '--1551801.09502', '--1551801.09502', '--1551801.09502', '0004-09-22 18:26:29.519542222', 'original'),
-          (2, 0, 100, 483777, -23866739993, -3651.672121, 46114.284799488, 46114.284799488, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
-          (3, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
-          (4, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '2402.3', '2402.3', '2402.3', '2002-05-10 05:29:48.990818073', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72, 3244222, -93222, 30.774, -66475.561431, -66475.561431, '1', '1', '1', '6229-06-28 02:54:28.970117179', 'original'),
+          (5, 1, -90, 754072151, 3289094, 46114.284799488 ,9250340.75, 9250340.75, '2402.3', '2402.3', '2402.3', '2002-05-10 05:29:48.990818073', 'original')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__22
 POSTHOOK: Output: default@part_change_various_various_decimal@part=1
@@ -1183,9 +1209,10 @@ POSTHOOK: Input: default@part_change_various_various_decimal@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	true	NULL	NULL	3244222	-29	4.70614144E8	4.70614135E8	--1551801.09502	--1551801.09502          	--1551801.09502	0004-09-22 18:26:29.519542222	original
-2	1	true	100	NULL	NULL	-3651	46114.285	46114.284799488		                         		2007-02-09 05:17:29.368756876	original
-3	1	false	72	NULL	-93222	30	-66475.56	-66475.561431	1	1                        	1	6229-06-28 02:54:28.970117179	original
-4	1	true	-90	NULL	3289094	46114	9250341.0	9250340.75	2402.3	2402.3                   	2402.3	2002-05-10 05:29:48.990818073	original
+2	1	true	100	32767	NULL	-3651	-9.223372E18	9.223372036854776E18		                         		2007-02-09 05:17:29.368756876	original
+3	1	true	100	-32768	NULL	-3651	-9.223372E18	9.223372036854776E18		                         		2007-02-09 05:17:29.368756876	original
+4	1	false	72	NULL	-93222	30	-66475.56	-66475.561431	1	1                        	1	6229-06-28 02:54:28.970117179	original
+5	1	true	-90	NULL	3289094	46114	9250341.0	9250340.75	2402.3	2402.3                   	2402.3	2002-05-10 05:29:48.990818073	original
 PREHOOK: query: alter table part_change_various_various_decimal replace columns (insert_num int, c1 DECIMAL(38,18), c2 DECIMAL(38,18), c3 DECIMAL(38,18), c4 DECIMAL(38,18), c5 DECIMAL(38,18), c6 DECIMAL(38,18), c7 DECIMAL(38,18), c8 DECIMAL(38,18), c9 DECIMAL(38,18), c10 DECIMAL(38,18), c11 DECIMAL(38,18), b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_various_various_decimal
@@ -1195,12 +1222,12 @@ POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_various_various_decimal
 POSTHOOK: Output: default@part_change_various_various_decimal
 PREHOOK: query: insert into table part_change_various_various_decimal partition(part=2)
-    values (5, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, 0.00007011717, 4.28479948, 'new')
+    values (6, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, 0.00007011717, 4.28479948, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__23
 PREHOOK: Output: default@part_change_various_various_decimal@part=2
 POSTHOOK: query: insert into table part_change_various_various_decimal partition(part=2)
-    values (5, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, 0.00007011717, 4.28479948, 'new')
+    values (6, 953967041., 62.0791539559013466, 718.78, 1, 203.199548118, -60, 6275638713485623898, -230, -695025, 0.00007011717, 4.28479948, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__23
 POSTHOOK: Output: default@part_change_various_various_decimal@part=2
@@ -1219,12 +1246,12 @@ POSTHOOK: Lineage: part_change_various_various_decimal PARTITION(part=2).c9 EXPR
 POSTHOOK: Lineage: part_change_various_various_decimal PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__23)values__tmp__table__23.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12
 PREHOOK: query: insert into table part_change_various_various_decimal partition(part=1)
-    values (6,-1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -66475.0000008, -284799488.1, 'new')
+    values (7,-1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -66475.0000008, -284799488.1, 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__24
 PREHOOK: Output: default@part_change_various_various_decimal@part=1
 POSTHOOK: query: insert into table part_change_various_various_decimal partition(part=1)
-    values (6,-1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -66475.0000008, -284799488.1, 'new')
+    values (7,-1255178165.77663, 9043162437544575070.974, -4314.7918, -1240033819, 91, 1698.95, -100.3597812, -63, 0, -66475.0000008, -284799488.1, 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__24
 POSTHOOK: Output: default@part_change_various_various_decimal@part=1
@@ -1260,13 +1287,13 @@ Stage-0
     Stage-1
       Reducer 2 vectorized
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=180)
+        Select Operator [SEL_7] (rows=7 width=174)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
         <-Map 1 [SIMPLE_EDGE] vectorized
           SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=6 width=180)
+            Select Operator [SEL_5] (rows=7 width=174)
               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-              TableScan [TS_0] (rows=6 width=180)
+              TableScan [TS_0] (rows=7 width=174)
                 default@part_change_various_various_decimal,part_change_various_various_decimal,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","b"]
 
 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,b from part_change_various_various_decimal order by insert_num
@@ -1283,11 +1310,12 @@ POSTHOOK: Input: default@part_change_various_various_decimal@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	b
 1	1	1.000000000000000000	NULL	NULL	3244222.000000000000000000	-29.000000000000000000	470614144.000000000000000000	470614135.000000000000000000	NULL	NULL	NULL	-62018170410.480460000000000000	original
-2	1	1.000000000000000000	100.000000000000000000	NULL	NULL	-3651.000000000000000000	46114.285000000000000000	46114.284799488000000000	NULL	NULL	NULL	1171027049.368756800000000000	original
-3	1	0.000000000000000000	72.000000000000000000	NULL	-93222.000000000000000000	30.000000000000000000	-66475.560000000000000000	-66475.561431000000000000	1.000000000000000000	1.000000000000000000	1.000000000000000000	134416490068.970120000000000000	original
-4	1	1.000000000000000000	-90.000000000000000000	NULL	3289094.000000000000000000	46114.000000000000000000	9250341.000000000000000000	9250340.750000000000000000	2402.300000000000000000	2402.300000000000000000	2402.300000000000000000	1021033788.990818000000000000	original
-5	2	953967041.000000000000000000	62.079153955901346600	718.780000000000000000	1.000000000000000000	203.199548118000000000	-60.000000000000000000	6275638713485623898.000000000000000000	-230.000000000000000000	-695025.000000000000000000	0.000070117170000000	4.284799480000000000	new
-6	1	NULL	NULL	-4314.000000000000000000	-1240033819.000000000000000000	91.000000000000000000	1698.950000000000000000	-100.359781200000000000	-63.000000000000000000	0.000000000000000000	-66475.000000800000000000	NULL	new
+2	1	1.000000000000000000	100.000000000000000000	32767.000000000000000000	NULL	-3651.000000000000000000	-9223372000000000000.000000000000000000	9223372036854776000.000000000000000000	NULL	NULL	NULL	1171027049.368756800000000000	original
+3	1	1.000000000000000000	100.000000000000000000	-32768.000000000000000000	NULL	-3651.000000000000000000	-9223372000000000000.000000000000000000	9223372036854776000.000000000000000000	NULL	NULL	NULL	1171027049.368756800000000000	original
+4	1	0.000000000000000000	72.000000000000000000	NULL	-93222.000000000000000000	30.000000000000000000	-66475.560000000000000000	-66475.561431000000000000	1.000000000000000000	1.000000000000000000	1.000000000000000000	134416490068.970120000000000000	original
+5	1	1.000000000000000000	-90.000000000000000000	NULL	3289094.000000000000000000	46114.000000000000000000	9250341.000000000000000000	9250340.750000000000000000	2402.300000000000000000	2402.300000000000000000	2402.300000000000000000	1021033788.990818000000000000	original
+6	2	953967041.000000000000000000	62.079153955901346600	718.780000000000000000	1.000000000000000000	203.199548118000000000	-60.000000000000000000	6275638713485623898.000000000000000000	-230.000000000000000000	-695025.000000000000000000	0.000070117170000000	4.284799480000000000	new
+7	1	NULL	NULL	-4314.000000000000000000	-1240033819.000000000000000000	91.000000000000000000	1698.950000000000000000	-100.359781200000000000	-63.000000000000000000	0.000000000000000000	-66475.000000800000000000	NULL	new
 PREHOOK: query: drop table part_change_various_various_decimal
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_various_various_decimal
@@ -1306,17 +1334,19 @@ POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_various_various_string
 PREHOOK: query: insert into table part_change_various_various_string partition(part=1)
     values(1, true,  200,  72909,      3244222, -99999999999,     -29.0764,      470614135,        470614135,         'dynamic reptile  ', 'dynamic reptile  ',  '0004-09-22 18:26:29.519542222', '2007-02-09', 'binary', 'original'),
-          (2, 0,     100,  483777,      14,     -23866739993,     -3651.672121,  46114.284799488,  46114.284799488,   '  baffling    ', '  baffling    ',        '2007-02-09 05:17:29.368756876', '0004-09-22', 'binary', 'original'),
-          (3, false, 72,   3244222,    -93222,   30.774,       -   66475.561431, -66475.561431,    0.561431,          '1', '1',                                  '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'),
-          (4, 1,    -90,   754072151,   3289094, 46114.284799488,  9250340.75,    9250340.75,      9250340.75,        'junkyard', 'junkyard',                    '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72,   3244222,    -93222,   30.774,       -   66475.561431, -66475.561431,    0.561431,          '1', '1',                                  '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'),
+          (5, 1,    -90,   754072151,   3289094, 46114.284799488,  9250340.75,    9250340.75,      9250340.75,        'junkyard', 'junkyard',                    '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__25
 PREHOOK: Output: default@part_change_various_various_string@part=1
 POSTHOOK: query: insert into table part_change_various_various_string partition(part=1)
     values(1, true,  200,  72909,      3244222, -99999999999,     -29.0764,      470614135,        470614135,         'dynamic reptile  ', 'dynamic reptile  ',  '0004-09-22 18:26:29.519542222', '2007-02-09', 'binary', 'original'),
-          (2, 0,     100,  483777,      14,     -23866739993,     -3651.672121,  46114.284799488,  46114.284799488,   '  baffling    ', '  baffling    ',        '2007-02-09 05:17:29.368756876', '0004-09-22', 'binary', 'original'),
-          (3, false, 72,   3244222,    -93222,   30.774,       -   66475.561431, -66475.561431,    0.561431,          '1', '1',                                  '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'),
-          (4, 1,    -90,   754072151,   3289094, 46114.284799488,  9250340.75,    9250340.75,      9250340.75,        'junkyard', 'junkyard',                    '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72,   3244222,    -93222,   30.774,       -   66475.561431, -66475.561431,    0.561431,          '1', '1',                                  '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'),
+          (5, 1,    -90,   754072151,   3289094, 46114.284799488,  9250340.75,    9250340.75,      9250340.75,        'junkyard', 'junkyard',                    '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__25
 POSTHOOK: Output: default@part_change_various_various_string@part=1
@@ -1348,9 +1378,10 @@ POSTHOOK: Input: default@part_change_various_various_string@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	b
 1	1	true	NULL	NULL	3244222	-99999999999	-29.0764	4.70614135E8	470614135.000000000000000000	dynamic reptile          	dynamic reptile  	0004-09-22 18:26:29.519542222	2007-02-09	binary	original
-2	1	true	100	NULL	14	-23866739993	-3651.672	46114.284799488	46114.284799488000000000	  baffling               	  baffling    	2007-02-09 05:17:29.368756876	0004-09-22	binary	original
-3	1	false	72	NULL	-93222	30	-66475.56	-66475.561431	0.561431000000000000	1                        	1	6229-06-28 02:54:28.970117179	5966-07-09	binary	original
-4	1	true	-90	NULL	3289094	46114	9250341.0	9250340.75	9250340.750000000000000000	junkyard                 	junkyard	2002-05-10 05:29:48.990818073	1815-05-06	binary	original
+2	1	true	100	32767	NULL	-3651	-9.223372E18	9.223372036854776E18	NULL	                         		2007-02-09 05:17:29.368756876	NULL	NULL	NULL
+3	1	true	100	-32768	NULL	-3651	-9.223372E18	9.223372036854776E18	NULL	                         		2007-02-09 05:17:29.368756876	NULL	NULL	NULL
+4	1	false	72	NULL	-93222	30	-66475.56	-66475.561431	0.561431000000000000	1                        	1	6229-06-28 02:54:28.970117179	5966-07-09	binary	original
+5	1	true	-90	NULL	3289094	46114	9250341.0	9250340.75	9250340.750000000000000000	junkyard                 	junkyard	2002-05-10 05:29:48.990818073	1815-05-06	binary	original
 PREHOOK: query: alter table part_change_various_various_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING, c6 STRING, c7 STRING, c8 STRING, c9 STRING, c10 STRING, c11 STRING, c12 STRING, c13 STRING, b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_various_various_string
@@ -1360,12 +1391,12 @@ POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_various_various_string
 POSTHOOK: Output: default@part_change_various_various_string
 PREHOOK: query: insert into table part_change_various_various_string partition(part=2)
-    values (5, 'true', '400',  '44388',       -'100',    '953967041.',       '62.079153',     '718.78',         '1',                'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new')
+    values (6, 'true', '400',  '44388',       -'100',    '953967041.',       '62.079153',     '718.78',         '1',                'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__26
 PREHOOK: Output: default@part_change_various_various_string@part=2
 POSTHOOK: query: insert into table part_change_various_various_string partition(part=2)
-    values (5, 'true', '400',  '44388',       -'100',    '953967041.',       '62.079153',     '718.78',         '1',                'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new')
+    values (6, 'true', '400',  '44388',       -'100',    '953967041.',       '62.079153',     '718.78',         '1',                'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__26
 POSTHOOK: Output: default@part_change_various_various_string@part=2
@@ -1386,12 +1417,12 @@ POSTHOOK: Lineage: part_change_various_various_string PARTITION(part=2).c9 SIMPL
 POSTHOOK: Lineage: part_change_various_various_string PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__26)values__tmp__table__26.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
 PREHOOK: query: insert into table part_change_various_various_string partition(part=1)
-    values (6,-'false', '-67', '833',          '63993', ' 1255178165.77663', '905070.974', '-4314.7918',        -'1240033819',      'trial',   'trial',  '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new')
+    values (7,-'false', '-67', '833',          '63993', ' 1255178165.77663', '905070.974', '-4314.7918',        -'1240033819',      'trial',   'trial',  '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__27
 PREHOOK: Output: default@part_change_various_various_string@part=1
 POSTHOOK: query: insert into table part_change_various_various_string partition(part=1)
-    values (6,-'false', '-67', '833',          '63993', ' 1255178165.77663', '905070.974', '-4314.7918',        -'1240033819',      'trial',   'trial',  '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new')
+    values (7,-'false', '-67', '833',          '63993', ' 1255178165.77663', '905070.974', '-4314.7918',        -'1240033819',      'trial',   'trial',  '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__27
 POSTHOOK: Output: default@part_change_various_various_string@part=1
@@ -1429,13 +1460,13 @@ Stage-0
     Stage-1
       Reducer 2 vectorized
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=152)
+        Select Operator [SEL_7] (rows=7 width=142)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
         <-Map 1 [SIMPLE_EDGE] vectorized
           SHUFFLE [RS_6]
-            Select Operator [SEL_5] (rows=6 width=152)
+            Select Operator [SEL_5] (rows=7 width=142)
               Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-              TableScan [TS_0] (rows=6 width=152)
+              TableScan [TS_0] (rows=7 width=142)
                 default@part_change_various_various_string,part_change_various_various_string,Tbl:COMPLETE,Col:NONE,Output:["insert_num","c1","c2","c3","c4","c5","c6","c7","c8","c9","c10","c11","c12","c13","b"]
 
 PREHOOK: query: select insert_num,part,c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,b from part_change_various_various_string order by insert_num
@@ -1452,11 +1483,12 @@ POSTHOOK: Input: default@part_change_various_various_string@part=2
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	b
 1	1	true	NULL	NULL	3244222	-99999999999	-29.0764	4.70614135E8	470614135	dynamic reptile	dynamic reptile  	0004-09-22 18:26:29.519542222	2007-02-09	binary	original
-2	1	true	100	NULL	14	-23866739993	-3651.672	46114.284799488	46114.284799488	  baffling	  baffling    	2007-02-09 05:17:29.368756876	0004-09-22	binary	original
-3	1	false	72	NULL	-93222	30	-66475.56	-66475.561431	0.561431	1	1	6229-06-28 02:54:28.970117179	5966-07-09	binary	original
-4	1	true	-90	NULL	3289094	46114	9250341.0	9250340.75	9250340.75	junkyard	junkyard	2002-05-10 05:29:48.990818073	1815-05-06	binary	original
-5	2	true	400	44388	-100	953967041.	62.079153	718.78	1	verdict	verdict	timestamp	date	binary	new
-6	1	NULL	-67	833	63993	NULL	905071.0	-4314.7918	-1240033819	trial	trial	2016-03-07 03:02:22	2016-03-07	n)گ	new
+2	1	true	100	32767	NULL	-3651	-9.223372E18	9.223372036854776E18	NULL			2007-02-09 05:17:29.368756876	NULL	NULL	NULL
+3	1	true	100	-32768	NULL	-3651	-9.223372E18	9.223372036854776E18	NULL			2007-02-09 05:17:29.368756876	NULL	NULL	NULL
+4	1	false	72	NULL	-93222	30	-66475.56	-66475.561431	0.561431	1	1	6229-06-28 02:54:28.970117179	5966-07-09	binary	original
+5	1	true	-90	NULL	3289094	46114	9250341.0	9250340.75	9250340.75	junkyard	junkyard	2002-05-10 05:29:48.990818073	1815-05-06	binary	original
+6	2	true	400	44388	-100	953967041.	62.079153	718.78	1	verdict	verdict	timestamp	date	binary	new
+7	1	NULL	-67	833	63993	NULL	905071.0	-4314.7918	-1240033819	trial	trial	2016-03-07 03:02:22	2016-03-07	n)گ	new
 PREHOOK: query: drop table part_change_various_various_string
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@part_change_various_various_string
@@ -1475,17 +1507,19 @@ POSTHOOK: Output: database:default
 POSTHOOK: Output: default@part_change_various_various_char
 PREHOOK: query: insert into table part_change_various_various_char partition(part=1)
     values(1, true,  200,  72909,      3244222, -99999999999,     -29.0764,      470614135,        470614135,         'dynamic reptile  ', 'dynamic reptile  ',  '0004-09-22 18:26:29.519542222', '2007-02-09', 'binary', 'original'),
-          (2, 0,     100,  483777,      14,     -23866739993,     -3651.672121,  46114.284799488,  46114.284799488,   '  baffling    ', '  baffling    ',        '2007-02-09 05:17:29.368756876', '0004-09-22', 'binary', 'original'),
-          (3, false, 72,   3244222,    -93222,   30.774,       -   66475.561431, -66475.561431,    0.561431,         '1', '1',                                  '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'),
-          (4, 1,    -90,   754072151,   3289094, 46114.284799488,  9250340.75,    9250340.75,      9250340.75,        'junkyard', 'junkyard',                    '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72,   3244222,    -93222,   30.774,       -   66475.561431, -66475.561431,    0.561431,         '1', '1',                                  '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'),
+          (5, 1,    -90,   754072151,   3289094, 46114.284799488,  9250340.75,    9250340.75,      9250340.75,        'junkyard', 'junkyard',                    '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__28
 PREHOOK: Output: default@part_change_various_various_char@part=1
 POSTHOOK: query: insert into table part_change_various_various_char partition(part=1)
     values(1, true,  200,  72909,      3244222, -99999999999,     -29.0764,      470614135,        470614135,         'dynamic reptile  ', 'dynamic reptile  ',  '0004-09-22 18:26:29.519542222', '2007-02-09', 'binary', 'original'),
-          (2, 0,     100,  483777,      14,     -23866739993,     -3651.672121,  46114.284799488,  46114.284799488,   '  baffling    ', '  baffling    ',        '2007-02-09 05:17:29.368756876', '0004-09-22', 'binary', 'original'),
-          (3, false, 72,   3244222,    -93222,   30.774,       -   66475.561431, -66475.561431,    0.561431,         '1', '1',                                  '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'),
-          (4, 1,    -90,   754072151,   3289094, 46114.284799488,  9250340.75,    9250340.75,      9250340.75,        'junkyard', 'junkyard',                    '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original')
+          (2, 0, 100, 32767, -23372036854775, -3651.672121, -9223372036854775808.0, 9223372036854775807.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (3, 0, 100, -32768, 23372036854775, -3651.672121, -9223372036854775809.0, 9223372036854775808.0, '', '', '', '2007-02-09 05:17:29.368756876', 'original'),
+          (4, false, 72,   3244222,    -93222,   30.774,       -   66475.561431, -66475.561431,    0.561431,         '1', '1',                                  '6229-06-28 02:54:28.970117179', '5966-07-09', 'binary', 'original'),
+          (5, 1,    -90,   754072151,   3289094, 46114.284799488,  9250340.75,    9250340.75,      9250340.75,        'junkyard', 'junkyard',                    '2002-05-10 05:29:48.990818073', '1815-05-06', 'binary', 'original')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__28
 POSTHOOK: Output: default@part_change_various_various_char@part=1
@@ -1517,9 +1551,10 @@ POSTHOOK: Input: default@part_change_various_various_char@part=1
 #### A masked pattern was here ####
 insert_num	part	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	b
 1	1	true	NULL	NULL	3244222	-99999999999	-29.0764	4.70614135E8	470614135.000000000000000000	dynamic reptile  	dynamic reptile  	0004-09-22 18:26:29.519542222	2007-02-09	binary	original
-2	1	true	100	NULL	14	-23866739993	-3651.672	46114.284799488	46114.284799488000000000	  baffling    	  baffling    	2007-02-09 05:17:29.368756876	0004-09-22	binary	original
-3	1	false	72	NULL	-93222	30	-66475.56	-66475.561431	0.561431000000000000	1	1	6229-06-28 02:54:28.970117179	5966-07-09	binary	original
-4	1	true	-90	NULL	3289094	46114	9250341.0	9250340.75	9250340.750000000000000000	junkyard	junkyard	2002-05-10 05:29:48.990818073	1815-05-06	binary	original
+2	1	true	100	32767	NULL	-3651	-9.223372E18	9.223372036854776E18	NULL			2007-02-09 05:17:29.368756876	NULL	NULL	NULL
+3	1	true	100	-32768	NULL	-3651	-9.223372E18	9.223372036854776E18	NULL			2007-02-09 05:17:29.368756876	NULL	NULL	NULL
+4	1	false	72	NULL	-93222	30	-66475.56	-66475.561431	0.561431000000000000	1	1	6229-06-28 02:54:28.970117179	5966-07-09	binary	original
+5	1	true	-90	NULL	3289094	46114	9250341.0	9250340.75	9250340.750000000000000000	junkyard	junkyard	2002-05-10 05:29:48.990818073	1815-05-06	binary	original
 PREHOOK: query: alter table part_change_various_various_char replace columns (insert_num int, c1 CHAR(25), c2 CHAR(25), c3 CHAR(25), c4 CHAR(25), c5 CHAR(25), c6 CHAR(25), c7 CHAR(25), c8 CHAR(25), c9 CHAR(25), c10 CHAR(25), c11 CHAR(25), c12 CHAR(25), c13 CHAR(25), b STRING)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: default@part_change_various_various_char
@@ -1529,12 +1564,12 @@ POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: default@part_change_various_various_char
 POSTHOOK: Output: default@part_change_various_various_char
 PREHOOK: query: insert into table part_change_various_various_char partition(part=2)
-    values (5, 'true', '400',  '44388',       -'100',    '953967041.',       '62.079153',     '718.78',         '1',                'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new')
+    values (6, 'true', '400',  '44388',       -'100',    '953967041.',       '62.079153',     '718.78',         '1',                'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__29
 PREHOOK: Output: default@part_change_various_various_char@part=2
 POSTHOOK: query: insert into table part_change_various_various_char partition(part=2)
-    values (5, 'true', '400',  '44388',       -'100',    '953967041.',       '62.079153',     '718.78',         '1',                'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new')
+    values (6, 'true', '400',  '44388',       -'100',    '953967041.',       '62.079153',     '718.78',         '1',                'verdict', 'verdict', 'timestamp', 'date', 'binary', 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__29
 POSTHOOK: Output: default@part_change_various_various_char@part=2
@@ -1555,12 +1590,12 @@ POSTHOOK: Lineage: part_change_various_various_char PARTITION(part=2).c9 EXPRESS
 POSTHOOK: Lineage: part_change_various_various_char PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__29)values__tmp__table__29.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
 _col0	_col1	_col2	_col3	_col4	_col5	_col6	_col7	_col8	_col9	_col10	_col11	_col12	_col13	_col14
 PREHOOK: query: insert into table part_change_various_various_char partition(part=1)
-    values (6,-'false', '-67', '833',          '63993', ' 1255178165.77663', '905070.974', '-4314.7918',        -'1240033819',      'trial',   'trial',  '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new')
+    values (7,-'false', '-67', '833',          '63993', ' 1255178165.77663', '905070.974', '-4314.7918',        -'1240033819',      'trial',   'trial',  '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@values__tmp__table__30
 PREHOOK: Output: default@part_change_various_various_char@part=1
 POSTHOOK: query: insert into table part_change_various_various_char partition(part=1)
-    values (6,-'false', '-67', '833',          '63993', ' 1255178165.77663', '905070.974', '-4314.7918',        -'1240033819',      'trial',   'trial',  '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new')
+    values (7,-'false', '-67', '833',          '63993', ' 1255178165.77663', '905070.974', '-4314.7918',        -'1240033819',      'trial',   'trial',  '2016-03-07 03:02:22.0', '2016-03-07', 'binary', 'new')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@values__tmp__table__30
 POSTHOOK: Output: default@part_change_various_various_char@part=1
@@ -1598,13 +1633,13 @@ Stage-0
     Stage-1
       Reducer 2 vectorized
       File Output Operator [FS_8]
-        Select Operator [SEL_7] (rows=6 width=219)
+        Select Operator [SEL_7] (rows=7 width=194)
           Output:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
         <-Map 1 [SIMPLE_EDGE] vectorized
           SHUFFLE [RS_6]
-            Sele

<TRUNCATED>

Mime
View raw message