You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by mm...@apache.org on 2016/07/28 18:53:39 UTC
[15/25] hive git commit: HIVE-14000: (ORC) Changing a numeric type
column of a partitioned table to lower type set values to something other
than 'NULL' (Matt McCline, reviewed by Sergey Shelukhin)
http://git-wip-us.apache.org/repos/asf/hive/blob/66a2ded1/ql/src/test/results/clientpositive/schema_evol_orc_nonvec_mapwork_part_all_primitive.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/schema_evol_orc_nonvec_mapwork_part_all_primitive.q.out b/ql/src/test/results/clientpositive/schema_evol_orc_nonvec_mapwork_part_all_primitive.q.out
index 0ac57b3..7a7c264 100644
--- a/ql/src/test/results/clientpositive/schema_evol_orc_nonvec_mapwork_part_all_primitive.q.out
+++ b/ql/src/test/results/clientpositive/schema_evol_orc_nonvec_mapwork_part_all_primitive.q.out
@@ -200,6 +200,7 @@ POSTHOOK: Input: default@part_change_various_various_boolean
POSTHOOK: Output: default@part_change_various_various_boolean
PREHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, SHORT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> BYTE
+-- -128 and a maximum value of 127
--
CREATE TABLE part_change_various_various_tinyint(insert_num int, c1 BOOLEAN, c2 SMALLINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
@@ -207,24 +208,27 @@ PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_various_various_tinyint
POSTHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, SHORT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> BYTE
+-- -128 and a maximum value of 127
--
CREATE TABLE part_change_various_various_tinyint(insert_num int, c1 BOOLEAN, c2 SMALLINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
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
@@ -253,10 +257,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: -- Table-Non-Cascade CHANGE COLUMNS ...
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
@@ -268,12 +273,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
@@ -292,12 +297,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
@@ -332,24 +337,24 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_various_various_tinyint
- Statistics: Num rows: 6 Data size: 2482 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: tinyint), c2 (type: tinyint), c3 (type: tinyint), c4 (type: tinyint), c5 (type: tinyint), c6 (type: tinyint), c7 (type: tinyint), c8 (type: tinyint), c9 (type: tinyint), c10 (type: tinyint), c11 (type: tinyint), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2482 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 6 Data size: 2482 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: tinyint), _col3 (type: tinyint), _col4 (type: tinyint), _col5 (type: tinyint), _col6 (type: tinyint), _col7 (type: tinyint), _col8 (type: tinyint), _col9 (type: tinyint), _col10 (type: tinyint), _col11 (type: tinyint), _col12 (type: tinyint), _col13 (type: string)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: tinyint), VALUE._col2 (type: tinyint), VALUE._col3 (type: tinyint), VALUE._col4 (type: tinyint), VALUE._col5 (type: tinyint), VALUE._col6 (type: tinyint), VALUE._col7 (type: tinyint), VALUE._col8 (type: tinyint), VALUE._col9 (type: tinyint), VALUE._col10 (type: tinyint), VALUE._col11 (type: tinyint), VALUE._col12 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2482 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 2482 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3070 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -374,12 +379,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 119 73 73 73 -43 original
-2 1 1 -24 -63 -25 -67 34 34 NULL NULL NULL 105 original
-3 1 0 NULL -66 -38 30 85 85 1 1 1 84 original
-4 1 1 NULL 87 6 34 36 36 -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 NULL NULL NULL -29 NULL NULL NULL -128 NULL NULL original
+2 1 1 -128 -48 -20 NULL NULL NULL NULL -99 40 NULL original
+3 1 1 NULL 100 NULL NULL NULL NULL NULL -99 40 NULL original
+4 1 0 -72 -127 127 30 127 -106 NULL NULL 1 NULL original
+5 1 1 -90 75 -38 109 -128 98 NULL NULL NULL NULL original
+6 2 23 71 127 1 NULL -60 68 NULL NULL 40 93 new
+7 1 -120 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
@@ -390,6 +396,7 @@ POSTHOOK: Input: default@part_change_various_various_tinyint
POSTHOOK: Output: default@part_change_various_various_tinyint
PREHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> SMALLINT
+-- -32768 and a maximum value of 32767
--
CREATE TABLE part_change_various_various_smallint(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
@@ -397,6 +404,7 @@ PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_various_various_smallint
POSTHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, INT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> SMALLINT
+-- -32768 and a maximum value of 32767
--
CREATE TABLE part_change_various_various_smallint(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 INT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
@@ -404,17 +412,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
@@ -444,9 +454,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: -- Table-Non-Cascade CHANGE COLUMNS ...
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
@@ -458,12 +469,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
@@ -482,12 +493,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
@@ -522,24 +533,24 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_various_various_smallint
- Statistics: Num rows: 6 Data size: 2498 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3074 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: smallint), c2 (type: smallint), c3 (type: smallint), c4 (type: smallint), c5 (type: smallint), c6 (type: smallint), c7 (type: smallint), c8 (type: smallint), c9 (type: smallint), c10 (type: smallint), c11 (type: smallint), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2498 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3074 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 6 Data size: 2498 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3074 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: smallint), _col3 (type: smallint), _col4 (type: smallint), _col5 (type: smallint), _col6 (type: smallint), _col7 (type: smallint), _col8 (type: smallint), _col9 (type: smallint), _col10 (type: smallint), _col11 (type: smallint), _col12 (type: smallint), _col13 (type: string)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: smallint), VALUE._col2 (type: smallint), VALUE._col3 (type: smallint), VALUE._col4 (type: smallint), VALUE._col5 (type: smallint), VALUE._col6 (type: smallint), VALUE._col7 (type: smallint), VALUE._col8 (type: smallint), VALUE._col9 (type: smallint), VALUE._col10 (type: smallint), VALUE._col11 (type: smallint), VALUE._col12 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2498 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3074 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 2498 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3074 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -564,12 +575,13 @@ POSTHOOK: Input: default@part_change_various_various_smallint@part=1
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 119 -2999 -2999 -2999 -11819 original
-2 1 1 100 25025 29415 -3651 -19422 -19422 NULL NULL NULL 29801 original
-3 1 0 72 -32578 -27686 30 -939 -939 1 1 1 -8620 original
-4 1 1 -90 14935 12294 -19422 9764 9764 5299 5299 5299 -17092 original
-5 2 -30486 15230 3117 1 -117 -7131 20227 -24858 -28771 NULL NULL new
-6 1 -10542 -1805 -4844 15507 91 22385 -28 -12268 0 NULL 774 new
+1 1 1 NULL NULL NULL -29 NULL NULL -2999 -2999 -2999 NULL original
+2 1 1 100 -32768 32767 -3651 NULL NULL 9000 32767 -32768 NULL original
+3 1 1 -127 NULL NULL -3651 NULL NULL 9000 32767 -32768 NULL original
+4 1 0 72 32422 -9322 30 -6675 -6675 1 1 1 NULL original
+5 1 1 -90 7151 3094 30000 -9000 0 5299 5299 5299 NULL original
+6 2 -30486 15230 3117 1 -117 -7131 20227 -24858 -28771 NULL NULL new
+7 1 -10542 -1805 -4844 15507 91 22385 -28 -12268 0 NULL 774 new
PREHOOK: query: drop table part_change_various_various_smallint
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_various_various_smallint
@@ -580,6 +592,7 @@ POSTHOOK: Input: default@part_change_various_various_smallint
POSTHOOK: Output: default@part_change_various_various_smallint
PREHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> INT
+-- \u20132147483648 to 2147483647
--
CREATE TABLE part_change_various_various_int(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
@@ -587,6 +600,7 @@ PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_various_various_int
POSTHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, LONG, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> INT
+-- \u20132147483648 to 2147483647
--
CREATE TABLE part_change_various_various_int(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 BIGINT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
@@ -594,17 +608,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
@@ -634,9 +650,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: -- Table-Non-Cascade CHANGE COLUMNS ...
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
@@ -712,24 +729,24 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_various_various_int
- Statistics: Num rows: 6 Data size: 2494 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3051 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: int), c2 (type: int), c3 (type: int), c4 (type: int), c5 (type: int), c6 (type: int), c7 (type: int), c8 (type: int), c9 (type: int), c10 (type: int), c11 (type: int), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2494 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3051 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 6 Data size: 2494 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3051 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col9 (type: int), _col10 (type: int), _col11 (type: int), _col12 (type: int), _col13 (type: string)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int), VALUE._col8 (type: int), VALUE._col9 (type: int), VALUE._col10 (type: int), VALUE._col11 (type: int), VALUE._col12 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2494 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3051 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 2494 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3051 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -754,10 +771,11 @@ POSTHOOK: Input: default@part_change_various_various_int@part=1
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
+1 1 1 NULL NULL 3244222 -29 470614135 470614135 -2999 -2999 -2999 NULL original
+2 1 1 100 NULL NULL -3651 NULL NULL NULL NULL NULL 1171027049 original
+3 1 1 100 NULL NULL -3651 NULL NULL NULL NULL NULL 1171027049 original
+4 1 0 72 NULL -93222 30 -66475 -66475 1 1 1 NULL 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 -1928921 695025 -151775655 -167 91 113 -164341325 -134237413 0 6229 4422 new
PREHOOK: query: drop table part_change_various_various_int
@@ -770,6 +788,7 @@ POSTHOOK: Input: default@part_change_various_various_int
POSTHOOK: Output: default@part_change_various_various_int
PREHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> BIGINT
+-- -9223372036854775808 to 9223372036854775807
--
CREATE TABLE part_change_various_various_bigint(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
@@ -777,6 +796,7 @@ PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_various_various_bigint
POSTHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for Various --> Various: (BOOLEAN, TINYINT, SMALLINT, INT, FLOAT, DOUBLE, DECIMAL, STRING, CHAR, VARCHAR, TIMESTAMP) --> BIGINT
+-- -9223372036854775808 to 9223372036854775807
--
CREATE TABLE part_change_various_various_bigint(insert_num int, c1 BOOLEAN, c2 TINYINT, c3 SMALLINT, c4 INT, c5 FLOAT, c6 DOUBLE, c7 DECIMAL(38,18), c8 STRING, c9 CHAR(25), c10 VARCHAR(25), c11 TIMESTAMP, b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
@@ -784,17 +804,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
@@ -824,9 +846,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: -- Table-Non-Cascade CHANGE COLUMNS ...
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
@@ -838,12 +861,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
@@ -862,12 +885,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
@@ -902,24 +925,24 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_various_various_bigint
- Statistics: Num rows: 6 Data size: 2578 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3129 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: bigint), c2 (type: bigint), c3 (type: bigint), c4 (type: bigint), c5 (type: bigint), c6 (type: bigint), c7 (type: bigint), c8 (type: bigint), c9 (type: bigint), c10 (type: bigint), c11 (type: bigint), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2578 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3129 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 6 Data size: 2578 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3129 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint), _col6 (type: bigint), _col7 (type: bigint), _col8 (type: bigint), _col9 (type: bigint), _col10 (type: bigint), _col11 (type: bigint), _col12 (type: bigint), _col13 (type: string)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: bigint), VALUE._col3 (type: bigint), VALUE._col4 (type: bigint), VALUE._col5 (type: bigint), VALUE._col6 (type: bigint), VALUE._col7 (type: bigint), VALUE._col8 (type: bigint), VALUE._col9 (type: bigint), VALUE._col10 (type: bigint), VALUE._col11 (type: bigint), VALUE._col12 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2578 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3129 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 2578 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3129 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -945,11 +968,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 NULL NULL NULL 1021033788 original
-5 2 5573199346255528403 71 151775655 1 131 -60 6275638713485623898 -230 -695025 519542222 -29 new
-6 1 -164341325 9043162437544575070 -126 -6566204574741299000 91 113 -28 -63 0 3244222 -90 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 NULL NULL NULL 1021033788 original
+6 2 5573199346255528403 71 151775655 1 131 -60 6275638713485623898 -230 -695025 519542222 -29 new
+7 1 -164341325 9043162437544575070 -126 -6566204574741299000 91 113 -28 -63 0 3244222 -90 new
PREHOOK: query: drop table part_change_various_various_bigint
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_various_various_bigint
@@ -974,17 +998,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
@@ -1014,9 +1040,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: -- Table-Non-Cascade CHANGE COLUMNS ...
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
@@ -1028,12 +1055,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
@@ -1052,12 +1079,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
@@ -1092,24 +1119,24 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_various_various_float
- Statistics: Num rows: 6 Data size: 2498 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3061 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: float), c2 (type: float), c3 (type: float), c4 (type: float), c5 (type: float), c6 (type: float), c7 (type: float), c8 (type: float), c9 (type: float), c10 (type: float), c11 (type: float), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2498 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3061 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 6 Data size: 2498 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3061 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: float), _col3 (type: float), _col4 (type: float), _col5 (type: float), _col6 (type: float), _col7 (type: float), _col8 (type: float), _col9 (type: float), _col10 (type: float), _col11 (type: float), _col12 (type: float), _col13 (type: string)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: float), VALUE._col2 (type: float), VALUE._col3 (type: float), VALUE._col4 (type: float), VALUE._col5 (type: float), VALUE._col6 (type: float), VALUE._col7 (type: float), VALUE._col8 (type: float), VALUE._col9 (type: float), VALUE._col10 (type: float), VALUE._col11 (type: float), VALUE._col12 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2498 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3061 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 2498 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3061 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1135,11 +1162,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 -1.25517811E9 9.0431626E18 -4314.792 -1.24003379E9 91.0 1698.95 -100.35978 -63.0 0.0 -93222.2 29.076 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 -1.25517811E9 9.0431626E18 -4314.792 -1.24003379E9 91.0 1698.95 -100.35978 -63.0 0.0 -93222.2 29.076 new
PREHOOK: query: drop table part_change_various_various_float
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_various_various_float
@@ -1164,17 +1192,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
@@ -1204,9 +1234,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: -- Table-Non-Cascade CHANGE COLUMNS ...
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
@@ -1218,12 +1249,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
@@ -1242,12 +1273,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
@@ -1282,24 +1313,24 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_various_various_double
- Statistics: Num rows: 6 Data size: 2578 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3139 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: double), c2 (type: double), c3 (type: double), c4 (type: double), c5 (type: double), c6 (type: double), c7 (type: double), c8 (type: double), c9 (type: double), c10 (type: double), c11 (type: double), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2578 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3139 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 6 Data size: 2578 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3139 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: double), _col3 (type: double), _col4 (type: double), _col5 (type: double), _col6 (type: double), _col7 (type: double), _col8 (type: double), _col9 (type: double), _col10 (type: double), _col11 (type: double), _col12 (type: double), _col13 (type: string)
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: double), VALUE._col2 (type: double), VALUE._col3 (type: double), VALUE._col4 (type: double), VALUE._col5 (type: double), VALUE._col6 (type: double), VALUE._col7 (type: double), VALUE._col8 (type: double), VALUE._col9 (type: double), VALUE._col10 (type: double), VALUE._col11 (type: double), VALUE._col12 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 2578 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3139 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 2578 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 3139 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1325,11 +1356,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 -1.25517816577663E9 9.043162437544575E18 -4314.7918 -1.240033819E9 91.0 1698.95 -100.3597812 -63.0 0.0 -66475.0000008 -2.847994881E8 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 -1.25517816577663E9 9.043162437544575E18 -4314.7918 -1.240033819E9 91.0 1698.95 -100.3597812 -63.0 0.0 -66475.0000008 -2.847994881E8 new
PREHOOK: query: drop table part_change_various_various_double
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_various_various_double
@@ -1354,17 +1386,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
@@ -1394,9 +1428,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: -- Table-Non-Cascade CHANGE COLUMNS ...
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
@@ -1408,12 +1443,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
@@ -1432,12 +1467,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
@@ -1472,24 +1507,24 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_various_various_decimal
- Statistics: Num rows: 6 Data size: 4458 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 4907 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: decimal(38,18)), c2 (type: decimal(38,18)), c3 (type: decimal(38,18)), c4 (type: decimal(38,18)), c5 (type: decimal(38,18)), c6 (type: decimal(38,18)), c7 (type: decimal(38,18)), c8 (type: decimal(38,18)), c9 (type: decimal(38,18)), c10 (type: decimal(38,18)), c11 (type: decimal(38,18)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 4458 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 4907 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 6 Data size: 4458 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 4907 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: decimal(38,18)), _col3 (type: decimal(38,18)), _col4 (type: decimal(38,18)), _col5 (type: decimal(38,18)), _col6 (type: decimal(38,18)), _col7 (type: decimal(38,18)), _col8 (type: decimal(38,18)), _col9 (type: decimal(38,18)), _col10 (type: decimal(38,18)), _col11 (type: decimal(38,18)), _col12 (type: decimal(38,18)), _col13 (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: decimal(38,18)), VALUE._col3 (type: decimal(38,18)), VALUE._col4 (type: decimal(38,18)), VALUE._col5 (type: decimal(38,18)), VALUE._col6 (type: decimal(38,18)), VALUE._col7 (type: decimal(38,18)), VALUE._col8 (type: decimal(38,18)), VALUE._col9 (type: decimal(38,18)), VALUE._col10 (type: decimal(38,18)), VALUE._col11 (type: decimal(38,18)), VALUE._col12 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11, _col12, _col13
- Statistics: Num rows: 6 Data size: 4458 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 4907 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 6 Data size: 4458 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 7 Data size: 4907 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -1515,11 +1550,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 -1255178165.776630000000000000 9043162437544575070.974000000000000000 -4314.791800000000000000 -1240033819.000000000000000000 91.000000000000000000 1698.950000000000000000 -100.359781200000000000 -63.000000000000000000 0.000000000000000000 -66475.000000800000000000 -284799488.100000000000000000 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 -1255178165.776630000000000000 9043162437544575070.974000000000000000 -4314.791800000000000000 -1240033819.000000000000000000 91.000000000000000000 1698.950000000000000000 -100.359781200000000000 -63.000000000000000000 0.000000000000000000 -66475.000000800000000000 -284799488.100000000000000000 new
PREHOOK: query: drop table part_change_various_various_decimal
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_various_various_decimal
@@ -1544,17 +1580,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,
<TRUNCATED>