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:34 UTC
[16/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_table.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out b/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out
index f7f178a..c0e047e 100644
--- a/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out
+++ b/ql/src/test/results/clientpositive/schema_evol_text_vec_mapwork_table.q.out
@@ -1982,14 +1982,14 @@ POSTHOOK: Output: default@table_change_numeric_group_string_group_multi_ints_var
PREHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), STRING
--
-CREATE TABLE table_change_numeric_group_string_group_floating_string(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING)
+CREATE TABLE table_change_numeric_group_string_group_floating_string(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@table_change_numeric_group_string_group_floating_string
POSTHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for NUMERIC_GROUP -> STRING_GROUP: (FLOAT, DOUBLE, DECIMAL), STRING
--
-CREATE TABLE table_change_numeric_group_string_group_floating_string(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING)
+CREATE TABLE table_change_numeric_group_string_group_floating_string(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_string
@@ -2024,10 +2024,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string
#### A masked pattern was here ####
insert_num c1 c2 c3 b
-1 -23866739993.000000000000000000 753.7028 -3651.672121 original
-2 -10.300000000000000000 -2.0 -29.0764 original
-3 -832222222.000000000000000000 255.0 4957.0 original
-4 847492223.000000000000000000 0.0 20435.0 original
+1 -2.38667407E10 753.7028 -3651.672121000000000000 original
+2 -10.3 -2.0 -29.076400000000000000 original
+3 -8.3222221E8 255.0 4957.000000000000000000 original
+4 8.4749222E8 0.0 20435.000000000000000000 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
alter table table_change_numeric_group_string_group_floating_string replace columns (insert_num int, c1 STRING, c2 STRING, c3 STRING, b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
@@ -2081,25 +2081,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: table_change_numeric_group_string_group_floating_string
- Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), c1 (type: string), c2 (type: string), c3 (type: string), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string), VALUE._col1 (type: string), VALUE._col2 (type: string), VALUE._col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2120,11 +2120,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string
#### A masked pattern was here ####
insert_num c1 c2 c3 b
-1 -23866739993.000000000000000000 753.7028 -3651.672121 original
+1 -2.38667407E10 753.7028 -3651.672121000000000000 original
10 17 90000 754072151 new
-2 -10.300000000000000000 -2.0 -29.0764 original
-3 -832222222.000000000000000000 255.0 4957.0 original
-4 847492223.000000000000000000 0.0 20435.0 original
+2 -10.3 -2.0 -29.076400000000000000 original
+3 -8.3222221E8 255.0 4957.000000000000000000 original
+4 8.4749222E8 0.0 20435.000000000000000000 original
5 30.774 20.31 46114.284799488 new
6 -66475.561431 52927714 7203778961 new
7 256 32768 31889 new
@@ -2139,16 +2139,16 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_string
POSTHOOK: Output: default@table_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 table_change_numeric_group_string_group_floating_char(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING)
+CREATE TABLE table_change_numeric_group_string_group_floating_char(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@table_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 table_change_numeric_group_string_group_floating_char(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING)
+CREATE TABLE table_change_numeric_group_string_group_floating_char(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_char
@@ -2183,10 +2183,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char
#### A masked pattern was here ####
insert_num c1 c2 c3 b
-1 -23866739993.000000000000000000 753.7028 -3651.672121 original
-2 -10.300000000000000000 -2.0 -29.0764 original
-3 9000000000.000000000000000000 -255.0 4957.0 original
-4 -999999999999.000000000000000000 0.0 20435.0 original
+1 -2.38667407E10 753.7028 -3651.672121000000000000 original
+2 -10.3 -2.0 -29.076400000000000000 original
+3 8.9999995E9 -255.0 4957.000000000000000000 original
+4 -1.0E12 0.0 20435.000000000000000000 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
alter table table_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
@@ -2240,25 +2240,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: table_change_numeric_group_string_group_floating_char
- Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), c1 (type: char(50)), c2 (type: char(50)), c3 (type: char(50)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: char(50)), _col2 (type: char(50)), _col3 (type: char(50)), _col4 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: char(50)), VALUE._col1 (type: char(50)), VALUE._col2 (type: char(50)), VALUE._col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2279,11 +2279,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char
#### A masked pattern was here ####
insert_num c1 c2 c3 b
-1 -23866739993.000000000000000000 753.7028 -3651.672121 original
+1 -2.38667407E10 753.7028 -3651.672121000000000000 original
10 17 90000 754072151 new
-2 -10.300000000000000000 -2.0 -29.0764 original
-3 9000000000.000000000000000000 -255.0 4957.0 original
-4 -999999999999.000000000000000000 0.0 20435.0 original
+2 -10.3 -2.0 -29.076400000000000000 original
+3 8.9999995E9 -255.0 4957.000000000000000000 original
+4 -1.0E12 0.0 20435.000000000000000000 original
5 30.774 20.31 46114.284799488 new
6 -66475.561431 52927714 7203778961 new
7 256 32768 31889 new
@@ -2298,16 +2298,16 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char
POSTHOOK: Output: default@table_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 table_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING)
+CREATE TABLE table_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@table_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 table_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING)
+CREATE TABLE table_change_numeric_group_string_group_floating_char_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_char_trunc
@@ -2342,10 +2342,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char_trunc
#### A masked pattern was here ####
insert_num c1 c2 c3 b
-1 -23866739993.000000000000000000 753.7028 -3651.672121 original
-2 -10.300000000000000000 -2.0 -29.0764 original
-3 832222222.000000000000000000 -255.0 4957.0 original
-4 847492223.000000000000000000 0.0 20435.0 original
+1 -2.38667407E10 753.7028 -3651.672121000000000000 original
+2 -10.3 -2.0 -29.076400000000000000 original
+3 8.3222221E8 -255.0 4957.000000000000000000 original
+4 8.4749222E8 0.0 20435.000000000000000000 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
alter table table_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
@@ -2399,25 +2399,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: table_change_numeric_group_string_group_floating_char_trunc
- Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), c1 (type: char(7)), c2 (type: char(7)), c3 (type: char(7)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: char(7)), _col2 (type: char(7)), _col3 (type: char(7)), _col4 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: char(7)), VALUE._col1 (type: char(7)), VALUE._col2 (type: char(7)), VALUE._col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 215 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 207 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2438,11 +2438,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char_trunc
#### A masked pattern was here ####
insert_num c1 c2 c3 b
-1 -238667 753.702 -3651.6 original
+1 -2.3866 753.702 -3651.6 original
10 17 90000 7540721 new
-2 -10.300 -2.0 -29.076 original
-3 8322222 -255.0 4957.0 original
-4 8474922 0.0 20435.0 original
+2 -10.3 -2.0 -29.076 original
+3 8.32222 -255.0 4957.00 original
+4 8.47492 0.0 20435.0 original
5 30.774 20.31 46114.2 new
6 -66475. 5292771 7203778 new
7 256 32768 31889 new
@@ -2457,14 +2457,14 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_char_trunc
POSTHOOK: Output: default@table_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 table_change_numeric_group_string_group_floating_varchar(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@table_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 table_change_numeric_group_string_group_floating_varchar(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING)
POSTHOOK: type: CREATETABLE
@@ -2616,16 +2616,16 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar
POSTHOOK: Output: default@table_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 table_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING)
+CREATE TABLE table_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@table_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 table_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 decimal(38,18), c2 float, c3 double, b STRING)
+CREATE TABLE table_change_numeric_group_string_group_floating_varchar_trunc(insert_num int, c1 float, c2 double, c3 decimal(38,18), b STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_change_numeric_group_string_group_floating_varchar_trunc
@@ -2660,10 +2660,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar_trunc
#### A masked pattern was here ####
insert_num c1 c2 c3 b
-1 -23866739993.000000000000000000 753.7028 -3651.672121 original
-2 -10.300000000000000000 -2.0 -29.0764 original
-3 9000000000.000000000000000000 -255.0 4957.0 original
-4 -999999999999.000000000000000000 0.0 20435.0 original
+1 -2.38667407E10 753.7028 -3651.672121000000000000 original
+2 -10.3 -2.0 -29.076400000000000000 original
+3 8.9999995E9 -255.0 4957.000000000000000000 original
+4 -1.0E12 0.0 20435.000000000000000000 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
alter table table_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
@@ -2717,25 +2717,25 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: table_change_numeric_group_string_group_floating_varchar_trunc
- Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), c1 (type: varchar(7)), c2 (type: varchar(7)), c3 (type: varchar(7)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
- Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: varchar(7)), _col2 (type: varchar(7)), _col3 (type: varchar(7)), _col4 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: varchar(7)), VALUE._col1 (type: varchar(7)), VALUE._col2 (type: varchar(7)), VALUE._col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 4 Data size: 220 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 203 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -2756,11 +2756,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_numeric_group_string_group_floating_varchar_trunc
#### A masked pattern was here ####
insert_num c1 c2 c3 b
-1 -238667 753.702 -3651.6 original
+1 -2.3866 753.702 -3651.6 original
10 17 90000 7540721 new
-2 -10.300 -2.0 -29.076 original
-3 9000000 -255.0 4957.0 original
-4 -999999 0.0 20435.0 original
+2 -10.3 -2.0 -29.076 original
+3 8.99999 -255.0 4957.00 original
+4 -1.0E12 0.0 20435.0 original
5 30.774 20.31 46114.2 new
6 -66475. 5292771 7203778 new
7 256 32768 31889 new
@@ -3266,7 +3266,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 table_change_lower_to_higher_numeric_group_tinyint(insert_num int, c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, b STRING)
PREHOOK: type: CREATETABLE
@@ -3277,7 +3277,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 table_change_lower_to_higher_numeric_group_tinyint(insert_num int, c1 tinyint, c2 tinyint, c3 tinyint, c4 tinyint, c5 tinyint, c6 tinyint, b STRING)
POSTHOOK: type: CREATETABLE
@@ -3322,12 +3322,12 @@ insert_num c1 c2 c3 c4 c5 c6 b
3 NULL NULL NULL NULL NULL NULL original
4 100 100 100 100 100 100 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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 table_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@table_change_lower_to_higher_numeric_group_tinyint
PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_tinyint
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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 table_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@table_change_lower_to_higher_numeric_group_tinyint
POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_tinyint
@@ -3379,18 +3379,18 @@ STAGE PLANS:
alias: table_change_lower_to_higher_numeric_group_tinyint
Statistics: Num rows: 4 Data size: 118 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: insert_num (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), 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
Statistics: Num rows: 4 Data size: 118 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Statistics: Num rows: 4 Data size: 118 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: smallint), _col2 (type: int), _col3 (type: bigint), _col4 (type: decimal(38,18)), _col5 (type: float), _col6 (type: double), _col7 (type: string)
+ value expressions: _col1 (type: smallint), _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: smallint), 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: smallint), 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: 4 Data size: 118 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -3416,16 +3416,16 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint
#### A masked pattern was here ####
insert_num c1 c2 c3 c4 c5 c6 b
-1 45 45 45 45.000000000000000000 45.0 45.0 original
-10 17 90000 754072151 95.000000000000000000 20.0 18.0 new
-2 -2 -2 -2 -2.000000000000000000 -2.0 -2.0 original
+1 45 45 45 45.0 45.0 45.000000000000000000 original
+10 17 90000 754072151 95.0 20.0 18.000000000000000000 new
+2 -2 -2 -2 -2.0 -2.0 -2.000000000000000000 original
3 NULL NULL NULL NULL NULL NULL original
-4 100 100 100 100.000000000000000000 100.0 100.0 original
-5 774 2031 200 12.000000000000000000 99.0 0.0 new
-6 NULL 52927714 7203778961 8.000000000000000000 7.0 6.0 new
-7 256 32768 31889 300.000000000000000000 444.0 506.0 new
-8 5555 40000 -719017797 45.000000000000000000 55.0 65.0 new
-9 100 5000 5443 22.000000000000000000 2.0 -2.0 new
+4 100 100 100 100.0 100.0 100.000000000000000000 original
+5 774 2031 200 12.0 99.0 0.000000000000000000 new
+6 NULL 52927714 7203778961 8.0 7.0 6.000000000000000000 new
+7 256 32768 31889 300.0 444.0 506.000000000000000000 new
+8 5555 40000 -719017797 45.0 55.0 65.000000000000000000 new
+9 100 5000 5443 22.0 2.0 -2.000000000000000000 new
PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_tinyint
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint
@@ -3435,14 +3435,14 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_tinyint
POSTHOOK: Output: default@table_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 table_change_lower_to_higher_numeric_group_smallint(insert_num int, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint, b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@table_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 table_change_lower_to_higher_numeric_group_smallint(insert_num int, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint, b STRING)
POSTHOOK: type: CREATETABLE
@@ -3486,12 +3486,12 @@ insert_num c1 c2 c3 c4 c5 b
3 -5000 -5000 -5000 -5000 -5000 original
4 100 100 100 100 100 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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 table_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@table_change_lower_to_higher_numeric_group_smallint
PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_smallint
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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 table_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@table_change_lower_to_higher_numeric_group_smallint
POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_smallint
@@ -3542,18 +3542,18 @@ STAGE PLANS:
alias: table_change_lower_to_higher_numeric_group_smallint
Statistics: Num rows: 4 Data size: 130 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: insert_num (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), 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
Statistics: Num rows: 4 Data size: 130 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Statistics: Num rows: 4 Data size: 130 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: decimal(38,18)), _col4 (type: float), _col5 (type: double), _col6 (type: string)
+ value expressions: _col1 (type: int), _col2 (type: bigint), _col3 (type: float), _col4 (type: double), _col5 (type: decimal(38,18)), _col6 (type: string)
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: 4 Data size: 130 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -3579,16 +3579,16 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint
#### A masked pattern was here ####
insert_num c1 c2 c3 c4 c5 b
-1 2031 2031 2031.000000000000000000 2031.0 2031.0 original
-10 17 90000 754072151.000000000000000000 95.0 20.0 new
-2 -2 -2 -2.000000000000000000 -2.0 -2.0 original
-3 -5000 -5000 -5000.000000000000000000 -5000.0 -5000.0 original
-4 100 100 100.000000000000000000 100.0 100.0 original
-5 774 2031 200.000000000000000000 12.0 99.0 new
-6 561431 52927714 7203778961.000000000000000000 8.0 7.0 new
-7 256 32768 31889.000000000000000000 300.0 444.0 new
-8 5555 40000 -719017797.000000000000000000 45.0 55.0 new
-9 100 5000 5443.000000000000000000 22.0 2.0 new
+1 2031 2031 2031.0 2031.0 2031.000000000000000000 original
+10 17 90000 7.5407213E8 95.0 20.000000000000000000 new
+2 -2 -2 -2.0 -2.0 -2.000000000000000000 original
+3 -5000 -5000 -5000.0 -5000.0 -5000.000000000000000000 original
+4 100 100 100.0 100.0 100.000000000000000000 original
+5 774 2031 200.0 12.0 99.000000000000000000 new
+6 561431 52927714 7.2037791E9 8.0 7.000000000000000000 new
+7 256 32768 31889.0 300.0 444.000000000000000000 new
+8 5555 40000 -7.1901779E8 45.0 55.000000000000000000 new
+9 100 5000 5443.0 22.0 2.000000000000000000 new
PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_smallint
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint
@@ -3598,14 +3598,14 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_smallint
POSTHOOK: Output: default@table_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 table_change_lower_to_higher_numeric_group_int(insert_num int, c1 int, c2 int, c3 int, c4 int, b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@table_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 table_change_lower_to_higher_numeric_group_int(insert_num int, c1 int, c2 int, c3 int, c4 int, b STRING)
POSTHOOK: type: CREATETABLE
@@ -3648,12 +3648,12 @@ insert_num c1 c2 c3 c4 b
3 -5000 -5000 -5000 -5000 original
4 52927714 52927714 52927714 52927714 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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 table_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@table_change_lower_to_higher_numeric_group_int
PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_int
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_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 table_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@table_change_lower_to_higher_numeric_group_int
POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_int
@@ -3703,18 +3703,18 @@ STAGE PLANS:
alias: table_change_lower_to_higher_numeric_group_int
Statistics: Num rows: 4 Data size: 132 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: insert_num (type: int), c1 (type: bigint), c2 (type: decimal(38,18)), c3 (type: float), c4 (type: double), b (type: string)
+ expressions: insert_num (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
Statistics: Num rows: 4 Data size: 132 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Statistics: Num rows: 4 Data size: 132 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: bigint), _col2 (type: decimal(38,18)), _col3 (type: float), _col4 (type: double), _col5 (type: string)
+ value expressions: _col1 (type: bigint), _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: bigint), 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: bigint), 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: 4 Data size: 132 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -3740,16 +3740,16 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_int
#### A masked pattern was here ####
insert_num c1 c2 c3 c4 b
-1 2031 2031.000000000000000000 2031.0 2031.0 original
-10 17 90000.000000000000000000 7.5407213E8 95.0 new
-2 -2 -2.000000000000000000 -2.0 -2.0 original
-3 -5000 -5000.000000000000000000 -5000.0 -5000.0 original
-4 52927714 52927714.000000000000000000 5.2927712E7 5.2927714E7 original
-5 774 2031.000000000000000000 200.0 12.0 new
-6 561431 52927714.000000000000000000 7.2037791E9 8.0 new
-7 256 32768.000000000000000000 31889.0 300.0 new
-8 5555 40000.000000000000000000 -7.1901779E8 45.0 new
-9 100 5000.000000000000000000 5443.0 22.0 new
+1 2031 2031.0 2031.0 2031.000000000000000000 original
+10 17 90000.0 7.54072151E8 95.000000000000000000 new
+2 -2 -2.0 -2.0 -2.000000000000000000 original
+3 -5000 -5000.0 -5000.0 -5000.000000000000000000 original
+4 52927714 5.2927712E7 5.2927714E7 52927714.000000000000000000 original
+5 774 2031.0 200.0 12.000000000000000000 new
+6 561431 5.2927712E7 7.203778961E9 8.000000000000000000 new
+7 256 32768.0 31889.0 300.000000000000000000 new
+8 5555 40000.0 -7.19017797E8 45.000000000000000000 new
+9 100 5000.0 5443.0 22.000000000000000000 new
PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_int
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_int
@@ -3759,14 +3759,14 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_int
POSTHOOK: Output: default@table_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 table_change_lower_to_higher_numeric_group_bigint(insert_num int, c1 bigint, c2 bigint, c3 bigint, b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@table_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 table_change_lower_to_higher_numeric_group_bigint(insert_num int, c1 bigint, c2 bigint, c3 bigint, b STRING)
POSTHOOK: type: CREATETABLE
@@ -3808,12 +3808,12 @@ insert_num c1 c2 c3 b
3 -5000 -5000 -5000 original
4 52927714 52927714 52927714 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING)
+alter table table_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@table_change_lower_to_higher_numeric_group_bigint
PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_lower_to_higher_numeric_group_bigint replace columns (insert_num int, c1 decimal(38,18), c2 FLOAT, c3 DOUBLE, b STRING)
+alter table table_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@table_change_lower_to_higher_numeric_group_bigint
POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint
@@ -3862,18 +3862,18 @@ STAGE PLANS:
alias: table_change_lower_to_higher_numeric_group_bigint
Statistics: Num rows: 4 Data size: 127 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: insert_num (type: int), c1 (type: decimal(38,18)), c2 (type: float), c3 (type: double), b (type: string)
+ expressions: insert_num (type: int), c1 (type: float), c2 (type: double), c3 (type: decimal(38,18)), b (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 4 Data size: 127 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: int)
sort order: +
Statistics: Num rows: 4 Data size: 127 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: decimal(38,18)), _col2 (type: float), _col3 (type: double), _col4 (type: string)
+ value expressions: _col1 (type: float), _col2 (type: double), _col3 (type: decimal(38,18)), _col4 (type: string)
Execution mode: vectorized
Reduce Operator Tree:
Select Operator
- expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: decimal(38,18)), VALUE._col1 (type: float), VALUE._col2 (type: double), VALUE._col3 (type: string)
+ expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: float), VALUE._col1 (type: double), VALUE._col2 (type: decimal(38,18)), VALUE._col3 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Statistics: Num rows: 4 Data size: 127 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -3899,16 +3899,16 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint
#### A masked pattern was here ####
insert_num c1 c2 c3 b
-1 7203778961.000000000000000000 7.2037791E9 7.203778961E9 original
-10 17.000000000000000000 90000.0 7.54072151E8 new
-2 -2.000000000000000000 -2.0 -2.0 original
-3 -5000.000000000000000000 -5000.0 -5000.0 original
-4 52927714.000000000000000000 5.2927712E7 5.2927714E7 original
-5 774.000000000000000000 2031.0 200.0 new
-6 561431.000000000000000000 5.2927712E7 7.203778961E9 new
-7 256.000000000000000000 32768.0 31889.0 new
-8 5555.000000000000000000 40000.0 -7.19017797E8 new
-9 100.000000000000000000 5000.0 5443.0 new
+1 7.2037791E9 7.203778961E9 7203778961.000000000000000000 original
+10 17.0 90000.0 754072151.000000000000000000 new
+2 -2.0 -2.0 -2.000000000000000000 original
+3 -5000.0 -5000.0 -5000.000000000000000000 original
+4 5.2927712E7 5.2927714E7 52927714.000000000000000000 original
+5 774.0 2031.0 200.000000000000000000 new
+6 561431.0 5.2927714E7 7203778961.000000000000000000 new
+7 256.0 32768.0 31889.000000000000000000 new
+8 5555.0 40000.0 -719017797.000000000000000000 new
+9 100.0 5000.0 5443.000000000000000000 new
PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_bigint
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint
@@ -3918,47 +3918,47 @@ POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_bigint
POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_bigint
PREHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (FLOAT, DECIMAL)
--
-CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING)
+CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, c2 float, b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal
+PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
POSTHOOK: query: --
--- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (DOUBLE, DECIMAL)
+-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: FLOAT, (FLOAT, DECIMAL)
--
-CREATE TABLE table_change_lower_to_higher_numeric_group_decimal(insert_num int, c1 float, c2 float, b STRING)
+CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 float, c2 float, b STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal
-PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_decimal
+POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
+PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float
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@table_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_decimal
+PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
+POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float
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@table_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.b SIMPLE [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c1 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c2 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.insert_num EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.b SIMPLE [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c1 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c2 EXPRESSION [(values__tmp__table__49)values__tmp__table__49.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.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,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num
+PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num
PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal
+PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num
+POSTHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal
+POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
#### A masked pattern was here ####
insert_num c1 c2 b
1 -29.0764 -29.0764 original
@@ -3966,16 +3966,16 @@ insert_num c1 c2 b
3 -5000.0 -5000.0 original
4 5.2927712E7 5.2927712E7 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING)
+alter table table_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@table_change_lower_to_higher_numeric_group_decimal
-PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal
+PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
+PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_lower_to_higher_numeric_group_decimal replace columns (insert_num int, c1 double, c2 decimal(38,18), b STRING)
+alter table table_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@table_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal
-PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_decimal
+POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
+POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
+PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float
values (5, '7.74', '22.3', 'new'),
(6, '56.1431', '90.9', 'new'),
(7, '2.56', '25.6', 'new'),
@@ -3984,8 +3984,8 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_dec
(10, '1.7', '17.8888', 'new')
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__50
-PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_decimal
+PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
+POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float
values (5, '7.74', '22.3', 'new'),
(6, '56.1431', '90.9', 'new'),
(7, '2.56', '25.6', 'new'),
@@ -3994,17 +3994,17 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_de
(10, '1.7', '17.8888', 'new')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@values__tmp__table__50
-POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_decimal.insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.b SIMPLE [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c1 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c2 EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.insert_num EXPRESSION [(values__tmp__table__50)values__tmp__table__50.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
_col0 _col1 _col2 _col3
PREHOOK: query: explain
-select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num
+select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num
+select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num
POSTHOOK: type: QUERY
Explain
STAGE DEPENDENCIES:
@@ -4016,7 +4016,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: table_change_lower_to_higher_numeric_group_decimal
+ alias: table_change_lower_to_higher_numeric_group_float
Statistics: Num rows: 4 Data size: 116 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), c1 (type: double), c2 (type: decimal(38,18)), b (type: string)
@@ -4047,13 +4047,13 @@ STAGE PLANS:
Processor Tree:
ListSink
-PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num
+PREHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num
PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal
+PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_decimal order by insert_num
+POSTHOOK: query: select insert_num,c1,c2,b from table_change_lower_to_higher_numeric_group_float order by insert_num
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal
+POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
#### A masked pattern was here ####
insert_num c1 c2 b
1 -29.0764 -29.076400000000000000 original
@@ -4066,55 +4066,55 @@ insert_num c1 c2 b
7 2.56 25.600000000000000000 new
8 555.5 55.550000000000000000 new
9 10.0 0.100000000000000000 new
-PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_decimal
+PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_float
PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal
-PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: query: drop table table_change_lower_to_higher_numeric_group_decimal
+PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
+PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
+POSTHOOK: query: drop table table_change_lower_to_higher_numeric_group_float
POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_decimal
-POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_decimal
+POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
+POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
PREHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL)
--
-CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING)
+CREATE TABLE table_change_lower_to_higher_numeric_group_double(insert_num int, c1 double, b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
-PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
+PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_double
POSTHOOK: query: --
-- SUBSECTION: ALTER TABLE CHANGE COLUMNS for "lower" type to "higher" NUMERIC_GROUP: DOUBLE, (DECIMAL)
--
-CREATE TABLE table_change_lower_to_higher_numeric_group_float(insert_num int, c1 double, b STRING)
+CREATE TABLE table_change_lower_to_higher_numeric_group_double(insert_num int, c1 double, b STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
-POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
-PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float
+POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_double
+PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_double
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@table_change_lower_to_higher_numeric_group_float
-POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float
+PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_double
+POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_double
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@table_change_lower_to_higher_numeric_group_float
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.b SIMPLE [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c1 EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.insert_num EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_double
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.b SIMPLE [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.c1 EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.insert_num EXPRESSION [(values__tmp__table__51)values__tmp__table__51.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
_col0 _col1 _col2
-PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num
+PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num
PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
+PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_double
#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num
+POSTHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
+POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_double
#### A masked pattern was here ####
insert_num c1 b
1 -29.0764 original
@@ -4122,16 +4122,16 @@ insert_num c1 b
3 -5000.0 original
4 5.2927714E7 original
PREHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING)
+alter table table_change_lower_to_higher_numeric_group_double replace columns (insert_num int, c1 decimal(38,18), b STRING)
PREHOOK: type: ALTERTABLE_REPLACECOLS
-PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
-PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
+PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_double
+PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_double
POSTHOOK: query: -- Table-Non-Cascade CHANGE COLUMNS ...
-alter table table_change_lower_to_higher_numeric_group_float replace columns (insert_num int, c1 decimal(38,18), b STRING)
+alter table table_change_lower_to_higher_numeric_group_double replace columns (insert_num int, c1 decimal(38,18), b STRING)
POSTHOOK: type: ALTERTABLE_REPLACECOLS
-POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
-POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
-PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float
+POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_double
+POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_double
+PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_double
values (5, '774', 'new'),
(6, '561431', 'new'),
(7, '256', 'new'),
@@ -4140,8 +4140,8 @@ PREHOOK: query: insert into table table_change_lower_to_higher_numeric_group_flo
(10, '17', 'new')
PREHOOK: type: QUERY
PREHOOK: Input: default@values__tmp__table__52
-PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
-POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_float
+PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_double
+POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_double
values (5, '774', 'new'),
(6, '561431', 'new'),
(7, '256', 'new'),
@@ -4150,16 +4150,16 @@ POSTHOOK: query: insert into table table_change_lower_to_higher_numeric_group_fl
(10, '17', 'new')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@values__tmp__table__52
-POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.b SIMPLE [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.c1 EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
-POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_float.insert_num EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_double
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.b SIMPLE [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.c1 EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: table_change_lower_to_higher_numeric_group_double.insert_num EXPRESSION [(values__tmp__table__52)values__tmp__table__52.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
_col0 _col1 _col2
PREHOOK: query: explain
-select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num
+select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num
PREHOOK: type: QUERY
POSTHOOK: query: explain
-select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num
+select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num
POSTHOOK: type: QUERY
Explain
STAGE DEPENDENCIES:
@@ -4171,7 +4171,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: table_change_lower_to_higher_numeric_group_float
+ alias: table_change_lower_to_higher_numeric_group_double
Statistics: Num rows: 4 Data size: 78 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: insert_num (type: int), c1 (type: decimal(38,18)), b (type: string)
@@ -4202,13 +4202,13 @@ STAGE PLANS:
Processor Tree:
ListSink
-PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num
+PREHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num
PREHOOK: type: QUERY
-PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
+PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_double
#### A masked pattern was here ####
-POSTHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_float order by insert_num
+POSTHOOK: query: select insert_num,c1,b from table_change_lower_to_higher_numeric_group_double order by insert_num
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
+POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_double
#### A masked pattern was here ####
insert_num c1 b
1 -29.076400000000000000 original
@@ -4221,11 +4221,11 @@ insert_num c1 b
7 256.000000000000000000 new
8 5555.000000000000000000 new
9 100.000000000000000000 new
-PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_float
+PREHOOK: query: drop table table_change_lower_to_higher_numeric_group_double
PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
-PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
-POSTHOOK: query: drop table table_change_lower_to_higher_numeric_group_float
+PREHOOK: Input: default@table_change_lower_to_higher_numeric_group_double
+PREHOOK: Output: default@table_change_lower_to_higher_numeric_group_double
+POSTHOOK: query: drop table table_change_lower_to_higher_numeric_group_double
POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_float
-POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_float
+POSTHOOK: Input: default@table_change_lower_to_higher_numeric_group_double
+POSTHOOK: Output: default@table_change_lower_to_higher_numeric_group_double