http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/tez/vector_decimal_precision.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_decimal_precision.q.out b/ql/src/test/results/clientpositive/tez/vector_decimal_precision.q.out index 8b6614e..0b14304 100644 --- a/ql/src/test/results/clientpositive/tez/vector_decimal_precision.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_decimal_precision.q.out @@ -99,13 +99,13 @@ NULL NULL NULL NULL -0 -0 -0 -0 -0 -0.123456789 -0.123456789 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.0000000000 +0.1234567890 +0.1234567890 1.2345678901 1.2345678901 1.2345678901 @@ -122,14 +122,14 @@ NULL 12345.6789012346 123456.7890123456 123456.7890123457 -1234567.890123456 +1234567.8901234560 1234567.8901234568 -12345678.90123456 +12345678.9012345600 12345678.9012345679 -123456789.0123456 +123456789.0123456000 123456789.0123456789 -1234567890.123456 -1234567890.123456789 +1234567890.1234560000 +1234567890.1234567890 PREHOOK: query: SELECT dec, dec + 1, dec - 1 FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision @@ -182,13 +182,13 @@ NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -0 1 -1 -0 1 -1 -0 1 -1 -0 1 -1 -0 1 -1 -0.123456789 1.123456789 -0.876543211 -0.123456789 1.123456789 -0.876543211 +0.0000000000 1.0000000000 -1.0000000000 +0.0000000000 1.0000000000 -1.0000000000 +0.0000000000 1.0000000000 -1.0000000000 +0.0000000000 1.0000000000 -1.0000000000 +0.0000000000 1.0000000000 -1.0000000000 +0.1234567890 1.1234567890 -0.8765432110 +0.1234567890 1.1234567890 -0.8765432110 1.2345678901 2.2345678901 0.2345678901 1.2345678901 2.2345678901 0.2345678901 1.2345678901 2.2345678901 0.2345678901 @@ -205,14 +205,14 @@ NULL NULL NULL 12345.6789012346 12346.6789012346 12344.6789012346 123456.7890123456 123457.7890123456 123455.7890123456 123456.7890123457 123457.7890123457 123455.7890123457 -1234567.890123456 1234568.890123456 1234566.890123456 +1234567.8901234560 1234568.8901234560 1234566.8901234560 1234567.8901234568 1234568.8901234568 1234566.8901234568 -12345678.90123456 12345679.90123456 12345677.90123456 +12345678.9012345600 12345679.9012345600 12345677.9012345600 12345678.9012345679 12345679.9012345679 12345677.9012345679 -123456789.0123456 123456790.0123456 123456788.0123456 +123456789.0123456000 123456790.0123456000 123456788.0123456000 123456789.0123456789 123456790.0123456789 123456788.0123456789 -1234567890.123456 1234567891.123456 1234567889.123456 -1234567890.123456789 1234567891.123456789 1234567889.123456789 +1234567890.1234560000 1234567891.1234560000 1234567889.1234560000 +1234567890.1234567890 1234567891.1234567890 1234567889.1234567890 PREHOOK: query: SELECT dec, dec * 2, dec / 3 FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision @@ -265,37 +265,37 @@ NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -0 0 0 -0 0 0 -0 0 0 -0 0 0 -0 0 0 -0.123456789 0.246913578 0.041152263 -0.123456789 0.246913578 0.041152263 +0.0000000000 0.0000000000 0.000000000000 +0.0000000000 0.0000000000 0.000000000000 +0.0000000000 0.0000000000 0.000000000000 +0.0000000000 0.0000000000 0.000000000000 +0.0000000000 0.0000000000 0.000000000000 +0.1234567890 0.2469135780 0.041152263000 +0.1234567890 0.2469135780 0.041152263000 1.2345678901 2.4691357802 0.411522630033 1.2345678901 2.4691357802 0.411522630033 1.2345678901 2.4691357802 0.411522630033 -12.3456789012 24.6913578024 4.1152263004 -12.3456789012 24.6913578024 4.1152263004 -12.3456789012 24.6913578024 4.1152263004 -123.4567890123 246.9135780246 41.1522630041 -123.4567890123 246.9135780246 41.1522630041 -123.4567890123 246.9135780246 41.1522630041 -1234.5678901235 2469.135780247 411.522630041167 -1234.5678901235 2469.135780247 411.522630041167 -1234.5678901235 2469.135780247 411.522630041167 +12.3456789012 24.6913578024 4.115226300400 +12.3456789012 24.6913578024 4.115226300400 +12.3456789012 24.6913578024 4.115226300400 +123.4567890123 246.9135780246 41.152263004100 +123.4567890123 246.9135780246 41.152263004100 +123.4567890123 246.9135780246 41.152263004100 +1234.5678901235 2469.1357802470 411.522630041167 +1234.5678901235 2469.1357802470 411.522630041167 +1234.5678901235 2469.1357802470 411.522630041167 12345.6789012346 24691.3578024692 4115.226300411533 12345.6789012346 24691.3578024692 4115.226300411533 -123456.7890123456 246913.5780246912 41152.2630041152 +123456.7890123456 246913.5780246912 41152.263004115200 123456.7890123457 246913.5780246914 41152.263004115233 -1234567.890123456 2469135.780246912 411522.630041152 +1234567.8901234560 2469135.7802469120 411522.630041152000 1234567.8901234568 2469135.7802469136 411522.630041152267 -12345678.90123456 24691357.80246912 4115226.30041152 +12345678.9012345600 24691357.8024691200 4115226.300411520000 12345678.9012345679 24691357.8024691358 4115226.300411522633 -123456789.0123456 246913578.0246912 41152263.0041152 -123456789.0123456789 246913578.0246913578 41152263.0041152263 -1234567890.123456 2469135780.246912 411522630.041152 -1234567890.123456789 2469135780.246913578 411522630.041152263 +123456789.0123456000 246913578.0246912000 41152263.004115200000 +123456789.0123456789 246913578.0246913578 41152263.004115226300 +1234567890.1234560000 2469135780.2469120000 411522630.041152000000 +1234567890.1234567890 2469135780.2469135780 411522630.041152263000 PREHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision @@ -348,13 +348,13 @@ NULL NULL NULL NULL NULL NULL NULL NULL -0 0 -0 0 -0 0 -0 0 -0 0 -0.123456789 0.013717421 -0.123456789 0.013717421 +0.0000000000 0.000000000000 +0.0000000000 0.000000000000 +0.0000000000 0.000000000000 +0.0000000000 0.000000000000 +0.0000000000 0.000000000000 +0.1234567890 0.013717421000 +0.1234567890 0.013717421000 1.2345678901 0.137174210011 1.2345678901 0.137174210011 1.2345678901 0.137174210011 @@ -371,14 +371,14 @@ NULL NULL 12345.6789012346 1371.742100137178 123456.7890123456 13717.421001371733 123456.7890123457 13717.421001371744 -1234567.890123456 137174.210013717333 +1234567.8901234560 137174.210013717333 1234567.8901234568 137174.210013717422 -12345678.90123456 1371742.100137173333 +12345678.9012345600 1371742.100137173333 12345678.9012345679 1371742.100137174211 -123456789.0123456 13717421.001371733333 -123456789.0123456789 13717421.0013717421 -1234567890.123456 137174210.013717333333 -1234567890.123456789 137174210.013717421 +123456789.0123456000 13717421.001371733333 +123456789.0123456789 13717421.001371742100 +1234567890.1234560000 137174210.013717333333 +1234567890.1234567890 137174210.013717421000 PREHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision @@ -431,13 +431,13 @@ NULL NULL NULL NULL NULL NULL NULL NULL -0 0 -0 0 -0 0 -0 0 -0 0 -0.123456789 0.0045724736667 -0.123456789 0.0045724736667 +0.0000000000 0.0000000000000 +0.0000000000 0.0000000000000 +0.0000000000 0.0000000000000 +0.0000000000 0.0000000000000 +0.0000000000 0.0000000000000 +0.1234567890 0.0045724736667 +0.1234567890 0.0045724736667 1.2345678901 0.0457247366704 1.2345678901 0.0457247366704 1.2345678901 0.0457247366704 @@ -454,14 +454,14 @@ NULL NULL 12345.6789012346 457.2473667123926 123456.7890123456 4572.4736671239111 123456.7890123457 4572.4736671239148 -1234567.890123456 45724.7366712391111 +1234567.8901234560 45724.7366712391111 1234567.8901234568 45724.7366712391407 -12345678.90123456 457247.3667123911111 +12345678.9012345600 457247.3667123911111 12345678.9012345679 457247.3667123914037 -123456789.0123456 4572473.6671239111111 +123456789.0123456000 4572473.6671239111111 123456789.0123456789 4572473.6671239140333 -1234567890.123456 45724736.6712391111111 -1234567890.123456789 45724736.6712391403333 +1234567890.1234560000 45724736.6712391111111 +1234567890.1234567890 45724736.6712391403333 PREHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision @@ -514,13 +514,13 @@ NULL NULL NULL NULL NULL NULL NULL NULL -0 0 -0 0 -0 0 -0 0 -0 0 -0.123456789 0.015241578750190521 -0.123456789 0.015241578750190521 +0.0000000000 0.00000000000000000000 +0.0000000000 0.00000000000000000000 +0.0000000000 0.00000000000000000000 +0.0000000000 0.00000000000000000000 +0.0000000000 0.00000000000000000000 +0.1234567890 0.01524157875019052100 +0.1234567890 0.01524157875019052100 1.2345678901 1.52415787526596567801 1.2345678901 1.52415787526596567801 1.2345678901 1.52415787526596567801 @@ -537,14 +537,14 @@ NULL NULL 12345.6789012346 152415787.53238916034140423716 123456.7890123456 15241578753.23881726870921383936 123456.7890123457 15241578753.23884196006701630849 -1234567.890123456 1524157875323.881726870921383936 +1234567.8901234560 1524157875323.88172687092138393600 1234567.8901234568 1524157875323.88370217954558146624 -12345678.90123456 152415787532388.1726870921383936 +12345678.9012345600 152415787532388.17268709213839360000 12345678.9012345679 152415787532388.36774881877789971041 -123456789.0123456 15241578753238817.26870921383936 +123456789.0123456000 15241578753238817.26870921383936000000 123456789.0123456789 15241578753238836.75019051998750190521 -1234567890.123456 NULL -1234567890.123456789 NULL +1234567890.1234560000 NULL +1234567890.1234567890 NULL PREHOOK: query: EXPLAIN SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT avg(dec), sum(dec) FROM DECIMAL_PRECISION @@ -643,7 +643,7 @@ POSTHOOK: query: SELECT MIN(cast('12345678901234567890.12345678' as decimal(38,1 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_precision #### A masked pattern was here #### -12345678901234567890.12345678 +12345678901234567890.123456780000000000 PREHOOK: query: SELECT COUNT(cast('12345678901234567890.12345678' as decimal(38,18))) FROM DECIMAL_PRECISION PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision
http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/tez/vector_decimal_round_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_decimal_round_2.q.out b/ql/src/test/results/clientpositive/tez/vector_decimal_round_2.q.out index edde023..8336999 100644 --- a/ql/src/test/results/clientpositive/tez/vector_decimal_round_2.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_decimal_round_2.q.out @@ -25,7 +25,7 @@ POSTHOOK: query: select * from decimal_tbl_1_orc POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_tbl_1_orc #### A masked pattern was here #### -55555 +55555.000000000000000000 PREHOOK: query: -- EXPLAIN -- SELECT dec, round(null), round(null, 0), round(125, null), -- round(1.0/0.0, 0), round(power(-1.0,0.5), 0) @@ -121,7 +121,7 @@ FROM decimal_tbl_1_orc ORDER BY d POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_tbl_1_orc #### A masked pattern was here #### -55555 55555 55555 55555 55555 55560 55600 56000 60000 100000 0 0 0 +55555 55555 55555.0 55555.00 55555.000 55560 55600 56000 60000 100000 0 0 0 PREHOOK: query: create table decimal_tbl_2_orc (pos decimal(38,18), neg decimal(38,18)) STORED AS ORC PREHOOK: type: CREATETABLE @@ -150,7 +150,7 @@ POSTHOOK: query: select * from decimal_tbl_2_orc POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_tbl_2_orc #### A masked pattern was here #### -125.315 -125.315 +125.315000000000000000 -125.315000000000000000 PREHOOK: query: EXPLAIN SELECT round(pos) as p, round(pos, 0), @@ -240,7 +240,7 @@ FROM decimal_tbl_2_orc ORDER BY p POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_tbl_2_orc #### A masked pattern was here #### -125 125 125.3 125.32 125.315 125.315 130 100 0 0 -125 -125 -125.3 -125.32 -125.315 -125.315 -130 -100 0 0 +125 125 125.3 125.32 125.315 125.3150 130 100 0 0 -125 -125 -125.3 -125.32 -125.315 -125.3150 -130 -100 0 0 PREHOOK: query: create table decimal_tbl_3_orc (dec decimal(38,18)) STORED AS ORC PREHOOK: type: CREATETABLE @@ -268,7 +268,7 @@ POSTHOOK: query: select * from decimal_tbl_3_orc POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_tbl_3_orc #### A masked pattern was here #### -3.141592653589793 +3.141592653589793000 PREHOOK: query: EXPLAIN SELECT round(dec, -15) as d, round(dec, -16), @@ -402,7 +402,7 @@ FROM decimal_tbl_3_orc ORDER BY d POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_tbl_3_orc #### A masked pattern was here #### -0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3.1 3.14 3.142 3.1416 3.14159 3.141593 3.1415927 3.14159265 3.141592654 3.1415926536 3.14159265359 3.14159265359 3.1415926535898 3.1415926535898 3.14159265358979 3.141592653589793 3.141592653589793 +0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 3.1 3.14 3.142 3.1416 3.14159 3.141593 3.1415927 3.14159265 3.141592654 3.1415926536 3.14159265359 3.141592653590 3.1415926535898 3.1415926535898 3.14159265358979 3.141592653589793 3.1415926535897930 PREHOOK: query: create table decimal_tbl_4_orc (pos decimal(38,18), neg decimal(38,18)) STORED AS ORC PREHOOK: type: CREATETABLE @@ -431,7 +431,7 @@ POSTHOOK: query: select * from decimal_tbl_4_orc POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_tbl_4_orc #### A masked pattern was here #### -1809242.3151111344 -1809242.3151111344 +1809242.315111134400000000 -1809242.315111134400000000 PREHOOK: query: EXPLAIN SELECT round(pos, 9) as p, round(neg, 9), round(1809242.3151111344BD, 9), round(-1809242.3151111344BD, 9) FROM decimal_tbl_4_orc ORDER BY p http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/tez/vector_decimal_trailing.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_decimal_trailing.q.out b/ql/src/test/results/clientpositive/tez/vector_decimal_trailing.q.out index ffdb1c9..7dea1a2 100644 --- a/ql/src/test/results/clientpositive/tez/vector_decimal_trailing.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_decimal_trailing.q.out @@ -73,16 +73,16 @@ POSTHOOK: query: SELECT * FROM DECIMAL_TRAILING ORDER BY id POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_trailing #### A masked pattern was here #### -0 0 0 -1 0 0 +0 0.0000 0.00000000 +1 0.0000 0.00000000 2 NULL NULL -3 1 1 -4 10 10 -5 100 100 -6 1000 1000 -7 10000 10000 -8 100000 100000 -9 NULL 1000000 +3 1.0000 1.00000000 +4 10.0000 10.00000000 +5 100.0000 100.00000000 +6 1000.0000 1000.00000000 +7 10000.0000 10000.00000000 +8 100000.0000 100000.00000000 +9 NULL 1000000.00000000 10 NULL NULL 11 NULL NULL 12 NULL NULL @@ -91,18 +91,18 @@ POSTHOOK: Input: default@decimal_trailing 15 NULL NULL 16 NULL NULL 17 NULL NULL -18 1 1 -19 10 10 -20 100 100 -21 1000 1000 -22 100000 10000 -23 0 0 -24 0 0 -25 0 0 -26 0 0 -27 0 0 -28 12313.2 134134.312525 -29 99999.999 134134.31242553 +18 1.0000 1.00000000 +19 10.0000 10.00000000 +20 100.0000 100.00000000 +21 1000.0000 1000.00000000 +22 100000.0000 10000.00000000 +23 0.0000 0.00000000 +24 0.0000 0.00000000 +25 0.0000 0.00000000 +26 0.0000 0.00000000 +27 0.0000 0.00000000 +28 12313.2000 134134.31252500 +29 99999.9990 134134.31242553 PREHOOK: query: DROP TABLE DECIMAL_TRAILING_txt PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_trailing_txt http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out b/ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out index cc22a56..6df956d 100644 --- a/ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out @@ -95,44 +95,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 @@ -178,44 +178,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 @@ -429,44 +429,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 @@ -512,44 +512,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 @@ -763,42 +763,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 @@ -849,29 +849,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 @@ -917,44 +917,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 @@ -1268,40 +1268,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 @@ -1350,30 +1350,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 @@ -1576,44 +1576,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 @@ -1700,23 +1700,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 @@ -1764,44 +1764,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 @@ -1831,44 +1831,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 @@ -2086,42 +2086,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 @@ -2255,44 +2255,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 @@ -2596,7 +2596,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 @@ -2663,7 +2663,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/tez/vector_reduce_groupby_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out b/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out index 1cd5959..337d83f 100644 --- a/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out @@ -111,56 +111,56 @@ LIMIT 50 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_test #### A masked pattern was here #### --1073051226 -7382.0 -4409.2486486486 -5280.969230769231 -4409.2486486486 --1072081801 8373.0 5001.1702702703 5989.915384615385 5001.1702702703 --1072076362 -5470.0 -3267.2162162162 -3913.1538461538466 -3267.2162162162 --1070883071 -741.0 -442.5972972973 -530.1 -442.5972972973 --1070551679 -947.0 -565.6405405405 -677.4692307692308 -565.6405405405 --1069512165 11417.0 6819.3432432432 8167.546153846154 6819.3432432432 --1069109166 8390.0 5011.3243243243 6002.076923076923 5011.3243243243 --1068623584 -14005.0 -8365.1486486486 -10018.961538461539 -8365.1486486486 --1067386090 -3977.0 -2375.4513513514 -2845.084615384616 -2375.4513513514 --1066922682 -9987.0 -5965.2081081081 -7144.546153846154 -5965.2081081081 --1066226047 -9439.0 -5637.8891891892 -6752.515384615385 -5637.8891891892 --1065117869 2538.0 1515.9405405405 1815.646153846154 1515.9405405405 --1064949302 6454.0 3854.9567567568 4617.092307692308 3854.9567567568 --1063498122 -11480.0 -6856.972972973 -8212.615384615387 -6856.972972973 --1062973443 10541.0 6296.1108108108 7540.869230769231 6296.1108108108 --1061614989 -4234.0 -2528.9567567568 -3028.938461538462 -2528.9567567568 --1061057428 -1085.0 -648.0675675676 -776.1923076923077 -648.0675675676 --1059941909 8782.0 5245.4648648649 6282.507692307693 5245.4648648649 --1059338191 7322.0 4373.4108108108 5238.046153846154 4373.4108108108 --1059047258 12452.0 7437.5459459459 8907.969230769231 7437.5459459459 --1056684111 13991.0 8356.7864864865 10008.946153846155 8356.7864864865 --1055945837 13690.0 8177 9793.615384615387 8177 --1055669248 2570.0 1535.0540540541 1838.538461538462 1535.0540540541 --1055316250 -14990.0 -8953.4864864865 -10723.615384615385 -8953.4864864865 --1053385587 14504.0 8663.2 10375.938461538462 8663.2 --1053238077 -3704.0 -2212.3891891892 -2649.784615384616 -2212.3891891892 --1052745800 -12404.0 -7408.8756756757 -8873.630769230771 -7408.8756756757 --1052322972 -7433.0 -4439.7108108108 -5317.453846153847 -4439.7108108108 --1050684541 -8261.0 -4934.272972973 -5909.792307692308 -4934.272972973 --1050657303 -6999.0 -4180.4837837838 -5006.976923076923 -4180.4837837838 --1050165799 8634.0 5157.0648648649 6176.63076923077 5157.0648648649 +-1073051226 -7382.0 -4409.2486486486 -5280.96923076923100 -4409.2486486486 +-1072081801 8373.0 5001.1702702703 5989.91538461538500 5001.1702702703 +-1072076362 -5470.0 -3267.2162162162 -3913.15384615384660 -3267.2162162162 +-1070883071 -741.0 -442.5972972973 -530.10000000000000 -442.5972972973 +-1070551679 -947.0 -565.6405405405 -677.46923076923080 -565.6405405405 +-1069512165 11417.0 6819.3432432432 8167.54615384615400 6819.3432432432 +-1069109166 8390.0 5011.3243243243 6002.07692307692300 5011.3243243243 +-1068623584 -14005.0 -8365.1486486486 -10018.96153846153900 -8365.1486486486 +-1067386090 -3977.0 -2375.4513513514 -2845.08461538461600 -2375.4513513514 +-1066922682 -9987.0 -5965.2081081081 -7144.54615384615400 -5965.2081081081 +-1066226047 -9439.0 -5637.8891891892 -6752.51538461538500 -5637.8891891892 +-1065117869 2538.0 1515.9405405405 1815.64615384615400 1515.9405405405 +-1064949302 6454.0 3854.9567567568 4617.09230769230800 3854.9567567568 +-1063498122 -11480.0 -6856.9729729730 -8212.61538461538700 -6856.9729729730 +-1062973443 10541.0 6296.1108108108 7540.86923076923100 6296.1108108108 +-1061614989 -4234.0 -2528.9567567568 -3028.93846153846200 -2528.9567567568 +-1061057428 -1085.0 -648.0675675676 -776.19230769230770 -648.0675675676 +-1059941909 8782.0 5245.4648648649 6282.50769230769300 5245.4648648649 +-1059338191 7322.0 4373.4108108108 5238.04615384615400 4373.4108108108 +-1059047258 12452.0 7437.5459459459 8907.96923076923100 7437.5459459459 +-1056684111 13991.0 8356.7864864865 10008.94615384615500 8356.7864864865 +-1055945837 13690.0 8177.0000000000 9793.61538461538700 8177.0000000000 +-1055669248 2570.0 1535.0540540541 1838.53846153846200 1535.0540540541 +-1055316250 -14990.0 -8953.4864864865 -10723.61538461538500 -8953.4864864865 +-1053385587 14504.0 8663.2000000000 10375.93846153846200 8663.2000000000 +-1053238077 -3704.0 -2212.3891891892 -2649.78461538461600 -2212.3891891892 +-1052745800 -12404.0 -7408.8756756757 -8873.63076923077100 -7408.8756756757 +-1052322972 -7433.0 -4439.7108108108 -5317.45384615384700 -4439.7108108108 +-1050684541 -8261.0 -4934.2729729730 -5909.79230769230800 -4934.2729729730 +-1050657303 -6999.0 -4180.4837837838 -5006.97692307692300 -4180.4837837838 +-1050165799 8634.0 5157.0648648649 6176.63076923077000 5157.0648648649 -1048934049 -524.0 -312.9837837838 -374.86153846153854 -312.9837837838 --1046399794 4130.0 2466.8378378378 2954.5384615384614 2466.8378378378 --1045867222 -8034.0 -4798.6864864865 -5747.400000000001 -4798.6864864865 --1045196363 -5039.0 -3009.7810810811 -3604.823076923077 -3009.7810810811 --1045181724 -5706.0 -3408.1783783784 -4081.9846153846156 -3408.1783783784 --1045087657 -5865.0 -3503.1486486486 -4195.7307692307695 -3503.1486486486 --1044207190 5381.0 3214.0567567568 3849.4846153846156 3214.0567567568 --1044093617 -3422.0 -2043.9513513514 -2448.046153846154 -2043.9513513514 --1043573508 16216.0 9685.772972973 11600.676923076924 9685.772972973 --1043132597 12302.0 7347.9513513514 8800.66153846154 7347.9513513514 --1043082182 9180.0 5483.1891891892 6567.2307692307695 5483.1891891892 --1042805968 5133.0 3065.927027027 3672.0692307692307 3065.927027027 --1042712895 9296.0 5552.4756756757 6650.215384615385 5552.4756756757 --1042396242 9583.0 5723.9 6855.53076923077 5723.9 --1041734429 -836.0 -499.3405405405 -598.0615384615385 -499.3405405405 --1041391389 -12970.0 -7746.9459459459 -9278.538461538463 -7746.9459459459 --1041252354 756.0 451.5567567568 540.8307692307692 451.5567567568 --1039776293 13704.0 8185.3621621622 9803.630769230771 8185.3621621622 --1039762548 -3802.0 -2270.9243243243 -2719.8923076923083 -2270.9243243243 +-1046399794 4130.0 2466.8378378378 2954.53846153846140 2466.8378378378 +-1045867222 -8034.0 -4798.6864864865 -5747.40000000000100 -4798.6864864865 +-1045196363 -5039.0 -3009.7810810811 -3604.82307692307700 -3009.7810810811 +-1045181724 -5706.0 -3408.1783783784 -4081.98461538461560 -3408.1783783784 +-1045087657 -5865.0 -3503.1486486486 -4195.73076923076950 -3503.1486486486 +-1044207190 5381.0 3214.0567567568 3849.48461538461560 3214.0567567568 +-1044093617 -3422.0 -2043.9513513514 -2448.04615384615400 -2043.9513513514 +-1043573508 16216.0 9685.7729729730 11600.67692307692400 9685.7729729730 +-1043132597 12302.0 7347.9513513514 8800.66153846154000 7347.9513513514 +-1043082182 9180.0 5483.1891891892 6567.23076923076950 5483.1891891892 +-1042805968 5133.0 3065.9270270270 3672.06923076923070 3065.9270270270 +-1042712895 9296.0 5552.4756756757 6650.21538461538500 5552.4756756757 +-1042396242 9583.0 5723.9000000000 6855.53076923077000 5723.9000000000 +-1041734429 -836.0 -499.3405405405 -598.06153846153850 -499.3405405405 +-1041391389 -12970.0 -7746.9459459459 -9278.53846153846300 -7746.9459459459 +-1041252354 756.0 451.5567567568 540.83076923076920 451.5567567568 +-1039776293 13704.0 8185.3621621622 9803.63076923077100 8185.3621621622 +-1039762548 -3802.0 -2270.9243243243 -2719.89230769230830 -2270.9243243243 PREHOOK: query: SELECT sum(hash(*)) FROM (SELECT cint, cdouble, cdecimal1, cdecimal2, min(cdecimal1) as min_decimal1 FROM decimal_test WHERE cdecimal1 is not null and cdecimal2 is not null http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/update_all_types.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/update_all_types.q.out b/ql/src/test/results/clientpositive/update_all_types.q.out index 1cfa088..c5c1abb 100644 --- a/ql/src/test/results/clientpositive/update_all_types.q.out +++ b/ql/src/test/results/clientpositive/update_all_types.q.out @@ -96,11 +96,11 @@ POSTHOOK: query: select * from acid_uat order by i POSTHOOK: type: QUERY POSTHOOK: Input: default@acid_uat #### A masked pattern was here #### --51 NULL -1071480828 -1071480828 -1401575336 -51.0 NULL -51 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true -11 NULL -1069736047 -1069736047 -453772520 11.0 NULL 11 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true -11 NULL -1072910839 -1072910839 2048385991 11.0 NULL 11 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false -11 NULL -1073279343 -1073279343 -1595604468 11.0 NULL 11 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true -8 NULL -1071363017 -1071363017 1349676361 8.0 NULL 8 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true +-51 NULL -1071480828 -1071480828 -1401575336 -51.0 NULL -51.00 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true +11 NULL -1069736047 -1069736047 -453772520 11.0 NULL 11.00 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true +11 NULL -1072910839 -1072910839 2048385991 11.0 NULL 11.00 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false +11 NULL -1073279343 -1073279343 -1595604468 11.0 NULL 11.00 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true +8 NULL -1071363017 -1071363017 1349676361 8.0 NULL 8.00 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true NULL -5470 -1072076362 -1072076362 1864027286 NULL -5470.0 NULL NULL 1969-12-31 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true NULL -7382 -1073051226 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1969-12-31 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false NULL -741 -1070883071 -1070883071 -1645852809 NULL -741.0 NULL NULL 1969-12-31 0ruyd6Y50JpdGRf6HqD 0ruyd6Y50JpdGRf6HqD xH7445Rals48VOulSyR5F false @@ -150,12 +150,12 @@ POSTHOOK: query: select * from acid_uat order by i POSTHOOK: type: QUERY POSTHOOK: Input: default@acid_uat #### A masked pattern was here #### --51 NULL -1071480828 -1071480828 -1401575336 -51.0 NULL -51 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true +-51 NULL -1071480828 -1071480828 -1401575336 -51.0 NULL -51.00 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true 1 2 -1070883071 3 4 3.14 6.28 5.99 NULL 2014-09-01 its a beautiful day in the neighbhorhood a beautiful day for a neighbor wont you be mine true -11 NULL -1069736047 -1069736047 -453772520 11.0 NULL 11 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true -11 NULL -1072910839 -1072910839 2048385991 11.0 NULL 11 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false -11 NULL -1073279343 -1073279343 -1595604468 11.0 NULL 11 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true -8 NULL -1071363017 -1071363017 1349676361 8.0 NULL 8 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true +11 NULL -1069736047 -1069736047 -453772520 11.0 NULL 11.00 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true +11 NULL -1072910839 -1072910839 2048385991 11.0 NULL 11.00 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false +11 NULL -1073279343 -1073279343 -1595604468 11.0 NULL 11.00 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true +8 NULL -1071363017 -1071363017 1349676361 8.0 NULL 8.00 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true NULL -5470 -1072076362 -1072076362 1864027286 NULL -5470.0 NULL NULL 1969-12-31 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true NULL -7382 -1073051226 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1969-12-31 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false NULL -947 -1070551679 -1070551679 1864027286 NULL -947.0 NULL NULL 1969-12-31 iUR3Q iUR3Q 4KWs6gw7lv2WYd66P false @@ -184,12 +184,12 @@ POSTHOOK: query: select * from acid_uat order by i POSTHOOK: type: QUERY POSTHOOK: Input: default@acid_uat #### A masked pattern was here #### --102 -51 -1071480828 -1071480828 -1401575336 -51.0 -51.0 -51 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true +-102 -51 -1071480828 -1071480828 -1401575336 -51.0 -51.0 -51.00 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true 1 2 -1070883071 3 4 3.14 6.28 5.99 NULL 2014-09-01 its a beautiful day in the neighbhorhood a beautiful day for a neighbor wont you be mine true -11 NULL -1069736047 -1069736047 -453772520 11.0 NULL 11 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true -11 NULL -1072910839 -1072910839 2048385991 11.0 NULL 11 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false -11 NULL -1073279343 -1073279343 -1595604468 11.0 NULL 11 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true -8 NULL -1071363017 -1071363017 1349676361 8.0 NULL 8 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true +11 NULL -1069736047 -1069736047 -453772520 11.0 NULL 11.00 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true +11 NULL -1072910839 -1072910839 2048385991 11.0 NULL 11.00 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false +11 NULL -1073279343 -1073279343 -1595604468 11.0 NULL 11.00 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true +8 NULL -1071363017 -1071363017 1349676361 8.0 NULL 8.00 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true NULL -5470 -1072076362 -1072076362 1864027286 NULL -5470.0 NULL NULL 1969-12-31 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true NULL -7382 -1073051226 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1969-12-31 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false NULL -947 -1070551679 -1070551679 1864027286 NULL -947.0 NULL NULL 1969-12-31 iUR3Q iUR3Q 4KWs6gw7lv2WYd66P false http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/vector_aggregate_9.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_aggregate_9.q.out b/ql/src/test/results/clientpositive/vector_aggregate_9.q.out index 72dc004..e0cf903 100644 --- a/ql/src/test/results/clientpositive/vector_aggregate_9.q.out +++ b/ql/src/test/results/clientpositive/vector_aggregate_9.q.out @@ -164,4 +164,4 @@ select min(dc), max(dc), sum(dc), avg(dc) from vectortab2korc POSTHOOK: type: QUERY POSTHOOK: Input: default@vectortab2korc #### A masked pattern was here #### --4997414117561.546875 4994550248722.298828 -10252745435816.02441 -5399023399.587163986308583465 +-4997414117561.546875000000000000 4994550248722.298828000000000000 -10252745435816.024410000000000000 -5399023399.587163986308583465 http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/vector_between_in.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_between_in.q.out b/ql/src/test/results/clientpositive/vector_between_in.q.out index a9b9a4b..b80da1b 100644 --- a/ql/src/test/results/clientpositive/vector_between_in.q.out +++ b/ql/src/test/results/clientpositive/vector_between_in.q.out @@ -594,34 +594,34 @@ POSTHOOK: Input: default@decimal_date_test -18.5162162162 -17.3216216216 -16.7243243243 --16.127027027 +-16.1270270270 -15.5297297297 -10.7513513514 -9.5567567568 -8.3621621622 --5.972972973 +-5.9729729730 -3.5837837838 4.1810810811 4.7783783784 4.7783783784 5.3756756757 -5.972972973 -5.972972973 +5.9729729730 +5.9729729730 11.3486486486 11.3486486486 11.9459459459 14.9324324324 19.1135135135 20.3081081081 -22.1 +22.1000000000 24.4891891892 33.4486486486 34.6432432432 40.0189189189 42.4081081081 43.0054054054 -44.2 -44.2 +44.2000000000 +44.2000000000 44.7972972973 45.9918918919 PREHOOK: query: SELECT COUNT(*) FROM decimal_date_test WHERE cdecimal1 NOT BETWEEN -2000 AND 4390.1351351351 http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.7.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.7.out b/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.7.out index 9edd6f1..e5d56ec 100644 --- a/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.7.out +++ b/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.7.out @@ -207,13 +207,13 @@ POSTHOOK: query: SELECT POSTHOOK: type: QUERY POSTHOOK: Input: default@over1korc #### A masked pattern was here #### -65536 50.0 50.0 50 -65537 50.0 50.0 50 -65538 50.0 50.0 50 -65539 50.0 50.0 50 -65540 50.0 50.0 50 -65541 50.0 50.0 50 -65542 50.0 50.0 50 -65543 50.0 50.0 50 -65544 50.0 50.0 50 -65545 50.0 50.0 50 +65536 50.0 50.0 50.0000 +65537 50.0 50.0 50.0000 +65538 50.0 50.0 50.0000 +65539 50.0 50.0 50.0000 +65540 50.0 50.0 50.0000 +65541 50.0 50.0 50.0000 +65542 50.0 50.0 50.0000 +65543 50.0 50.0 50.0000 +65544 50.0 50.0 50.0000 +65545 50.0 50.0 50.0000 http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/vector_data_types.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_data_types.q.out b/ql/src/test/results/clientpositive/vector_data_types.q.out index 3ed833b..86f1677 100644 --- a/ql/src/test/results/clientpositive/vector_data_types.q.out +++ b/ql/src/test/results/clientpositive/vector_data_types.q.out @@ -153,7 +153,7 @@ POSTHOOK: Input: default@over1korc #### A masked pattern was here #### NULL 374 65560 4294967516 65.43 22.48 true oscar quirinius 2013-03-01 09:11:58.703316 16.86 mathematics NULL 409 65536 4294967490 46.97 25.92 false fred miller 2013-03-01 09:11:58.703116 33.45 history -NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.8 mathematics +NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.80 mathematics -3 275 65622 4294967302 71.78 8.49 false wendy robinson 2013-03-01 09:11:58.703294 95.39 undecided -3 344 65733 4294967363 0.56 11.96 true rachel thompson 2013-03-01 09:11:58.703276 88.46 wind surfing -3 376 65548 4294967431 96.78 43.23 false fred ellison 2013-03-01 09:11:58.703233 75.39 education @@ -239,7 +239,7 @@ POSTHOOK: Input: default@over1korc #### A masked pattern was here #### NULL 374 65560 4294967516 65.43 22.48 true oscar quirinius 2013-03-01 09:11:58.703316 16.86 mathematics NULL 409 65536 4294967490 46.97 25.92 false fred miller 2013-03-01 09:11:58.703116 33.45 history -NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.8 mathematics +NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.80 mathematics -3 275 65622 4294967302 71.78 8.49 false wendy robinson 2013-03-01 09:11:58.703294 95.39 undecided -3 344 65733 4294967363 0.56 11.96 true rachel thompson 2013-03-01 09:11:58.703276 88.46 wind surfing -3 376 65548 4294967431 96.78 43.23 false fred ellison 2013-03-01 09:11:58.703233 75.39 education http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/vector_decimal_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_2.q.out b/ql/src/test/results/clientpositive/vector_decimal_2.q.out index 8a4d53a..ff82f38 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_2.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_2.q.out @@ -1051,7 +1051,7 @@ POSTHOOK: query: select cast(cast('2012-12-19 11:12:19.1234567' as timestamp) as POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_2 #### A masked pattern was here #### -1355944339.1234567 +1355944339.12345670 PREHOOK: query: explain select cast(true as decimal) as c from decimal_2 order by c PREHOOK: type: QUERY @@ -1406,7 +1406,7 @@ POSTHOOK: query: select cast(0.99999999999999999999 as decimal(20,19)) as c from POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_2 #### A masked pattern was here #### -1 +1.0000000000000000000 PREHOOK: query: explain select cast('0.99999999999999999999' as decimal(20,20)) as c from decimal_2 order by c PREHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/vector_decimal_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_3.q.out b/ql/src/test/results/clientpositive/vector_decimal_3.q.out index 75f872e..eea91bb 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_3.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_3.q.out @@ -47,43 +47,43 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### NULL 0 --1234567890.123456789 -1234567890 --4400 4400 --1255.49 -1255 --1.122 -11 --1.12 -1 --1.12 -1 --0.333 0 --0.33 0 --0.3 0 -0 0 -0 0 -0 0 -0.01 0 -0.02 0 -0.1 0 -0.2 0 -0.3 0 -0.33 0 -0.333 0 -1 1 -1 1 -1 1 -1.12 1 -1.122 1 -2 2 -2 2 -3.14 3 -3.14 3 -3.14 3 -3.14 4 -10 10 -20 20 -100 100 -124 124 -125.2 125 -200 200 -1234567890.12345678 1234567890 +-1234567890.123456789000000000 -1234567890 +-4400.000000000000000000 4400 +-1255.490000000000000000 -1255 +-1.122000000000000000 -11 +-1.120000000000000000 -1 +-1.120000000000000000 -1 +-0.333000000000000000 0 +-0.330000000000000000 0 +-0.300000000000000000 0 +0.000000000000000000 0 +0.000000000000000000 0 +0.000000000000000000 0 +0.010000000000000000 0 +0.020000000000000000 0 +0.100000000000000000 0 +0.200000000000000000 0 +0.300000000000000000 0 +0.330000000000000000 0 +0.333000000000000000 0 +1.000000000000000000 1 +1.000000000000000000 1 +1.000000000000000000 1 +1.120000000000000000 1 +1.122000000000000000 1 +2.000000000000000000 2 +2.000000000000000000 2 +3.140000000000000000 3 +3.140000000000000000 3 +3.140000000000000000 3 +3.140000000000000000 4 +10.000000000000000000 10 +20.000000000000000000 20 +100.000000000000000000 100 +124.000000000000000000 124 +125.200000000000000000 125 +200.000000000000000000 200 +1234567890.123456780000000000 1234567890 PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key DESC, value DESC PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -92,43 +92,43 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key DESC, value DESC POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### -1234567890.12345678 1234567890 -200 200 -125.2 125 -124 124 -100 100 -20 20 -10 10 -3.14 4 -3.14 3 -3.14 3 -3.14 3 -2 2 -2 2 -1.122 1 -1.12 1 -1 1 -1 1 -1 1 -0.333 0 -0.33 0 -0.3 0 -0.2 0 -0.1 0 -0.02 0 -0.01 0 -0 0 -0 0 -0 0 --0.3 0 --0.33 0 --0.333 0 --1.12 -1 --1.12 -1 --1.122 -11 --1255.49 -1255 --4400 4400 --1234567890.123456789 -1234567890 +1234567890.123456780000000000 1234567890 +200.000000000000000000 200 +125.200000000000000000 125 +124.000000000000000000 124 +100.000000000000000000 100 +20.000000000000000000 20 +10.000000000000000000 10 +3.140000000000000000 4 +3.140000000000000000 3 +3.140000000000000000 3 +3.140000000000000000 3 +2.000000000000000000 2 +2.000000000000000000 2 +1.122000000000000000 1 +1.120000000000000000 1 +1.000000000000000000 1 +1.000000000000000000 1 +1.000000000000000000 1 +0.333000000000000000 0 +0.330000000000000000 0 +0.300000000000000000 0 +0.200000000000000000 0 +0.100000000000000000 0 +0.020000000000000000 0 +0.010000000000000000 0 +0.000000000000000000 0 +0.000000000000000000 0 +0.000000000000000000 0 +-0.300000000000000000 0 +-0.330000000000000000 0 +-0.333000000000000000 0 +-1.120000000000000000 -1 +-1.120000000000000000 -1 +-1.122000000000000000 -11 +-1255.490000000000000000 -1255 +-4400.000000000000000000 4400 +-1234567890.123456789000000000 -1234567890 NULL 0 PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key, value PREHOOK: type: QUERY @@ -139,43 +139,43 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### NULL 0 --1234567890.123456789 -1234567890 --4400 4400 --1255.49 -1255 --1.122 -11 --1.12 -1 --1.12 -1 --0.333 0 --0.33 0 --0.3 0 -0 0 -0 0 -0 0 -0.01 0 -0.02 0 -0.1 0 -0.2 0 -0.3 0 -0.33 0 -0.333 0 -1 1 -1 1 -1 1 -1.12 1 -1.122 1 -2 2 -2 2 -3.14 3 -3.14 3 -3.14 3 -3.14 4 -10 10 -20 20 -100 100 -124 124 -125.2 125 -200 200 -1234567890.12345678 1234567890 +-1234567890.123456789000000000 -1234567890 +-4400.000000000000000000 4400 +-1255.490000000000000000 -1255 +-1.122000000000000000 -11 +-1.120000000000000000 -1 +-1.120000000000000000 -1 +-0.333000000000000000 0 +-0.330000000000000000 0 +-0.300000000000000000 0 +0.000000000000000000 0 +0.000000000000000000 0 +0.000000000000000000 0 +0.010000000000000000 0 +0.020000000000000000 0 +0.100000000000000000 0 +0.200000000000000000 0 +0.300000000000000000 0 +0.330000000000000000 0 +0.333000000000000000 0 +1.000000000000000000 1 +1.000000000000000000 1 +1.000000000000000000 1 +1.120000000000000000 1 +1.122000000000000000 1 +2.000000000000000000 2 +2.000000000000000000 2 +3.140000000000000000 3 +3.140000000000000000 3 +3.140000000000000000 3 +3.140000000000000000 4 +10.000000000000000000 10 +20.000000000000000000 20 +100.000000000000000000 100 +124.000000000000000000 124 +125.200000000000000000 125 +200.000000000000000000 200 +1234567890.123456780000000000 1234567890 PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_3 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -185,34 +185,34 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### NULL --1234567890.123456789 --4400 --1255.49 --1.122 --1.12 --0.333 --0.33 --0.3 -0 -0.01 -0.02 -0.1 -0.2 -0.3 -0.33 -0.333 -1 -1.12 -1.122 -2 -3.14 -10 -20 -100 -124 -125.2 -200 -1234567890.12345678 +-1234567890.123456789000000000 +-4400.000000000000000000 +-1255.490000000000000000 +-1.122000000000000000 +-1.120000000000000000 +-0.333000000000000000 +-0.330000000000000000 +-0.300000000000000000 +0.000000000000000000 +0.010000000000000000 +0.020000000000000000 +0.100000000000000000 +0.200000000000000000 +0.300000000000000000 +0.330000000000000000 +0.333000000000000000 +1.000000000000000000 +1.120000000000000000 +1.122000000000000000 +2.000000000000000000 +3.140000000000000000 +10.000000000000000000 +20.000000000000000000 +100.000000000000000000 +124.000000000000000000 +125.200000000000000000 +200.000000000000000000 +1234567890.123456780000000000 PREHOOK: query: SELECT key, sum(value) FROM DECIMAL_3 GROUP BY key ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -222,34 +222,34 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### NULL 0 --1234567890.123456789 -1234567890 --4400 4400 --1255.49 -1255 --1.122 -11 --1.12 -2 --0.333 0 --0.33 0 --0.3 0 -0 0 -0.01 0 -0.02 0 -0.1 0 -0.2 0 -0.3 0 -0.33 0 -0.333 0 -1 3 -1.12 1 -1.122 1 -2 4 -3.14 13 -10 10 -20 20 -100 100 -124 124 -125.2 125 -200 200 -1234567890.12345678 1234567890 +-1234567890.123456789000000000 -1234567890 +-4400.000000000000000000 4400 +-1255.490000000000000000 -1255 +-1.122000000000000000 -11 +-1.120000000000000000 -2 +-0.333000000000000000 0 +-0.330000000000000000 0 +-0.300000000000000000 0 +0.000000000000000000 0 +0.010000000000000000 0 +0.020000000000000000 0 +0.100000000000000000 0 +0.200000000000000000 0 +0.300000000000000000 0 +0.330000000000000000 0 +0.333000000000000000 0 +1.000000000000000000 3 +1.120000000000000000 1 +1.122000000000000000 1 +2.000000000000000000 4 +3.140000000000000000 13 +10.000000000000000000 10 +20.000000000000000000 20 +100.000000000000000000 100 +124.000000000000000000 124 +125.200000000000000000 125 +200.000000000000000000 200 +1234567890.123456780000000000 1234567890 PREHOOK: query: SELECT value, sum(key) FROM DECIMAL_3 GROUP BY value ORDER BY value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -258,23 +258,23 @@ POSTHOOK: query: SELECT value, sum(key) FROM DECIMAL_3 GROUP BY value ORDER BY v POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### --1234567890 -1234567890.123456789 --1255 -1255.49 --11 -1.122 --1 -2.24 -0 0.33 -1 5.242 -2 4 -3 9.42 -4 3.14 -10 10 -20 20 -100 100 -124 124 -125 125.2 -200 200 -4400 -4400 -1234567890 1234567890.12345678 +-1234567890 -1234567890.123456789000000000 +-1255 -1255.490000000000000000 +-11 -1.122000000000000000 +-1 -2.240000000000000000 +0 0.330000000000000000 +1 5.242000000000000000 +2 4.000000000000000000 +3 9.420000000000000000 +4 3.140000000000000000 +10 10.000000000000000000 +20 20.000000000000000000 +100 100.000000000000000000 +124 124.000000000000000000 +125 125.200000000000000000 +200 200.000000000000000000 +4400 -4400.000000000000000000 +1234567890 1234567890.123456780000000000 PREHOOK: query: SELECT * FROM DECIMAL_3 a JOIN DECIMAL_3 b ON (a.key = b.key) ORDER BY a.key, a.value, b.value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -283,71 +283,71 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3 a JOIN DECIMAL_3 b ON (a.key = b.key) O POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### --1234567890.123456789 -1234567890 -1234567890.123456789 -1234567890 --4400 4400 -4400 4400 --1255.49 -1255 -1255.49 -1255 --1.122 -11 -1.122 -11 --1.12 -1 -1.12 -1 --1.12 -1 -1.12 -1 --1.12 -1 -1.12 -1 --1.12 -1 -1.12 -1 --0.333 0 -0.333 0 --0.33 0 -0.33 0 --0.3 0 -0.3 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 -0.01 0 0.01 0 -0.02 0 0.02 0 -0.1 0 0.1 0 -0.2 0 0.2 0 -0.3 0 0.3 0 -0.33 0 0.33 0 -0.333 0 0.333 0 -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 1 -1.12 1 1.12 1 -1.122 1 1.122 1 -2 2 2 2 -2 2 2 2 -2 2 2 2 -2 2 2 2 -3.14 3 3.14 3 -3.14 3 3.14 3 -3.14 3 3.14 3 -3.14 3 3.14 3 -3.14 3 3.14 3 -3.14 3 3.14 3 -3.14 3 3.14 3 -3.14 3 3.14 3 -3.14 3 3.14 3 -3.14 3 3.14 4 -3.14 3 3.14 4 -3.14 3 3.14 4 -3.14 4 3.14 3 -3.14 4 3.14 3 -3.14 4 3.14 3 -3.14 4 3.14 4 -10 10 10 10 -20 20 20 20 -100 100 100 100 -124 124 124 124 -125.2 125 125.2 125 -200 200 200 200 -1234567890.12345678 1234567890 1234567890.12345678 1234567890 +-1234567890.123456789000000000 -1234567890 -1234567890.123456789000000000 -1234567890 +-4400.000000000000000000 4400 -4400.000000000000000000 4400 +-1255.490000000000000000 -1255 -1255.490000000000000000 -1255 +-1.122000000000000000 -11 -1.122000000000000000 -11 +-1.120000000000000000 -1 -1.120000000000000000 -1 +-1.120000000000000000 -1 -1.120000000000000000 -1 +-1.120000000000000000 -1 -1.120000000000000000 -1 +-1.120000000000000000 -1 -1.120000000000000000 -1 +-0.333000000000000000 0 -0.333000000000000000 0 +-0.330000000000000000 0 -0.330000000000000000 0 +-0.300000000000000000 0 -0.300000000000000000 0 +0.000000000000000000 0 0.000000000000000000 0 +0.000000000000000000 0 0.000000000000000000 0 +0.000000000000000000 0 0.000000000000000000 0 +0.000000000000000000 0 0.000000000000000000 0 +0.000000000000000000 0 0.000000000000000000 0 +0.000000000000000000 0 0.000000000000000000 0 +0.000000000000000000 0 0.000000000000000000 0 +0.000000000000000000 0 0.000000000000000000 0 +0.000000000000000000 0 0.000000000000000000 0 +0.010000000000000000 0 0.010000000000000000 0 +0.020000000000000000 0 0.020000000000000000 0 +0.100000000000000000 0 0.100000000000000000 0 +0.200000000000000000 0 0.200000000000000000 0 +0.300000000000000000 0 0.300000000000000000 0 +0.330000000000000000 0 0.330000000000000000 0 +0.333000000000000000 0 0.333000000000000000 0 +1.000000000000000000 1 1.000000000000000000 1 +1.000000000000000000 1 1.000000000000000000 1 +1.000000000000000000 1 1.000000000000000000 1 +1.000000000000000000 1 1.000000000000000000 1 +1.000000000000000000 1 1.000000000000000000 1 +1.000000000000000000 1 1.000000000000000000 1 +1.000000000000000000 1 1.000000000000000000 1 +1.000000000000000000 1 1.000000000000000000 1 +1.000000000000000000 1 1.000000000000000000 1 +1.120000000000000000 1 1.120000000000000000 1 +1.122000000000000000 1 1.122000000000000000 1 +2.000000000000000000 2 2.000000000000000000 2 +2.000000000000000000 2 2.000000000000000000 2 +2.000000000000000000 2 2.000000000000000000 2 +2.000000000000000000 2 2.000000000000000000 2 +3.140000000000000000 3 3.140000000000000000 3 +3.140000000000000000 3 3.140000000000000000 3 +3.140000000000000000 3 3.140000000000000000 3 +3.140000000000000000 3 3.140000000000000000 3 +3.140000000000000000 3 3.140000000000000000 3 +3.140000000000000000 3 3.140000000000000000 3 +3.140000000000000000 3 3.140000000000000000 3 +3.140000000000000000 3 3.140000000000000000 3 +3.140000000000000000 3 3.140000000000000000 3 +3.140000000000000000 3 3.140000000000000000 4 +3.140000000000000000 3 3.140000000000000000 4 +3.140000000000000000 3 3.140000000000000000 4 +3.140000000000000000 4 3.140000000000000000 3 +3.140000000000000000 4 3.140000000000000000 3 +3.140000000000000000 4 3.140000000000000000 3 +3.140000000000000000 4 3.140000000000000000 4 +10.000000000000000000 10 10.000000000000000000 10 +20.000000000000000000 20 20.000000000000000000 20 +100.000000000000000000 100 100.000000000000000000 100 +124.000000000000000000 124 124.000000000000000000 124 +125.200000000000000000 125 125.200000000000000000 125 +200.000000000000000000 200 200.000000000000000000 200 +1234567890.123456780000000000 1234567890 1234567890.123456780000000000 1234567890 PREHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.14 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -356,10 +356,10 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.14 ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### -3.14 3 -3.14 3 -3.14 3 -3.14 4 +3.140000000000000000 3 +3.140000000000000000 3 +3.140000000000000000 3 +3.140000000000000000 4 PREHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.140 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -368,10 +368,10 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.140 ORDER BY key, value POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### -3.14 3 -3.14 3 -3.14 3 -3.14 4 +3.140000000000000000 3 +3.140000000000000000 3 +3.140000000000000000 3 +3.140000000000000000 4 PREHOOK: query: DROP TABLE DECIMAL_3_txt PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_3_txt http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/vector_decimal_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_4.q.out b/ql/src/test/results/clientpositive/vector_decimal_4.q.out index 613f5a8..c7d3d9e 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_4.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_4.q.out @@ -57,43 +57,43 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_1 #### A masked pattern was here #### NULL 0 --1234567890.123456789 -1234567890 --4400 4400 --1255.49 -1255 --1.122 -11 --1.12 -1 --1.12 -1 --0.333 0 --0.33 0 --0.3 0 -0 0 -0 0 -0 0 -0.01 0 -0.02 0 -0.1 0 -0.2 0 -0.3 0 -0.33 0 -0.333 0 +-1234567890.1234567890000000000000000 -1234567890 +-4400.0000000000000000000000000 4400 +-1255.4900000000000000000000000 -1255 +-1.1220000000000000000000000 -11 +-1.1200000000000000000000000 -1 +-1.1200000000000000000000000 -1 +-0.3330000000000000000000000 0 +-0.3300000000000000000000000 0 +-0.3000000000000000000000000 0 +0.0000000000000000000000000 0 +0.0000000000000000000000000 0 +0.0000000000000000000000000 0 +0.0100000000000000000000000 0 +0.0200000000000000000000000 0 +0.1000000000000000000000000 0 +0.2000000000000000000000000 0 +0.3000000000000000000000000 0 +0.3300000000000000000000000 0 +0.3330000000000000000000000 0 0.9999999999999999999999999 1 -1 1 -1 1 -1.12 1 -1.122 1 -2 2 -2 2 -3.14 3 -3.14 3 -3.14 3 -3.14 4 -10 10 -20 20 -100 100 -124 124 -125.2 125 -200 200 -1234567890.12345678 1234567890 +1.0000000000000000000000000 1 +1.0000000000000000000000000 1 +1.1200000000000000000000000 1 +1.1220000000000000000000000 1 +2.0000000000000000000000000 2 +2.0000000000000000000000000 2 +3.1400000000000000000000000 3 +3.1400000000000000000000000 3 +3.1400000000000000000000000 3 +3.1400000000000000000000000 4 +10.0000000000000000000000000 10 +20.0000000000000000000000000 20 +100.0000000000000000000000000 100 +124.0000000000000000000000000 124 +125.2000000000000000000000000 125 +200.0000000000000000000000000 200 +1234567890.1234567800000000000000000 1234567890 PREHOOK: query: SELECT * FROM DECIMAL_4_2 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_2 @@ -103,43 +103,43 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_2 #### A masked pattern was here #### NULL NULL --1234567890.123456789 -3703703670.370370367 --4400 -13200 --1255.49 -3766.47 --1.122 -3.366 --1.12 -3.36 --1.12 -3.36 --0.333 -0.999 --0.33 -0.99 --0.3 -0.9 -0 0 -0 0 -0 0 -0.01 0.03 -0.02 0.06 -0.1 0.3 -0.2 0.6 -0.3 0.9 -0.33 0.99 -0.333 0.999 +-1234567890.1234567890000000000000000 -3703703670.3703703670000000000000000 +-4400.0000000000000000000000000 -13200.0000000000000000000000000 +-1255.4900000000000000000000000 -3766.4700000000000000000000000 +-1.1220000000000000000000000 -3.3660000000000000000000000 +-1.1200000000000000000000000 -3.3600000000000000000000000 +-1.1200000000000000000000000 -3.3600000000000000000000000 +-0.3330000000000000000000000 -0.9990000000000000000000000 +-0.3300000000000000000000000 -0.9900000000000000000000000 +-0.3000000000000000000000000 -0.9000000000000000000000000 +0.0000000000000000000000000 0.0000000000000000000000000 +0.0000000000000000000000000 0.0000000000000000000000000 +0.0000000000000000000000000 0.0000000000000000000000000 +0.0100000000000000000000000 0.0300000000000000000000000 +0.0200000000000000000000000 0.0600000000000000000000000 +0.1000000000000000000000000 0.3000000000000000000000000 +0.2000000000000000000000000 0.6000000000000000000000000 +0.3000000000000000000000000 0.9000000000000000000000000 +0.3300000000000000000000000 0.9900000000000000000000000 +0.3330000000000000000000000 0.9990000000000000000000000 0.9999999999999999999999999 2.9999999999999999999999997 -1 3 -1 3 -1.12 3.36 -1.122 3.366 -2 6 -2 6 -3.14 9.42 -3.14 9.42 -3.14 9.42 -3.14 9.42 -10 30 -20 60 -100 300 -124 372 -125.2 375.6 -200 600 -1234567890.12345678 3703703670.37037034 +1.0000000000000000000000000 3.0000000000000000000000000 +1.0000000000000000000000000 3.0000000000000000000000000 +1.1200000000000000000000000 3.3600000000000000000000000 +1.1220000000000000000000000 3.3660000000000000000000000 +2.0000000000000000000000000 6.0000000000000000000000000 +2.0000000000000000000000000 6.0000000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +10.0000000000000000000000000 30.0000000000000000000000000 +20.0000000000000000000000000 60.0000000000000000000000000 +100.0000000000000000000000000 300.0000000000000000000000000 +124.0000000000000000000000000 372.0000000000000000000000000 +125.2000000000000000000000000 375.6000000000000000000000000 +200.0000000000000000000000000 600.0000000000000000000000000 +1234567890.1234567800000000000000000 3703703670.3703703400000000000000000 PREHOOK: query: SELECT * FROM DECIMAL_4_2 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_2 @@ -149,43 +149,43 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_2 #### A masked pattern was here #### NULL NULL --1234567890.123456789 -3703703670.370370367 --4400 -13200 --1255.49 -3766.47 --1.122 -3.366 --1.12 -3.36 --1.12 -3.36 --0.333 -0.999 --0.33 -0.99 --0.3 -0.9 -0 0 -0 0 -0 0 -0.01 0.03 -0.02 0.06 -0.1 0.3 -0.2 0.6 -0.3 0.9 -0.33 0.99 -0.333 0.999 +-1234567890.1234567890000000000000000 -3703703670.3703703670000000000000000 +-4400.0000000000000000000000000 -13200.0000000000000000000000000 +-1255.4900000000000000000000000 -3766.4700000000000000000000000 +-1.1220000000000000000000000 -3.3660000000000000000000000 +-1.1200000000000000000000000 -3.3600000000000000000000000 +-1.1200000000000000000000000 -3.3600000000000000000000000 +-0.3330000000000000000000000 -0.9990000000000000000000000 +-0.3300000000000000000000000 -0.9900000000000000000000000 +-0.3000000000000000000000000 -0.9000000000000000000000000 +0.0000000000000000000000000 0.0000000000000000000000000 +0.0000000000000000000000000 0.0000000000000000000000000 +0.0000000000000000000000000 0.0000000000000000000000000 +0.0100000000000000000000000 0.0300000000000000000000000 +0.0200000000000000000000000 0.0600000000000000000000000 +0.1000000000000000000000000 0.3000000000000000000000000 +0.2000000000000000000000000 0.6000000000000000000000000 +0.3000000000000000000000000 0.9000000000000000000000000 +0.3300000000000000000000000 0.9900000000000000000000000 +0.3330000000000000000000000 0.9990000000000000000000000 0.9999999999999999999999999 2.9999999999999999999999997 -1 3 -1 3 -1.12 3.36 -1.122 3.366 -2 6 -2 6 -3.14 9.42 -3.14 9.42 -3.14 9.42 -3.14 9.42 -10 30 -20 60 -100 300 -124 372 -125.2 375.6 -200 600 -1234567890.12345678 3703703670.37037034 +1.0000000000000000000000000 3.0000000000000000000000000 +1.0000000000000000000000000 3.0000000000000000000000000 +1.1200000000000000000000000 3.3600000000000000000000000 +1.1220000000000000000000000 3.3660000000000000000000000 +2.0000000000000000000000000 6.0000000000000000000000000 +2.0000000000000000000000000 6.0000000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +10.0000000000000000000000000 30.0000000000000000000000000 +20.0000000000000000000000000 60.0000000000000000000000000 +100.0000000000000000000000000 300.0000000000000000000000000 +124.0000000000000000000000000 372.0000000000000000000000000 +125.2000000000000000000000000 375.6000000000000000000000000 +200.0000000000000000000000000 600.0000000000000000000000000 +1234567890.1234567800000000000000000 3703703670.3703703400000000000000000 PREHOOK: query: SELECT * FROM DECIMAL_4_2 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_2 @@ -195,43 +195,43 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_2 #### A masked pattern was here #### NULL NULL --1234567890.123456789 -3703703670.370370367 --4400 -13200 --1255.49 -3766.47 --1.122 -3.366 --1.12 -3.36 --1.12 -3.36 --0.333 -0.999 --0.33 -0.99 --0.3 -0.9 -0 0 -0 0 -0 0 -0.01 0.03 -0.02 0.06 -0.1 0.3 -0.2 0.6 -0.3 0.9 -0.33 0.99 -0.333 0.999 +-1234567890.1234567890000000000000000 -3703703670.3703703670000000000000000 +-4400.0000000000000000000000000 -13200.0000000000000000000000000 +-1255.4900000000000000000000000 -3766.4700000000000000000000000 +-1.1220000000000000000000000 -3.3660000000000000000000000 +-1.1200000000000000000000000 -3.3600000000000000000000000 +-1.1200000000000000000000000 -3.3600000000000000000000000 +-0.3330000000000000000000000 -0.9990000000000000000000000 +-0.3300000000000000000000000 -0.9900000000000000000000000 +-0.3000000000000000000000000 -0.9000000000000000000000000 +0.0000000000000000000000000 0.0000000000000000000000000 +0.0000000000000000000000000 0.0000000000000000000000000 +0.0000000000000000000000000 0.0000000000000000000000000 +0.0100000000000000000000000 0.0300000000000000000000000 +0.0200000000000000000000000 0.0600000000000000000000000 +0.1000000000000000000000000 0.3000000000000000000000000 +0.2000000000000000000000000 0.6000000000000000000000000 +0.3000000000000000000000000 0.9000000000000000000000000 +0.3300000000000000000000000 0.9900000000000000000000000 +0.3330000000000000000000000 0.9990000000000000000000000 0.9999999999999999999999999 2.9999999999999999999999997 -1 3 -1 3 -1.12 3.36 -1.122 3.366 -2 6 -2 6 -3.14 9.42 -3.14 9.42 -3.14 9.42 -3.14 9.42 -10 30 -20 60 -100 300 -124 372 -125.2 375.6 -200 600 -1234567890.12345678 3703703670.37037034 +1.0000000000000000000000000 3.0000000000000000000000000 +1.0000000000000000000000000 3.0000000000000000000000000 +1.1200000000000000000000000 3.3600000000000000000000000 +1.1220000000000000000000000 3.3660000000000000000000000 +2.0000000000000000000000000 6.0000000000000000000000000 +2.0000000000000000000000000 6.0000000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +3.1400000000000000000000000 9.4200000000000000000000000 +10.0000000000000000000000000 30.0000000000000000000000000 +20.0000000000000000000000000 60.0000000000000000000000000 +100.0000000000000000000000000 300.0000000000000000000000000 +124.0000000000000000000000000 372.0000000000000000000000000 +125.2000000000000000000000000 375.6000000000000000000000000 +200.0000000000000000000000000 600.0000000000000000000000000 +1234567890.1234567800000000000000000 3703703670.3703703400000000000000000 PREHOOK: query: DROP TABLE DECIMAL_4_1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_4_1 http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/vector_decimal_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_5.q.out b/ql/src/test/results/clientpositive/vector_decimal_5.q.out index 34c3351..0bfd12e 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_5.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_5.q.out @@ -59,41 +59,41 @@ POSTHOOK: Input: default@decimal_5 NULL NULL NULL --4400 --1255.49 --1.122 --1.12 --1.12 --0.333 --0.33 --0.3 -0 -0 -0 -0.01 -0.02 -0.1 -0.2 -0.3 -0.33 -0.333 -1 -1 -1 -1.12 -1.122 -2 -2 -3.14 -3.14 -3.14 -3.14 -10 -20 -100 -124 -125.2 -200 +-4400.00000 +-1255.49000 +-1.12200 +-1.12000 +-1.12000 +-0.33300 +-0.33000 +-0.30000 +0.00000 +0.00000 +0.00000 +0.01000 +0.02000 +0.10000 +0.20000 +0.30000 +0.33000 +0.33300 +1.00000 +1.00000 +1.00000 +1.12000 +1.12200 +2.00000 +2.00000 +3.14000 +3.14000 +3.14000 +3.14000 +10.00000 +20.00000 +100.00000 +124.00000 +125.20000 +200.00000 PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_5 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_5 @@ -103,32 +103,32 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_5 #### A masked pattern was here #### NULL --4400 --1255.49 --1.122 --1.12 --0.333 --0.33 --0.3 -0 -0.01 -0.02 -0.1 -0.2 -0.3 -0.33 -0.333 -1 -1.12 -1.122 -2 -3.14 -10 -20 -100 -124 -125.2 -200 +-4400.00000 +-1255.49000 +-1.12200 +-1.12000 +-0.33300 +-0.33000 +-0.30000 +0.00000 +0.01000 +0.02000 +0.10000 +0.20000 +0.30000 +0.33000 +0.33300 +1.00000 +1.12000 +1.12200 +2.00000 +3.14000 +10.00000 +20.00000 +100.00000 +124.00000 +125.20000 +200.00000 PREHOOK: query: SELECT cast(key as decimal) FROM DECIMAL_5 PREHOOK: type: QUERY PREHOOK: Input: default@decimal_5 @@ -185,40 +185,40 @@ POSTHOOK: Input: default@decimal_5 #### A masked pattern was here #### NULL NULL -0 -0 -100 -10 -1 -0.1 -0.01 -200 -20 -2 -0 -0.2 -0.02 -0.3 -0.33 +0.000 +0.000 +100.000 +10.000 +1.000 +0.100 +0.010 +200.000 +20.000 +2.000 +0.000 +0.200 +0.020 +0.300 +0.330 0.333 --0.3 --0.33 +-0.300 +-0.330 -0.333 -1 -2 -3.14 --1.12 --1.12 +1.000 +2.000 +3.140 +-1.120 +-1.120 -1.122 -1.12 +1.120 1.122 -124 -125.2 +124.000 +125.200 NULL -3.14 -3.14 -3.14 -1 +3.140 +3.140 +3.140 +1.000 NULL NULL PREHOOK: query: DROP TABLE DECIMAL_5_txt http://git-wip-us.apache.org/repos/asf/hive/blob/3228ba7c/ql/src/test/results/clientpositive/vector_decimal_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_decimal_6.q.out b/ql/src/test/results/clientpositive/vector_decimal_6.q.out index 9cdd7fc..e0ccbc6 100644 --- a/ql/src/test/results/clientpositive/vector_decimal_6.q.out +++ b/ql/src/test/results/clientpositive/vector_decimal_6.q.out @@ -119,27 +119,27 @@ NULL 0 NULL 3 NULL 4 NULL 1234567890 --4400 4400 --1255.49 -1255 --1.122 -11 --1.12 -1 --0.333 0 --0.3 0 -0 0 -0 0 -0.333 0 -1 1 -1 1 -1.12 1 -1.122 1 -2 2 -3.14 3 -3.14 3 -3.14 4 -10 10 +-4400.00000 4400 +-1255.49000 -1255 +-1.12200 -11 +-1.12000 -1 +-0.33300 0 +-0.30000 0 +0.00000 0 +0.00000 0 +0.33300 0 +1.00000 1 +1.00000 1 +1.12000 1 +1.12200 1 +2.00000 2 +3.14000 3 +3.14000 3 +3.14000 4 +10.00000 10 10.73433 5 -124 124 -125.2 125 +124.00000 124 +125.20000 125 23232.23435 2 PREHOOK: query: SELECT * FROM DECIMAL_6_2 ORDER BY key, value PREHOOK: type: QUERY @@ -151,27 +151,27 @@ POSTHOOK: Input: default@decimal_6_2 #### A masked pattern was here #### NULL 0 -1234567890.1235 -1234567890 --4400 4400 --1255.49 -1255 --1.122 -11 --1.12 -1 --0.333 0 --0.3 0 -0 0 -0 0 -0.333 0 -1 1 -1 1 -1.12 1 -1.122 1 -2 2 -3.14 3 -3.14 3 -3.14 4 -10 10 +-4400.0000 4400 +-1255.4900 -1255 +-1.1220 -11 +-1.1200 -1 +-0.3330 0 +-0.3000 0 +0.0000 0 +0.0000 0 +0.3330 0 +1.0000 1 +1.0000 1 +1.1200 1 +1.1220 1 +2.0000 2 +3.1400 3 +3.1400 3 +3.1400 4 +10.0000 10 10.7343 5 -124 124 -125.2 125 +124.0000 124 +125.2000 125 23232.2344 2 2389432.2375 3 2389432.2375 4 @@ -200,54 +200,54 @@ NULL NULL NULL NULL --1234567890.1235 --4400 --4400 --1255.49 --1255.49 --1.122 --1.122 --1.12 --1.12 --0.333 --0.333 --0.3 --0.3 -0 -0 -0 -0 -0.333 -0.333 -1 -1 -1 -1 -1.12 -1.12 -1.122 -1.122 -2 -2 -3.14 -3.14 -3.14 -3.14 -3.14 -3.14 -10 -10 -10.7343 +-1234567890.12350 +-4400.00000 +-4400.00000 +-1255.49000 +-1255.49000 +-1.12200 +-1.12200 +-1.12000 +-1.12000 +-0.33300 +-0.33300 +-0.30000 +-0.30000 +0.00000 +0.00000 +0.00000 +0.00000 +0.33300 +0.33300 +1.00000 +1.00000 +1.00000 +1.00000 +1.12000 +1.12000 +1.12200 +1.12200 +2.00000 +2.00000 +3.14000 +3.14000 +3.14000 +3.14000 +3.14000 +3.14000 +10.00000 +10.00000 +10.73430 10.73433 -124 -124 -125.2 -125.2 +124.00000 +124.00000 +125.20000 +125.20000 23232.23435 -23232.2344 -2389432.2375 -2389432.2375 -1234567890.1235 +23232.23440 +2389432.23750 +2389432.23750 +1234567890.12350 PREHOOK: query: CREATE TABLE DECIMAL_6_3 STORED AS ORC AS SELECT key + 5.5 AS k, value * 11 AS v from DECIMAL_6_1 ORDER BY v PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@decimal_6_1
