You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by om...@apache.org on 2017/07/20 20:09:35 UTC
[17/43] hive git commit: HIVE-16787 Fix itests in branch-2.2
http://git-wip-us.apache.org/repos/asf/hive/blob/62a3778e/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_part.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_part.q.out b/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_part.q.out
index fefe9c4..de222d1 100644
--- a/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_part.q.out
+++ b/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_part.q.out
@@ -2056,16 +2056,16 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc
POSTHOOK: Output: default@part_change_numeric_group_string_group_multi_ints_varchar_trunc
PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), STRING
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), STRING
--
-CREATE TABLE part_change_numeric_group_string_group_floating_string(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_string(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_numeric_group_string_group_floating_string
POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), STRING
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), STRING
--
-CREATE TABLE part_change_numeric_group_string_group_floating_string(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_string(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_string
@@ -2102,10 +2102,10 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string@part=1
#### A masked pattern was here ####
insert_num part c1 c2 c3 b
-1 1 -23866739993.000000000000000000 753.7028 -3651.672121 original
-2 1 -10.300000000000000000 -2.0 -29.0764 original
-3 1 -832222222.000000000000000000 255.0 4957.0 original
-4 1 847492223.000000000000000000 0.0 20435.0 original
+1 1 -2.38667407E10 753.7028 -3651.672121000000000000 original
+2 1 -10.3 -2.0 -29.076400000000000000 original
+3 1 -8.3222221E8 255.0 4957.000000000000000000 original
+4 1 8.4749222E8 0.0 20435.000000000000000000 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
alter table part_change_numeric_group_string_group_floating_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
@@ -2165,25 +2165,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_numeric_group_string_group_floating_string
- Statistics: Num rows: 10 Data size: 380 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 372 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: string), c2 (type: string), c3 (type: string), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 10 Data size: 380 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 372 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 10 Data size: 380 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 372 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string), VALUE._col4 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 10 Data size: 380 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 372 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 380 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 372 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2208,16 +2208,16 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string@
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string@part=2
#### A masked pattern was here ####
insert_num part c1 c2 c3 b
-1 1 -23866739993 753.7028 -3651.672121 original
-10 1 17 90000.0 7.54072151E8 new
+1 1 -2.38667407E10 753.7028 -3651.672121 original
+10 1 17.0 90000.0 754072151 new
2 1 -10.3 -2.0 -29.0764 original
-3 1 -832222222 255.0 4957.0 original
-4 1 847492223 0.0 20435.0 original
+3 1 -8.3222221E8 255.0 4957 original
+4 1 8.4749222E8 0.0 20435 original
5 2 30.774 20.31 46114.284799488 new
6 2 -66475.561431 52927714 7203778961 new
7 2 256 32768 31889 new
8 2 5555 40000 -719017797 new
-9 1 100 5000.0 5443.0 new
+9 1 100.0 5000.0 5443 new
PREHOOK: query: drop table part_change_numeric_group_string_group_floating_string
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_numeric_group_string_group_floating_string
@@ -2227,16 +2227,16 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_string
POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_string
PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR
--
-CREATE TABLE part_change_numeric_group_string_group_floating_char(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_char(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_numeric_group_string_group_floating_char
POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR
--
-CREATE TABLE part_change_numeric_group_string_group_floating_char(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_char(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_char
@@ -2273,10 +2273,10 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char@part=1
#### A masked pattern was here ####
insert_num part c1 c2 c3 b
-1 1 -23866739993.000000000000000000 753.7028 -3651.672121 original
-2 1 -10.300000000000000000 -2.0 -29.0764 original
-3 1 9000000000.000000000000000000 -255.0 4957.0 original
-4 1 -999999999999.000000000000000000 0.0 20435.0 original
+1 1 -2.38667407E10 753.7028 -3651.672121000000000000 original
+2 1 -10.3 -2.0 -29.076400000000000000 original
+3 1 8.9999995E9 -255.0 4957.000000000000000000 original
+4 1 -1.0E12 0.0 20435.000000000000000000 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
alter table part_change_numeric_group_string_group_floating_char replace columns (insert_num int, c1 CHAR(50), c2 CHAR(50), c3 CHAR(50), b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
@@ -2336,25 +2336,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_numeric_group_string_group_floating_char
- Statistics: Num rows: 10 Data size: 385 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: char(50)), c2 (type: char(50)), c3 (type: char(50)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 10 Data size: 385 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 368 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 10 Data size: 385 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 368 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: char(50)), _col3 (type: char(50)), _col4 (type: char(50)), _col5 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: char(50)), VALUE._col2 (type: char(50)), VALUE._col3 (type: char(50)), VALUE._col4 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 10 Data size: 385 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 368 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 385 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 368 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2379,16 +2379,16 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char@pa
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char@part=2
#### A masked pattern was here ####
insert_num part c1 c2 c3 b
-1 1 -23866739993 753.7028 -3651.672121 original
-10 1 17 90000.0 7.54072151E8 new
+1 1 -2.38667407E10 753.7028 -3651.672121 original
+10 1 17.0 90000.0 754072151 new
2 1 -10.3 -2.0 -29.0764 original
-3 1 9000000000 -255.0 4957.0 original
-4 1 -999999999999 0.0 20435.0 original
+3 1 8.9999995E9 -255.0 4957 original
+4 1 -1.0E12 0.0 20435 original
5 2 30.774 20.31 46114.284799488 new
6 2 -66475.561431 52927714 7203778961 new
7 2 256 32768 31889 new
8 2 5555 40000 -719017797 new
-9 1 100 5000.0 5443.0 new
+9 1 100.0 5000.0 5443 new
PREHOOK: query: drop table part_change_numeric_group_string_group_floating_char
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char
@@ -2398,16 +2398,16 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char
POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_char
PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR truncation
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR truncation
--
-CREATE TABLE part_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_numeric_group_string_group_floating_char_trunc
POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), CHAR truncation
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), CHAR truncation
--
-CREATE TABLE part_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_char_trunc
@@ -2444,10 +2444,10 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_tr
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc@part=1
#### A masked pattern was here ####
insert_num part c1 c2 c3 b
-1 1 -23866739993.000000000000000000 753.7028 -3651.672121 original
-2 1 -10.300000000000000000 -2.0 -29.0764 original
-3 1 832222222.000000000000000000 -255.0 4957.0 original
-4 1 847492223.000000000000000000 0.0 20435.0 original
+1 1 -2.38667407E10 753.7028 -3651.672121000000000000 original
+2 1 -10.3 -2.0 -29.076400000000000000 original
+3 1 8.3222221E8 -255.0 4957.000000000000000000 original
+4 1 8.4749222E8 0.0 20435.000000000000000000 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
alter table part_change_numeric_group_string_group_floating_char_trunc replace columns (insert_num int, c1 CHAR(7), c2 CHAR(7), c3 CHAR(7), b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
@@ -2507,25 +2507,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_numeric_group_string_group_floating_char_trunc
- Statistics: Num rows: 10 Data size: 357 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 349 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: char(7)), c2 (type: char(7)), c3 (type: char(7)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 10 Data size: 357 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 349 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 10 Data size: 357 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 349 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: char(7)), _col3 (type: char(7)), _col4 (type: char(7)), _col5 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: char(7)), VALUE._col2 (type: char(7)), VALUE._col3 (type: char(7)), VALUE._col4 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 10 Data size: 357 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 349 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 357 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 349 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2550,16 +2550,16 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_tr
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc@part=2
#### A masked pattern was here ####
insert_num part c1 c2 c3 b
-1 1 -238667 753.702 -3651.6 original
-10 1 17 90000.0 7540721 new
+1 1 -2.3866 753.702 -3651.6 original
+10 1 17.0 90000.0 7540721 new
2 1 -10.3 -2.0 -29.076 original
-3 1 8322222 -255.0 4957.0 original
-4 1 8474922 0.0 20435.0 original
+3 1 8.32222 -255.0 4957 original
+4 1 8.47492 0.0 20435 original
5 2 30.774 20.31 46114.2 new
6 2 -66475. 5292771 7203778 new
7 2 256 32768 31889 new
8 2 5555 40000 -719017 new
-9 1 100 5000.0 5443.0 new
+9 1 100.0 5000.0 5443 new
PREHOOK: query: drop table part_change_numeric_group_string_group_floating_char_trunc
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc
@@ -2569,14 +2569,14 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_char_trunc
POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_char_trunc
PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR
--
CREATE TABLE part_change_numeric_group_string_group_floating_varchar(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_numeric_group_string_group_floating_varchar
POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR
--
CREATE TABLE part_change_numeric_group_string_group_floating_varchar(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
@@ -2740,16 +2740,16 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar
POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_varchar
PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR truncation
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR truncation
--
-CREATE TABLE part_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_numeric_group_string_group_floating_varchar_trunc
POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (DECIMAL, FLOAT, DOUBLE), VARCHAR truncation
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), VARCHAR truncation
--
-CREATE TABLE part_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@part_change_numeric_group_string_group_floating_varchar_trunc
@@ -2786,10 +2786,10 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc@part=1
#### A masked pattern was here ####
insert_num part c1 c2 c3 b
-1 1 -23866739993.000000000000000000 753.7028 -3651.672121 original
-2 1 -10.300000000000000000 -2.0 -29.0764 original
-3 1 9000000000.000000000000000000 -255.0 4957.0 original
-4 1 -999999999999.000000000000000000 0.0 20435.0 original
+1 1 -2.38667407E10 753.7028 -3651.672121000000000000 original
+2 1 -10.3 -2.0 -29.076400000000000000 original
+3 1 8.9999995E9 -255.0 4957.000000000000000000 original
+4 1 -1.0E12 0.0 20435.000000000000000000 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
alter table part_change_numeric_group_string_group_floating_varchar_trunc replace columns (insert_num int, c1 VARCHAR(7), c2 VARCHAR(7), c3 VARCHAR(7), b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
@@ -2849,25 +2849,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_numeric_group_string_group_floating_varchar_trunc
- Statistics: Num rows: 10 Data size: 362 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 345 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), part (type: int), c1 (type: varchar(7)), c2 (type: varchar(7)), c3 (type: varchar(7)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 10 Data size: 362 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 345 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 10 Data size: 362 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 345 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: varchar(7)), _col3 (type: varchar(7)), _col4 (type: varchar(7)), _col5 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: varchar(7)), VALUE._col2 (type: varchar(7)), VALUE._col3 (type: varchar(7)), VALUE._col4 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 10 Data size: 362 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 345 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 362 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 345 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2892,16 +2892,16 @@ POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar
POSTHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc@part=2
#### A masked pattern was here ####
insert_num part c1 c2 c3 b
-1 1 -238667 753.702 -3651.6 original
-10 1 17 90000.0 7540721 new
+1 1 -2.3866 753.702 -3651.6 original
+10 1 17.0 90000.0 7540721 new
2 1 -10.3 -2.0 -29.076 original
-3 1 9000000 -255.0 4957.0 original
-4 1 -999999 0.0 20435.0 original
+3 1 8.99999 -255.0 4957 original
+4 1 -1.0E12 0.0 20435 original
5 2 30.774 20.31 46114.2 new
6 2 -66475. 5292771 7203778 new
7 2 256 32768 31889 new
8 2 5555 40000 -719017 new
-9 1 100 5000.0 5443.0 new
+9 1 100.0 5000.0 5443 new
PREHOOK: query: drop table part_change_numeric_group_string_group_floating_varchar_trunc
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_numeric_group_string_group_floating_varchar_trunc
@@ -3439,7 +3439,7 @@ PREHOOK: query: ----------------------------------------------------------------
--
--
--
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, FLOAT, DOUBLE, DECIMAL)
--
CREATE TABLE part_change_lower_to_higher_numeric_group_tinyint(insert_num int, c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
@@ -3450,7 +3450,7 @@ POSTHOOK: query: ---------------------------------------------------------------
--
--
--
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: TINYINT, (SMALLINT, INT, BIGINT, FLOAT, DOUBLE, DECIMAL)
--
CREATE TABLE part_change_lower_to_higher_numeric_group_tinyint(insert_num int, c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
@@ -3497,12 +3497,12 @@ insert_num part c1 c2 c3 c4 c5 c6 b
3 1 NULL NULL NULL NULL NULL NULL original
4 1 100 100 100 100 100 100 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 FLOAT, c5 DOUBLE, c6 decimal(38,18), b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint
PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_tinyint
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 decimal(38,18), c5 FLOAT, c6 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_tinyint replace columns (insert_num int, c1 SMALLINT, c2 INT, c3 BIGINT, c4 FLOAT, c5 DOUBLE, c6 decimal(38,18), b STRING)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_tinyint
@@ -3563,18 +3563,18 @@ STAGE PLANS:
alias: part_change_lower_to_higher_numeric_group_tinyint
Statistics: Num rows: 10 Data size: 446 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: insert_num (type: int), part (type: int), c1 (type: smallint), c2 (type: int), c3 (type: bigint), c4 (type: decimal(38,18)), c5 (type: float), c6 (type: double), b (type: string)
+ expressions: insert_num (type: int), part (type: int), c1 (type: smallint), c2 (type: int), c3 (type: bigint), c4 (type: float), c5 (type: double), c6 (type: decimal(38,18)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
Statistics: Num rows: 10 Data size: 446 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Statistics: Num rows: 10 Data size: 446 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: int), _col2 (type: smallint), _col3 (type: int), _col4 (type: bigint), _col5 (type: decimal(38,18)), _col6 (type: float), _col7 (type: double), _col8 (type: string)
+ value expressions: _col1 (type: int), _col2 (type: smallint), _col3 (type: int), _col4 (type: bigint), _col5 (type: float), _col6 (type: double), _col7 (type: decimal(38,18)), _col8 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
- expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: decimal(38,18)), VALUE._col5 (type: float), VALUE._col6 (type: double), VALUE._col7 (type: string)
+ expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: smallint), VALUE._col2 (type: int), VALUE._col3 (type: bigint), VALUE._col4 (type: float), VALUE._col5 (type: double), VALUE._col6 (type: decimal(38,18)), VALUE._col7 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
Statistics: Num rows: 10 Data size: 446 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -3604,16 +3604,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint@part=
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint@part=2
#### A masked pattern was here ####
insert_num part c1 c2 c3 c4 c5 c6 b
-1 1 45 45 45 45.000000000000000000 45.0 45.0 original
-10 1 17 NULL NULL 95.000000000000000000 20.0 18.0 new
-2 1 -2 -2 -2 -2.000000000000000000 -2.0 -2.0 original
+1 1 45 45 45 45.0 45.0 45.000000000000000000 original
+10 1 17 NULL NULL 95.0 20.0 18.000000000000000000 new
+2 1 -2 -2 -2 -2.0 -2.0 -2.000000000000000000 original
3 1 NULL NULL NULL NULL NULL NULL original
-4 1 100 100 100 100.000000000000000000 100.0 100.0 original
-5 2 774 2031 200 12.000000000000000000 99.0 0.0 new
-6 2 NULL 52927714 7203778961 8.000000000000000000 7.0 6.0 new
-7 2 256 32768 31889 300.000000000000000000 444.0 506.0 new
-8 2 5555 40000 -719017797 45.000000000000000000 55.0 65.0 new
-9 1 100 NULL NULL 22.000000000000000000 2.0 -2.0 new
+4 1 100 100 100 100.0 100.0 100.000000000000000000 original
+5 2 774 2031 200 12.0 99.0 0.000000000000000000 new
+6 2 NULL 52927714 7203778961 8.0 7.0 6.000000000000000000 new
+7 2 256 32768 31889 300.0 444.0 506.000000000000000000 new
+8 2 5555 40000 -719017797 45.0 55.0 65.000000000000000000 new
+9 1 100 NULL NULL 22.0 2.0 -2.000000000000000000 new
PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_tinyint
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint
@@ -3623,14 +3623,14 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_tinyint
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_tinyint
PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, FLOAT, DOUBLE, DECIMAL)
--
CREATE TABLE part_change_lower_to_higher_numeric_group_smallint(insert_num int, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint, b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_smallint
POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: SMALLINT, (INT, BIGINT, FLOAT, DOUBLE, DECIMAL)
--
CREATE TABLE part_change_lower_to_higher_numeric_group_smallint(insert_num int, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint, b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
@@ -3676,12 +3676,12 @@ insert_num part c1 c2 c3 c4 c5 b
3 1 -5000 -5000 -5000 -5000 -5000 original
4 1 100 100 100 100 100 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 decimal(38,18), c4 FLOAT, c5 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 FLOAT, c4 DOUBLE, c5 decimal(38,18), b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint
PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_smallint
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 decimal(38,18), c4 FLOAT, c5 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_smallint replace columns (insert_num int, c1 INT, c2 BIGINT, c3 FLOAT, c4 DOUBLE, c5 decimal(38,18), b STRING)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_smallint
@@ -3738,25 +3738,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_lower_to_higher_numeric_group_smallint
- Statistics: Num rows: 10 Data size: 445 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 444 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: insert_num (type: int), part (type: int), c1 (type: int), c2 (type: bigint), c3 (type: decimal(38,18)), c4 (type: float), c5 (type: double), b (type: string)
+ expressions: insert_num (type: int), part (type: int), c1 (type: int), c2 (type: bigint), c3 (type: float), c4 (type: double), c5 (type: decimal(38,18)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
- Statistics: Num rows: 10 Data size: 445 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 444 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 10 Data size: 445 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: bigint), _col4 (type: decimal(38,18)), _col5 (type: float), _col6 (type: double), _col7 (type: string)
+ Statistics: Num rows: 10 Data size: 444 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: decimal(38,18)), _col7 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
- expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: decimal(38,18)), VALUE._col4 (type: float), VALUE._col5 (type: double), VALUE._col6 (type: string)
+ expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: float), VALUE._col4 (type: double), VALUE._col5 (type: decimal(38,18)), VALUE._col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7
- Statistics: Num rows: 10 Data size: 445 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 444 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 445 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 444 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -3781,16 +3781,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint@part
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint@part=2
#### A masked pattern was here ####
insert_num part c1 c2 c3 c4 c5 b
-1 1 2031 2031 2031.000000000000000000 2031.0 2031.0 original
-10 1 17 NULL NULL 95.0 20.0 new
-2 1 -2 -2 -2.000000000000000000 -2.0 -2.0 original
-3 1 -5000 -5000 -5000.000000000000000000 -5000.0 -5000.0 original
-4 1 100 100 100.000000000000000000 100.0 100.0 original
-5 2 774 2031 200.000000000000000000 12.0 99.0 new
-6 2 561431 52927714 7203778961.000000000000000000 8.0 7.0 new
-7 2 256 32768 31889.000000000000000000 300.0 444.0 new
-8 2 5555 40000 -719017797.000000000000000000 45.0 55.0 new
-9 1 100 5000 5443.000000000000000000 22.0 2.0 new
+1 1 2031 2031 2031.0 2031.0 2031.000000000000000000 original
+10 1 17 NULL NULL 95.0 20.000000000000000000 new
+2 1 -2 -2 -2.0 -2.0 -2.000000000000000000 original
+3 1 -5000 -5000 -5000.0 -5000.0 -5000.000000000000000000 original
+4 1 100 100 100.0 100.0 100.000000000000000000 original
+5 2 774 2031 200.0 12.0 99.000000000000000000 new
+6 2 561431 52927714 7.2037791E9 8.0 7.000000000000000000 new
+7 2 256 32768 31889.0 300.0 444.000000000000000000 new
+8 2 5555 40000 -7.1901779E8 45.0 55.000000000000000000 new
+9 1 100 5000 5443.0 22.0 2.000000000000000000 new
PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_smallint
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint
@@ -3800,14 +3800,14 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_smallint
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_smallint
PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, FLOAT, DOUBLE, DECIMAL)
--
CREATE TABLE part_change_lower_to_higher_numeric_group_int(insert_num int, c1 int, c2 int, c3 int, c4 int, b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_int
POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: INT, (BIGINT, FLOAT, DOUBLE, DECIMAL)
--
CREATE TABLE part_change_lower_to_higher_numeric_group_int(insert_num int, c1 int, c2 int, c3 int, c4 int, b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
@@ -3852,12 +3852,12 @@ insert_num part c1 c2 c3 c4 b
3 1 -5000 -5000 -5000 -5000 original
4 1 52927714 52927714 52927714 52927714 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 decimal(38,18), c3 FLOAT, c4 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 FLOAT, c3 DOUBLE, c4 decimal(38,18), b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_int
PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_int
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 decimal(38,18), c3 FLOAT, c4 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_int replace columns (insert_num int, c1 BIGINT, c2 FLOAT, c3 DOUBLE, c4 decimal(38,18), b STRING)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_int
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_int
@@ -3912,25 +3912,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_lower_to_higher_numeric_group_int
- Statistics: Num rows: 10 Data size: 429 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 434 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: insert_num (type: int), part (type: int), c1 (type: bigint), c2 (type: decimal(38,18)), c3 (type: float), c4 (type: double), b (type: string)
+ expressions: insert_num (type: int), part (type: int), c1 (type: bigint), c2 (type: float), c3 (type: double), c4 (type: decimal(38,18)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 10 Data size: 429 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 434 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 10 Data size: 429 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: decimal(38,18)), _col4 (type: float), _col5 (type: double), _col6 (type: string)
+ Statistics: Num rows: 10 Data size: 434 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: double), _col5 (type: decimal(38,18)), _col6 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
- expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: decimal(38,18)), VALUE._col3 (type: float), VALUE._col4 (type: double), VALUE._col5 (type: string)
+ expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: bigint), VALUE._col2 (type: float), VALUE._col3 (type: double), VALUE._col4 (type: decimal(38,18)), VALUE._col5 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
- Statistics: Num rows: 10 Data size: 429 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 434 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 429 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 434 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -3955,16 +3955,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_int@part=1
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_int@part=2
#### A masked pattern was here ####
insert_num part c1 c2 c3 c4 b
-1 1 2031 2031.000000000000000000 2031.0 2031.0 original
-10 1 17 90000.000000000000000000 NULL 95.0 new
-2 1 -2 -2.000000000000000000 -2.0 -2.0 original
-3 1 -5000 -5000.000000000000000000 -5000.0 -5000.0 original
-4 1 52927714 52927714.000000000000000000 5.2927712E7 5.2927714E7 original
-5 2 774 2031.000000000000000000 200.0 12.0 new
-6 2 561431 52927714.000000000000000000 7.2037791E9 8.0 new
-7 2 256 32768.000000000000000000 31889.0 300.0 new
-8 2 5555 40000.000000000000000000 -7.1901779E8 45.0 new
-9 1 100 5000.000000000000000000 5443.0 22.0 new
+1 1 2031 2031.0 2031.0 2031.000000000000000000 original
+10 1 17 90000.0 NULL 95.000000000000000000 new
+2 1 -2 -2.0 -2.0 -2.000000000000000000 original
+3 1 -5000 -5000.0 -5000.0 -5000.000000000000000000 original
+4 1 52927714 5.2927712E7 5.2927714E7 52927714.000000000000000000 original
+5 2 774 2031.0 200.0 12.000000000000000000 new
+6 2 561431 5.2927712E7 7.203778961E9 8.000000000000000000 new
+7 2 256 32768.0 31889.0 300.000000000000000000 new
+8 2 5555 40000.0 -7.19017797E8 45.000000000000000000 new
+9 1 100 5000.0 5443.0 22.000000000000000000 new
PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_int
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_int
@@ -3974,14 +3974,14 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_int
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_int
PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (FLOAT, DOUBLE, DECIMAL)
--
CREATE TABLE part_change_lower_to_higher_numeric_group_bigint(insert_num int, c1 bigint, c2 bigint, c3 bigint, b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint
POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (DECIMAL, FLOAT, DOUBLE)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: BIGINT, (FLOAT, DOUBLE, DECIMAL)
--
CREATE TABLE part_change_lower_to_higher_numeric_group_bigint(insert_num int, c1 bigint, c2 bigint, c3 bigint, b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
@@ -4025,12 +4025,12 @@ insert_num part c1 c2 c3 b
3 1 -5000 -5000 -5000 original
4 1 52927714 52927714 52927714 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 FLOAT, c2 DOUBLE, c3 decimal(38,18), b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint
PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING)
+alter table part_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 FLOAT, c2 DOUBLE, c3 decimal(38,18), b STRING)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint
@@ -4083,25 +4083,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_lower_to_higher_numeric_group_bigint
- Statistics: Num rows: 10 Data size: 411 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 408 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: insert_num (type: int), part (type: int), c1 (type: decimal(38,18)), c2 (type: float), c3 (type: double), b (type: string)
+ expressions: insert_num (type: int), part (type: int), c1 (type: float), c2 (type: double), c3 (type: decimal(38,18)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 10 Data size: 411 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 408 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 10 Data size: 411 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: int), _col2 (type: decimal(38,18)), _col3 (type: float), _col4 (type: double), _col5 (type: string)
+ Statistics: Num rows: 10 Data size: 408 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: int), _col2 (type: float), _col3 (type: double), _col4 (type: decimal(38,18)), _col5 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
- expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: decimal(38,18)), VALUE._col2 (type: float), VALUE._col3 (type: double), VALUE._col4 (type: string)
+ expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: float), VALUE._col2 (type: double), VALUE._col3 (type: decimal(38,18)), VALUE._col4 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
- Statistics: Num rows: 10 Data size: 411 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 408 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 411 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 408 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -4126,16 +4126,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint@part=1
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint@part=2
#### A masked pattern was here ####
insert_num part c1 c2 c3 b
-1 1 7203778961.000000000000000000 7.2037791E9 7.203778961E9 original
-10 1 17.000000000000000000 90000.0 NULL new
-2 1 -2.000000000000000000 -2.0 -2.0 original
-3 1 -5000.000000000000000000 -5000.0 -5000.0 original
-4 1 52927714.000000000000000000 5.2927712E7 5.2927714E7 original
-5 2 774.000000000000000000 2031.0 200.0 new
-6 2 561431.000000000000000000 5.2927712E7 7.203778961E9 new
-7 2 256.000000000000000000 32768.0 31889.0 new
-8 2 5555.000000000000000000 40000.0 -7.19017797E8 new
-9 1 100.000000000000000000 5000.0 5443.0 new
+1 1 7.2037791E9 7.203778961E9 7203778961.000000000000000000 original
+10 1 17.0 90000.0 754072151.000000000000000000 new
+2 1 -2.0 -2.0 -2.000000000000000000 original
+3 1 -5000.0 -5000.0 -5000.000000000000000000 original
+4 1 5.2927712E7 5.2927714E7 52927714.000000000000000000 original
+5 2 774.0 2031.0 200.000000000000000000 new
+6 2 561431.0 5.2927714E7 7203778961.000000000000000000 new
+7 2 256.0 32768.0 31889.000000000000000000 new
+8 2 5555.0 40000.0 -719017797.000000000000000000 new
+9 1 100.0 5000.0 5443.000000000000000000 new
PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_bigint
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_bigint
@@ -4147,205 +4147,38 @@ POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_bigint
PREHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL)
--
-CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal
+PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float
POSTHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL)
--
-CREATE TABLE part_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT)
+CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, c2 float, b STRING) PARTITIONED BY(part INT)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
-POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_decimal partition(part=1)
- values (1, -29.0764, -29.0764, 'original'),
+POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float
+PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part=1)
+ values (1, -29.0764, -29.0764, 'original'),
(2, 753.7028, 753.7028, 'original'),
(3, -5000, -5000, 'original'),
(4, 52927714, 52927714, 'original')
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__49
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_decimal partition(part=1)
- values (1, -29.0764, -29.0764, 'original'),
+PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float@part=1
+POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part=1)
+ values (1, -29.0764, -29.0764, 'original'),
(2, 753.7028, 753.7028, 'original'),
(3, -5000, -5000, 'original'),
(4, 52927714, 52927714, 'original')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@values__tmp__table__49
-POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).b SIMPLE [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-_col0 _col1 _col2 _col3
-PREHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-#### A masked pattern was here ####
-insert_num part c1 b
-1 1 -29.0764 original
-2 1 753.7028 original
-3 1 -5000.0 original
-4 1 5.2927712E7 original
-PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING)
-PREHOOK: type: ALTERTABLE_REPLACECOLS
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING)
-POSTHOOK: type: ALTERTABLE_REPLACECOLS
-POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_decimal partition(part)
- values (5, '7.74', '22.3', 'new', 2),
- (6, '56.1431', '90.9', 'new', 2),
- (7, '2.56', '25.6', 'new', 2),
- (8, '555.5', '55.55', 'new', 2),
- (9, '10.0', '0.100', 'new', 1),
- (10, '1.7', '17.8888', 'new', 1)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__50
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_decimal partition(part)
- values (5, '7.74', '22.3', 'new', 2),
- (6, '56.1431', '90.9', 'new', 2),
- (7, '2.56', '25.6', 'new', 2),
- (8, '555.5', '55.55', 'new', 2),
- (9, '10.0', '0.100', 'new', 1),
- (10, '1.7', '17.8888', 'new', 1)
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__50
-POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal@part=2
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=2).b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=2).c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=2).c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_decimal PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-_col0 _col1 _col2 _col3 _col4
-PREHOOK: query: explain
-select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-PREHOOK: type: QUERY
-POSTHOOK: query: explain
-select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-POSTHOOK: type: QUERY
-Explain
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Map Operator Tree:
- TableScan
- alias: part_change_lower_to_higher_numeric_group_decimal
- Statistics: Num rows: 10 Data size: 311 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: insert_num (type: int), part (type: int), c1 (type: double), b (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 10 Data size: 311 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col0 (type: int)
- sort order: +
- Statistics: Num rows: 10 Data size: 311 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: int), _col2 (type: double), _col3 (type: string)
- Execution mode: vectorized
- Reduce Operator Tree:
- Select Operator
- expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: double), VALUE._col2 (type: string)
- outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 10 Data size: 311 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 10 Data size: 311 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
-
-PREHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=2
-#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_decimal order by insert_num
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=1
-POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal@part=2
-#### A masked pattern was here ####
-insert_num part c1 b
-1 1 -29.076400756835938 original
-10 1 1.7000000476837158 new
-2 1 753.7028198242188 original
-3 1 -5000.0 original
-4 1 5.2927712E7 original
-5 2 7.74 new
-6 2 56.1431 new
-7 2 2.56 new
-8 2 555.5 new
-9 1 10.0 new
-PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: query: drop table part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_decimal
-PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL)
---
-CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 DOUBLE, b STRING) PARTITIONED BY(part INT)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float
-POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL)
---
-CREATE TABLE part_change_lower_to_higher_numeric_group_float(insert_num int, c1 DOUBLE, b STRING) PARTITIONED BY(part INT)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float
-PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part=1)
- values (1, -29.0764, 'original'),
- (2, 753.7028, 'original'),
- (3, -5000, 'original'),
- (4, 52927714, 'original')
-PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__51
-PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float@part=1
-POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part=1)
- values (1, -29.0764, 'original'),
- (2, 753.7028, 'original'),
- (3, -5000, 'original'),
- (4, 52927714, 'original')
-POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__51
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float@part=1
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).b SIMPLE [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-_col0 _col1 _col2
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).b SIMPLE [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+_col0 _col1 _col2 _col3
PREHOOK: query: select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float order by insert_num
PREHOOK: type: QUERY
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float
@@ -4360,45 +4193,47 @@ insert_num part c1 b
1 1 -29.0764 original
2 1 753.7028 original
3 1 -5000.0 original
-4 1 5.2927714E7 original
+4 1 5.2927712E7 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING)
+alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, c2 decimal(38,18), b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float
PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING)
+alter table part_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 DOUBLE, c2 decimal(38,18), b STRING)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float
PREHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part)
- values (5, '774', 'new', 2),
- (6, '561431', 'new', 2),
- (7, '256', 'new', 2),
- (8, '5555', 'new', 2),
- (9, '100', 'new', 1),
- (10, '17', 'new', 1)
+ values (5, '774', '774', 'new', 2),
+ (6, '561431', '561431', 'new', 2),
+ (7, '256', '256', 'new', 2),
+ (8, '5555', '5555', 'new', 2),
+ (9, '100', '100', 'new', 1),
+ (10, '17', '17', 'new', 1)
PREHOOK: type: QUERY
-PREHOOK: Input: default@values__tmp__table__52
+PREHOOK: Input: default@values__tmp__table__50
PREHOOK: Output: default@part_change_lower_to_higher_numeric_group_float
POSTHOOK: query: insert into table part_change_lower_to_higher_numeric_group_float partition(part)
- values (5, '774', 'new', 2),
- (6, '561431', 'new', 2),
- (7, '256', 'new', 2),
- (8, '5555', 'new', 2),
- (9, '100', 'new', 1),
- (10, '17', 'new', 1)
+ values (5, '774', '774', 'new', 2),
+ (6, '561431', '561431', 'new', 2),
+ (7, '256', '256', 'new', 2),
+ (8, '5555', '5555', 'new', 2),
+ (9, '100', '100', 'new', 1),
+ (10, '17', '17', 'new', 1)
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@values__tmp__table__52
+POSTHOOK: Input: default@values__tmp__table__50
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float@part=1
POSTHOOK: Output: default@part_change_lower_to_higher_numeric_group_float@part=2
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).b SIMPLE [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).b SIMPLE [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).c1 EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
-_col0 _col1 _col2 _col3
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=1).insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: part_change_lower_to_higher_numeric_group_float PARTITION(part=2).insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+_col0 _col1 _col2 _col3 _col4
PREHOOK: query: explain
select insert_num,part,c1,b from part_change_lower_to_higher_numeric_group_float order by insert_num
PREHOOK: type: QUERY
@@ -4416,25 +4251,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: part_change_lower_to_higher_numeric_group_float
- Statistics: Num rows: 10 Data size: 250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 327 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: insert_num (type: int), part (type: int), c1 (type: decimal(38,18)), b (type: string)
+ expressions: insert_num (type: int), part (type: int), c1 (type: double), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 10 Data size: 250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 327 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 10 Data size: 250 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: int), _col2 (type: decimal(38,18)), _col3 (type: string)
+ Statistics: Num rows: 10 Data size: 327 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: int), _col2 (type: double), _col3 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
- expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: decimal(38,18)), VALUE._col2 (type: string)
+ expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: int), VALUE._col1 (type: double), VALUE._col2 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 10 Data size: 250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 327 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 250 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 327 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -4459,16 +4294,16 @@ POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float@part=1
POSTHOOK: Input: default@part_change_lower_to_higher_numeric_group_float@part=2
#### A masked pattern was here ####
insert_num part c1 b
-1 1 -29.076400000000000000 original
-10 1 17.000000000000000000 new
-2 1 753.702800000000000000 original
-3 1 -5000.000000000000000000 original
-4 1 52927714.000000000000000000 original
-5 2 774.000000000000000000 new
-6 2 561431.000000000000000000 new
-7 2 256.000000000000000000 new
-8 2 5555.000000000000000000 new
-9 1 100.000000000000000000 new
+1 1 -29.076400756835938 original
+10 1 17.0 new
+2 1 753.7028198242188 original
+3 1 -5000.0 original
+4 1 5.2927712E7 original
+5 2 774.0 new
+6 2 561431.0 new
+7 2 256.0 new
+8 2 5555.0 new
+9 1 100.0 new
PREHOOK: query: drop table part_change_lower_to_higher_numeric_group_float
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@part_change_lower_to_higher_numeric_group_float