http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/decimal_udf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/decimal_udf.q.out b/ql/src/test/results/clientpositive/decimal_udf.q.out index ce1fe3f..abbfc50 100644 --- a/ql/src/test/results/clientpositive/decimal_udf.q.out +++ b/ql/src/test/results/clientpositive/decimal_udf.q.out @@ -55,44 +55,44 @@ POSTHOOK: query: SELECT key + key FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --8800 +-8800.0000000000 NULL -0 -0 -200 -20 -2 -0.2 -0.02 -400 -40 -4 -0 -0.4 -0.04 -0.6 -0.66 -0.666 --0.6 --0.66 --0.666 -2 -4 -6.28 --2.24 --2.24 --2.244 -2.24 -2.244 -248 -250.4 --2510.98 -6.28 -6.28 -6.28 -2 --2469135780.246913578 -2469135780.24691356 +0.0000000000 +0.0000000000 +200.0000000000 +20.0000000000 +2.0000000000 +0.2000000000 +0.0200000000 +400.0000000000 +40.0000000000 +4.0000000000 +0.0000000000 +0.4000000000 +0.0400000000 +0.6000000000 +0.6600000000 +0.6660000000 +-0.6000000000 +-0.6600000000 +-0.6660000000 +2.0000000000 +4.0000000000 +6.2800000000 +-2.2400000000 +-2.2400000000 +-2.2440000000 +2.2400000000 +2.2440000000 +248.0000000000 +250.4000000000 +-2510.9800000000 +6.2800000000 +6.2800000000 +6.2800000000 +2.0000000000 +-2469135780.2469135780 +2469135780.2469135600 PREHOOK: query: EXPLAIN SELECT key + value FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key + value FROM DECIMAL_UDF @@ -122,44 +122,44 @@ POSTHOOK: query: SELECT key + value FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -0 +0.0000000000 NULL -0 -0 -200 -20 -2 -0.1 -0.01 -400 -40 -4 -0 -0.2 -0.02 -0.3 -0.33 -0.333 --0.3 --0.33 --0.333 -2 -4 -6.14 --2.12 --2.12 --12.122 -2.12 -2.122 -248 -250.2 --2510.49 -6.14 -6.14 -7.14 -2 --2469135780.123456789 -2469135780.12345678 +0.0000000000 +0.0000000000 +200.0000000000 +20.0000000000 +2.0000000000 +0.1000000000 +0.0100000000 +400.0000000000 +40.0000000000 +4.0000000000 +0.0000000000 +0.2000000000 +0.0200000000 +0.3000000000 +0.3300000000 +0.3330000000 +-0.3000000000 +-0.3300000000 +-0.3330000000 +2.0000000000 +4.0000000000 +6.1400000000 +-2.1200000000 +-2.1200000000 +-12.1220000000 +2.1200000000 +2.1220000000 +248.0000000000 +250.2000000000 +-2510.4900000000 +6.1400000000 +6.1400000000 +7.1400000000 +2.0000000000 +-2469135780.1234567890 +2469135780.1234567800 PREHOOK: query: EXPLAIN SELECT key + (value/2) FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key + (value/2) FROM DECIMAL_UDF @@ -325,44 +325,44 @@ POSTHOOK: query: SELECT key - key FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -0 +0.0000000000 NULL -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 -0 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 PREHOOK: query: EXPLAIN SELECT key - value FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key - value FROM DECIMAL_UDF @@ -392,44 +392,44 @@ POSTHOOK: query: SELECT key - value FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --8800 +-8800.0000000000 NULL -0 -0 -0 -0 -0 -0.1 -0.01 -0 -0 -0 -0 -0.2 -0.02 -0.3 -0.33 -0.333 --0.3 --0.33 --0.333 -0 -0 -0.14 --0.12 --0.12 -9.878 -0.12 -0.122 -0 -0.2 --0.49 -0.14 -0.14 --0.86 -0 --0.123456789 -0.12345678 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.1000000000 +0.0100000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.2000000000 +0.0200000000 +0.3000000000 +0.3300000000 +0.3330000000 +-0.3000000000 +-0.3300000000 +-0.3330000000 +0.0000000000 +0.0000000000 +0.1400000000 +-0.1200000000 +-0.1200000000 +9.8780000000 +0.1200000000 +0.1220000000 +0.0000000000 +0.2000000000 +-0.4900000000 +0.1400000000 +0.1400000000 +-0.8600000000 +0.0000000000 +-0.1234567890 +0.1234567800 PREHOOK: query: EXPLAIN SELECT key - (value/2) FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key - (value/2) FROM DECIMAL_UDF @@ -595,42 +595,42 @@ POSTHOOK: query: SELECT key * key FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -19360000 +19360000.00000000000000000000 NULL -0 -0 -10000 -100 -1 -0.01 -0.0001 -40000 -400 -4 -0 -0.04 -0.0004 -0.09 -0.1089 -0.110889 -0.09 -0.1089 -0.110889 -1 -4 -9.8596 -1.2544 -1.2544 -1.258884 -1.2544 -1.258884 -15376 -15675.04 -1576255.1401 -9.8596 -9.8596 -9.8596 -1 +0.00000000000000000000 +0.00000000000000000000 +10000.00000000000000000000 +100.00000000000000000000 +1.00000000000000000000 +0.01000000000000000000 +0.00010000000000000000 +40000.00000000000000000000 +400.00000000000000000000 +4.00000000000000000000 +0.00000000000000000000 +0.04000000000000000000 +0.00040000000000000000 +0.09000000000000000000 +0.10890000000000000000 +0.11088900000000000000 +0.09000000000000000000 +0.10890000000000000000 +0.11088900000000000000 +1.00000000000000000000 +4.00000000000000000000 +9.85960000000000000000 +1.25440000000000000000 +1.25440000000000000000 +1.25888400000000000000 +1.25440000000000000000 +1.25888400000000000000 +15376.00000000000000000000 +15675.04000000000000000000 +1576255.14010000000000000000 +9.85960000000000000000 +9.85960000000000000000 +9.85960000000000000000 +1.00000000000000000000 NULL NULL PREHOOK: query: EXPLAIN SELECT key, value FROM DECIMAL_UDF where key * value > 0 @@ -665,29 +665,29 @@ POSTHOOK: query: SELECT key, value FROM DECIMAL_UDF where key * value > 0 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -100 100 -10 10 -1 1 -200 200 -20 20 -2 2 -1 1 -2 2 -3.14 3 --1.12 -1 --1.12 -1 --1.122 -11 -1.12 1 -1.122 1 -124 124 -125.2 125 --1255.49 -1255 -3.14 3 -3.14 3 -3.14 4 -1 1 --1234567890.123456789 -1234567890 -1234567890.12345678 1234567890 +100.0000000000 100 +10.0000000000 10 +1.0000000000 1 +200.0000000000 200 +20.0000000000 20 +2.0000000000 2 +1.0000000000 1 +2.0000000000 2 +3.1400000000 3 +-1.1200000000 -1 +-1.1200000000 -1 +-1.1220000000 -11 +1.1200000000 1 +1.1220000000 1 +124.0000000000 124 +125.2000000000 125 +-1255.4900000000 -1255 +3.1400000000 3 +3.1400000000 3 +3.1400000000 4 +1.0000000000 1 +-1234567890.1234567890 -1234567890 +1234567890.1234567800 1234567890 PREHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF @@ -717,44 +717,44 @@ POSTHOOK: query: SELECT key * value FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --19360000 +-19360000.0000000000 NULL -0 -0 -10000 -100 -1 -0 -0 -40000 -400 -4 -0 -0 -0 -0 -0 -0 -0 -0 -0 -1 -4 -9.42 -1.12 -1.12 -12.342 -1.12 -1.122 -15376 -15650 -1575639.95 -9.42 -9.42 -12.56 -1 -1524157875171467887.50190521 -1524157875171467876.3907942 +0.0000000000 +0.0000000000 +10000.0000000000 +100.0000000000 +1.0000000000 +0.0000000000 +0.0000000000 +40000.0000000000 +400.0000000000 +4.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +1.0000000000 +4.0000000000 +9.4200000000 +1.1200000000 +1.1200000000 +12.3420000000 +1.1200000000 +1.1220000000 +15376.0000000000 +15650.0000000000 +1575639.9500000000 +9.4200000000 +9.4200000000 +12.5600000000 +1.0000000000 +1524157875171467887.5019052100 +1524157875171467876.3907942000 PREHOOK: query: EXPLAIN SELECT key * (value/2) FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key * (value/2) FROM DECIMAL_UDF @@ -989,40 +989,40 @@ POSTHOOK: query: SELECT key / key FROM DECIMAL_UDF WHERE key is not null and key POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 +1.000000000000000000000000 PREHOOK: query: EXPLAIN SELECT key / value FROM DECIMAL_UDF WHERE value is not null and value <> 0 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key / value FROM DECIMAL_UDF WHERE value is not null and value <> 0 @@ -1055,30 +1055,30 @@ POSTHOOK: query: SELECT key / value FROM DECIMAL_UDF WHERE value is not null and POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --1 -1 -1 -1 -1 -1 -1 -1 -1 +-1.000000000000000000000 +1.000000000000000000000 +1.000000000000000000000 +1.000000000000000000000 +1.000000000000000000000 +1.000000000000000000000 +1.000000000000000000000 +1.000000000000000000000 +1.000000000000000000000 1.046666666666666666667 -1.12 -1.12 -0.102 -1.12 -1.122 -1 -1.0016 +1.120000000000000000000 +1.120000000000000000000 +0.102000000000000000000 +1.120000000000000000000 +1.122000000000000000000 +1.000000000000000000000 +1.001600000000000000000 1.000390438247011952191 1.046666666666666666667 1.046666666666666666667 -0.785 -1 -1.0000000001 -1.00000000009999999271 +0.785000000000000000000 +1.000000000000000000000 +1.000000000100000000000 +1.000000000099999992710 PREHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key / (value/2) FROM DECIMAL_UDF WHERE value is not null and value <> 0 @@ -1233,44 +1233,44 @@ POSTHOOK: query: SELECT abs(key) FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -4400 +4400.0000000000 NULL -0 -0 -100 -10 -1 -0.1 -0.01 -200 -20 -2 -0 -0.2 -0.02 -0.3 -0.33 -0.333 -0.3 -0.33 -0.333 -1 -2 -3.14 -1.12 -1.12 -1.122 -1.12 -1.122 -124 -125.2 -1255.49 -3.14 -3.14 -3.14 -1 -1234567890.123456789 -1234567890.12345678 +0.0000000000 +0.0000000000 +100.0000000000 +10.0000000000 +1.0000000000 +0.1000000000 +0.0100000000 +200.0000000000 +20.0000000000 +2.0000000000 +0.0000000000 +0.2000000000 +0.0200000000 +0.3000000000 +0.3300000000 +0.3330000000 +0.3000000000 +0.3300000000 +0.3330000000 +1.0000000000 +2.0000000000 +3.1400000000 +1.1200000000 +1.1200000000 +1.1220000000 +1.1200000000 +1.1220000000 +124.0000000000 +125.2000000000 +1255.4900000000 +3.1400000000 +3.1400000000 +3.1400000000 +1.0000000000 +1234567890.1234567890 +1234567890.1234567800 PREHOOK: query: -- avg EXPLAIN SELECT value, sum(key) / count(key), avg(key), sum(key) FROM DECIMAL_UDF GROUP BY value ORDER BY value PREHOOK: type: QUERY @@ -1359,23 +1359,23 @@ POSTHOOK: query: SELECT value, sum(key) / count(key), avg(key), sum(key) FROM DE POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --1234567890 -1234567890.123456789 -1234567890.123456789 -1234567890.123456789 --1255 -1255.49 -1255.49 -1255.49 --11 -1.122 -1.122 -1.122 --1 -1.12 -1.12 -2.24 -0 0.02538461538461538461538 0.02538461538462 0.33 -1 1.0484 1.0484 5.242 -2 2 2 4 -3 3.14 3.14 9.42 -4 3.14 3.14 3.14 -10 10 10 10 -20 20 20 20 -100 100 100 100 -124 124 124 124 -125 125.2 125.2 125.2 -200 200 200 200 -4400 -4400 -4400 -4400 -1234567890 1234567890.12345678 1234567890.12345678 1234567890.12345678 +-1234567890 -1234567890.12345678900000000000000 -1234567890.12345678900000 -1234567890.1234567890 +-1255 -1255.49000000000000000000000 -1255.49000000000000 -1255.4900000000 +-11 -1.12200000000000000000000 -1.12200000000000 -1.1220000000 +-1 -1.12000000000000000000000 -1.12000000000000 -2.2400000000 +0 0.02538461538461538461538 0.02538461538462 0.3300000000 +1 1.04840000000000000000000 1.04840000000000 5.2420000000 +2 2.00000000000000000000000 2.00000000000000 4.0000000000 +3 3.14000000000000000000000 3.14000000000000 9.4200000000 +4 3.14000000000000000000000 3.14000000000000 3.1400000000 +10 10.00000000000000000000000 10.00000000000000 10.0000000000 +20 20.00000000000000000000000 20.00000000000000 20.0000000000 +100 100.00000000000000000000000 100.00000000000000 100.0000000000 +124 124.00000000000000000000000 124.00000000000000 124.0000000000 +125 125.20000000000000000000000 125.20000000000000 125.2000000000 +200 200.00000000000000000000000 200.00000000000000 200.0000000000 +4400 -4400.00000000000000000000000 -4400.00000000000000 -4400.0000000000 +1234567890 1234567890.12345678000000000000000 1234567890.12345678000000 1234567890.1234567800 PREHOOK: query: -- negative EXPLAIN SELECT -key FROM DECIMAL_UDF PREHOOK: type: QUERY @@ -1407,44 +1407,44 @@ POSTHOOK: query: SELECT -key FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -4400 +4400.0000000000 NULL -0 -0 --100 --10 --1 --0.1 --0.01 --200 --20 --2 -0 --0.2 --0.02 --0.3 --0.33 --0.333 -0.3 -0.33 -0.333 --1 --2 --3.14 -1.12 -1.12 -1.122 --1.12 --1.122 --124 --125.2 -1255.49 --3.14 --3.14 --3.14 --1 -1234567890.123456789 --1234567890.12345678 +0.0000000000 +0.0000000000 +-100.0000000000 +-10.0000000000 +-1.0000000000 +-0.1000000000 +-0.0100000000 +-200.0000000000 +-20.0000000000 +-2.0000000000 +0.0000000000 +-0.2000000000 +-0.0200000000 +-0.3000000000 +-0.3300000000 +-0.3330000000 +0.3000000000 +0.3300000000 +0.3330000000 +-1.0000000000 +-2.0000000000 +-3.1400000000 +1.1200000000 +1.1200000000 +1.1220000000 +-1.1200000000 +-1.1220000000 +-124.0000000000 +-125.2000000000 +1255.4900000000 +-3.1400000000 +-3.1400000000 +-3.1400000000 +-1.0000000000 +1234567890.1234567890 +-1234567890.1234567800 PREHOOK: query: -- positive EXPLAIN SELECT +key FROM DECIMAL_UDF PREHOOK: type: QUERY @@ -1476,44 +1476,44 @@ POSTHOOK: query: SELECT +key FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --4400 +-4400.0000000000 NULL -0 -0 -100 -10 -1 -0.1 -0.01 -200 -20 -2 -0 -0.2 -0.02 -0.3 -0.33 -0.333 --0.3 --0.33 --0.333 -1 -2 -3.14 --1.12 --1.12 --1.122 -1.12 -1.122 -124 -125.2 --1255.49 -3.14 -3.14 -3.14 -1 --1234567890.123456789 -1234567890.12345678 +0.0000000000 +0.0000000000 +100.0000000000 +10.0000000000 +1.0000000000 +0.1000000000 +0.0100000000 +200.0000000000 +20.0000000000 +2.0000000000 +0.0000000000 +0.2000000000 +0.0200000000 +0.3000000000 +0.3300000000 +0.3330000000 +-0.3000000000 +-0.3300000000 +-0.3330000000 +1.0000000000 +2.0000000000 +3.1400000000 +-1.1200000000 +-1.1200000000 +-1.1220000000 +1.1200000000 +1.1220000000 +124.0000000000 +125.2000000000 +-1255.4900000000 +3.1400000000 +3.1400000000 +3.1400000000 +1.0000000000 +-1234567890.1234567890 +1234567890.1234567800 PREHOOK: query: -- ceiling EXPlAIN SELECT CEIL(key) FROM DECIMAL_UDF PREHOOK: type: QUERY @@ -1683,42 +1683,42 @@ POSTHOOK: query: SELECT ROUND(key, 2) FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --4400 +-4400.00 NULL -0 -0 -100 -10 -1 -0.1 +0.00 +0.00 +100.00 +10.00 +1.00 +0.10 0.01 -200 -20 -2 -0 -0.2 +200.00 +20.00 +2.00 +0.00 +0.20 0.02 -0.3 +0.30 0.33 0.33 --0.3 +-0.30 -0.33 -0.33 -1 -2 +1.00 +2.00 3.14 -1.12 -1.12 -1.12 1.12 1.12 -124 -125.2 +124.00 +125.20 -1255.49 3.14 3.14 3.14 -1 +1.00 -1234567890.12 1234567890.12 PREHOOK: query: -- power @@ -1821,44 +1821,44 @@ POSTHOOK: query: SELECT (key + 1) % (key / 2) FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --2199 +-2199.000000000000 NULL NULL NULL -1 -1 -0 -0 -0 -1 -1 -0 +1.000000000000 +1.000000000000 +0.000000000000 +0.000000000000 +0.000000000000 +1.000000000000 +1.000000000000 +0.000000000000 NULL -0 -0 -0.1 -0.01 -0.001 -0.1 -0.01 -0.001 -0 -0 -1 --0.12 --0.12 --0.122 -0.44 -0.439 -1 -1 --626.745 -1 -1 -1 -0 --617283944.0617283945 -1 +0.000000000000 +0.000000000000 +0.100000000000 +0.010000000000 +0.001000000000 +0.100000000000 +0.010000000000 +0.001000000000 +0.000000000000 +0.000000000000 +1.000000000000 +-0.120000000000 +-0.120000000000 +-0.122000000000 +0.440000000000 +0.439000000000 +1.000000000000 +1.000000000000 +-626.745000000000 +1.000000000000 +1.000000000000 +1.000000000000 +0.000000000000 +-617283944.061728394500 +1.000000000000 PREHOOK: query: -- stddev, var EXPLAIN SELECT value, stddev(key), variance(key) FROM DECIMAL_UDF GROUP BY value PREHOOK: type: QUERY @@ -2134,7 +2134,7 @@ POSTHOOK: query: SELECT MIN(key) FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --1234567890.123456789 +-1234567890.1234567890 PREHOOK: query: -- max EXPLAIN SELECT MAX(key) FROM DECIMAL_UDF PREHOOK: type: QUERY @@ -2193,7 +2193,7 @@ POSTHOOK: query: SELECT MAX(key) FROM DECIMAL_UDF POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -1234567890.12345678 +1234567890.1234567800 PREHOOK: query: -- count EXPLAIN SELECT COUNT(key) FROM DECIMAL_UDF PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out b/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out index 1f613c4..f7a9853 100644 --- a/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out +++ b/ql/src/test/results/clientpositive/insert_nonacid_from_acid.q.out @@ -31,11 +31,11 @@ POSTHOOK: query: select * from sample_06 where gpa = 3.00 POSTHOOK: type: QUERY POSTHOOK: Input: default@sample_06 #### A masked pattern was here #### -aaa 35 3 -bbb 32 3 -ccc 32 3 -ddd 35 3 -eee 32 3 +aaa 35 3.00 +bbb 32 3.00 +ccc 32 3.00 +ddd 35 3.00 +eee 32 3.00 PREHOOK: query: create table tab1 (name varchar(50), age int, gpa decimal(3, 2)) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default @@ -63,8 +63,8 @@ POSTHOOK: query: select * from tab1 POSTHOOK: type: QUERY POSTHOOK: Input: default@tab1 #### A masked pattern was here #### -aaa 35 3 -bbb 32 3 -ccc 32 3 -ddd 35 3 -eee 32 3 +aaa 35 3.00 +bbb 32 3.00 +ccc 32 3.00 +ddd 35 3.00 +eee 32 3.00 http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out b/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out index 1586f8a..36a032a 100644 --- a/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out +++ b/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_1.q.out @@ -1320,105 +1320,105 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_mapjoin #### A masked pattern was here #### 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 -617.5607769230769 -6981 6981 5831542.269248378 -617.5607769230769 -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 6984454.211097692 -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 NULL +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 -617.56077692307690 +6981 6981 5831542.2692483780 -617.56077692307690 +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 6984454.21109769200000 +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 -617.5607769230769 -6981 6981 -515.621072973 -617.5607769230769 -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 6984454.211097692 -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 -617.5607769230769 -6981 6981 -515.621072973 -617.5607769230769 -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 6984454.211097692 -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 -617.56077692307690 +6981 6981 -515.6210729730 -617.56077692307690 +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 6984454.21109769200000 +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 -617.56077692307690 +6981 6981 -515.6210729730 -617.56077692307690 +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 6984454.21109769200000 +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL PREHOOK: query: EXPLAIN SELECT l.cint, r.cint, l.cdecimal1, r.cdecimal2 FROM decimal_mapjoin l JOIN decimal_mapjoin r ON l.cint = r.cint @@ -1508,105 +1508,105 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_mapjoin #### A masked pattern was here #### 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 -617.5607769230769 -6981 6981 5831542.269248378 -617.5607769230769 -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 6984454.211097692 -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 NULL -6981 6981 5831542.269248378 NULL +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 -617.56077692307690 +6981 6981 5831542.2692483780 -617.56077692307690 +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 6984454.21109769200000 +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 NULL +6981 6981 5831542.2692483780 NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL -617.5607769230769 -6981 6981 NULL -617.5607769230769 +6981 6981 NULL -617.56077692307690 +6981 6981 NULL -617.56077692307690 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 NULL 6984454.211097692 +6981 6981 NULL 6984454.21109769200000 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 -617.5607769230769 -6981 6981 -515.621072973 -617.5607769230769 -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 6984454.211097692 -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 -617.5607769230769 -6981 6981 -515.621072973 -617.5607769230769 -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 6984454.211097692 -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 -617.56077692307690 +6981 6981 -515.6210729730 -617.56077692307690 +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 6984454.21109769200000 +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 -617.56077692307690 +6981 6981 -515.6210729730 -617.56077692307690 +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 6984454.21109769200000 +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL PREHOOK: query: DROP TABLE decimal_mapjoin PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_mapjoin http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out index 98d9ceb..4c8b295 100644 --- a/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out +++ b/ql/src/test/results/clientpositive/llap/mapjoin_decimal.q.out @@ -169,112 +169,112 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@t1 POSTHOOK: Input: default@t2 #### A masked pattern was here #### -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -45 45 -45 45 -45 45 -45 45 -45 45 -6 6 -6 6 -6 6 -6 6 -6 6 -6 6 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -70 70 -70 70 -70 70 -70 70 -70 70 -70 70 -70 70 -79 79 -79 79 -79 79 -79 79 -79 79 -79 79 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +45.00 45 +45.00 45 +45.00 45 +45.00 45 +45.00 45 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec) order by t1.dec PREHOOK: type: QUERY PREHOOK: Input: default@t1 @@ -285,109 +285,109 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@t1 POSTHOOK: Input: default@t2 #### A masked pattern was here #### -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -45 45 -45 45 -45 45 -45 45 -45 45 -6 6 -6 6 -6 6 -6 6 -6 6 -6 6 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -70 70 -70 70 -70 70 -70 70 -70 70 -70 70 -70 70 -79 79 -79 79 -79 79 -79 79 -79 79 -79 79 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +45.00 45 +45.00 45 +45.00 45 +45.00 45 +45.00 45 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/orc_file_dump.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/orc_file_dump.q.out b/ql/src/test/results/clientpositive/orc_file_dump.q.out index c494d47..50d5701 100644 --- a/ql/src/test/results/clientpositive/orc_file_dump.q.out +++ b/ql/src/test/results/clientpositive/orc_file_dump.q.out @@ -196,7 +196,7 @@ File length: 33458 bytes Padding length: 0 bytes Padding ratio: 0% -- END ORC FILE DUMP -- -124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty +124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty PREHOOK: query: alter table orc_ppd set tblproperties("orc.bloom.filter.fpp"="0.01") PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: default@orc_ppd @@ -314,7 +314,7 @@ File length: 38613 bytes Padding length: 0 bytes Padding ratio: 0% -- END ORC FILE DUMP -- -124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty +124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty PREHOOK: query: CREATE TABLE orc_ppd_part(t tinyint, si smallint, i int, @@ -444,4 +444,4 @@ File length: 33458 bytes Padding length: 0 bytes Padding ratio: 0% -- END ORC FILE DUMP -- -124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty 2015 10 +124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty 2015 10 http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out b/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out index 0d4cd15..6a528dd 100644 --- a/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out +++ b/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out @@ -251,7 +251,7 @@ POSTHOOK: query: SELECT * FROM orc_pred WHERE t>2 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_pred #### A masked pattern was here #### -124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty +124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty PREHOOK: query: SELECT * FROM orc_pred WHERE t>2 limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@orc_pred @@ -260,7 +260,7 @@ POSTHOOK: query: SELECT * FROM orc_pred WHERE t>2 limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_pred #### A masked pattern was here #### -124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty +124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty PREHOOK: query: SELECT SUM(HASH(t)) FROM orc_pred WHERE t IS NOT NULL AND t < 0 http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/parquet_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/parquet_decimal.q.out b/ql/src/test/results/clientpositive/parquet_decimal.q.out index 493bd4f..a19cd6d 100644 --- a/ql/src/test/results/clientpositive/parquet_decimal.q.out +++ b/ql/src/test/results/clientpositive/parquet_decimal.q.out @@ -63,9 +63,9 @@ Mary 4.33 Cluck 5.96 Tom -12.25 Mary 33.33 -Tom 19 -Beck 0 -Beck 79.9 +Tom 19.00 +Beck 0.00 +Beck 79.90 PREHOOK: query: SELECT value, count(*) FROM parq_dec GROUP BY value ORDER BY value PREHOOK: type: QUERY PREHOOK: Input: default@parq_dec @@ -75,14 +75,14 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@parq_dec #### A masked pattern was here #### -12.25 1 -0 1 +0.00 1 4.33 1 5.96 1 -19 1 +19.00 1 33.33 1 55.71 1 77.34 1 -79.9 1 +79.90 1 234.79 1 PREHOOK: query: TRUNCATE TABLE parq_dec PREHOOK: type: TRUNCATETABLE @@ -158,12 +158,12 @@ POSTHOOK: Input: default@parq_dec1 77.3 55.7 4.3 -6 +6.0 12.3 33.3 0.2 3.2 -8 +8.0 PREHOOK: query: DROP TABLE dec PREHOOK: type: DROPTABLE PREHOOK: Input: default@dec http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out b/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out index 1355849..6e62ee4 100644 --- a/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out +++ b/ql/src/test/results/clientpositive/parquet_ppd_boolean.q.out @@ -26,11 +26,11 @@ POSTHOOK: query: select * from newtypestbl where b=true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true PREHOOK: query: select * from newtypestbl where b!=true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -39,11 +39,11 @@ POSTHOOK: query: select * from newtypestbl where b!=true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false PREHOOK: query: select * from newtypestbl where b<true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -52,11 +52,11 @@ POSTHOOK: query: select * from newtypestbl where b<true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false PREHOOK: query: select * from newtypestbl where b>true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -73,16 +73,16 @@ POSTHOOK: query: select * from newtypestbl where b<=true sort by c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false PREHOOK: query: select * from newtypestbl where b=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -91,11 +91,11 @@ POSTHOOK: query: select * from newtypestbl where b=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false PREHOOK: query: select * from newtypestbl where b!=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -104,11 +104,11 @@ POSTHOOK: query: select * from newtypestbl where b!=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true PREHOOK: query: select * from newtypestbl where b<false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -125,11 +125,11 @@ POSTHOOK: query: select * from newtypestbl where b>false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true PREHOOK: query: select * from newtypestbl where b<=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -138,11 +138,11 @@ POSTHOOK: query: select * from newtypestbl where b<=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false PREHOOK: query: select * from newtypestbl where b=true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -151,11 +151,11 @@ POSTHOOK: query: select * from newtypestbl where b=true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true PREHOOK: query: select * from newtypestbl where b!=true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -164,11 +164,11 @@ POSTHOOK: query: select * from newtypestbl where b!=true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false PREHOOK: query: select * from newtypestbl where b<true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -177,11 +177,11 @@ POSTHOOK: query: select * from newtypestbl where b<true POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false PREHOOK: query: select * from newtypestbl where b>true PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -198,16 +198,16 @@ POSTHOOK: query: select * from newtypestbl where b<=true sort by c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false PREHOOK: query: select * from newtypestbl where b=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -216,11 +216,11 @@ POSTHOOK: query: select * from newtypestbl where b=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false PREHOOK: query: select * from newtypestbl where b!=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -229,11 +229,11 @@ POSTHOOK: query: select * from newtypestbl where b!=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true PREHOOK: query: select * from newtypestbl where b<false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -250,11 +250,11 @@ POSTHOOK: query: select * from newtypestbl where b>false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true -apple bee 0.22 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true +apple bee 0.220 true PREHOOK: query: select * from newtypestbl where b<=false PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -263,8 +263,8 @@ POSTHOOK: query: select * from newtypestbl where b<=false POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false -hello world 11.22 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false +hello world 11.220 false http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/parquet_ppd_char.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/parquet_ppd_char.q.out b/ql/src/test/results/clientpositive/parquet_ppd_char.q.out index f224870..defaa9d 100644 --- a/ql/src/test/results/clientpositive/parquet_ppd_char.q.out +++ b/ql/src/test/results/clientpositive/parquet_ppd_char.q.out @@ -28,11 +28,11 @@ select * from newtypestbl where c="apple" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where c="apple" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -41,11 +41,11 @@ POSTHOOK: query: select * from newtypestbl where c="apple" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where c!="apple" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -54,11 +54,11 @@ POSTHOOK: query: select * from newtypestbl where c!="apple" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where c!="apple" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -67,11 +67,11 @@ POSTHOOK: query: select * from newtypestbl where c!="apple" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where c<"hello" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -80,11 +80,11 @@ POSTHOOK: query: select * from newtypestbl where c<"hello" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where c<"hello" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -93,11 +93,11 @@ POSTHOOK: query: select * from newtypestbl where c<"hello" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where c<="hello" sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -106,16 +106,16 @@ POSTHOOK: query: select * from newtypestbl where c<="hello" sort by c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where c<="hello" sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -124,16 +124,16 @@ POSTHOOK: query: select * from newtypestbl where c<="hello" sort by c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where c="apple " PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -158,11 +158,11 @@ POSTHOOK: query: select * from newtypestbl where c in ("apple", "carrot") POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where c in ("apple", "carrot") PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -171,11 +171,11 @@ POSTHOOK: query: select * from newtypestbl where c in ("apple", "carrot") POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where c in ("apple", "hello") sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -184,16 +184,16 @@ POSTHOOK: query: select * from newtypestbl where c in ("apple", "hello") sort by POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where c in ("apple", "hello") sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -202,16 +202,16 @@ POSTHOOK: query: select * from newtypestbl where c in ("apple", "hello") sort by POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where c in ("carrot") PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -236,11 +236,11 @@ POSTHOOK: query: select * from newtypestbl where c between "apple" and "carrot" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where c between "apple" and "carrot" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -249,11 +249,11 @@ POSTHOOK: query: select * from newtypestbl where c between "apple" and "carrot" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where c between "apple" and "zombie" sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -262,16 +262,16 @@ POSTHOOK: query: select * from newtypestbl where c between "apple" and "zombie" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where c between "apple" and "zombie" sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -280,16 +280,16 @@ POSTHOOK: query: select * from newtypestbl where c between "apple" and "zombie" POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where c between "carrot" and "carrot1" PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/parquet_ppd_date.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/parquet_ppd_date.q.out b/ql/src/test/results/clientpositive/parquet_ppd_date.q.out index e599014..55231e9 100644 --- a/ql/src/test/results/clientpositive/parquet_ppd_date.q.out +++ b/ql/src/test/results/clientpositive/parquet_ppd_date.q.out @@ -28,11 +28,11 @@ select * from newtypestbl where da='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da='1970-02-20' PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -41,11 +41,11 @@ POSTHOOK: query: select * from newtypestbl where da='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da= date '1970-02-20' PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -54,11 +54,11 @@ POSTHOOK: query: select * from newtypestbl where da= date '1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da=cast('1970-02-20' as date) PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -67,11 +67,11 @@ POSTHOOK: query: select * from newtypestbl where da=cast('1970-02-20' as date) POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da=cast('1970-02-20' as date) PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -80,11 +80,11 @@ POSTHOOK: query: select * from newtypestbl where da=cast('1970-02-20' as date) POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da=cast('1970-02-20' as varchar(20)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -93,11 +93,11 @@ POSTHOOK: query: select * from newtypestbl where da=cast('1970-02-20' as varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da=cast('1970-02-20' as varchar(20)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -106,11 +106,11 @@ POSTHOOK: query: select * from newtypestbl where da=cast('1970-02-20' as varchar POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da!='1970-02-20' PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -119,11 +119,11 @@ POSTHOOK: query: select * from newtypestbl where da!='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da!='1970-02-20' PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -132,11 +132,11 @@ POSTHOOK: query: select * from newtypestbl where da!='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da<'1970-02-27' PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -145,11 +145,11 @@ POSTHOOK: query: select * from newtypestbl where da<'1970-02-27' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da<'1970-02-27' PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -158,11 +158,11 @@ POSTHOOK: query: select * from newtypestbl where da<'1970-02-27' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da<'1970-02-29' sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -171,16 +171,16 @@ POSTHOOK: query: select * from newtypestbl where da<'1970-02-29' sort by c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da<'1970-02-29' sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -189,16 +189,16 @@ POSTHOOK: query: select * from newtypestbl where da<'1970-02-29' sort by c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da<'1970-02-15' PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -223,11 +223,11 @@ POSTHOOK: query: select * from newtypestbl where da<='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da<='1970-02-20' PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -236,11 +236,11 @@ POSTHOOK: query: select * from newtypestbl where da<='1970-02-20' POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da<='1970-02-27' sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -249,16 +249,16 @@ POSTHOOK: query: select * from newtypestbl where da<='1970-02-27' sort by c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da<='1970-02-27' sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -267,16 +267,16 @@ POSTHOOK: query: select * from newtypestbl where da<='1970-02-27' sort by c POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -285,11 +285,11 @@ POSTHOOK: query: select * from newtypestbl where da in (cast('1970-02-21' as dat POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-27' as date)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -298,11 +298,11 @@ POSTHOOK: query: select * from newtypestbl where da in (cast('1970-02-21' as dat POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)) sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -311,16 +311,16 @@ POSTHOOK: query: select * from newtypestbl where da in (cast('1970-02-20' as dat POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da in (cast('1970-02-20' as date), cast('1970-02-27' as date)) sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -329,16 +329,16 @@ POSTHOOK: query: select * from newtypestbl where da in (cast('1970-02-20' as dat POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da in (cast('1970-02-21' as date), cast('1970-02-22' as date)) PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -363,11 +363,11 @@ POSTHOOK: query: select * from newtypestbl where da between '1970-02-19' and '19 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da between '1970-02-19' and '1970-02-22' PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -376,11 +376,11 @@ POSTHOOK: query: select * from newtypestbl where da between '1970-02-19' and '19 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 PREHOOK: query: select * from newtypestbl where da between '1970-02-19' and '1970-02-28' sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -389,16 +389,16 @@ POSTHOOK: query: select * from newtypestbl where da between '1970-02-19' and '19 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da between '1970-02-19' and '1970-02-28' sort by c PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl @@ -407,16 +407,16 @@ POSTHOOK: query: select * from newtypestbl where da between '1970-02-19' and '19 POSTHOOK: type: QUERY POSTHOOK: Input: default@newtypestbl #### A masked pattern was here #### -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -apple bee 0.22 1970-02-20 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 -hello world 11.22 1970-02-27 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +apple bee 0.220 1970-02-20 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 +hello world 11.220 1970-02-27 PREHOOK: query: select * from newtypestbl where da between '1970-02-18' and '1970-02-19' PREHOOK: type: QUERY PREHOOK: Input: default@newtypestbl
