You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jx...@apache.org on 2015/11/06 18:33:12 UTC
[30/55] [abbrv] hive git commit: HIVE-12063: Pad Decimal numbers with
trailing zeros to the scale of the column (reviewed by Szehon)
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