Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_2.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_2.q.out Fri Nov 7 21:58:56 2014 @@ -1423,7 +1423,7 @@ POSTHOOK: query: select cast(0.999999999 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_2 #### A masked pattern was here #### -1.0 +1 PREHOOK: query: explain select cast('0.99999999999999999999' as decimal(20,20)) as c from decimal_2 order by c PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_3.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_3.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_3.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_3.q.out Fri Nov 7 21:58:56 2014 @@ -47,7 +47,7 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### NULL 0 --1234567890.1234567890 -1234567890 +-1234567890.123456789 -1234567890 -4400 4400 -1255.49 -1255 -1.122 -11 @@ -56,7 +56,7 @@ NULL 0 -0.333 0 -0.33 0 -0.3 0 -0.000000000000000000 0 +0 0 0 0 0 0 0.01 0 @@ -67,8 +67,8 @@ NULL 0 0.33 0 0.333 0 1 1 -1.0 1 -1.000000000000000000 1 +1 1 +1 1 1.12 1 1.122 1 2 2 @@ -76,14 +76,14 @@ NULL 0 3.14 3 3.14 3 3.14 3 -3.140 4 +3.14 4 10 10 20 20 100 100 -124.00 124 +124 124 125.2 125 200 200 -1234567890.1234567800 1234567890 +1234567890.12345678 1234567890 PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key DESC, value DESC PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -92,14 +92,14 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### -1234567890.1234567800 1234567890 +1234567890.12345678 1234567890 200 200 125.2 125 -124.00 124 +124 124 100 100 20 20 10 10 -3.140 4 +3.14 4 3.14 3 3.14 3 3.14 3 @@ -107,8 +107,8 @@ POSTHOOK: Input: default@decimal_3 2 2 1.122 1 1.12 1 -1.000000000000000000 1 -1.0 1 +1 1 +1 1 1 1 0.333 0 0.33 0 @@ -119,7 +119,7 @@ POSTHOOK: Input: default@decimal_3 0.01 0 0 0 0 0 -0.000000000000000000 0 +0 0 -0.3 0 -0.33 0 -0.333 0 @@ -128,7 +128,7 @@ POSTHOOK: Input: default@decimal_3 -1.122 -11 -1255.49 -1255 -4400 4400 --1234567890.1234567890 -1234567890 +-1234567890.123456789 -1234567890 NULL 0 PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key, value PREHOOK: type: QUERY @@ -139,7 +139,7 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### NULL 0 --1234567890.1234567890 -1234567890 +-1234567890.123456789 -1234567890 -4400 4400 -1255.49 -1255 -1.122 -11 @@ -148,7 +148,7 @@ NULL 0 -0.333 0 -0.33 0 -0.3 0 -0.000000000000000000 0 +0 0 0 0 0 0 0.01 0 @@ -159,8 +159,8 @@ NULL 0 0.33 0 0.333 0 1 1 -1.0 1 -1.000000000000000000 1 +1 1 +1 1 1.12 1 1.122 1 2 2 @@ -168,14 +168,14 @@ NULL 0 3.14 3 3.14 3 3.14 3 -3.140 4 +3.14 4 10 10 20 20 100 100 -124.00 124 +124 124 125.2 125 200 200 -1234567890.1234567800 1234567890 +1234567890.12345678 1234567890 PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_3 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -185,7 +185,7 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### NULL --1234567890.1234567890 +-1234567890.123456789 -4400 -1255.49 -1.122 @@ -193,7 +193,7 @@ NULL -0.333 -0.33 -0.3 -0.000000000000000000 +0 0.01 0.02 0.1 @@ -209,10 +209,10 @@ NULL 10 20 100 -124.00 +124 125.2 200 -1234567890.1234567800 +1234567890.12345678 PREHOOK: query: SELECT key, sum(value) FROM DECIMAL_3 GROUP BY key ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -222,7 +222,7 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### NULL 0 --1234567890.1234567890 -1234567890 +-1234567890.123456789 -1234567890 -4400 4400 -1255.49 -1255 -1.122 -11 @@ -230,7 +230,7 @@ NULL 0 -0.333 0 -0.33 0 -0.3 0 -0.000000000000000000 0 +0 0 0.01 0 0.02 0 0.1 0 @@ -246,10 +246,10 @@ NULL 0 10 10 20 20 100 100 -124.00 124 +124 124 125.2 125 200 200 -1234567890.1234567800 1234567890 +1234567890.12345678 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) POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### --1234567890 -1234567890.1234567890 +-1234567890 -1234567890.123456789 -1255 -1255.49 -11 -1.122 -1 -2.24 -0 0.330000000000000000 -1 5.242000000000000000 +0 0.33 +1 5.242 2 4 3 9.42 -4 3.140 +4 3.14 10 10 20 20 100 100 -124 124.00 +124 124 125 125.2 200 200 4400 -4400 -1234567890 1234567890.1234567800 +1234567890 1234567890.12345678 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,7 +283,7 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_3 #### A masked pattern was here #### --1234567890.1234567890 -1234567890 -1234567890.1234567890 -1234567890 +-1234567890.123456789 -1234567890 -1234567890.123456789 -1234567890 -4400 4400 -4400 4400 -1255.49 -1255 -1255.49 -1255 -1.122 -11 -1.122 -11 @@ -294,7 +294,11 @@ POSTHOOK: Input: default@decimal_3 -0.333 0 -0.333 0 -0.33 0 -0.33 0 -0.3 0 -0.3 0 -0.000000000000000000 0 0.000000000000000000 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 @@ -307,8 +311,14 @@ POSTHOOK: Input: default@decimal_3 0.33 0 0.33 0 0.333 0 0.333 0 1 1 1 1 -1.0 1 1.0 1 -1.000000000000000000 1 1.000000000000000000 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 @@ -324,14 +334,20 @@ POSTHOOK: Input: default@decimal_3 3.14 3 3.14 3 3.14 3 3.14 3 3.14 3 3.14 3 -3.140 4 3.140 4 +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.00 124 124.00 124 +124 124 124 124 125.2 125 125.2 125 200 200 200 200 -1234567890.1234567800 1234567890 1234567890.1234567800 1234567890 +1234567890.12345678 1234567890 1234567890.12345678 1234567890 PREHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.14 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -343,7 +359,7 @@ POSTHOOK: Input: default@decimal_3 3.14 3 3.14 3 3.14 3 -3.140 4 +3.14 4 PREHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.140 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_3 @@ -355,7 +371,7 @@ POSTHOOK: Input: default@decimal_3 3.14 3 3.14 3 3.14 3 -3.140 4 +3.14 4 PREHOOK: query: DROP TABLE DECIMAL_3_txt PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_3_txt Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_4.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_4.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_4.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_4.q.out Fri Nov 7 21:58:56 2014 @@ -57,7 +57,7 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_1 #### A masked pattern was here #### NULL 0 --1234567890.1234567890 -1234567890 +-1234567890.123456789 -1234567890 -4400 4400 -1255.49 -1255 -1.122 -11 @@ -66,7 +66,7 @@ NULL 0 -0.333 0 -0.33 0 -0.3 0 -0.0000000000000000000000000 0 +0 0 0 0 0 0 0.01 0 @@ -78,7 +78,7 @@ NULL 0 0.333 0 0.9999999999999999999999999 1 1 1 -1.0 1 +1 1 1.12 1 1.122 1 2 2 @@ -86,14 +86,14 @@ NULL 0 3.14 3 3.14 3 3.14 3 -3.140 4 +3.14 4 10 10 20 20 100 100 -124.00 124 +124 124 125.2 125 200 200 -1234567890.1234567800 1234567890 +1234567890.12345678 1234567890 PREHOOK: query: SELECT * FROM DECIMAL_4_2 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_2 @@ -103,7 +103,7 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_2 #### A masked pattern was here #### NULL NULL --1234567890.1234567890 -3703703670.3703703670 +-1234567890.123456789 -3703703670.370370367 -4400 -13200 -1255.49 -3766.47 -1.122 -3.366 @@ -112,7 +112,7 @@ NULL NULL -0.333 -0.999 -0.33 -0.99 -0.3 -0.9 -0.0000000000000000000000000 0.0000000000000000000000000 +0 0 0 0 0 0 0.01 0.03 @@ -124,7 +124,7 @@ NULL NULL 0.333 0.999 0.9999999999999999999999999 2.9999999999999999999999997 1 3 -1.0 3.0 +1 3 1.12 3.36 1.122 3.366 2 6 @@ -132,14 +132,14 @@ NULL NULL 3.14 9.42 3.14 9.42 3.14 9.42 -3.140 9.420 +3.14 9.42 10 30 20 60 100 300 -124.00 372.00 +124 372 125.2 375.6 200 600 -1234567890.1234567800 3703703670.3703703400 +1234567890.12345678 3703703670.37037034 PREHOOK: query: SELECT * FROM DECIMAL_4_2 ORDER BY key PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_2 @@ -149,7 +149,7 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_2 #### A masked pattern was here #### NULL NULL --1234567890.1234567890 -3703703670.3703703670 +-1234567890.123456789 -3703703670.370370367 -4400 -13200 -1255.49 -3766.47 -1.122 -3.366 @@ -158,7 +158,7 @@ NULL NULL -0.333 -0.999 -0.33 -0.99 -0.3 -0.9 -0.0000000000000000000000000 0.0000000000000000000000000 +0 0 0 0 0 0 0.01 0.03 @@ -170,7 +170,7 @@ NULL NULL 0.333 0.999 0.9999999999999999999999999 2.9999999999999999999999997 1 3 -1.0 3.0 +1 3 1.12 3.36 1.122 3.366 2 6 @@ -178,14 +178,14 @@ NULL NULL 3.14 9.42 3.14 9.42 3.14 9.42 -3.140 9.420 +3.14 9.42 10 30 20 60 100 300 -124.00 372.00 +124 372 125.2 375.6 200 600 -1234567890.1234567800 3703703670.3703703400 +1234567890.12345678 3703703670.37037034 PREHOOK: query: SELECT * FROM DECIMAL_4_2 ORDER BY key, value PREHOOK: type: QUERY PREHOOK: Input: default@decimal_4_2 @@ -195,7 +195,7 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_4_2 #### A masked pattern was here #### NULL NULL --1234567890.1234567890 -3703703670.3703703670 +-1234567890.123456789 -3703703670.370370367 -4400 -13200 -1255.49 -3766.47 -1.122 -3.366 @@ -204,7 +204,7 @@ NULL NULL -0.333 -0.999 -0.33 -0.99 -0.3 -0.9 -0.0000000000000000000000000 0.0000000000000000000000000 +0 0 0 0 0 0 0.01 0.03 @@ -216,7 +216,7 @@ NULL NULL 0.333 0.999 0.9999999999999999999999999 2.9999999999999999999999997 1 3 -1.0 3.0 +1 3 1.12 3.36 1.122 3.366 2 6 @@ -224,14 +224,14 @@ NULL NULL 3.14 9.42 3.14 9.42 3.14 9.42 -3.140 9.420 +3.14 9.42 10 30 20 60 100 300 -124.00 372.00 +124 372 125.2 375.6 200 600 -1234567890.1234567800 3703703670.3703703400 +1234567890.12345678 3703703670.37037034 PREHOOK: query: DROP TABLE DECIMAL_4_1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_4_1 Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_5.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_5.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_5.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_5.q.out Fri Nov 7 21:58:56 2014 @@ -67,7 +67,7 @@ NULL -0.333 -0.33 -0.3 -0.00000 +0 0 0 0.01 @@ -78,8 +78,8 @@ NULL 0.33 0.333 1 -1.0 -1.00000 +1 +1 1.12 1.122 2 @@ -87,11 +87,11 @@ NULL 3.14 3.14 3.14 -3.140 +3.14 10 20 100 -124.00 +124 125.2 200 PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_5 ORDER BY key @@ -110,7 +110,7 @@ NULL -0.333 -0.33 -0.3 -0.00000 +0 0.01 0.02 0.1 @@ -126,7 +126,7 @@ NULL 10 20 100 -124.00 +124 125.2 200 PREHOOK: query: SELECT cast(key as decimal) FROM DECIMAL_5 @@ -185,7 +185,7 @@ POSTHOOK: Input: default@decimal_5 #### A masked pattern was here #### NULL NULL -0.000 +0 0 100 10 @@ -204,7 +204,7 @@ NULL -0.3 -0.33 -0.333 -1.0 +1 2 3.14 -1.12 @@ -212,13 +212,13 @@ NULL -1.122 1.12 1.122 -124.00 +124 125.2 NULL 3.14 3.14 -3.140 -1.000 +3.14 +1 NULL NULL PREHOOK: query: DROP TABLE DECIMAL_5_txt Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_6.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_6.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_6.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_6.q.out Fri Nov 7 21:58:56 2014 @@ -125,20 +125,20 @@ NULL 1234567890 -1.12 -1 -0.333 0 -0.3 0 -0.00000 0 +0 0 0 0 0.333 0 -1.0 1 -1.00000 1 +1 1 +1 1 1.12 1 1.122 1 2 2 3.14 3 3.14 3 -3.140 4 +3.14 4 10 10 10.73433 5 -124.00 124 +124 124 125.2 125 23232.23435 2 PREHOOK: query: SELECT * FROM DECIMAL_6_2 ORDER BY key, value @@ -157,20 +157,20 @@ NULL 0 -1.12 -1 -0.333 0 -0.3 0 -0.0000 0 +0 0 0 0 0.333 0 -1.0 1 -1.0000 1 +1 1 +1 1 1.12 1 1.122 1 2 2 3.14 3 3.14 3 -3.140 4 +3.14 4 10 10 10.7343 5 -124.00 124 +124 124 125.2 125 23232.2344 2 2389432.2375 3 @@ -213,16 +213,16 @@ NULL -0.333 -0.3 -0.3 -0.00000 -0.0000 +0 +0 0 0 0.333 0.333 -1.0 -1.0 -1.0000 -1.00000 +1 +1 +1 +1 1.12 1.12 1.122 @@ -233,14 +233,14 @@ NULL 3.14 3.14 3.14 -3.140 -3.140 +3.14 +3.14 10 10 10.7343 10.73433 -124.00 -124.00 +124 +124 125.2 125.2 23232.23435 Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out Fri Nov 7 21:58:56 2014 @@ -108,9 +108,9 @@ POSTHOOK: Input: default@decimal_vgby #### A masked pattern was here #### NULL 3072 9318.4351351351 -4298.1513513514 5018444.1081079808 3072 11160.715384615385 -5147.907692307693 6010604.3076923073536 -3728 6 5831542.269248378 -3367.6517567568 5817556.0411483778 6 6984454.211097692 -4033.445769230769 6967702.8672438458471 --563 2 -515.6210729730 -3367.6517567568 -3883.2728297298 2 -617.5607769230769 -4033.445769230769 -4651.0065461538459 +-563 2 -515.621072973 -3367.6517567568 -3883.2728297298 2 -617.5607769230769 -4033.445769230769 -4651.0065461538459 762 2 5831542.269248378 1531.2194054054 5833073.4886537834 2 6984454.211097692 1833.9456923076925 6986288.1567899996925 -6981 3 5831542.269248378 -515.6210729730 5830511.0271024320 3 6984454.211097692 -617.5607769230769 6983219.0895438458462 +6981 3 5831542.269248378 -515.621072973 5830511.027102432 3 6984454.211097692 -617.5607769230769 6983219.0895438458462 253665376 1024 9767.0054054054 -9779.5486486487 -347484.0818378374 1024 11697.969230769231 -11712.99230769231 -416182.64030769233089 528534767 1024 5831542.269248378 -9777.1594594595 11646372.8607481068 1024 6984454.211097692 -11710.130769230771 13948892.79980307629003 626923679 1024 9723.4027027027 -9778.9513513514 10541.0525297287 1024 11645.746153846154 -11712.276923076923 12625.04759999997746 @@ -206,9 +206,9 @@ POSTHOOK: Input: default@decimal_vgby #### A masked pattern was here #### NULL 3072 9318.4351351351 -4298.1513513514 5018444.1081079808 1633.60810810806667 5695.483082135364 5696.4103077145055 3072 11160.715384615385 -5147.907692307693 6010604.3076923073536 1956.576923076922966667 6821.495748565159 6822.606289190924 -3728 6 5831542.269248378 -3367.6517567568 5817556.0411483778 969592.67352472963333 2174330.2092403853 2381859.406131774 6 6984454.211097692 -4033.445769230769 6967702.8672438458471 1161283.811207307641183333 2604201.2704476737 2852759.5602156054 --563 2 -515.6210729730 -3367.6517567568 -3883.2728297298 -1941.6364148649 1426.0153418918999 2016.6902366556308 2 -617.5607769230769 -4033.445769230769 -4651.0065461538459 -2325.50327307692295 1707.9424961538462 2415.395441814127 +-563 2 -515.621072973 -3367.6517567568 -3883.2728297298 -1941.6364148649 1426.0153418918999 2016.6902366556308 2 -617.5607769230769 -4033.445769230769 -4651.0065461538459 -2325.50327307692295 1707.9424961538462 2415.395441814127 762 2 5831542.269248378 1531.2194054054 5833073.4886537834 2916536.7443268917 2915005.5249214866 4122440.3477364695 2 6984454.211097692 1833.9456923076925 6986288.1567899996925 3493144.07839499984625 3491310.1327026924 4937458.140118758 -6981 3 5831542.269248378 -515.6210729730 5830511.0271024320 1943503.67570081066667 2749258.455012492 3367140.1929065133 3 6984454.211097692 -617.5607769230769 6983219.0895438458462 2327739.696514615282066667 3292794.4113115156 4032833.0678006653 +6981 3 5831542.269248378 -515.621072973 5830511.027102432 1943503.67570081066667 2749258.455012492 3367140.1929065133 3 6984454.211097692 -617.5607769230769 6983219.0895438458462 2327739.696514615282066667 3292794.4113115156 4032833.0678006653 253665376 1024 9767.0054054054 -9779.5486486487 -347484.0818378374 -339.33992366976309 5708.9563478862 5711.745967572779 1024 11697.969230769231 -11712.99230769231 -416182.64030769233089 -406.428359675480791885 6837.632716002934 6840.973851172274 528534767 1024 5831542.269248378 -9777.1594594595 11646372.8607481068 11373.41099682432305 257528.92988206653 257654.7686043977 1024 6984454.211097692 -11710.130769230771 13948892.79980307629003 13621.965624807691689482 308443.1074570801 308593.82484083984 626923679 1024 9723.4027027027 -9778.9513513514 10541.0525297287 10.29399661106318 5742.09145323734 5744.897264034267 1024 11645.746153846154 -11712.276923076923 12625.04759999997746 12.329148046874977988 6877.318722794877 6880.679250101603 Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_cast.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_cast.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_cast.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_cast.q.out Fri Nov 7 21:58:56 2014 @@ -46,13 +46,13 @@ POSTHOOK: query: SELECT cdouble, cint, c POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### --13326.0 528534767 true 1969-12-31 15:59:46.674 -13326.0 528534767 1 -13 --15813.0 528534767 true 1969-12-31 15:59:55.787 -15813.0 528534767 1 -4 --9566.0 528534767 true 1969-12-31 15:59:44.187 -9566.0 528534767 1 -16 -15007.0 528534767 true 1969-12-31 15:59:50.434 15007.0 528534767 1 -10 -7021.0 528534767 true 1969-12-31 16:00:15.007 7021.0 528534767 1 15 -4963.0 528534767 true 1969-12-31 16:00:07.021 4963.0 528534767 1 7 --7824.0 528534767 true 1969-12-31 16:00:04.963 -7824.0 528534767 1 5 --15431.0 528534767 true 1969-12-31 15:59:52.176 -15431.0 528534767 1 -8 --15549.0 528534767 true 1969-12-31 15:59:44.569 -15549.0 528534767 1 -15 -5780.0 528534767 true 1969-12-31 15:59:44.451 5780.0 528534767 1 -16 +-13326.0 528534767 true 1969-12-31 15:59:46.674 -13326 528534767 1 -13 +-15813.0 528534767 true 1969-12-31 15:59:55.787 -15813 528534767 1 -4 +-9566.0 528534767 true 1969-12-31 15:59:44.187 -9566 528534767 1 -16 +15007.0 528534767 true 1969-12-31 15:59:50.434 15007 528534767 1 -10 +7021.0 528534767 true 1969-12-31 16:00:15.007 7021 528534767 1 15 +4963.0 528534767 true 1969-12-31 16:00:07.021 4963 528534767 1 7 +-7824.0 528534767 true 1969-12-31 16:00:04.963 -7824 528534767 1 5 +-15431.0 528534767 true 1969-12-31 15:59:52.176 -15431 528534767 1 -8 +-15549.0 528534767 true 1969-12-31 15:59:44.569 -15549 528534767 1 -15 +5780.0 528534767 true 1969-12-31 15:59:44.451 5780 528534767 1 -16 Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out Fri Nov 7 21:58:56 2014 @@ -57,12 +57,12 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_test #### A masked pattern was here #### 19699.417463617423 -12507.913305613346 0.8351496686995997 2.8303425077026896E7 3.6405405405 8963 10735 -17 8963 true 10735.776923076923 8963.641 10735.776923076923 1969-12-31 18:29:23.64054054 -9216.339708939685 -5851.806444906470 0.8353975893550668 6195112.1797296945 3.6243243243 4193 5022 -98 4193 true 5022.715384615385 4193.6245 5022.715384615385 1969-12-31 17:09:53.624324324 +9216.339708939685 -5851.80644490647 0.8353975893550668 6195112.1797296945 3.6243243243 4193 5022 -98 4193 true 5022.715384615385 4193.6245 5022.715384615385 1969-12-31 17:09:53.624324324 6514.8403326403464 -4136.5212058211928 0.8355907765708067 3095563.9418919063 4.3864864865 2964 3550 -34 2964 true 3550.4538461538464 2964.3865 3550.4538461538464 1969-12-31 16:49:24.386486486 7587.301455301477 -4817.467775467754 0.8354976172734904 4198623.24324327 2.3783783784 3452 4134 38 3452 true 4134.923076923077 3452.3784 4134.923076923077 1969-12-31 16:57:32.378378378 -19197.9729729730 -12189.5270270270 0.835155361813429 2.6880848817567654E7 5.4729729730 8735 10462 -34 8735 true 10462.5 8735.473 10462.5 1969-12-31 18:25:35.472972973 +19197.972972973 -12189.527027027 0.835155361813429 2.6880848817567654E7 5.472972973 8735 10462 -34 8735 true 10462.5 8735.473 10462.5 1969-12-31 18:25:35.472972973 17098.9945945946 -10856.8054054054 0.8351828165813104 2.132423090270272E7 0.3945945946 7780 9318 102 7780 true 9318.6 7780.3945 9318.6 1969-12-31 18:09:40.394594594 12433.723076923077 -7894.646153846154 0.8352770361086894 1.12754688E7 7.6 5657 6776 120 5657 true 6776.123076923077 5657.6 6776.123076923077 1969-12-31 17:34:17.6 7247.316839916862 -4601.598544698524 0.8355241651897876 3830775.6932432684 7.6783783784 3297 3949 109 3297 true 3949.638461538462 3297.6785 3949.638461538462 1969-12-31 16:54:57.678378378 -14757.1700623700465 -9369.8914760914930 0.8352226654922171 1.5883214124324286E7 4.8162162162 6714 8042 106 6714 true 8042.3538461538465 6714.8164 8042.3538461538465 1969-12-31 17:51:54.816216216 +14757.1700623700465 -9369.891476091493 0.8352226654922171 1.5883214124324286E7 4.8162162162 6714 8042 106 6714 true 8042.3538461538465 6714.8164 8042.3538461538465 1969-12-31 17:51:54.816216216 10964.832016631993 -6961.991060291086 0.8353232978714221 8768719.779729689 9.2243243243 4989 5975 87 4989 true 5975.607692307693 4989.224 5975.607692307693 1969-12-31 17:23:09.224324324 Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out Fri Nov 7 21:58:56 2014 @@ -113,26 +113,26 @@ POSTHOOK: query: SELECT l.cint, r.cint, POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_mapjoin #### A masked pattern was here #### -6981 6981 -515.6210729730 -617.5607769230769 -6981 6981 -515.6210729730 -617.5607769230769 -6981 6981 -515.6210729730 -617.5607769230769 -6981 6981 -515.6210729730 -617.5607769230769 -6981 6981 -515.6210729730 6984454.211097692 -6981 6981 -515.6210729730 6984454.211097692 -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL -6981 6981 -515.6210729730 NULL +6981 6981 -515.621072973 -617.5607769230769 +6981 6981 -515.621072973 -617.5607769230769 +6981 6981 -515.621072973 -617.5607769230769 +6981 6981 -515.621072973 -617.5607769230769 +6981 6981 -515.621072973 6984454.211097692 +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 NULL +6981 6981 -515.621072973 NULL +6981 6981 -515.621072973 NULL +6981 6981 -515.621072973 NULL +6981 6981 -515.621072973 NULL +6981 6981 -515.621072973 NULL +6981 6981 -515.621072973 NULL +6981 6981 -515.621072973 NULL +6981 6981 -515.621072973 NULL +6981 6981 -515.621072973 NULL 6981 6981 5831542.269248378 -617.5607769230769 6981 6981 5831542.269248378 -617.5607769230769 6981 6981 5831542.269248378 6984454.211097692 Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_precision.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_precision.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_precision.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_precision.q.out Fri Nov 7 21:58:56 2014 @@ -99,13 +99,13 @@ NULL NULL NULL NULL -0.0000000000 -0.0000000000 -0.0000000000 -0.0000000000 0 -0.1234567890 -0.1234567890 +0 +0 +0 +0 +0.123456789 +0.123456789 1.2345678901 1.2345678901 1.2345678901 @@ -129,7 +129,7 @@ NULL 123456789.0123456 123456789.0123456789 1234567890.123456 -1234567890.1234567890 +1234567890.123456789 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.0000000000 1.0000000000 -1.0000000000 -0.0000000000 1.0000000000 -1.0000000000 -0.0000000000 1.0000000000 -1.0000000000 -0.0000000000 1.0000000000 -1.0000000000 0 1 -1 -0.1234567890 1.1234567890 -0.8765432110 -0.1234567890 1.1234567890 -0.8765432110 +0 1 -1 +0 1 -1 +0 1 -1 +0 1 -1 +0.123456789 1.123456789 -0.876543211 +0.123456789 1.123456789 -0.876543211 1.2345678901 2.2345678901 0.2345678901 1.2345678901 2.2345678901 0.2345678901 1.2345678901 2.2345678901 0.2345678901 @@ -212,7 +212,7 @@ NULL NULL NULL 123456789.0123456 123456790.0123456 123456788.0123456 123456789.0123456789 123456790.0123456789 123456788.0123456789 1234567890.123456 1234567891.123456 1234567889.123456 -1234567890.1234567890 1234567891.1234567890 1234567889.1234567890 +1234567890.123456789 1234567891.123456789 1234567889.123456789 PREHOOK: query: SELECT dec, dec * 2, dec / 3 FROM DECIMAL_PRECISION ORDER BY dec PREHOOK: type: QUERY PREHOOK: Input: default@decimal_precision @@ -265,13 +265,13 @@ NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL -0.0000000000 0.0000000000 0 -0.0000000000 0.0000000000 0 -0.0000000000 0.0000000000 0 -0.0000000000 0.0000000000 0 0 0 0 -0.1234567890 0.2469135780 0.041152263 -0.1234567890 0.2469135780 0.041152263 +0 0 0 +0 0 0 +0 0 0 +0 0 0 +0.123456789 0.246913578 0.041152263 +0.123456789 0.246913578 0.041152263 1.2345678901 2.4691357802 0.411522630033 1.2345678901 2.4691357802 0.411522630033 1.2345678901 2.4691357802 0.411522630033 @@ -281,9 +281,9 @@ NULL NULL NULL 123.4567890123 246.9135780246 41.1522630041 123.4567890123 246.9135780246 41.1522630041 123.4567890123 246.9135780246 41.1522630041 -1234.5678901235 2469.1357802470 411.522630041167 -1234.5678901235 2469.1357802470 411.522630041167 -1234.5678901235 2469.1357802470 411.522630041167 +1234.5678901235 2469.135780247 411.522630041167 +1234.5678901235 2469.135780247 411.522630041167 +1234.5678901235 2469.135780247 411.522630041167 12345.6789012346 24691.3578024692 4115.226300411533 12345.6789012346 24691.3578024692 4115.226300411533 123456.7890123456 246913.5780246912 41152.2630041152 @@ -295,7 +295,7 @@ NULL NULL NULL 123456789.0123456 246913578.0246912 41152263.0041152 123456789.0123456789 246913578.0246913578 41152263.0041152263 1234567890.123456 2469135780.246912 411522630.041152 -1234567890.1234567890 2469135780.2469135780 411522630.041152263 +1234567890.123456789 2469135780.246913578 411522630.041152263 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.0000000000 0 -0.0000000000 0 -0.0000000000 0 -0.0000000000 0 0 0 -0.1234567890 0.013717421 -0.1234567890 0.013717421 +0 0 +0 0 +0 0 +0 0 +0.123456789 0.013717421 +0.123456789 0.013717421 1.2345678901 0.137174210011 1.2345678901 0.137174210011 1.2345678901 0.137174210011 @@ -378,7 +378,7 @@ NULL NULL 123456789.0123456 13717421.001371733333 123456789.0123456789 13717421.0013717421 1234567890.123456 137174210.013717333333 -1234567890.1234567890 137174210.013717421 +1234567890.123456789 137174210.013717421 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.0000000000 0 -0.0000000000 0 -0.0000000000 0 -0.0000000000 0 0 0 -0.1234567890 0.0045724736667 -0.1234567890 0.0045724736667 +0 0 +0 0 +0 0 +0 0 +0.123456789 0.0045724736667 +0.123456789 0.0045724736667 1.2345678901 0.0457247366704 1.2345678901 0.0457247366704 1.2345678901 0.0457247366704 @@ -461,7 +461,7 @@ NULL NULL 123456789.0123456 4572473.6671239111111 123456789.0123456789 4572473.6671239140333 1234567890.123456 45724736.6712391111111 -1234567890.1234567890 45724736.6712391403333 +1234567890.123456789 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.0000000000 0.00000000000000000000 -0.0000000000 0.00000000000000000000 -0.0000000000 0.00000000000000000000 -0.0000000000 0.00000000000000000000 0 0 -0.1234567890 0.01524157875019052100 -0.1234567890 0.01524157875019052100 +0 0 +0 0 +0 0 +0 0 +0.123456789 0.015241578750190521 +0.123456789 0.015241578750190521 1.2345678901 1.52415787526596567801 1.2345678901 1.52415787526596567801 1.2345678901 1.52415787526596567801 @@ -544,7 +544,7 @@ NULL NULL 123456789.0123456 15241578753238817.26870921383936 123456789.0123456789 15241578753238836.75019051998750190521 1234567890.123456 NULL -1234567890.1234567890 NULL +1234567890.123456789 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 Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_round_2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_round_2.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_round_2.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_round_2.q.out Fri Nov 7 21:58:56 2014 @@ -114,7 +114,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.0 55555.00 55555.000 55560 55600 56000 60000 100000 0 0 0 +55555 55555 55555 55555 55555 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 @@ -226,7 +226,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.3150 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.315 130 100 0 0 -125 -125 -125.3 -125.32 -125.315 -125.315 -130 -100 0 0 PREHOOK: query: create table decimal_tbl_3_orc (dec decimal(38,18)) STORED AS ORC PREHOOK: type: CREATETABLE @@ -381,7 +381,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.141592653590 3.1415926535898 3.1415926535898 3.14159265358979 3.141592653589793 3.1415926535897930 +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 PREHOOK: query: create table decimal_tbl_4_orc (pos decimal(38,18), neg decimal(38,18)) STORED AS ORC PREHOOK: type: CREATETABLE Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_trailing.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_trailing.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_trailing.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_trailing.q.out Fri Nov 7 21:58:56 2014 @@ -76,13 +76,13 @@ POSTHOOK: Input: default@decimal_trailin 0 0 0 1 0 0 2 NULL NULL -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 +3 1 1 +4 10 10 +5 100 100 +6 1000 1000 +7 10000 10000 +8 100000 100000 +9 NULL 1000000 10 NULL NULL 11 NULL NULL 12 NULL NULL @@ -91,18 +91,18 @@ POSTHOOK: Input: default@decimal_trailin 15 NULL NULL 16 NULL NULL 17 NULL NULL -18 1.0000 1.00000000 -19 10.000 10.0000000 -20 100.00 100.000000 -21 1000.0 1000.00000 -22 100000 10000.0000 -23 0.0000 0.00000000 -24 0.000 0.0000000 -25 0.00 0.000000 -26 0.0 0.00000 -27 0 0.00000 -28 12313.2000 134134.31252500 -29 99999.9990 134134.31242553 +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 PREHOOK: query: DROP TABLE DECIMAL_TRAILING_txt PREHOOK: type: DROPTABLE PREHOOK: Input: default@decimal_trailing_txt Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_udf.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_udf.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_udf.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_udf.q.out Fri Nov 7 21:58:56 2014 @@ -94,7 +94,7 @@ POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -8800 NULL -0.0000000000 +0 0 200 20 @@ -113,7 +113,7 @@ NULL -0.6 -0.66 -0.666 -2.0 +2 4 6.28 -2.24 @@ -121,15 +121,15 @@ NULL -2.244 2.24 2.244 -248.00 +248 250.4 -2510.98 6.28 6.28 -6.280 -2.0000000000 --2469135780.2469135780 -2469135780.2469135600 +6.28 +2 +-2469135780.246913578 +2469135780.24691356 PREHOOK: query: EXPLAIN SELECT key + value FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key + value FROM DECIMAL_UDF @@ -174,7 +174,7 @@ POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### 0 NULL -0.0000000000 +0 0 200 20 @@ -193,7 +193,7 @@ NULL -0.3 -0.33 -0.333 -2.0 +2 4 6.14 -2.12 @@ -201,15 +201,15 @@ NULL -12.122 2.12 2.122 -248.00 +248 250.2 -2510.49 6.14 6.14 -7.140 -2.0000000000 --2469135780.1234567890 -2469135780.1234567800 +7.14 +2 +-2469135780.123456789 +2469135780.12345678 PREHOOK: query: EXPLAIN SELECT key + (value/2) FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key + (value/2) FROM DECIMAL_UDF @@ -415,42 +415,42 @@ POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### 0 NULL -0.0000000000 0 0 0 0 -0.0 -0.00 0 0 0 0 -0.0 -0.00 -0.0 -0.00 -0.000 -0.0 -0.00 -0.000 -0.0 0 -0.00 -0.00 -0.00 -0.000 -0.00 -0.000 -0.00 -0.0 -0.00 -0.00 -0.00 -0.000 -0.0000000000 -0.0000000000 -0.0000000000 +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 PREHOOK: query: EXPLAIN SELECT key - value FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key - value FROM DECIMAL_UDF @@ -495,7 +495,7 @@ POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -8800 NULL -0.0000000000 +0 0 0 0 @@ -514,7 +514,7 @@ NULL -0.3 -0.33 -0.333 -0.0 +0 0 0.14 -0.12 @@ -522,15 +522,15 @@ NULL 9.878 0.12 0.122 -0.00 +0 0.2 -0.49 0.14 0.14 --0.860 -0.0000000000 --0.1234567890 -0.1234567800 +-0.86 +0 +-0.123456789 +0.12345678 PREHOOK: query: EXPLAIN SELECT key - (value/2) FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key - (value/2) FROM DECIMAL_UDF @@ -736,7 +736,7 @@ POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### 19360000 NULL -0.00000000000000000000 +0 0 10000 100 @@ -755,7 +755,7 @@ NULL 0.09 0.1089 0.110889 -1.00 +1 4 9.8596 1.2544 @@ -763,13 +763,13 @@ NULL 1.258884 1.2544 1.258884 -15376.0000 +15376 15675.04 1576255.1401 9.8596 9.8596 -9.859600 -1.00000000000000000000 +9.8596 +1 NULL NULL PREHOOK: query: EXPLAIN SELECT key, value FROM DECIMAL_UDF where key * value > 0 @@ -823,7 +823,7 @@ POSTHOOK: Input: default@decimal_udf 200 200 20 20 2 2 -1.0 1 +1 1 2 2 3.14 3 -1.12 -1 @@ -831,15 +831,15 @@ POSTHOOK: Input: default@decimal_udf -1.122 -11 1.12 1 1.122 1 -124.00 124 +124 124 125.2 125 -1255.49 -1255 3.14 3 3.14 3 -3.140 4 -1.0000000000 1 --1234567890.1234567890 -1234567890 -1234567890.1234567800 1234567890 +3.14 4 +1 1 +-1234567890.123456789 -1234567890 +1234567890.12345678 1234567890 PREHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF @@ -884,26 +884,26 @@ POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -19360000 NULL -0.0000000000 +0 0 10000 100 1 -0.0 -0.00 +0 +0 40000 400 4 0 -0.0 -0.00 -0.0 -0.00 -0.000 -0.0 -0.00 -0.000 -1.0 +0 +0 +0 +0 +0 +0 +0 +0 +1 4 9.42 1.12 @@ -911,15 +911,15 @@ NULL 12.342 1.12 1.122 -15376.00 -15650.0 +15376 +15650 1575639.95 9.42 9.42 -12.560 -1.0000000000 -1524157875171467887.5019052100 -1524157875171467876.3907942000 +12.56 +1 +1524157875171467887.50190521 +1524157875171467876.3907942 PREHOOK: query: EXPLAIN SELECT key * (value/2) FROM DECIMAL_UDF PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT key * (value/2) FROM DECIMAL_UDF @@ -1319,7 +1319,7 @@ POSTHOOK: Input: default@decimal_udf 0.785 1 1.0000000001 -1.000000000099999992710 +1.00000000009999999271 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 @@ -1514,7 +1514,7 @@ POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### 4400 NULL -0.0000000000 +0 0 100 10 @@ -1533,7 +1533,7 @@ NULL 0.3 0.33 0.333 -1.0 +1 2 3.14 1.12 @@ -1541,15 +1541,15 @@ NULL 1.122 1.12 1.122 -124.00 +124 125.2 1255.49 3.14 3.14 -3.140 -1.0000000000 -1234567890.1234567890 -1234567890.1234567800 +3.14 +1 +1234567890.123456789 +1234567890.12345678 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 @@ -1639,23 +1639,23 @@ POSTHOOK: query: SELECT value, sum(key) POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --1234567890 -1234567890.123456789 -1234567890.123456789 -1234567890.1234567890 +-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.3300000000 -1 1.0484 1.0484 5.2420000000 +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.140 +4 3.14 3.14 3.14 10 10 10 10 20 20 20 20 100 100 100 100 -124 124 124 124.00 +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.1234567800 +1234567890 1234567890.12345678 1234567890.12345678 1234567890.12345678 PREHOOK: query: -- negative EXPLAIN SELECT -key FROM DECIMAL_UDF PREHOOK: type: QUERY @@ -1702,7 +1702,7 @@ POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### 4400 NULL -0.0000000000 +0 0 -100 -10 @@ -1721,7 +1721,7 @@ NULL 0.3 0.33 0.333 --1.0 +-1 -2 -3.14 1.12 @@ -1729,15 +1729,15 @@ NULL 1.122 -1.12 -1.122 --124.00 +-124 -125.2 1255.49 -3.14 -3.14 --3.140 --1.0000000000 -1234567890.1234567890 --1234567890.1234567800 +-3.14 +-1 +1234567890.123456789 +-1234567890.12345678 PREHOOK: query: -- positive EXPLAIN SELECT +key FROM DECIMAL_UDF PREHOOK: type: QUERY @@ -1771,7 +1771,7 @@ POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -4400 NULL -0.0000000000 +0 0 100 10 @@ -1790,7 +1790,7 @@ NULL -0.3 -0.33 -0.333 -1.0 +1 2 3.14 -1.12 @@ -1798,15 +1798,15 @@ NULL -1.122 1.12 1.122 -124.00 +124 125.2 -1255.49 3.14 3.14 -3.140 -1.0000000000 --1234567890.1234567890 -1234567890.1234567800 +3.14 +1 +-1234567890.123456789 +1234567890.12345678 PREHOOK: query: -- ceiling EXPlAIN SELECT CEIL(key) FROM DECIMAL_UDF PREHOOK: type: QUERY @@ -2015,42 +2015,42 @@ POSTHOOK: query: SELECT ROUND(key, 2) FR POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --4400.00 +-4400 NULL -0.00 -0.00 -100.00 -10.00 -1.00 -0.10 +0 +0 +100 +10 +1 +0.1 0.01 -200.00 -20.00 -2.00 -0.00 -0.20 +200 +20 +2 +0 +0.2 0.02 -0.30 +0.3 0.33 0.33 --0.30 +-0.3 -0.33 -0.33 -1.00 -2.00 +1 +2 3.14 -1.12 -1.12 -1.12 1.12 1.12 -124.00 -125.20 +124 +125.2 -1255.49 3.14 3.14 3.14 -1.00 +1 -1234567890.12 1234567890.12 PREHOOK: query: -- power @@ -2184,38 +2184,38 @@ NULL NULL 1 1 -0.0 -0.00 -0.000 +0 +0 +0 1 1 0 NULL -0.0 -0.00 -0.10 -0.010 -0.0010 -0.10 -0.010 -0.0010 -0.0 0 -1.00 +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.00 -1.0 +1 +1 -626.745 -1.00 -1.00 -1.000 -0.0000000000 +1 +1 +1 +0 -617283944.0617283945 -1.0000000000 +1 PREHOOK: query: -- stddev, var EXPLAIN SELECT value, stddev(key), variance(key) FROM DECIMAL_UDF GROUP BY value PREHOOK: type: QUERY @@ -2510,7 +2510,7 @@ POSTHOOK: query: SELECT MIN(key) FROM DE POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### --1234567890.1234567890 +-1234567890.123456789 PREHOOK: query: -- max EXPLAIN SELECT MAX(key) FROM DECIMAL_UDF PREHOOK: type: QUERY @@ -2574,7 +2574,7 @@ POSTHOOK: query: SELECT MAX(key) FROM DE POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_udf #### A masked pattern was here #### -1234567890.1234567800 +1234567890.12345678 PREHOOK: query: -- count EXPLAIN SELECT COUNT(key) FROM DECIMAL_UDF PREHOOK: type: QUERY Modified: hive/trunk/ql/src/test/results/clientpositive/vector_reduce_groupby_decimal.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_reduce_groupby_decimal.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/vector_reduce_groupby_decimal.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/vector_reduce_groupby_decimal.q.out Fri Nov 7 21:58:56 2014 @@ -134,7 +134,7 @@ POSTHOOK: Input: default@decimal_test -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.9729729730 -8212.615384615387 -6856.9729729730 +-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 @@ -142,14 +142,14 @@ POSTHOOK: Input: default@decimal_test -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.0 9793.615384615387 8177.0 +-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.2729729730 -5909.792307692308 -4934.2729729730 +-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 -1048934049 -524.0 -312.9837837838 -374.86153846153854 -312.9837837838 @@ -160,12 +160,12 @@ POSTHOOK: Input: default@decimal_test -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.7729729730 11600.676923076924 9685.7729729730 +-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.9270270270 3672.0692307692307 3065.9270270270 +-1042805968 5133.0 3065.927027027 3672.0692307692307 3065.927027027 -1042712895 9296.0 5552.4756756757 6650.215384615385 5552.4756756757 --1042396242 9583.0 5723.9000000000 6855.53076923077 5723.9000000000 +-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 Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_decimal.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_decimal.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/windowing_decimal.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/windowing_decimal.q.out Fri Nov 7 21:58:56 2014 @@ -57,8 +57,8 @@ from part_dec POSTHOOK: type: QUERY POSTHOOK: Input: default@part_dec #### A masked pattern was here #### -Manufacturer#1 1173.15 1173.15 2346.30 -Manufacturer#1 1173.15 1173.15 2346.30 +Manufacturer#1 1173.15 1173.15 2346.3 +Manufacturer#1 1173.15 1173.15 2346.3 Manufacturer#1 1414.42 1173.15 3760.72 Manufacturer#1 1602.59 1173.15 5363.31 Manufacturer#1 1632.66 1173.15 6995.97 @@ -76,7 +76,7 @@ Manufacturer#3 1922.98 1190.27 7532.61 Manufacturer#4 1206.26 1206.26 1206.26 Manufacturer#4 1290.35 1206.26 2496.61 Manufacturer#4 1375.42 1206.26 3872.03 -Manufacturer#4 1620.67 1206.26 5492.70 +Manufacturer#4 1620.67 1206.26 5492.7 Manufacturer#4 1844.92 1206.26 7337.62 Manufacturer#5 1018.1 1018.1 1018.1 Manufacturer#5 1464.48 1018.1 2482.58 @@ -97,8 +97,8 @@ from part_dec POSTHOOK: type: QUERY POSTHOOK: Input: default@part_dec #### A masked pattern was here #### -Manufacturer#1 1173.15 1173.15 2346.30 -Manufacturer#1 1173.15 1173.15 2346.30 +Manufacturer#1 1173.15 1173.15 2346.3 +Manufacturer#1 1173.15 1173.15 2346.3 Manufacturer#1 1414.42 1414.42 1414.42 Manufacturer#1 1602.59 1602.59 1602.59 Manufacturer#1 1632.66 1632.66 1632.66 Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out Fri Nov 7 21:58:56 2014 @@ -277,13 +277,13 @@ POSTHOOK: Input: default@over10k 65536 98.42 65536 0.93 65536 83.48 -65536 75.70 +65536 75.7 65536 88.04 65536 94.09 65536 33.45 65536 44.41 65536 22.15 -65536 20.50 +65536 20.5 65536 58.86 65536 30.91 65536 74.47 @@ -300,9 +300,9 @@ POSTHOOK: Input: default@over10k 65536 80.26 65536 35.07 65536 95.88 -65536 30.60 +65536 30.6 65536 46.97 -65536 58.80 +65536 58.8 65536 5.72 65536 29.27 65536 62.25 @@ -326,7 +326,7 @@ POSTHOOK: Input: default@over10k 65537 35.86 65537 47.75 65537 1.12 -65537 52.90 +65537 52.9 65537 53.92 65537 43.45 65537 7.52 @@ -340,20 +340,20 @@ POSTHOOK: Input: default@over10k 65537 56.48 65537 83.21 65537 56.52 -65537 36.60 -65537 59.70 +65537 36.6 +65537 59.7 65537 80.14 -65537 66.30 +65537 66.3 65537 94.87 65537 40.92 -65537 25.20 +65537 25.2 65537 7.36 65538 NULL 65538 53.35 65538 54.64 65538 76.67 65538 15.17 -65538 1.20 +65538 1.2 65538 13.71 65538 81.59 65538 43.33 Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out Fri Nov 7 21:58:56 2014 @@ -508,16 +508,16 @@ where rnk = 1 limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### -2013-03-01 09:11:58.70307 0.50 1 -2013-03-01 09:11:58.70307 0.50 1 -2013-03-01 09:11:58.70307 0.50 1 -2013-03-01 09:11:58.70307 0.50 1 -2013-03-01 09:11:58.70307 0.50 1 -2013-03-01 09:11:58.70307 0.50 1 -2013-03-01 09:11:58.70307 0.50 1 -2013-03-01 09:11:58.70307 0.50 1 -2013-03-01 09:11:58.70307 0.50 1 -2013-03-01 09:11:58.70307 0.50 1 +2013-03-01 09:11:58.70307 0.5 1 +2013-03-01 09:11:58.70307 0.5 1 +2013-03-01 09:11:58.70307 0.5 1 +2013-03-01 09:11:58.70307 0.5 1 +2013-03-01 09:11:58.70307 0.5 1 +2013-03-01 09:11:58.70307 0.5 1 +2013-03-01 09:11:58.70307 0.5 1 +2013-03-01 09:11:58.70307 0.5 1 +2013-03-01 09:11:58.70307 0.5 1 +2013-03-01 09:11:58.70307 0.5 1 PREHOOK: query: select ts, dec, rnk from (select ts, dec, @@ -546,16 +546,16 @@ where dec = 89.5 limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### -2013-03-01 09:11:58.703124 89.50 1 -2013-03-01 09:11:58.703124 89.50 1 -2013-03-01 09:11:58.703124 89.50 1 -2013-03-01 09:11:58.703124 89.50 1 -2013-03-01 09:11:58.703124 89.50 1 -2013-03-01 09:11:58.703124 89.50 1 -2013-03-01 09:11:58.703124 89.50 1 -2013-03-01 09:11:58.703124 89.50 1 -2013-03-01 09:11:58.703124 89.50 1 -2013-03-01 09:11:58.703124 89.50 1 +2013-03-01 09:11:58.703124 89.5 1 +2013-03-01 09:11:58.703124 89.5 1 +2013-03-01 09:11:58.703124 89.5 1 +2013-03-01 09:11:58.703124 89.5 1 +2013-03-01 09:11:58.703124 89.5 1 +2013-03-01 09:11:58.703124 89.5 1 +2013-03-01 09:11:58.703124 89.5 1 +2013-03-01 09:11:58.703124 89.5 1 +2013-03-01 09:11:58.703124 89.5 1 +2013-03-01 09:11:58.703124 89.5 1 PREHOOK: query: select ts, dec, rnk from (select ts, dec, @@ -586,13 +586,13 @@ where rnk = 1 limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### -2013-03-01 09:11:58.70307 37.30 1 -2013-03-01 09:11:58.70307 37.30 1 -2013-03-01 09:11:58.70307 37.30 1 -2013-03-01 09:11:58.70307 37.30 1 -2013-03-01 09:11:58.70307 37.30 1 -2013-03-01 09:11:58.70307 37.30 1 -2013-03-01 09:11:58.70307 37.30 1 -2013-03-01 09:11:58.70307 37.30 1 -2013-03-01 09:11:58.70307 37.30 1 -2013-03-01 09:11:58.70307 37.30 1 +2013-03-01 09:11:58.70307 37.3 1 +2013-03-01 09:11:58.70307 37.3 1 +2013-03-01 09:11:58.70307 37.3 1 +2013-03-01 09:11:58.70307 37.3 1 +2013-03-01 09:11:58.70307 37.3 1 +2013-03-01 09:11:58.70307 37.3 1 +2013-03-01 09:11:58.70307 37.3 1 +2013-03-01 09:11:58.70307 37.3 1 +2013-03-01 09:11:58.70307 37.3 1 +2013-03-01 09:11:58.70307 37.3 1 Modified: hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDe.java URL: http://svn.apache.org/viewvc/hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDe.java?rev=1637469&r1=1637468&r2=1637469&view=diff ============================================================================== --- hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDe.java (original) +++ hive/trunk/serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDe.java Fri Nov 7 21:58:56 2014 @@ -779,7 +779,7 @@ public class BinarySortableSerDe extends // get the scale factor to turn big decimal into a decimal < 1 int factor = dec.precision() - dec.scale(); - factor = sign != -1 ? factor : -factor; + factor = sign == 1 ? factor : -factor; // convert the absolute big decimal to string dec.scaleByPowerOfTen(Math.abs(dec.scale()));