Repository: hive Updated Branches: refs/heads/branch-3 3c44a3820 -> 9cd62587f
http://git-wip-us.apache.org/repos/asf/hive/blob/9cd62587/ql/src/test/results/clientpositive/type_change_test_int_vectorized.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/type_change_test_int_vectorized.q.out b/ql/src/test/results/clientpositive/type_change_test_int_vectorized.q.out index 973cc4e..87a5b3d 100644 --- a/ql/src/test/results/clientpositive/type_change_test_int_vectorized.q.out +++ b/ql/src/test/results/clientpositive/type_change_test_int_vectorized.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.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 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.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 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
