You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by vi...@apache.org on 2018/05/16 21:46:37 UTC
[2/4] hive git commit: HIVE-19317 : Handle schema evolution from int
like types to decimal (Janaki Lahorani, reviewed by Vihang Karajgaonkar)
http://git-wip-us.apache.org/repos/asf/hive/blob/cb6dee1c/ql/src/test/results/clientpositive/type_change_test_int.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/type_change_test_int.q.out b/ql/src/test/results/clientpositive/type_change_test_int.q.out
index 2237a0e..cd4bcfd 100644
--- a/ql/src/test/results/clientpositive/type_change_test_int.q.out
+++ b/ql/src/test/results/clientpositive/type_change_test_int.q.out
@@ -275,6 +275,216 @@ POSTHOOK: Input: default@testaltcolt
2 1 2 3 4
3 NULL NULL NULL 123
4 NULL NULL NULL -123
+PREHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt
+PREHOOK: Output: default@testaltcolt
+POSTHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt
+POSTHOOK: Output: default@testaltcolt
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+1 1.23456794E18 1.23456794E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456794E18 1.23456794E9 12345.0 123.0
+4 -1.23456794E18 -1.23456794E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt
+PREHOOK: Output: default@testaltcolt
+POSTHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt
+POSTHOOK: Output: default@testaltcolt
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+1 1.23456789012345677E18 1.23456789E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456789012345677E18 1.23456789E9 12345.0 123.0
+4 -1.23456789012345677E18 -1.23456789E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt
+PREHOOK: Output: default@testaltcolt
+POSTHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt
+POSTHOOK: Output: default@testaltcolt
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+1 1234567890123456789.00 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 1234567890123456789.00 1234567890.00 12345.00 123.00
+4 -1234567890123456789.00 -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt
+PREHOOK: Output: default@testaltcolt
+POSTHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt
+POSTHOOK: Output: default@testaltcolt
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+1 NULL 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL 1234567890.00 12345.00 123.00
+4 NULL -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt
+PREHOOK: Output: default@testaltcolt
+POSTHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt
+POSTHOOK: Output: default@testaltcolt
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+1 NULL NULL 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL 12345.00 123.00
+4 NULL NULL -12345.00 -123.00
+PREHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt
+PREHOOK: Output: default@testaltcolt
+POSTHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt
+POSTHOOK: Output: default@testaltcolt
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+1 NULL NULL NULL 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL 123.00
+4 NULL NULL NULL -123.00
+PREHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt
+PREHOOK: Output: default@testaltcolt
+POSTHOOK: query: alter table testAltColT replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt
+POSTHOOK: Output: default@testaltcolt
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColT order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt
+#### A masked pattern was here ####
+1 NULL NULL NULL NULL
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL NULL
+4 NULL NULL NULL NULL
PREHOOK: query: drop table if exists testAltColT
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@testaltcolt
@@ -434,6 +644,216 @@ POSTHOOK: Input: default@testaltcolsf
2 1 2 3 4
3 NULL NULL NULL 123
4 NULL NULL NULL -123
+PREHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolsf
+PREHOOK: Output: default@testaltcolsf
+POSTHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolsf
+POSTHOOK: Output: default@testaltcolsf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+1 1.23456794E18 1.23456794E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456794E18 1.23456794E9 12345.0 123.0
+4 -1.23456794E18 -1.23456794E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolsf
+PREHOOK: Output: default@testaltcolsf
+POSTHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolsf
+POSTHOOK: Output: default@testaltcolsf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+1 1.23456789012345677E18 1.23456789E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456789012345677E18 1.23456789E9 12345.0 123.0
+4 -1.23456789012345677E18 -1.23456789E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolsf
+PREHOOK: Output: default@testaltcolsf
+POSTHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolsf
+POSTHOOK: Output: default@testaltcolsf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+1 1234567890123456789.00 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 1234567890123456789.00 1234567890.00 12345.00 123.00
+4 -1234567890123456789.00 -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolsf
+PREHOOK: Output: default@testaltcolsf
+POSTHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolsf
+POSTHOOK: Output: default@testaltcolsf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+1 NULL 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL 1234567890.00 12345.00 123.00
+4 NULL -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolsf
+PREHOOK: Output: default@testaltcolsf
+POSTHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolsf
+POSTHOOK: Output: default@testaltcolsf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+1 NULL NULL 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL 12345.00 123.00
+4 NULL NULL -12345.00 -123.00
+PREHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolsf
+PREHOOK: Output: default@testaltcolsf
+POSTHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolsf
+POSTHOOK: Output: default@testaltcolsf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+1 NULL NULL NULL 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL 123.00
+4 NULL NULL NULL -123.00
+PREHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolsf
+PREHOOK: Output: default@testaltcolsf
+POSTHOOK: query: alter table testAltColSF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolsf
+POSTHOOK: Output: default@testaltcolsf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColSF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolsf
+#### A masked pattern was here ####
+1 NULL NULL NULL NULL
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL NULL
+4 NULL NULL NULL NULL
PREHOOK: query: drop table if exists testAltColSF
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@testaltcolsf
@@ -593,6 +1013,216 @@ POSTHOOK: Input: default@testaltcolrcf
2 1 2 3 4
3 NULL NULL NULL 123
4 NULL NULL NULL -123
+PREHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolrcf
+PREHOOK: Output: default@testaltcolrcf
+POSTHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolrcf
+POSTHOOK: Output: default@testaltcolrcf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+1 1.23456794E18 1.23456794E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456794E18 1.23456794E9 12345.0 123.0
+4 -1.23456794E18 -1.23456794E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolrcf
+PREHOOK: Output: default@testaltcolrcf
+POSTHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolrcf
+POSTHOOK: Output: default@testaltcolrcf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+1 1.23456789012345677E18 1.23456789E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456789012345677E18 1.23456789E9 12345.0 123.0
+4 -1.23456789012345677E18 -1.23456789E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolrcf
+PREHOOK: Output: default@testaltcolrcf
+POSTHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolrcf
+POSTHOOK: Output: default@testaltcolrcf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+1 1234567890123456789.00 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 1234567890123456789.00 1234567890.00 12345.00 123.00
+4 -1234567890123456789.00 -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolrcf
+PREHOOK: Output: default@testaltcolrcf
+POSTHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolrcf
+POSTHOOK: Output: default@testaltcolrcf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+1 NULL 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL 1234567890.00 12345.00 123.00
+4 NULL -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolrcf
+PREHOOK: Output: default@testaltcolrcf
+POSTHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolrcf
+POSTHOOK: Output: default@testaltcolrcf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+1 NULL NULL 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL 12345.00 123.00
+4 NULL NULL -12345.00 -123.00
+PREHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolrcf
+PREHOOK: Output: default@testaltcolrcf
+POSTHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolrcf
+POSTHOOK: Output: default@testaltcolrcf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+1 NULL NULL NULL 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL 123.00
+4 NULL NULL NULL -123.00
+PREHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolrcf
+PREHOOK: Output: default@testaltcolrcf
+POSTHOOK: query: alter table testAltColRCF replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolrcf
+POSTHOOK: Output: default@testaltcolrcf
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColRCF order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolrcf
+#### A masked pattern was here ####
+1 NULL NULL NULL NULL
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL NULL
+4 NULL NULL NULL NULL
PREHOOK: query: drop table if exists testAltColRCF
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@testaltcolrcf
@@ -748,10 +1378,220 @@ POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColO
POSTHOOK: type: QUERY
POSTHOOK: Input: default@testaltcolorc
#### A masked pattern was here ####
-1 NULL NULL NULL 123
-2 1 2 3 4
-3 NULL NULL NULL 123
-4 NULL NULL NULL -123
+1 NULL NULL NULL 123
+2 1 2 3 4
+3 NULL NULL NULL 123
+4 NULL NULL NULL -123
+PREHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolorc
+PREHOOK: Output: default@testaltcolorc
+POSTHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolorc
+POSTHOOK: Output: default@testaltcolorc
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+1 1.23456794E18 1.23456794E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456794E18 1.23456794E9 12345.0 123.0
+4 -1.23456794E18 -1.23456794E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolorc
+PREHOOK: Output: default@testaltcolorc
+POSTHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolorc
+POSTHOOK: Output: default@testaltcolorc
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+1 1.23456789012345677E18 1.23456789E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456789012345677E18 1.23456789E9 12345.0 123.0
+4 -1.23456789012345677E18 -1.23456789E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolorc
+PREHOOK: Output: default@testaltcolorc
+POSTHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolorc
+POSTHOOK: Output: default@testaltcolorc
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+1 1234567890123456789.00 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 1234567890123456789.00 1234567890.00 12345.00 123.00
+4 -1234567890123456789.00 -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolorc
+PREHOOK: Output: default@testaltcolorc
+POSTHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolorc
+POSTHOOK: Output: default@testaltcolorc
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+1 NULL 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL 1234567890.00 12345.00 123.00
+4 NULL -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolorc
+PREHOOK: Output: default@testaltcolorc
+POSTHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolorc
+POSTHOOK: Output: default@testaltcolorc
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+1 NULL NULL 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL 12345.00 123.00
+4 NULL NULL -12345.00 -123.00
+PREHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolorc
+PREHOOK: Output: default@testaltcolorc
+POSTHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolorc
+POSTHOOK: Output: default@testaltcolorc
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+1 NULL NULL NULL 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL 123.00
+4 NULL NULL NULL -123.00
+PREHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolorc
+PREHOOK: Output: default@testaltcolorc
+POSTHOOK: query: alter table testAltColORC replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolorc
+POSTHOOK: Output: default@testaltcolorc
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColORC order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolorc
+#### A masked pattern was here ####
+1 NULL NULL NULL NULL
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL NULL
+4 NULL NULL NULL NULL
PREHOOK: query: drop table if exists testAltColORC
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@testaltcolorc
@@ -911,6 +1751,216 @@ POSTHOOK: Input: default@testaltcolpde
2 1 2 3 4
3 NULL NULL NULL 123
4 NULL NULL NULL -123
+PREHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpde
+PREHOOK: Output: default@testaltcolpde
+POSTHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpde
+POSTHOOK: Output: default@testaltcolpde
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+1 1.23456794E18 1.23456794E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456794E18 1.23456794E9 12345.0 123.0
+4 -1.23456794E18 -1.23456794E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpde
+PREHOOK: Output: default@testaltcolpde
+POSTHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpde
+POSTHOOK: Output: default@testaltcolpde
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+1 1.23456789012345677E18 1.234567936E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456789012345677E18 1.234567936E9 12345.0 123.0
+4 -1.23456789012345677E18 -1.234567936E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpde
+PREHOOK: Output: default@testaltcolpde
+POSTHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpde
+POSTHOOK: Output: default@testaltcolpde
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+1 1234567890123456789.00 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 1234567890123456789.00 1234567890.00 12345.00 123.00
+4 -1234567890123456789.00 -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpde
+PREHOOK: Output: default@testaltcolpde
+POSTHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpde
+POSTHOOK: Output: default@testaltcolpde
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+1 NULL 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL 1234567890.00 12345.00 123.00
+4 NULL -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpde
+PREHOOK: Output: default@testaltcolpde
+POSTHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpde
+POSTHOOK: Output: default@testaltcolpde
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+1 NULL NULL 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL 12345.00 123.00
+4 NULL NULL -12345.00 -123.00
+PREHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpde
+PREHOOK: Output: default@testaltcolpde
+POSTHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpde
+POSTHOOK: Output: default@testaltcolpde
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+1 NULL NULL NULL 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL 123.00
+4 NULL NULL NULL -123.00
+PREHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpde
+PREHOOK: Output: default@testaltcolpde
+POSTHOOK: query: alter table testAltColPDE replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpde
+POSTHOOK: Output: default@testaltcolpde
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDE order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpde
+#### A masked pattern was here ####
+1 NULL NULL NULL NULL
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL NULL
+4 NULL NULL NULL NULL
PREHOOK: query: drop table if exists testAltColPDE
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@testaltcolpde
@@ -1072,6 +2122,216 @@ POSTHOOK: Input: default@testaltcolpdd
2 1 2 3 4
3 NULL NULL NULL 123
4 NULL NULL NULL -123
+PREHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpdd
+PREHOOK: Output: default@testaltcolpdd
+POSTHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt FLOAT,
+ cInt FLOAT,
+ cSmallInt FLOAT,
+ cTinyint FLOAT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpdd
+POSTHOOK: Output: default@testaltcolpdd
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+1 1.23456794E18 1.23456794E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456794E18 1.23456794E9 12345.0 123.0
+4 -1.23456794E18 -1.23456794E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpdd
+PREHOOK: Output: default@testaltcolpdd
+POSTHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DOUBLE,
+ cInt DOUBLE,
+ cSmallInt DOUBLE,
+ cTinyint DOUBLE)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpdd
+POSTHOOK: Output: default@testaltcolpdd
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+1 1.23456789012345677E18 1.234567936E9 12345.0 123.0
+2 1.0 2.0 3.0 4.0
+3 1.23456789012345677E18 1.234567936E9 12345.0 123.0
+4 -1.23456789012345677E18 -1.234567936E9 -12345.0 -123.0
+PREHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpdd
+PREHOOK: Output: default@testaltcolpdd
+POSTHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(22,2),
+ cInt DECIMAL(22,2),
+ cSmallInt DECIMAL(22,2),
+ cTinyint DECIMAL(22,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpdd
+POSTHOOK: Output: default@testaltcolpdd
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+1 1234567890123456789.00 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 1234567890123456789.00 1234567890.00 12345.00 123.00
+4 -1234567890123456789.00 -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpdd
+PREHOOK: Output: default@testaltcolpdd
+POSTHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(13,2),
+ cInt DECIMAL(13,2),
+ cSmallInt DECIMAL(13,2),
+ cTinyint DECIMAL(13,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpdd
+POSTHOOK: Output: default@testaltcolpdd
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+1 NULL 1234567890.00 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL 1234567890.00 12345.00 123.00
+4 NULL -1234567890.00 -12345.00 -123.00
+PREHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpdd
+PREHOOK: Output: default@testaltcolpdd
+POSTHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(8,2),
+ cInt DECIMAL(8,2),
+ cSmallInt DECIMAL(8,2),
+ cTinyint DECIMAL(8,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpdd
+POSTHOOK: Output: default@testaltcolpdd
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+1 NULL NULL 12345.00 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL 12345.00 123.00
+4 NULL NULL -12345.00 -123.00
+PREHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpdd
+PREHOOK: Output: default@testaltcolpdd
+POSTHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(6,2),
+ cInt DECIMAL(6,2),
+ cSmallInt DECIMAL(6,2),
+ cTinyint DECIMAL(6,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpdd
+POSTHOOK: Output: default@testaltcolpdd
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+1 NULL NULL NULL 123.00
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL 123.00
+4 NULL NULL NULL -123.00
+PREHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolpdd
+PREHOOK: Output: default@testaltcolpdd
+POSTHOOK: query: alter table testAltColPDD replace columns
+(cId TINYINT,
+ cBigInt DECIMAL(3,2),
+ cInt DECIMAL(3,2),
+ cSmallInt DECIMAL(3,2),
+ cTinyint DECIMAL(3,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolpdd
+POSTHOOK: Output: default@testaltcolpdd
+PREHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cBigInt, cInt, cSmallInt, cTinyint from testAltColPDD order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolpdd
+#### A masked pattern was here ####
+1 NULL NULL NULL NULL
+2 1.00 2.00 3.00 4.00
+3 NULL NULL NULL NULL
+4 NULL NULL NULL NULL
PREHOOK: query: drop table if exists testAltColPDD
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@testaltcolpdd