You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by as...@apache.org on 2018/09/07 17:01:45 UTC
[2/5] hive git commit: HIVE-20437: Handle schema evolution from Float,
Double and Decimal. (Janaki Lahorani, reviewed by Andrew Sherman)
http://git-wip-us.apache.org/repos/asf/hive/blob/530e0406/ql/src/test/results/clientpositive/type_change_test_fraction.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/type_change_test_fraction.q.out b/ql/src/test/results/clientpositive/type_change_test_fraction.q.out
new file mode 100644
index 0000000..07cf8fa
--- /dev/null
+++ b/ql/src/test/results/clientpositive/type_change_test_fraction.q.out
@@ -0,0 +1,10462 @@
+PREHOOK: query: drop table if exists testAltCol_n2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists testAltCol_n2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table testAltCol_n2
+(cId TINYINT,
+ cFloat FLOAT,
+ cDouble DOUBLE,
+ cDecimal38_18 DECIMAL(38,18),
+ cDecimal38_37 DECIMAL(38,37),
+ cDecimal16_8 DECIMAL(16,8),
+ cDecimal3_2 DECIMAL(3,2),
+ cNumeric38_18 NUMERIC(38,18),
+ cNumeric38_37 NUMERIC(38,37),
+ cNumeric16_8 NUMERIC(16,8),
+ cNumeric3_2 NUMERIC(3,2))
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testAltCol_n2
+POSTHOOK: query: create table testAltCol_n2
+(cId TINYINT,
+ cFloat FLOAT,
+ cDouble DOUBLE,
+ cDecimal38_18 DECIMAL(38,18),
+ cDecimal38_37 DECIMAL(38,37),
+ cDecimal16_8 DECIMAL(16,8),
+ cDecimal3_2 DECIMAL(3,2),
+ cNumeric38_18 NUMERIC(38,18),
+ cNumeric38_37 NUMERIC(38,37),
+ cNumeric16_8 NUMERIC(16,8),
+ cNumeric3_2 NUMERIC(3,2))
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testAltCol_n2
+PREHOOK: query: insert into testAltCol_n2 values
+(1,
+ 1.234e5,
+ 2.345e67,
+ 12345678901234567890.123456789012345678,
+ 1.2345678901234567890123456789012345678,
+ 12345678.90123456,
+ 1.23,
+ 12345678901234567890.123456789012345678,
+ 1.2345678901234567890123456789012345678,
+ 12345678.90123456,
+ 1.23),
+(2,
+ 1.4e-45,
+ 4.94e-324,
+ 00000000000000000000.000000000000000001,
+ 0.0000000000000000000000000000000000001,
+ 00000000.00000001,
+ 0.01,
+ 00000000000000000000.000000000000000001,
+ 0.0000000000000000000000000000000000001,
+ 00000000.00000001,
+ 0.01),
+(3,
+ -1.4e-45,
+ -4.94e-324,
+ -00000000000000000000.000000000000000001,
+ -0.0000000000000000000000000000000000001,
+ -00000000.00000001,
+ -0.01,
+ -00000000000000000000.000000000000000001,
+ -0.0000000000000000000000000000000000001,
+ -00000000.00000001,
+ -0.01),
+(4,
+ 3.4e+38,
+ 1.79e+308,
+ 99999999999999999999.999999999999999999,
+ 9.9999999999999999999999999999999999999,
+ 99999999.99999999,
+ 9.99,
+ 99999999999999999999.999999999999999999,
+ 9.9999999999999999999999999999999999999,
+ 99999999.99999999,
+ 9.99),
+(5,
+ -3.4e+38,
+ -1.79e+308,
+ -99999999999999999999.999999999999999999,
+ -9.9999999999999999999999999999999999999,
+ -99999999.99999999,
+ -9.99,
+ -99999999999999999999.999999999999999999,
+ -9.9999999999999999999999999999999999999,
+ -99999999.99999999,
+ -9.99),
+(6,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1),
+(7,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1),
+(8,
+ 1234567890123456789,
+ 1234567890123456789,
+ 1234567890123456789,
+ 1,
+ 12345678,
+ 1,
+ 1234567890123456789,
+ 1,
+ 12345678,
+ 1),
+(9,
+ -1234567890123456789,
+ -1234567890123456789,
+ -1234567890123456789,
+ -1,
+ -12345678,
+ -1,
+ -1234567890123456789,
+ -1,
+ -12345678,
+ -1),
+(10,
+ 1234567890,
+ 1234567890,
+ 1234567890,
+ 1,
+ 12345678,
+ 1,
+ 1234567890,
+ 1,
+ 12345678,
+ 1),
+(11,
+ -1234567890,
+ -1234567890,
+ -1234567890,
+ -1,
+ -12345678,
+ -1,
+ -1234567890,
+ -1,
+ -12345678,
+ -1),
+(12,
+ 12345,
+ 12345,
+ 12345,
+ 1,
+ 12345,
+ 1,
+ 12345,
+ 1,
+ 12345,
+ 1),
+(13,
+ -12345,
+ -12345,
+ -12345,
+ -1,
+ -12345,
+ -1,
+ -12345,
+ -1,
+ -12345,
+ -1),
+(14,
+ 123,
+ 123,
+ 123,
+ 1,
+ 123,
+ 1,
+ 123,
+ 1,
+ 123,
+ 1),
+(15,
+ -123,
+ -123,
+ -123,
+ -1,
+ -123,
+ -1,
+ -123,
+ -1,
+ -123,
+ -1),
+(16,
+ 123456789e-8,
+ 234567890e-8,
+ 12345678.90123456,
+ 1.23456789,
+ 34567890.12345678,
+ 1.23,
+ 12345678.90123456,
+ 1.23456789,
+ 34567890.12345678,
+ 1.23),
+(17,
+ -123456789e-8,
+ -234567890e-8,
+ -12345678.90123456,
+ -1.23456789,
+ -34567890.12345678,
+ -1.23,
+ -12345678.90123456,
+ -1.23456789,
+ -34567890.12345678,
+ -1.23),
+(18,
+ 123456789e-2,
+ 234567890e-2,
+ 12345678.90,
+ 1.23,
+ 34567890.12,
+ 2.34,
+ 12345678.90,
+ 1.23,
+ 34567890.12,
+ 2.34),
+(19,
+ -123456789e-2,
+ -234567890e-2,
+ -12345678.90,
+ -1.23,
+ -34567890.12,
+ -2.34,
+ -12345678.90,
+ -1.23,
+ -34567890.12,
+ -2.34)
+PREHOOK: type: QUERY
+PREHOOK: Input: _dummy_database@_dummy_table
+PREHOOK: Output: default@testaltcol_n2
+POSTHOOK: query: insert into testAltCol_n2 values
+(1,
+ 1.234e5,
+ 2.345e67,
+ 12345678901234567890.123456789012345678,
+ 1.2345678901234567890123456789012345678,
+ 12345678.90123456,
+ 1.23,
+ 12345678901234567890.123456789012345678,
+ 1.2345678901234567890123456789012345678,
+ 12345678.90123456,
+ 1.23),
+(2,
+ 1.4e-45,
+ 4.94e-324,
+ 00000000000000000000.000000000000000001,
+ 0.0000000000000000000000000000000000001,
+ 00000000.00000001,
+ 0.01,
+ 00000000000000000000.000000000000000001,
+ 0.0000000000000000000000000000000000001,
+ 00000000.00000001,
+ 0.01),
+(3,
+ -1.4e-45,
+ -4.94e-324,
+ -00000000000000000000.000000000000000001,
+ -0.0000000000000000000000000000000000001,
+ -00000000.00000001,
+ -0.01,
+ -00000000000000000000.000000000000000001,
+ -0.0000000000000000000000000000000000001,
+ -00000000.00000001,
+ -0.01),
+(4,
+ 3.4e+38,
+ 1.79e+308,
+ 99999999999999999999.999999999999999999,
+ 9.9999999999999999999999999999999999999,
+ 99999999.99999999,
+ 9.99,
+ 99999999999999999999.999999999999999999,
+ 9.9999999999999999999999999999999999999,
+ 99999999.99999999,
+ 9.99),
+(5,
+ -3.4e+38,
+ -1.79e+308,
+ -99999999999999999999.999999999999999999,
+ -9.9999999999999999999999999999999999999,
+ -99999999.99999999,
+ -9.99,
+ -99999999999999999999.999999999999999999,
+ -9.9999999999999999999999999999999999999,
+ -99999999.99999999,
+ -9.99),
+(6,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1,
+ 1),
+(7,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1,
+ -1),
+(8,
+ 1234567890123456789,
+ 1234567890123456789,
+ 1234567890123456789,
+ 1,
+ 12345678,
+ 1,
+ 1234567890123456789,
+ 1,
+ 12345678,
+ 1),
+(9,
+ -1234567890123456789,
+ -1234567890123456789,
+ -1234567890123456789,
+ -1,
+ -12345678,
+ -1,
+ -1234567890123456789,
+ -1,
+ -12345678,
+ -1),
+(10,
+ 1234567890,
+ 1234567890,
+ 1234567890,
+ 1,
+ 12345678,
+ 1,
+ 1234567890,
+ 1,
+ 12345678,
+ 1),
+(11,
+ -1234567890,
+ -1234567890,
+ -1234567890,
+ -1,
+ -12345678,
+ -1,
+ -1234567890,
+ -1,
+ -12345678,
+ -1),
+(12,
+ 12345,
+ 12345,
+ 12345,
+ 1,
+ 12345,
+ 1,
+ 12345,
+ 1,
+ 12345,
+ 1),
+(13,
+ -12345,
+ -12345,
+ -12345,
+ -1,
+ -12345,
+ -1,
+ -12345,
+ -1,
+ -12345,
+ -1),
+(14,
+ 123,
+ 123,
+ 123,
+ 1,
+ 123,
+ 1,
+ 123,
+ 1,
+ 123,
+ 1),
+(15,
+ -123,
+ -123,
+ -123,
+ -1,
+ -123,
+ -1,
+ -123,
+ -1,
+ -123,
+ -1),
+(16,
+ 123456789e-8,
+ 234567890e-8,
+ 12345678.90123456,
+ 1.23456789,
+ 34567890.12345678,
+ 1.23,
+ 12345678.90123456,
+ 1.23456789,
+ 34567890.12345678,
+ 1.23),
+(17,
+ -123456789e-8,
+ -234567890e-8,
+ -12345678.90123456,
+ -1.23456789,
+ -34567890.12345678,
+ -1.23,
+ -12345678.90123456,
+ -1.23456789,
+ -34567890.12345678,
+ -1.23),
+(18,
+ 123456789e-2,
+ 234567890e-2,
+ 12345678.90,
+ 1.23,
+ 34567890.12,
+ 2.34,
+ 12345678.90,
+ 1.23,
+ 34567890.12,
+ 2.34),
+(19,
+ -123456789e-2,
+ -234567890e-2,
+ -12345678.90,
+ -1.23,
+ -34567890.12,
+ -2.34,
+ -12345678.90,
+ -1.23,
+ -34567890.12,
+ -2.34)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: _dummy_database@_dummy_table
+POSTHOOK: Output: default@testaltcol_n2
+POSTHOOK: Lineage: testaltcol_n2.cdecimal16_8 SCRIPT []
+POSTHOOK: Lineage: testaltcol_n2.cdecimal38_18 SCRIPT []
+POSTHOOK: Lineage: testaltcol_n2.cdecimal38_37 SCRIPT []
+POSTHOOK: Lineage: testaltcol_n2.cdecimal3_2 SCRIPT []
+POSTHOOK: Lineage: testaltcol_n2.cdouble SCRIPT []
+POSTHOOK: Lineage: testaltcol_n2.cfloat SCRIPT []
+POSTHOOK: Lineage: testaltcol_n2.cid SCRIPT []
+POSTHOOK: Lineage: testaltcol_n2.cnumeric16_8 SCRIPT []
+POSTHOOK: Lineage: testaltcol_n2.cnumeric38_18 SCRIPT []
+POSTHOOK: Lineage: testaltcol_n2.cnumeric38_37 SCRIPT []
+POSTHOOK: Lineage: testaltcol_n2.cnumeric3_2 SCRIPT []
+PREHOOK: query: select cId, cFloat, cDouble from testAltCol_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcol_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltCol_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcol_n2
+#### A masked pattern was here ####
+1 123400.0 2.345E67
+2 1.4E-45 4.9E-324
+3 -1.4E-45 -4.9E-324
+4 3.4E38 1.79E308
+5 -3.4E38 -1.79E308
+6 1.0 1.0
+7 -1.0 -1.0
+8 1.23456794E18 1.23456789012345677E18
+9 -1.23456794E18 -1.23456789012345677E18
+10 1.23456794E9 1.23456789E9
+11 -1.23456794E9 -1.23456789E9
+12 12345.0 12345.0
+13 -12345.0 -12345.0
+14 123.0 123.0
+15 -123.0 -123.0
+16 1.2345679 2.3456789
+17 -1.2345679 -2.3456789
+18 1234567.9 2345678.9
+19 -1234567.9 -2345678.9
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltCol_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcol_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltCol_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcol_n2
+#### A masked pattern was here ####
+1 12345678901234567890.123456789012345678 1.2345678901234567890123456789000000000 12345678.90123456 1.23
+2 0.000000000000000001 0.0000000000000000000000000000000000000 0.00000001 0.01
+3 -0.000000000000000001 0.0000000000000000000000000000000000000 -0.00000001 -0.01
+4 99999999999999999999.999999999999999999 NULL 99999999.99999999 9.99
+5 -99999999999999999999.999999999999999999 NULL -99999999.99999999 -9.99
+6 1.000000000000000000 1.0000000000000000000000000000000000000 1.00000000 1.00
+7 -1.000000000000000000 -1.0000000000000000000000000000000000000 -1.00000000 -1.00
+8 1234567890123456789.000000000000000000 1.0000000000000000000000000000000000000 12345678.00000000 1.00
+9 -1234567890123456789.000000000000000000 -1.0000000000000000000000000000000000000 -12345678.00000000 -1.00
+10 1234567890.000000000000000000 1.0000000000000000000000000000000000000 12345678.00000000 1.00
+11 -1234567890.000000000000000000 -1.0000000000000000000000000000000000000 -12345678.00000000 -1.00
+12 12345.000000000000000000 1.0000000000000000000000000000000000000 12345.00000000 1.00
+13 -12345.000000000000000000 -1.0000000000000000000000000000000000000 -12345.00000000 -1.00
+14 123.000000000000000000 1.0000000000000000000000000000000000000 123.00000000 1.00
+15 -123.000000000000000000 -1.0000000000000000000000000000000000000 -123.00000000 -1.00
+16 12345678.901234560000000000 1.2345678900000000000000000000000000000 34567890.12345678 1.23
+17 -12345678.901234560000000000 -1.2345678900000000000000000000000000000 -34567890.12345678 -1.23
+18 12345678.900000000000000000 1.2300000000000000000000000000000000000 34567890.12000000 2.34
+19 -12345678.900000000000000000 -1.2300000000000000000000000000000000000 -34567890.12000000 -2.34
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltCol_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcol_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltCol_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcol_n2
+#### A masked pattern was here ####
+1 12345678901234567890.123456789012345678 1.2345678901234567890123456789000000000 12345678.90123456 1.23
+2 0.000000000000000001 0.0000000000000000000000000000000000000 0.00000001 0.01
+3 -0.000000000000000001 0.0000000000000000000000000000000000000 -0.00000001 -0.01
+4 99999999999999999999.999999999999999999 NULL 99999999.99999999 9.99
+5 -99999999999999999999.999999999999999999 NULL -99999999.99999999 -9.99
+6 1.000000000000000000 1.0000000000000000000000000000000000000 1.00000000 1.00
+7 -1.000000000000000000 -1.0000000000000000000000000000000000000 -1.00000000 -1.00
+8 1234567890123456789.000000000000000000 1.0000000000000000000000000000000000000 12345678.00000000 1.00
+9 -1234567890123456789.000000000000000000 -1.0000000000000000000000000000000000000 -12345678.00000000 -1.00
+10 1234567890.000000000000000000 1.0000000000000000000000000000000000000 12345678.00000000 1.00
+11 -1234567890.000000000000000000 -1.0000000000000000000000000000000000000 -12345678.00000000 -1.00
+12 12345.000000000000000000 1.0000000000000000000000000000000000000 12345.00000000 1.00
+13 -12345.000000000000000000 -1.0000000000000000000000000000000000000 -12345.00000000 -1.00
+14 123.000000000000000000 1.0000000000000000000000000000000000000 123.00000000 1.00
+15 -123.000000000000000000 -1.0000000000000000000000000000000000000 -123.00000000 -1.00
+16 12345678.901234560000000000 1.2345678900000000000000000000000000000 34567890.12345678 1.23
+17 -12345678.901234560000000000 -1.2345678900000000000000000000000000000 -34567890.12345678 -1.23
+18 12345678.900000000000000000 1.2300000000000000000000000000000000000 34567890.12000000 2.34
+19 -12345678.900000000000000000 -1.2300000000000000000000000000000000000 -34567890.12000000 -2.34
+PREHOOK: query: drop table if exists testAltColT_n2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists testAltColT_n2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table testAltColT_n2 stored as textfile as select * from testAltCol_n2
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@testaltcol_n2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testAltColT_n2
+POSTHOOK: query: create table testAltColT_n2 stored as textfile as select * from testAltCol_n2
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@testaltcol_n2
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testAltColT_n2
+POSTHOOK: Lineage: testaltcolt_n2.cdecimal16_8 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cdecimal16_8, type:decimal(16,8), comment:null), ]
+POSTHOOK: Lineage: testaltcolt_n2.cdecimal38_18 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cdecimal38_18, type:decimal(38,18), comment:null), ]
+POSTHOOK: Lineage: testaltcolt_n2.cdecimal38_37 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cdecimal38_37, type:decimal(38,37), comment:null), ]
+POSTHOOK: Lineage: testaltcolt_n2.cdecimal3_2 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cdecimal3_2, type:decimal(3,2), comment:null), ]
+POSTHOOK: Lineage: testaltcolt_n2.cdouble SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cdouble, type:double, comment:null), ]
+POSTHOOK: Lineage: testaltcolt_n2.cfloat SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cfloat, type:float, comment:null), ]
+POSTHOOK: Lineage: testaltcolt_n2.cid SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cid, type:tinyint, comment:null), ]
+POSTHOOK: Lineage: testaltcolt_n2.cnumeric16_8 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cnumeric16_8, type:decimal(16,8), comment:null), ]
+POSTHOOK: Lineage: testaltcolt_n2.cnumeric38_18 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cnumeric38_18, type:decimal(38,18), comment:null), ]
+POSTHOOK: Lineage: testaltcolt_n2.cnumeric38_37 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cnumeric38_37, type:decimal(38,37), comment:null), ]
+POSTHOOK: Lineage: testaltcolt_n2.cnumeric3_2 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cnumeric3_2, type:decimal(3,2), comment:null), ]
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 123400.0 2.345E67
+2 1.4E-45 4.9E-324
+3 -1.4E-45 -4.9E-324
+4 3.4E38 1.79E308
+5 -3.4E38 -1.79E308
+6 1.0 1.0
+7 -1.0 -1.0
+8 1.23456794E18 1.23456789012345677E18
+9 -1.23456794E18 -1.23456789012345677E18
+10 1.23456794E9 1.23456789E9
+11 -1.23456794E9 -1.23456789E9
+12 12345.0 12345.0
+13 -12345.0 -12345.0
+14 123.0 123.0
+15 -123.0 -123.0
+16 1.2345679 2.3456789
+17 -1.2345679 -2.3456789
+18 1234567.9 2345678.9
+19 -1234567.9 -2345678.9
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 12345678901234567890.123456789012345678 1.2345678901234567890123456789000000000 12345678.90123456 1.23
+2 0.000000000000000001 0.0000000000000000000000000000000000000 0.00000001 0.01
+3 -0.000000000000000001 0.0000000000000000000000000000000000000 -0.00000001 -0.01
+4 99999999999999999999.999999999999999999 NULL 99999999.99999999 9.99
+5 -99999999999999999999.999999999999999999 NULL -99999999.99999999 -9.99
+6 1.000000000000000000 1.0000000000000000000000000000000000000 1.00000000 1.00
+7 -1.000000000000000000 -1.0000000000000000000000000000000000000 -1.00000000 -1.00
+8 1234567890123456789.000000000000000000 1.0000000000000000000000000000000000000 12345678.00000000 1.00
+9 -1234567890123456789.000000000000000000 -1.0000000000000000000000000000000000000 -12345678.00000000 -1.00
+10 1234567890.000000000000000000 1.0000000000000000000000000000000000000 12345678.00000000 1.00
+11 -1234567890.000000000000000000 -1.0000000000000000000000000000000000000 -12345678.00000000 -1.00
+12 12345.000000000000000000 1.0000000000000000000000000000000000000 12345.00000000 1.00
+13 -12345.000000000000000000 -1.0000000000000000000000000000000000000 -12345.00000000 -1.00
+14 123.000000000000000000 1.0000000000000000000000000000000000000 123.00000000 1.00
+15 -123.000000000000000000 -1.0000000000000000000000000000000000000 -123.00000000 -1.00
+16 12345678.901234560000000000 1.2345678900000000000000000000000000000 34567890.12345678 1.23
+17 -12345678.901234560000000000 -1.2345678900000000000000000000000000000 -34567890.12345678 -1.23
+18 12345678.900000000000000000 1.2300000000000000000000000000000000000 34567890.12000000 2.34
+19 -12345678.900000000000000000 -1.2300000000000000000000000000000000000 -34567890.12000000 -2.34
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 12345678901234567890.123456789012345678 1.2345678901234567890123456789000000000 12345678.90123456 1.23
+2 0.000000000000000001 0.0000000000000000000000000000000000000 0.00000001 0.01
+3 -0.000000000000000001 0.0000000000000000000000000000000000000 -0.00000001 -0.01
+4 99999999999999999999.999999999999999999 NULL 99999999.99999999 9.99
+5 -99999999999999999999.999999999999999999 NULL -99999999.99999999 -9.99
+6 1.000000000000000000 1.0000000000000000000000000000000000000 1.00000000 1.00
+7 -1.000000000000000000 -1.0000000000000000000000000000000000000 -1.00000000 -1.00
+8 1234567890123456789.000000000000000000 1.0000000000000000000000000000000000000 12345678.00000000 1.00
+9 -1234567890123456789.000000000000000000 -1.0000000000000000000000000000000000000 -12345678.00000000 -1.00
+10 1234567890.000000000000000000 1.0000000000000000000000000000000000000 12345678.00000000 1.00
+11 -1234567890.000000000000000000 -1.0000000000000000000000000000000000000 -12345678.00000000 -1.00
+12 12345.000000000000000000 1.0000000000000000000000000000000000000 12345.00000000 1.00
+13 -12345.000000000000000000 -1.0000000000000000000000000000000000000 -12345.00000000 -1.00
+14 123.000000000000000000 1.0000000000000000000000000000000000000 123.00000000 1.00
+15 -123.000000000000000000 -1.0000000000000000000000000000000000000 -123.00000000 -1.00
+16 12345678.901234560000000000 1.2345678900000000000000000000000000000 34567890.12345678 1.23
+17 -12345678.901234560000000000 -1.2345678900000000000000000000000000000 -34567890.12345678 -1.23
+18 12345678.900000000000000000 1.2300000000000000000000000000000000000 34567890.12000000 2.34
+19 -12345678.900000000000000000 -1.2300000000000000000000000000000000000 -34567890.12000000 -2.34
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat FLOAT,
+ cDouble FLOAT,
+ cDecimal38_18 FLOAT,
+ cDecimal38_37 FLOAT,
+ cDecimal16_8 FLOAT,
+ cDecimal3_2 FLOAT,
+ cNumeric38_18 FLOAT,
+ cNumeric38_37 FLOAT,
+ cNumeric16_8 FLOAT,
+ cNumeric3_2 FLOAT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat FLOAT,
+ cDouble FLOAT,
+ cDecimal38_18 FLOAT,
+ cDecimal38_37 FLOAT,
+ cDecimal16_8 FLOAT,
+ cDecimal3_2 FLOAT,
+ cNumeric38_18 FLOAT,
+ cNumeric38_37 FLOAT,
+ cNumeric16_8 FLOAT,
+ cNumeric3_2 FLOAT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 123400.0 Infinity
+2 1.4E-45 0.0
+3 -1.4E-45 -0.0
+4 3.4E38 Infinity
+5 -3.4E38 -Infinity
+6 1.0 1.0
+7 -1.0 -1.0
+8 1.23456794E18 1.23456794E18
+9 -1.23456794E18 -1.23456794E18
+10 1.23456794E9 1.23456794E9
+11 -1.23456794E9 -1.23456794E9
+12 12345.0 12345.0
+13 -12345.0 -12345.0
+14 123.0 123.0
+15 -123.0 -123.0
+16 1.2345679 2.3456788
+17 -1.2345679 -2.3456788
+18 1234567.9 2345679.0
+19 -1234567.9 -2345679.0
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 1.2345679E19 1.2345679 1.2345679E7 1.23
+2 1.0E-18 0.0 1.0E-8 0.01
+3 -1.0E-18 0.0 -1.0E-8 -0.01
+4 1.0E20 NULL 1.0E8 9.99
+5 -1.0E20 NULL -1.0E8 -9.99
+6 1.0 1.0 1.0 1.0
+7 -1.0 -1.0 -1.0 -1.0
+8 1.23456794E18 1.0 1.2345678E7 1.0
+9 -1.23456794E18 -1.0 -1.2345678E7 -1.0
+10 1.23456794E9 1.0 1.2345678E7 1.0
+11 -1.23456794E9 -1.0 -1.2345678E7 -1.0
+12 12345.0 1.0 12345.0 1.0
+13 -12345.0 -1.0 -12345.0 -1.0
+14 123.0 1.0 123.0 1.0
+15 -123.0 -1.0 -123.0 -1.0
+16 1.2345679E7 1.2345679 3.4567892E7 1.23
+17 -1.2345679E7 -1.2345679 -3.4567892E7 -1.23
+18 1.2345679E7 1.23 3.4567892E7 2.34
+19 -1.2345679E7 -1.23 -3.4567892E7 -2.34
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 1.2345679E19 1.2345679 1.2345679E7 1.23
+2 1.0E-18 0.0 1.0E-8 0.01
+3 -1.0E-18 0.0 -1.0E-8 -0.01
+4 1.0E20 NULL 1.0E8 9.99
+5 -1.0E20 NULL -1.0E8 -9.99
+6 1.0 1.0 1.0 1.0
+7 -1.0 -1.0 -1.0 -1.0
+8 1.23456794E18 1.0 1.2345678E7 1.0
+9 -1.23456794E18 -1.0 -1.2345678E7 -1.0
+10 1.23456794E9 1.0 1.2345678E7 1.0
+11 -1.23456794E9 -1.0 -1.2345678E7 -1.0
+12 12345.0 1.0 12345.0 1.0
+13 -12345.0 -1.0 -12345.0 -1.0
+14 123.0 1.0 123.0 1.0
+15 -123.0 -1.0 -123.0 -1.0
+16 1.2345679E7 1.2345679 3.4567892E7 1.23
+17 -1.2345679E7 -1.2345679 -3.4567892E7 -1.23
+18 1.2345679E7 1.23 3.4567892E7 2.34
+19 -1.2345679E7 -1.23 -3.4567892E7 -2.34
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat DOUBLE,
+ cDouble DOUBLE,
+ cDecimal38_18 DOUBLE,
+ cDecimal38_37 DOUBLE,
+ cDecimal16_8 DOUBLE,
+ cDecimal3_2 DOUBLE,
+ cNumeric38_18 DOUBLE,
+ cNumeric38_37 DOUBLE,
+ cNumeric16_8 DOUBLE,
+ cNumeric3_2 DOUBLE)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat DOUBLE,
+ cDouble DOUBLE,
+ cDecimal38_18 DOUBLE,
+ cDecimal38_37 DOUBLE,
+ cDecimal16_8 DOUBLE,
+ cDecimal3_2 DOUBLE,
+ cNumeric38_18 DOUBLE,
+ cNumeric38_37 DOUBLE,
+ cNumeric16_8 DOUBLE,
+ cNumeric3_2 DOUBLE)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 123400.0 2.345E67
+2 1.4E-45 4.9E-324
+3 -1.4E-45 -4.9E-324
+4 3.4E38 1.79E308
+5 -3.4E38 -1.79E308
+6 1.0 1.0
+7 -1.0 -1.0
+8 1.23456794E18 1.23456789012345677E18
+9 -1.23456794E18 -1.23456789012345677E18
+10 1.23456794E9 1.23456789E9
+11 -1.23456794E9 -1.23456789E9
+12 12345.0 12345.0
+13 -12345.0 -12345.0
+14 123.0 123.0
+15 -123.0 -123.0
+16 1.2345679 2.3456789
+17 -1.2345679 -2.3456789
+18 1234567.9 2345678.9
+19 -1234567.9 -2345678.9
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 1.2345678901234567E19 1.2345678901234567 1.234567890123456E7 1.23
+2 1.0E-18 0.0 1.0E-8 0.01
+3 -1.0E-18 0.0 -1.0E-8 -0.01
+4 1.0E20 NULL 9.999999999999999E7 9.99
+5 -1.0E20 NULL -9.999999999999999E7 -9.99
+6 1.0 1.0 1.0 1.0
+7 -1.0 -1.0 -1.0 -1.0
+8 1.23456789012345677E18 1.0 1.2345678E7 1.0
+9 -1.23456789012345677E18 -1.0 -1.2345678E7 -1.0
+10 1.23456789E9 1.0 1.2345678E7 1.0
+11 -1.23456789E9 -1.0 -1.2345678E7 -1.0
+12 12345.0 1.0 12345.0 1.0
+13 -12345.0 -1.0 -12345.0 -1.0
+14 123.0 1.0 123.0 1.0
+15 -123.0 -1.0 -123.0 -1.0
+16 1.234567890123456E7 1.23456789 3.456789012345678E7 1.23
+17 -1.234567890123456E7 -1.23456789 -3.456789012345678E7 -1.23
+18 1.23456789E7 1.23 3.456789012E7 2.34
+19 -1.23456789E7 -1.23 -3.456789012E7 -2.34
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 1.2345678901234567E19 1.2345678901234567 1.234567890123456E7 1.23
+2 1.0E-18 0.0 1.0E-8 0.01
+3 -1.0E-18 0.0 -1.0E-8 -0.01
+4 1.0E20 NULL 9.999999999999999E7 9.99
+5 -1.0E20 NULL -9.999999999999999E7 -9.99
+6 1.0 1.0 1.0 1.0
+7 -1.0 -1.0 -1.0 -1.0
+8 1.23456789012345677E18 1.0 1.2345678E7 1.0
+9 -1.23456789012345677E18 -1.0 -1.2345678E7 -1.0
+10 1.23456789E9 1.0 1.2345678E7 1.0
+11 -1.23456789E9 -1.0 -1.2345678E7 -1.0
+12 12345.0 1.0 12345.0 1.0
+13 -12345.0 -1.0 -12345.0 -1.0
+14 123.0 1.0 123.0 1.0
+15 -123.0 -1.0 -123.0 -1.0
+16 1.234567890123456E7 1.23456789 3.456789012345678E7 1.23
+17 -1.234567890123456E7 -1.23456789 -3.456789012345678E7 -1.23
+18 1.23456789E7 1.23 3.456789012E7 2.34
+19 -1.23456789E7 -1.23 -3.456789012E7 -2.34
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat DECIMAL(38,18),
+ cDouble DECIMAL(38,18),
+ cDecimal38_18 DECIMAL(38,18),
+ cDecimal38_37 DECIMAL(38,18),
+ cDecimal16_8 DECIMAL(38,18),
+ cDecimal3_2 DECIMAL(38,18),
+ cNumeric38_18 DECIMAL(38,18),
+ cNumeric38_37 DECIMAL(38,18),
+ cNumeric16_8 DECIMAL(38,18),
+ cNumeric3_2 DECIMAL(38,18))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat DECIMAL(38,18),
+ cDouble DECIMAL(38,18),
+ cDecimal38_18 DECIMAL(38,18),
+ cDecimal38_37 DECIMAL(38,18),
+ cDecimal16_8 DECIMAL(38,18),
+ cDecimal3_2 DECIMAL(38,18),
+ cNumeric38_18 DECIMAL(38,18),
+ cNumeric38_37 DECIMAL(38,18),
+ cNumeric16_8 DECIMAL(38,18),
+ cNumeric3_2 DECIMAL(38,18))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 123400.000000000000000000 NULL
+2 0.000000000000000000 NULL
+3 0.000000000000000000 NULL
+4 NULL NULL
+5 NULL NULL
+6 1.000000000000000000 1.000000000000000000
+7 -1.000000000000000000 -1.000000000000000000
+8 1234567940000000000.000000000000000000 1234567890123456770.000000000000000000
+9 -1234567940000000000.000000000000000000 -1234567890123456770.000000000000000000
+10 1234567940.000000000000000000 1234567890.000000000000000000
+11 -1234567940.000000000000000000 -1234567890.000000000000000000
+12 12345.000000000000000000 12345.000000000000000000
+13 -12345.000000000000000000 -12345.000000000000000000
+14 123.000000000000000000 123.000000000000000000
+15 -123.000000000000000000 -123.000000000000000000
+16 1.234567900000000000 2.345678900000000000
+17 -1.234567900000000000 -2.345678900000000000
+18 1234567.900000000000000000 2345678.900000000000000000
+19 -1234567.900000000000000000 -2345678.900000000000000000
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 12345678901234567890.123456789012345678 1.234567890123456789 12345678.901234560000000000 1.230000000000000000
+2 0.000000000000000001 0.000000000000000000 0.000000010000000000 0.010000000000000000
+3 -0.000000000000000001 0.000000000000000000 -0.000000010000000000 -0.010000000000000000
+4 99999999999999999999.999999999999999999 NULL 99999999.999999990000000000 9.990000000000000000
+5 -99999999999999999999.999999999999999999 NULL -99999999.999999990000000000 -9.990000000000000000
+6 1.000000000000000000 1.000000000000000000 1.000000000000000000 1.000000000000000000
+7 -1.000000000000000000 -1.000000000000000000 -1.000000000000000000 -1.000000000000000000
+8 1234567890123456789.000000000000000000 1.000000000000000000 12345678.000000000000000000 1.000000000000000000
+9 -1234567890123456789.000000000000000000 -1.000000000000000000 -12345678.000000000000000000 -1.000000000000000000
+10 1234567890.000000000000000000 1.000000000000000000 12345678.000000000000000000 1.000000000000000000
+11 -1234567890.000000000000000000 -1.000000000000000000 -12345678.000000000000000000 -1.000000000000000000
+12 12345.000000000000000000 1.000000000000000000 12345.000000000000000000 1.000000000000000000
+13 -12345.000000000000000000 -1.000000000000000000 -12345.000000000000000000 -1.000000000000000000
+14 123.000000000000000000 1.000000000000000000 123.000000000000000000 1.000000000000000000
+15 -123.000000000000000000 -1.000000000000000000 -123.000000000000000000 -1.000000000000000000
+16 12345678.901234560000000000 1.234567890000000000 34567890.123456780000000000 1.230000000000000000
+17 -12345678.901234560000000000 -1.234567890000000000 -34567890.123456780000000000 -1.230000000000000000
+18 12345678.900000000000000000 1.230000000000000000 34567890.120000000000000000 2.340000000000000000
+19 -12345678.900000000000000000 -1.230000000000000000 -34567890.120000000000000000 -2.340000000000000000
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 12345678901234567890.123456789012345678 1.234567890123456789 12345678.901234560000000000 1.230000000000000000
+2 0.000000000000000001 0.000000000000000000 0.000000010000000000 0.010000000000000000
+3 -0.000000000000000001 0.000000000000000000 -0.000000010000000000 -0.010000000000000000
+4 99999999999999999999.999999999999999999 NULL 99999999.999999990000000000 9.990000000000000000
+5 -99999999999999999999.999999999999999999 NULL -99999999.999999990000000000 -9.990000000000000000
+6 1.000000000000000000 1.000000000000000000 1.000000000000000000 1.000000000000000000
+7 -1.000000000000000000 -1.000000000000000000 -1.000000000000000000 -1.000000000000000000
+8 1234567890123456789.000000000000000000 1.000000000000000000 12345678.000000000000000000 1.000000000000000000
+9 -1234567890123456789.000000000000000000 -1.000000000000000000 -12345678.000000000000000000 -1.000000000000000000
+10 1234567890.000000000000000000 1.000000000000000000 12345678.000000000000000000 1.000000000000000000
+11 -1234567890.000000000000000000 -1.000000000000000000 -12345678.000000000000000000 -1.000000000000000000
+12 12345.000000000000000000 1.000000000000000000 12345.000000000000000000 1.000000000000000000
+13 -12345.000000000000000000 -1.000000000000000000 -12345.000000000000000000 -1.000000000000000000
+14 123.000000000000000000 1.000000000000000000 123.000000000000000000 1.000000000000000000
+15 -123.000000000000000000 -1.000000000000000000 -123.000000000000000000 -1.000000000000000000
+16 12345678.901234560000000000 1.234567890000000000 34567890.123456780000000000 1.230000000000000000
+17 -12345678.901234560000000000 -1.234567890000000000 -34567890.123456780000000000 -1.230000000000000000
+18 12345678.900000000000000000 1.230000000000000000 34567890.120000000000000000 2.340000000000000000
+19 -12345678.900000000000000000 -1.230000000000000000 -34567890.120000000000000000 -2.340000000000000000
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat DECIMAL(38,37),
+ cDouble DECIMAL(38,37),
+ cDecimal38_18 DECIMAL(38,37),
+ cDecimal38_37 DECIMAL(38,37),
+ cDecimal16_8 DECIMAL(38,37),
+ cDecimal3_2 DECIMAL(38,37),
+ cNumeric38_18 DECIMAL(38,37),
+ cNumeric38_37 DECIMAL(38,37),
+ cNumeric16_8 DECIMAL(38,37),
+ cNumeric3_2 DECIMAL(38,37))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat DECIMAL(38,37),
+ cDouble DECIMAL(38,37),
+ cDecimal38_18 DECIMAL(38,37),
+ cDecimal38_37 DECIMAL(38,37),
+ cDecimal16_8 DECIMAL(38,37),
+ cDecimal3_2 DECIMAL(38,37),
+ cNumeric38_18 DECIMAL(38,37),
+ cNumeric38_37 DECIMAL(38,37),
+ cNumeric16_8 DECIMAL(38,37),
+ cNumeric3_2 DECIMAL(38,37))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL NULL
+2 0.0000000000000000000000000000000000000 NULL
+3 0.0000000000000000000000000000000000000 NULL
+4 NULL NULL
+5 NULL NULL
+6 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000
+7 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000
+8 NULL NULL
+9 NULL NULL
+10 NULL NULL
+11 NULL NULL
+12 NULL NULL
+13 NULL NULL
+14 NULL NULL
+15 NULL NULL
+16 1.2345679000000000000000000000000000000 2.3456789000000000000000000000000000000
+17 -1.2345679000000000000000000000000000000 -2.3456789000000000000000000000000000000
+18 NULL NULL
+19 NULL NULL
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.2345678901234567890123456789000000000 NULL 1.2300000000000000000000000000000000000
+2 0.0000000000000000010000000000000000000 0.0000000000000000000000000000000000000 0.0000000100000000000000000000000000000 0.0100000000000000000000000000000000000
+3 -0.0000000000000000010000000000000000000 0.0000000000000000000000000000000000000 -0.0000000100000000000000000000000000000 -0.0100000000000000000000000000000000000
+4 NULL NULL NULL 9.9900000000000000000000000000000000000
+5 NULL NULL NULL -9.9900000000000000000000000000000000000
+6 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000
+7 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000
+8 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+9 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+10 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+11 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+12 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+13 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+14 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+15 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+16 NULL 1.2345678900000000000000000000000000000 NULL 1.2300000000000000000000000000000000000
+17 NULL -1.2345678900000000000000000000000000000 NULL -1.2300000000000000000000000000000000000
+18 NULL 1.2300000000000000000000000000000000000 NULL 2.3400000000000000000000000000000000000
+19 NULL -1.2300000000000000000000000000000000000 NULL -2.3400000000000000000000000000000000000
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.2345678901234567890123456789000000000 NULL 1.2300000000000000000000000000000000000
+2 0.0000000000000000010000000000000000000 0.0000000000000000000000000000000000000 0.0000000100000000000000000000000000000 0.0100000000000000000000000000000000000
+3 -0.0000000000000000010000000000000000000 0.0000000000000000000000000000000000000 -0.0000000100000000000000000000000000000 -0.0100000000000000000000000000000000000
+4 NULL NULL NULL 9.9900000000000000000000000000000000000
+5 NULL NULL NULL -9.9900000000000000000000000000000000000
+6 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000
+7 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000
+8 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+9 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+10 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+11 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+12 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+13 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+14 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+15 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+16 NULL 1.2345678900000000000000000000000000000 NULL 1.2300000000000000000000000000000000000
+17 NULL -1.2345678900000000000000000000000000000 NULL -1.2300000000000000000000000000000000000
+18 NULL 1.2300000000000000000000000000000000000 NULL 2.3400000000000000000000000000000000000
+19 NULL -1.2300000000000000000000000000000000000 NULL -2.3400000000000000000000000000000000000
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat DECIMAL(16,8),
+ cDouble DECIMAL(16,8),
+ cDecimal38_18 DECIMAL(16,8),
+ cDecimal38_37 DECIMAL(16,8),
+ cDecimal16_8 DECIMAL(16,8),
+ cDecimal3_2 DECIMAL(16,8),
+ cNumeric38_18 DECIMAL(16,8),
+ cNumeric38_37 DECIMAL(16,8),
+ cNumeric16_8 DECIMAL(16,8),
+ cNumeric3_2 DECIMAL(16,8))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat DECIMAL(16,8),
+ cDouble DECIMAL(16,8),
+ cDecimal38_18 DECIMAL(16,8),
+ cDecimal38_37 DECIMAL(16,8),
+ cDecimal16_8 DECIMAL(16,8),
+ cDecimal3_2 DECIMAL(16,8),
+ cNumeric38_18 DECIMAL(16,8),
+ cNumeric38_37 DECIMAL(16,8),
+ cNumeric16_8 DECIMAL(16,8),
+ cNumeric3_2 DECIMAL(16,8))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 123400.00000000 NULL
+2 0.00000000 NULL
+3 0.00000000 NULL
+4 NULL NULL
+5 NULL NULL
+6 1.00000000 1.00000000
+7 -1.00000000 -1.00000000
+8 NULL NULL
+9 NULL NULL
+10 NULL NULL
+11 NULL NULL
+12 12345.00000000 12345.00000000
+13 -12345.00000000 -12345.00000000
+14 123.00000000 123.00000000
+15 -123.00000000 -123.00000000
+16 1.23456790 2.34567890
+17 -1.23456790 -2.34567890
+18 1234567.90000000 2345678.90000000
+19 -1234567.90000000 -2345678.90000000
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.23456789 12345678.90123456 1.23000000
+2 0.00000000 0.00000000 0.00000001 0.01000000
+3 0.00000000 0.00000000 -0.00000001 -0.01000000
+4 NULL NULL 99999999.99999999 9.99000000
+5 NULL NULL -99999999.99999999 -9.99000000
+6 1.00000000 1.00000000 1.00000000 1.00000000
+7 -1.00000000 -1.00000000 -1.00000000 -1.00000000
+8 NULL 1.00000000 12345678.00000000 1.00000000
+9 NULL -1.00000000 -12345678.00000000 -1.00000000
+10 NULL 1.00000000 12345678.00000000 1.00000000
+11 NULL -1.00000000 -12345678.00000000 -1.00000000
+12 12345.00000000 1.00000000 12345.00000000 1.00000000
+13 -12345.00000000 -1.00000000 -12345.00000000 -1.00000000
+14 123.00000000 1.00000000 123.00000000 1.00000000
+15 -123.00000000 -1.00000000 -123.00000000 -1.00000000
+16 12345678.90123456 1.23456789 34567890.12345678 1.23000000
+17 -12345678.90123456 -1.23456789 -34567890.12345678 -1.23000000
+18 12345678.90000000 1.23000000 34567890.12000000 2.34000000
+19 -12345678.90000000 -1.23000000 -34567890.12000000 -2.34000000
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.23456789 12345678.90123456 1.23000000
+2 0.00000000 0.00000000 0.00000001 0.01000000
+3 0.00000000 0.00000000 -0.00000001 -0.01000000
+4 NULL NULL 99999999.99999999 9.99000000
+5 NULL NULL -99999999.99999999 -9.99000000
+6 1.00000000 1.00000000 1.00000000 1.00000000
+7 -1.00000000 -1.00000000 -1.00000000 -1.00000000
+8 NULL 1.00000000 12345678.00000000 1.00000000
+9 NULL -1.00000000 -12345678.00000000 -1.00000000
+10 NULL 1.00000000 12345678.00000000 1.00000000
+11 NULL -1.00000000 -12345678.00000000 -1.00000000
+12 12345.00000000 1.00000000 12345.00000000 1.00000000
+13 -12345.00000000 -1.00000000 -12345.00000000 -1.00000000
+14 123.00000000 1.00000000 123.00000000 1.00000000
+15 -123.00000000 -1.00000000 -123.00000000 -1.00000000
+16 12345678.90123456 1.23456789 34567890.12345678 1.23000000
+17 -12345678.90123456 -1.23456789 -34567890.12345678 -1.23000000
+18 12345678.90000000 1.23000000 34567890.12000000 2.34000000
+19 -12345678.90000000 -1.23000000 -34567890.12000000 -2.34000000
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat DECIMAL(3,2),
+ cDouble DECIMAL(3,2),
+ cDecimal38_18 DECIMAL(3,2),
+ cDecimal38_37 DECIMAL(3,2),
+ cDecimal16_8 DECIMAL(3,2),
+ cDecimal3_2 DECIMAL(3,2),
+ cNumeric38_18 DECIMAL(3,2),
+ cNumeric38_37 DECIMAL(3,2),
+ cNumeric16_8 DECIMAL(3,2),
+ cNumeric3_2 DECIMAL(3,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat DECIMAL(3,2),
+ cDouble DECIMAL(3,2),
+ cDecimal38_18 DECIMAL(3,2),
+ cDecimal38_37 DECIMAL(3,2),
+ cDecimal16_8 DECIMAL(3,2),
+ cDecimal3_2 DECIMAL(3,2),
+ cNumeric38_18 DECIMAL(3,2),
+ cNumeric38_37 DECIMAL(3,2),
+ cNumeric16_8 DECIMAL(3,2),
+ cNumeric3_2 DECIMAL(3,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL NULL
+2 0.00 NULL
+3 0.00 NULL
+4 NULL NULL
+5 NULL NULL
+6 1.00 1.00
+7 -1.00 -1.00
+8 NULL NULL
+9 NULL NULL
+10 NULL NULL
+11 NULL NULL
+12 NULL NULL
+13 NULL NULL
+14 NULL NULL
+15 NULL NULL
+16 1.23 2.35
+17 -1.23 -2.35
+18 NULL NULL
+19 NULL NULL
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.23 NULL 1.23
+2 0.00 0.00 0.00 0.01
+3 0.00 0.00 0.00 -0.01
+4 NULL NULL NULL 9.99
+5 NULL NULL NULL -9.99
+6 1.00 1.00 1.00 1.00
+7 -1.00 -1.00 -1.00 -1.00
+8 NULL 1.00 NULL 1.00
+9 NULL -1.00 NULL -1.00
+10 NULL 1.00 NULL 1.00
+11 NULL -1.00 NULL -1.00
+12 NULL 1.00 NULL 1.00
+13 NULL -1.00 NULL -1.00
+14 NULL 1.00 NULL 1.00
+15 NULL -1.00 NULL -1.00
+16 NULL 1.23 NULL 1.23
+17 NULL -1.23 NULL -1.23
+18 NULL 1.23 NULL 2.34
+19 NULL -1.23 NULL -2.34
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.23 NULL 1.23
+2 0.00 0.00 0.00 0.01
+3 0.00 0.00 0.00 -0.01
+4 NULL NULL NULL 9.99
+5 NULL NULL NULL -9.99
+6 1.00 1.00 1.00 1.00
+7 -1.00 -1.00 -1.00 -1.00
+8 NULL 1.00 NULL 1.00
+9 NULL -1.00 NULL -1.00
+10 NULL 1.00 NULL 1.00
+11 NULL -1.00 NULL -1.00
+12 NULL 1.00 NULL 1.00
+13 NULL -1.00 NULL -1.00
+14 NULL 1.00 NULL 1.00
+15 NULL -1.00 NULL -1.00
+16 NULL 1.23 NULL 1.23
+17 NULL -1.23 NULL -1.23
+18 NULL 1.23 NULL 2.34
+19 NULL -1.23 NULL -2.34
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat NUMERIC(38,18),
+ cDouble NUMERIC(38,18),
+ cDecimal38_18 NUMERIC(38,18),
+ cDecimal38_37 NUMERIC(38,18),
+ cDecimal16_8 NUMERIC(38,18),
+ cDecimal3_2 NUMERIC(38,18),
+ cNumeric38_18 NUMERIC(38,18),
+ cNumeric38_37 NUMERIC(38,18),
+ cNumeric16_8 NUMERIC(38,18),
+ cNumeric3_2 NUMERIC(38,18))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat NUMERIC(38,18),
+ cDouble NUMERIC(38,18),
+ cDecimal38_18 NUMERIC(38,18),
+ cDecimal38_37 NUMERIC(38,18),
+ cDecimal16_8 NUMERIC(38,18),
+ cDecimal3_2 NUMERIC(38,18),
+ cNumeric38_18 NUMERIC(38,18),
+ cNumeric38_37 NUMERIC(38,18),
+ cNumeric16_8 NUMERIC(38,18),
+ cNumeric3_2 NUMERIC(38,18))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 123400.000000000000000000 NULL
+2 0.000000000000000000 NULL
+3 0.000000000000000000 NULL
+4 NULL NULL
+5 NULL NULL
+6 1.000000000000000000 1.000000000000000000
+7 -1.000000000000000000 -1.000000000000000000
+8 1234567940000000000.000000000000000000 1234567890123456770.000000000000000000
+9 -1234567940000000000.000000000000000000 -1234567890123456770.000000000000000000
+10 1234567940.000000000000000000 1234567890.000000000000000000
+11 -1234567940.000000000000000000 -1234567890.000000000000000000
+12 12345.000000000000000000 12345.000000000000000000
+13 -12345.000000000000000000 -12345.000000000000000000
+14 123.000000000000000000 123.000000000000000000
+15 -123.000000000000000000 -123.000000000000000000
+16 1.234567900000000000 2.345678900000000000
+17 -1.234567900000000000 -2.345678900000000000
+18 1234567.900000000000000000 2345678.900000000000000000
+19 -1234567.900000000000000000 -2345678.900000000000000000
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 12345678901234567890.123456789012345678 1.234567890123456789 12345678.901234560000000000 1.230000000000000000
+2 0.000000000000000001 0.000000000000000000 0.000000010000000000 0.010000000000000000
+3 -0.000000000000000001 0.000000000000000000 -0.000000010000000000 -0.010000000000000000
+4 99999999999999999999.999999999999999999 NULL 99999999.999999990000000000 9.990000000000000000
+5 -99999999999999999999.999999999999999999 NULL -99999999.999999990000000000 -9.990000000000000000
+6 1.000000000000000000 1.000000000000000000 1.000000000000000000 1.000000000000000000
+7 -1.000000000000000000 -1.000000000000000000 -1.000000000000000000 -1.000000000000000000
+8 1234567890123456789.000000000000000000 1.000000000000000000 12345678.000000000000000000 1.000000000000000000
+9 -1234567890123456789.000000000000000000 -1.000000000000000000 -12345678.000000000000000000 -1.000000000000000000
+10 1234567890.000000000000000000 1.000000000000000000 12345678.000000000000000000 1.000000000000000000
+11 -1234567890.000000000000000000 -1.000000000000000000 -12345678.000000000000000000 -1.000000000000000000
+12 12345.000000000000000000 1.000000000000000000 12345.000000000000000000 1.000000000000000000
+13 -12345.000000000000000000 -1.000000000000000000 -12345.000000000000000000 -1.000000000000000000
+14 123.000000000000000000 1.000000000000000000 123.000000000000000000 1.000000000000000000
+15 -123.000000000000000000 -1.000000000000000000 -123.000000000000000000 -1.000000000000000000
+16 12345678.901234560000000000 1.234567890000000000 34567890.123456780000000000 1.230000000000000000
+17 -12345678.901234560000000000 -1.234567890000000000 -34567890.123456780000000000 -1.230000000000000000
+18 12345678.900000000000000000 1.230000000000000000 34567890.120000000000000000 2.340000000000000000
+19 -12345678.900000000000000000 -1.230000000000000000 -34567890.120000000000000000 -2.340000000000000000
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 12345678901234567890.123456789012345678 1.234567890123456789 12345678.901234560000000000 1.230000000000000000
+2 0.000000000000000001 0.000000000000000000 0.000000010000000000 0.010000000000000000
+3 -0.000000000000000001 0.000000000000000000 -0.000000010000000000 -0.010000000000000000
+4 99999999999999999999.999999999999999999 NULL 99999999.999999990000000000 9.990000000000000000
+5 -99999999999999999999.999999999999999999 NULL -99999999.999999990000000000 -9.990000000000000000
+6 1.000000000000000000 1.000000000000000000 1.000000000000000000 1.000000000000000000
+7 -1.000000000000000000 -1.000000000000000000 -1.000000000000000000 -1.000000000000000000
+8 1234567890123456789.000000000000000000 1.000000000000000000 12345678.000000000000000000 1.000000000000000000
+9 -1234567890123456789.000000000000000000 -1.000000000000000000 -12345678.000000000000000000 -1.000000000000000000
+10 1234567890.000000000000000000 1.000000000000000000 12345678.000000000000000000 1.000000000000000000
+11 -1234567890.000000000000000000 -1.000000000000000000 -12345678.000000000000000000 -1.000000000000000000
+12 12345.000000000000000000 1.000000000000000000 12345.000000000000000000 1.000000000000000000
+13 -12345.000000000000000000 -1.000000000000000000 -12345.000000000000000000 -1.000000000000000000
+14 123.000000000000000000 1.000000000000000000 123.000000000000000000 1.000000000000000000
+15 -123.000000000000000000 -1.000000000000000000 -123.000000000000000000 -1.000000000000000000
+16 12345678.901234560000000000 1.234567890000000000 34567890.123456780000000000 1.230000000000000000
+17 -12345678.901234560000000000 -1.234567890000000000 -34567890.123456780000000000 -1.230000000000000000
+18 12345678.900000000000000000 1.230000000000000000 34567890.120000000000000000 2.340000000000000000
+19 -12345678.900000000000000000 -1.230000000000000000 -34567890.120000000000000000 -2.340000000000000000
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat NUMERIC(38,37),
+ cDouble NUMERIC(38,37),
+ cDecimal38_18 NUMERIC(38,37),
+ cDecimal38_37 NUMERIC(38,37),
+ cDecimal16_8 NUMERIC(38,37),
+ cDecimal3_2 NUMERIC(38,37),
+ cNumeric38_18 NUMERIC(38,37),
+ cNumeric38_37 NUMERIC(38,37),
+ cNumeric16_8 NUMERIC(38,37),
+ cNumeric3_2 NUMERIC(38,37))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat NUMERIC(38,37),
+ cDouble NUMERIC(38,37),
+ cDecimal38_18 NUMERIC(38,37),
+ cDecimal38_37 NUMERIC(38,37),
+ cDecimal16_8 NUMERIC(38,37),
+ cDecimal3_2 NUMERIC(38,37),
+ cNumeric38_18 NUMERIC(38,37),
+ cNumeric38_37 NUMERIC(38,37),
+ cNumeric16_8 NUMERIC(38,37),
+ cNumeric3_2 NUMERIC(38,37))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL NULL
+2 0.0000000000000000000000000000000000000 NULL
+3 0.0000000000000000000000000000000000000 NULL
+4 NULL NULL
+5 NULL NULL
+6 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000
+7 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000
+8 NULL NULL
+9 NULL NULL
+10 NULL NULL
+11 NULL NULL
+12 NULL NULL
+13 NULL NULL
+14 NULL NULL
+15 NULL NULL
+16 1.2345679000000000000000000000000000000 2.3456789000000000000000000000000000000
+17 -1.2345679000000000000000000000000000000 -2.3456789000000000000000000000000000000
+18 NULL NULL
+19 NULL NULL
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.2345678901234567890123456789000000000 NULL 1.2300000000000000000000000000000000000
+2 0.0000000000000000010000000000000000000 0.0000000000000000000000000000000000000 0.0000000100000000000000000000000000000 0.0100000000000000000000000000000000000
+3 -0.0000000000000000010000000000000000000 0.0000000000000000000000000000000000000 -0.0000000100000000000000000000000000000 -0.0100000000000000000000000000000000000
+4 NULL NULL NULL 9.9900000000000000000000000000000000000
+5 NULL NULL NULL -9.9900000000000000000000000000000000000
+6 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000
+7 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000
+8 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+9 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+10 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+11 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+12 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+13 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+14 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+15 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+16 NULL 1.2345678900000000000000000000000000000 NULL 1.2300000000000000000000000000000000000
+17 NULL -1.2345678900000000000000000000000000000 NULL -1.2300000000000000000000000000000000000
+18 NULL 1.2300000000000000000000000000000000000 NULL 2.3400000000000000000000000000000000000
+19 NULL -1.2300000000000000000000000000000000000 NULL -2.3400000000000000000000000000000000000
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.2345678901234567890123456789000000000 NULL 1.2300000000000000000000000000000000000
+2 0.0000000000000000010000000000000000000 0.0000000000000000000000000000000000000 0.0000000100000000000000000000000000000 0.0100000000000000000000000000000000000
+3 -0.0000000000000000010000000000000000000 0.0000000000000000000000000000000000000 -0.0000000100000000000000000000000000000 -0.0100000000000000000000000000000000000
+4 NULL NULL NULL 9.9900000000000000000000000000000000000
+5 NULL NULL NULL -9.9900000000000000000000000000000000000
+6 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000 1.0000000000000000000000000000000000000
+7 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000 -1.0000000000000000000000000000000000000
+8 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+9 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+10 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+11 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+12 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+13 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+14 NULL 1.0000000000000000000000000000000000000 NULL 1.0000000000000000000000000000000000000
+15 NULL -1.0000000000000000000000000000000000000 NULL -1.0000000000000000000000000000000000000
+16 NULL 1.2345678900000000000000000000000000000 NULL 1.2300000000000000000000000000000000000
+17 NULL -1.2345678900000000000000000000000000000 NULL -1.2300000000000000000000000000000000000
+18 NULL 1.2300000000000000000000000000000000000 NULL 2.3400000000000000000000000000000000000
+19 NULL -1.2300000000000000000000000000000000000 NULL -2.3400000000000000000000000000000000000
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat NUMERIC(16,8),
+ cDouble NUMERIC(16,8),
+ cDecimal38_18 NUMERIC(16,8),
+ cDecimal38_37 NUMERIC(16,8),
+ cDecimal16_8 NUMERIC(16,8),
+ cDecimal3_2 NUMERIC(16,8),
+ cNumeric38_18 NUMERIC(16,8),
+ cNumeric38_37 NUMERIC(16,8),
+ cNumeric16_8 NUMERIC(16,8),
+ cNumeric3_2 NUMERIC(16,8))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat NUMERIC(16,8),
+ cDouble NUMERIC(16,8),
+ cDecimal38_18 NUMERIC(16,8),
+ cDecimal38_37 NUMERIC(16,8),
+ cDecimal16_8 NUMERIC(16,8),
+ cDecimal3_2 NUMERIC(16,8),
+ cNumeric38_18 NUMERIC(16,8),
+ cNumeric38_37 NUMERIC(16,8),
+ cNumeric16_8 NUMERIC(16,8),
+ cNumeric3_2 NUMERIC(16,8))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 123400.00000000 NULL
+2 0.00000000 NULL
+3 0.00000000 NULL
+4 NULL NULL
+5 NULL NULL
+6 1.00000000 1.00000000
+7 -1.00000000 -1.00000000
+8 NULL NULL
+9 NULL NULL
+10 NULL NULL
+11 NULL NULL
+12 12345.00000000 12345.00000000
+13 -12345.00000000 -12345.00000000
+14 123.00000000 123.00000000
+15 -123.00000000 -123.00000000
+16 1.23456790 2.34567890
+17 -1.23456790 -2.34567890
+18 1234567.90000000 2345678.90000000
+19 -1234567.90000000 -2345678.90000000
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.23456789 12345678.90123456 1.23000000
+2 0.00000000 0.00000000 0.00000001 0.01000000
+3 0.00000000 0.00000000 -0.00000001 -0.01000000
+4 NULL NULL 99999999.99999999 9.99000000
+5 NULL NULL -99999999.99999999 -9.99000000
+6 1.00000000 1.00000000 1.00000000 1.00000000
+7 -1.00000000 -1.00000000 -1.00000000 -1.00000000
+8 NULL 1.00000000 12345678.00000000 1.00000000
+9 NULL -1.00000000 -12345678.00000000 -1.00000000
+10 NULL 1.00000000 12345678.00000000 1.00000000
+11 NULL -1.00000000 -12345678.00000000 -1.00000000
+12 12345.00000000 1.00000000 12345.00000000 1.00000000
+13 -12345.00000000 -1.00000000 -12345.00000000 -1.00000000
+14 123.00000000 1.00000000 123.00000000 1.00000000
+15 -123.00000000 -1.00000000 -123.00000000 -1.00000000
+16 12345678.90123456 1.23456789 34567890.12345678 1.23000000
+17 -12345678.90123456 -1.23456789 -34567890.12345678 -1.23000000
+18 12345678.90000000 1.23000000 34567890.12000000 2.34000000
+19 -12345678.90000000 -1.23000000 -34567890.12000000 -2.34000000
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.23456789 12345678.90123456 1.23000000
+2 0.00000000 0.00000000 0.00000001 0.01000000
+3 0.00000000 0.00000000 -0.00000001 -0.01000000
+4 NULL NULL 99999999.99999999 9.99000000
+5 NULL NULL -99999999.99999999 -9.99000000
+6 1.00000000 1.00000000 1.00000000 1.00000000
+7 -1.00000000 -1.00000000 -1.00000000 -1.00000000
+8 NULL 1.00000000 12345678.00000000 1.00000000
+9 NULL -1.00000000 -12345678.00000000 -1.00000000
+10 NULL 1.00000000 12345678.00000000 1.00000000
+11 NULL -1.00000000 -12345678.00000000 -1.00000000
+12 12345.00000000 1.00000000 12345.00000000 1.00000000
+13 -12345.00000000 -1.00000000 -12345.00000000 -1.00000000
+14 123.00000000 1.00000000 123.00000000 1.00000000
+15 -123.00000000 -1.00000000 -123.00000000 -1.00000000
+16 12345678.90123456 1.23456789 34567890.12345678 1.23000000
+17 -12345678.90123456 -1.23456789 -34567890.12345678 -1.23000000
+18 12345678.90000000 1.23000000 34567890.12000000 2.34000000
+19 -12345678.90000000 -1.23000000 -34567890.12000000 -2.34000000
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat NUMERIC(3,2),
+ cDouble NUMERIC(3,2),
+ cDecimal38_18 NUMERIC(3,2),
+ cDecimal38_37 NUMERIC(3,2),
+ cDecimal16_8 NUMERIC(3,2),
+ cDecimal3_2 NUMERIC(3,2),
+ cNumeric38_18 NUMERIC(3,2),
+ cNumeric38_37 NUMERIC(3,2),
+ cNumeric16_8 NUMERIC(3,2),
+ cNumeric3_2 NUMERIC(3,2))
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat NUMERIC(3,2),
+ cDouble NUMERIC(3,2),
+ cDecimal38_18 NUMERIC(3,2),
+ cDecimal38_37 NUMERIC(3,2),
+ cDecimal16_8 NUMERIC(3,2),
+ cDecimal3_2 NUMERIC(3,2),
+ cNumeric38_18 NUMERIC(3,2),
+ cNumeric38_37 NUMERIC(3,2),
+ cNumeric16_8 NUMERIC(3,2),
+ cNumeric3_2 NUMERIC(3,2))
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL NULL
+2 0.00 NULL
+3 0.00 NULL
+4 NULL NULL
+5 NULL NULL
+6 1.00 1.00
+7 -1.00 -1.00
+8 NULL NULL
+9 NULL NULL
+10 NULL NULL
+11 NULL NULL
+12 NULL NULL
+13 NULL NULL
+14 NULL NULL
+15 NULL NULL
+16 1.23 2.35
+17 -1.23 -2.35
+18 NULL NULL
+19 NULL NULL
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.23 NULL 1.23
+2 0.00 0.00 0.00 0.01
+3 0.00 0.00 0.00 -0.01
+4 NULL NULL NULL 9.99
+5 NULL NULL NULL -9.99
+6 1.00 1.00 1.00 1.00
+7 -1.00 -1.00 -1.00 -1.00
+8 NULL 1.00 NULL 1.00
+9 NULL -1.00 NULL -1.00
+10 NULL 1.00 NULL 1.00
+11 NULL -1.00 NULL -1.00
+12 NULL 1.00 NULL 1.00
+13 NULL -1.00 NULL -1.00
+14 NULL 1.00 NULL 1.00
+15 NULL -1.00 NULL -1.00
+16 NULL 1.23 NULL 1.23
+17 NULL -1.23 NULL -1.23
+18 NULL 1.23 NULL 2.34
+19 NULL -1.23 NULL -2.34
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1.23 NULL 1.23
+2 0.00 0.00 0.00 0.01
+3 0.00 0.00 0.00 -0.01
+4 NULL NULL NULL 9.99
+5 NULL NULL NULL -9.99
+6 1.00 1.00 1.00 1.00
+7 -1.00 -1.00 -1.00 -1.00
+8 NULL 1.00 NULL 1.00
+9 NULL -1.00 NULL -1.00
+10 NULL 1.00 NULL 1.00
+11 NULL -1.00 NULL -1.00
+12 NULL 1.00 NULL 1.00
+13 NULL -1.00 NULL -1.00
+14 NULL 1.00 NULL 1.00
+15 NULL -1.00 NULL -1.00
+16 NULL 1.23 NULL 1.23
+17 NULL -1.23 NULL -1.23
+18 NULL 1.23 NULL 2.34
+19 NULL -1.23 NULL -2.34
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat BIGINT,
+ cDouble BIGINT,
+ cDecimal38_18 BIGINT,
+ cDecimal38_37 BIGINT,
+ cDecimal16_8 BIGINT,
+ cDecimal3_2 BIGINT,
+ cNumeric38_18 BIGINT,
+ cNumeric38_37 BIGINT,
+ cNumeric16_8 BIGINT,
+ cNumeric3_2 BIGINT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat BIGINT,
+ cDouble BIGINT,
+ cDecimal38_18 BIGINT,
+ cDecimal38_37 BIGINT,
+ cDecimal16_8 BIGINT,
+ cDecimal3_2 BIGINT,
+ cNumeric38_18 BIGINT,
+ cNumeric38_37 BIGINT,
+ cNumeric16_8 BIGINT,
+ cNumeric3_2 BIGINT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 123400 NULL
+2 NULL NULL
+3 NULL NULL
+4 NULL NULL
+5 NULL NULL
+6 1 1
+7 -1 -1
+8 NULL NULL
+9 NULL NULL
+10 NULL NULL
+11 NULL NULL
+12 12345 12345
+13 -12345 -12345
+14 123 123
+15 -123 -123
+16 1 2
+17 -1 -2
+18 1234567 2345678
+19 -1234567 -2345678
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1 12345678 1
+2 0 0 0 0
+3 0 0 0 0
+4 NULL NULL 99999999 9
+5 NULL NULL -99999999 -9
+6 1 1 1 1
+7 -1 -1 -1 -1
+8 1234567890123456789 1 12345678 1
+9 -1234567890123456789 -1 -12345678 -1
+10 1234567890 1 12345678 1
+11 -1234567890 -1 -12345678 -1
+12 12345 1 12345 1
+13 -12345 -1 -12345 -1
+14 123 1 123 1
+15 -123 -1 -123 -1
+16 12345678 1 34567890 1
+17 -12345678 -1 -34567890 -1
+18 12345678 1 34567890 2
+19 -12345678 -1 -34567890 -2
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1 12345678 1
+2 0 0 0 0
+3 0 0 0 0
+4 NULL NULL 99999999 9
+5 NULL NULL -99999999 -9
+6 1 1 1 1
+7 -1 -1 -1 -1
+8 1234567890123456789 1 12345678 1
+9 -1234567890123456789 -1 -12345678 -1
+10 1234567890 1 12345678 1
+11 -1234567890 -1 -12345678 -1
+12 12345 1 12345 1
+13 -12345 -1 -12345 -1
+14 123 1 123 1
+15 -123 -1 -123 -1
+16 12345678 1 34567890 1
+17 -12345678 -1 -34567890 -1
+18 12345678 1 34567890 2
+19 -12345678 -1 -34567890 -2
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat INT,
+ cDouble INT,
+ cDecimal38_18 INT,
+ cDecimal38_37 INT,
+ cDecimal16_8 INT,
+ cDecimal3_2 INT,
+ cNumeric38_18 INT,
+ cNumeric38_37 INT,
+ cNumeric16_8 INT,
+ cNumeric3_2 INT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat INT,
+ cDouble INT,
+ cDecimal38_18 INT,
+ cDecimal38_37 INT,
+ cDecimal16_8 INT,
+ cDecimal3_2 INT,
+ cNumeric38_18 INT,
+ cNumeric38_37 INT,
+ cNumeric16_8 INT,
+ cNumeric3_2 INT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 123400 NULL
+2 NULL NULL
+3 NULL NULL
+4 NULL NULL
+5 NULL NULL
+6 1 1
+7 -1 -1
+8 NULL NULL
+9 NULL NULL
+10 NULL NULL
+11 NULL NULL
+12 12345 12345
+13 -12345 -12345
+14 123 123
+15 -123 -123
+16 1 2
+17 -1 -2
+18 1234567 2345678
+19 -1234567 -2345678
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1 12345678 1
+2 0 0 0 0
+3 0 0 0 0
+4 NULL NULL 99999999 9
+5 NULL NULL -99999999 -9
+6 1 1 1 1
+7 -1 -1 -1 -1
+8 NULL 1 12345678 1
+9 NULL -1 -12345678 -1
+10 1234567890 1 12345678 1
+11 -1234567890 -1 -12345678 -1
+12 12345 1 12345 1
+13 -12345 -1 -12345 -1
+14 123 1 123 1
+15 -123 -1 -123 -1
+16 12345678 1 34567890 1
+17 -12345678 -1 -34567890 -1
+18 12345678 1 34567890 2
+19 -12345678 -1 -34567890 -2
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1 12345678 1
+2 0 0 0 0
+3 0 0 0 0
+4 NULL NULL 99999999 9
+5 NULL NULL -99999999 -9
+6 1 1 1 1
+7 -1 -1 -1 -1
+8 NULL 1 12345678 1
+9 NULL -1 -12345678 -1
+10 1234567890 1 12345678 1
+11 -1234567890 -1 -12345678 -1
+12 12345 1 12345 1
+13 -12345 -1 -12345 -1
+14 123 1 123 1
+15 -123 -1 -123 -1
+16 12345678 1 34567890 1
+17 -12345678 -1 -34567890 -1
+18 12345678 1 34567890 2
+19 -12345678 -1 -34567890 -2
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat SMALLINT,
+ cDouble SMALLINT,
+ cDecimal38_18 SMALLINT,
+ cDecimal38_37 SMALLINT,
+ cDecimal16_8 SMALLINT,
+ cDecimal3_2 SMALLINT,
+ cNumeric38_18 SMALLINT,
+ cNumeric38_37 SMALLINT,
+ cNumeric16_8 SMALLINT,
+ cNumeric3_2 SMALLINT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat SMALLINT,
+ cDouble SMALLINT,
+ cDecimal38_18 SMALLINT,
+ cDecimal38_37 SMALLINT,
+ cDecimal16_8 SMALLINT,
+ cDecimal3_2 SMALLINT,
+ cNumeric38_18 SMALLINT,
+ cNumeric38_37 SMALLINT,
+ cNumeric16_8 SMALLINT,
+ cNumeric3_2 SMALLINT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL NULL
+2 NULL NULL
+3 NULL NULL
+4 NULL NULL
+5 NULL NULL
+6 1 1
+7 -1 -1
+8 NULL NULL
+9 NULL NULL
+10 NULL NULL
+11 NULL NULL
+12 12345 12345
+13 -12345 -12345
+14 123 123
+15 -123 -123
+16 1 2
+17 -1 -2
+18 NULL NULL
+19 NULL NULL
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1 NULL 1
+2 0 0 0 0
+3 0 0 0 0
+4 NULL NULL NULL 9
+5 NULL NULL NULL -9
+6 1 1 1 1
+7 -1 -1 -1 -1
+8 NULL 1 NULL 1
+9 NULL -1 NULL -1
+10 NULL 1 NULL 1
+11 NULL -1 NULL -1
+12 12345 1 12345 1
+13 -12345 -1 -12345 -1
+14 123 1 123 1
+15 -123 -1 -123 -1
+16 NULL 1 NULL 1
+17 NULL -1 NULL -1
+18 NULL 1 NULL 2
+19 NULL -1 NULL -2
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1 NULL 1
+2 0 0 0 0
+3 0 0 0 0
+4 NULL NULL NULL 9
+5 NULL NULL NULL -9
+6 1 1 1 1
+7 -1 -1 -1 -1
+8 NULL 1 NULL 1
+9 NULL -1 NULL -1
+10 NULL 1 NULL 1
+11 NULL -1 NULL -1
+12 12345 1 12345 1
+13 -12345 -1 -12345 -1
+14 123 1 123 1
+15 -123 -1 -123 -1
+16 NULL 1 NULL 1
+17 NULL -1 NULL -1
+18 NULL 1 NULL 2
+19 NULL -1 NULL -2
+PREHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat TINYINT,
+ cDouble TINYINT,
+ cDecimal38_18 TINYINT,
+ cDecimal38_37 TINYINT,
+ cDecimal16_8 TINYINT,
+ cDecimal3_2 TINYINT,
+ cNumeric38_18 TINYINT,
+ cNumeric38_37 TINYINT,
+ cNumeric16_8 TINYINT,
+ cNumeric3_2 TINYINT)
+PREHOOK: type: ALTERTABLE_REPLACECOLS
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: alter table testAltColT_n2 replace columns
+(cId TINYINT,
+ cFloat TINYINT,
+ cDouble TINYINT,
+ cDecimal38_18 TINYINT,
+ cDecimal38_37 TINYINT,
+ cDecimal16_8 TINYINT,
+ cDecimal3_2 TINYINT,
+ cNumeric38_18 TINYINT,
+ cNumeric38_37 TINYINT,
+ cNumeric16_8 TINYINT,
+ cNumeric3_2 TINYINT)
+POSTHOOK: type: ALTERTABLE_REPLACECOLS
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColT_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL NULL
+2 NULL NULL
+3 NULL NULL
+4 NULL NULL
+5 NULL NULL
+6 1 1
+7 -1 -1
+8 NULL NULL
+9 NULL NULL
+10 NULL NULL
+11 NULL NULL
+12 NULL NULL
+13 NULL NULL
+14 123 123
+15 -123 -123
+16 1 2
+17 -1 -2
+18 NULL NULL
+19 NULL NULL
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1 NULL 1
+2 0 0 0 0
+3 0 0 0 0
+4 NULL NULL NULL 9
+5 NULL NULL NULL -9
+6 1 1 1 1
+7 -1 -1 -1 -1
+8 NULL 1 NULL 1
+9 NULL -1 NULL -1
+10 NULL 1 NULL 1
+11 NULL -1 NULL -1
+12 NULL 1 NULL 1
+13 NULL -1 NULL -1
+14 123 1 123 1
+15 -123 -1 -123 -1
+16 NULL 1 NULL 1
+17 NULL -1 NULL -1
+18 NULL 1 NULL 2
+19 NULL -1 NULL -2
+PREHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cNumeric38_18, cNumeric38_37, cNumeric16_8, cNumeric3_2 from testAltColT_n2
+order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolt_n2
+#### A masked pattern was here ####
+1 NULL 1 NULL 1
+2 0 0 0 0
+3 0 0 0 0
+4 NULL NULL NULL 9
+5 NULL NULL NULL -9
+6 1 1 1 1
+7 -1 -1 -1 -1
+8 NULL 1 NULL 1
+9 NULL -1 NULL -1
+10 NULL 1 NULL 1
+11 NULL -1 NULL -1
+12 NULL 1 NULL 1
+13 NULL -1 NULL -1
+14 123 1 123 1
+15 -123 -1 -123 -1
+16 NULL 1 NULL 1
+17 NULL -1 NULL -1
+18 NULL 1 NULL 2
+19 NULL -1 NULL -2
+PREHOOK: query: drop table if exists testAltColT_n2
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@testaltcolt_n2
+PREHOOK: Output: default@testaltcolt_n2
+POSTHOOK: query: drop table if exists testAltColT_n2
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@testaltcolt_n2
+POSTHOOK: Output: default@testaltcolt_n2
+PREHOOK: query: drop table if exists testAltColSF_n2
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: drop table if exists testAltColSF_n2
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: create table testAltColSF_n2 stored as sequencefile as select * from testAltCol_n2
+PREHOOK: type: CREATETABLE_AS_SELECT
+PREHOOK: Input: default@testaltcol_n2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testAltColSF_n2
+POSTHOOK: query: create table testAltColSF_n2 stored as sequencefile as select * from testAltCol_n2
+POSTHOOK: type: CREATETABLE_AS_SELECT
+POSTHOOK: Input: default@testaltcol_n2
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@testAltColSF_n2
+POSTHOOK: Lineage: testaltcolsf_n2.cdecimal16_8 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cdecimal16_8, type:decimal(16,8), comment:null), ]
+POSTHOOK: Lineage: testaltcolsf_n2.cdecimal38_18 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cdecimal38_18, type:decimal(38,18), comment:null), ]
+POSTHOOK: Lineage: testaltcolsf_n2.cdecimal38_37 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cdecimal38_37, type:decimal(38,37), comment:null), ]
+POSTHOOK: Lineage: testaltcolsf_n2.cdecimal3_2 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cdecimal3_2, type:decimal(3,2), comment:null), ]
+POSTHOOK: Lineage: testaltcolsf_n2.cdouble SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cdouble, type:double, comment:null), ]
+POSTHOOK: Lineage: testaltcolsf_n2.cfloat SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cfloat, type:float, comment:null), ]
+POSTHOOK: Lineage: testaltcolsf_n2.cid SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cid, type:tinyint, comment:null), ]
+POSTHOOK: Lineage: testaltcolsf_n2.cnumeric16_8 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cnumeric16_8, type:decimal(16,8), comment:null), ]
+POSTHOOK: Lineage: testaltcolsf_n2.cnumeric38_18 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cnumeric38_18, type:decimal(38,18), comment:null), ]
+POSTHOOK: Lineage: testaltcolsf_n2.cnumeric38_37 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cnumeric38_37, type:decimal(38,37), comment:null), ]
+POSTHOOK: Lineage: testaltcolsf_n2.cnumeric3_2 SIMPLE [(testaltcol_n2)testaltcol_n2.FieldSchema(name:cnumeric3_2, type:decimal(3,2), comment:null), ]
+PREHOOK: query: select cId, cFloat, cDouble from testAltColSF_n2 order by cId
+PREHOOK: type: QUERY
+PREHOOK: Input: default@testaltcolsf_n2
+#### A masked pattern was here ####
+POSTHOOK: query: select cId, cFloat, cDouble from testAltColSF_n2 order by cId
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@testaltcolsf_n2
+#### A masked pattern was here ####
+1 123400.0 2.345E67
+2 1.4E-45 4.9E-324
+3 -1.4E-45 -4.9E-324
+4 3.4E38 1.79E308
+5 -3.4E38 -1.79E308
+6 1.0 1.0
+7 -1.0 -1.0
+8 1.23456794E18 1.23456789012345677E18
+9 -1.23456794E18 -1.23456789012345677E18
+10 1.23456794E9 1.23456789E9
+11 -1.23456794E9 -1.23456789E9
+12 12345.0 12345.0
+13 -12345.0 -12345.0
+14 123.0 123.0
+15 -123.0 -123.0
+16 1.2345679 2.3456789
+17 -1.2345679 -2.3456789
+18 1234567.9 2345678.9
+19 -1234567.9 -2345678.9
+PREHOOK: query: select cId, cDecimal38_18, cDecimal38_37, cDecimal16_8, cDecimal3_2 from testAltColSF_n2
+order by cId
+PREHOOK: type: QUERY
+PRE
<TRUNCATED>