You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jd...@apache.org on 2014/11/07 23:14:44 UTC
svn commit: r1637473 [2/3] - in /hive/branches/branch-0.14:
common/src/java/org/apache/hadoop/hive/common/type/
common/src/test/org/apache/hadoop/hive/common/type/
ql/src/test/org/apache/hadoop/hive/ql/exec/vector/expressions/
ql/src/test/org/apache/ha...
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/decimal_udf.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/decimal_udf.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/decimal_udf.q.out Fri Nov 7 22:14:43 2014
@@ -57,7 +57,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-8800
NULL
-0.0000000000
+0
0
200
20
@@ -76,7 +76,7 @@ NULL
-0.6
-0.66
-0.666
-2.0
+2
4
6.28
-2.24
@@ -84,15 +84,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
@@ -124,7 +124,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
0
NULL
-0.0000000000
+0
0
200
20
@@ -143,7 +143,7 @@ NULL
-0.3
-0.33
-0.333
-2.0
+2
4
6.14
-2.12
@@ -151,15 +151,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
@@ -327,42 +327,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
@@ -394,7 +394,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-8800
NULL
-0.0000000000
+0
0
0
0
@@ -413,7 +413,7 @@ NULL
-0.3
-0.33
-0.333
-0.0
+0
0
0.14
-0.12
@@ -421,15 +421,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
@@ -597,7 +597,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
19360000
NULL
-0.00000000000000000000
+0
0
10000
100
@@ -616,7 +616,7 @@ NULL
0.09
0.1089
0.110889
-1.00
+1
4
9.8596
1.2544
@@ -624,13 +624,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
@@ -671,7 +671,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
@@ -679,15 +679,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
@@ -719,26 +719,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
@@ -746,15 +746,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
@@ -1078,7 +1078,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
@@ -1235,7 +1235,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
4400
NULL
-0.0000000000
+0
0
100
10
@@ -1254,7 +1254,7 @@ NULL
0.3
0.33
0.333
-1.0
+1
2
3.14
1.12
@@ -1262,15 +1262,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
@@ -1359,23 +1359,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
@@ -1409,7 +1409,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
4400
NULL
-0.0000000000
+0
0
-100
-10
@@ -1428,7 +1428,7 @@ NULL
0.3
0.33
0.333
--1.0
+-1
-2
-3.14
1.12
@@ -1436,15 +1436,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
@@ -1478,7 +1478,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4400
NULL
-0.0000000000
+0
0
100
10
@@ -1497,7 +1497,7 @@ NULL
-0.3
-0.33
-0.333
-1.0
+1
2
3.14
-1.12
@@ -1505,15 +1505,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
@@ -1683,42 +1683,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
@@ -1827,38 +1827,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
@@ -2150,7 +2150,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
@@ -2213,7 +2213,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/branches/branch-0.14/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out Fri Nov 7 22:14:43 2014
@@ -259,7 +259,7 @@ POSTHOOK: query: SELECT * FROM orc_pred
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_pred
#### A masked pattern was here ####
-124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty
+124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty
PREHOOK: query: SELECT * FROM orc_pred WHERE t>2 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_pred
@@ -268,7 +268,7 @@ POSTHOOK: query: SELECT * FROM orc_pred
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_pred
#### A masked pattern was here ####
-124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty
+124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty
PREHOOK: query: SELECT SUM(HASH(t)) FROM orc_pred
WHERE t IS NOT NULL
AND t < 0
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/parquet_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/parquet_decimal.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/parquet_decimal.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/parquet_decimal.q.out Fri Nov 7 22:14:43 2014
@@ -63,9 +63,9 @@ Mary 4.33
Cluck 5.96
Tom -12.25
Mary 33.33
-Tom 19.00
-Beck 0.00
-Beck 79.90
+Tom 19
+Beck 0
+Beck 79.9
PREHOOK: query: TRUNCATE TABLE parq_dec
PREHOOK: type: TRUNCATETABLE
PREHOOK: Output: default@parq_dec
@@ -140,12 +140,12 @@ POSTHOOK: Input: default@parq_dec1
77.3
55.7
4.3
-6.0
+6
12.3
33.3
0.2
3.2
-8.0
+8
PREHOOK: query: DROP TABLE dec
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@dec
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/parquet_decimal1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/parquet_decimal1.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/parquet_decimal1.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/parquet_decimal1.q.out Fri Nov 7 22:14:43 2014
@@ -28,7 +28,7 @@ POSTHOOK: query: SELECT * FROM dec_comp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dec_comp
#### A masked pattern was here ####
-[3.14,6.28,7.30] {"k1":92.77,"k2":29.39} {"i":5,"d":9.03}
+[3.14,6.28,7.3] {"k1":92.77,"k2":29.39} {"i":5,"d":9.03}
[12.4,1.33,0.34] {"k2":2.79,"k4":29.09} {"i":11,"d":0.03}
PREHOOK: query: DROP TABLE IF EXISTS parq_dec_comp
PREHOOK: type: DROPTABLE
@@ -72,8 +72,8 @@ POSTHOOK: query: SELECT * FROM parq_dec_
POSTHOOK: type: QUERY
POSTHOOK: Input: default@parq_dec_comp
#### A masked pattern was here ####
-[3.14,6.28,7.30] {"k2":29.39,"k1":92.77} {"i":5,"d":9.03}
-[12.40,1.33,0.34] {"k4":29.09,"k2":2.79} {"i":11,"d":0.03}
+[3.14,6.28,7.3] {"k2":29.39,"k1":92.77} {"i":5,"d":9.03}
+[12.4,1.33,0.34] {"k4":29.09,"k2":2.79} {"i":11,"d":0.03}
PREHOOK: query: DROP TABLE dec_comp
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@dec_comp
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/serde_regex.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/serde_regex.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/serde_regex.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/serde_regex.q.out Fri Nov 7 22:14:43 2014
@@ -201,7 +201,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@serde_regex1
#### A masked pattern was here ####
NULL 0
--1234567890.1234567890 -1234567890
+-1234567890.123456789 -1234567890
-4400 4400
-1255.49 -1255
-1.122 -11
@@ -210,7 +210,7 @@ NULL 0
-0.333 0
-0.33 0
-0.3 0
-0.000000000000000000 0
+0 0
0 0
0 0
0.01 0
@@ -221,8 +221,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
@@ -230,14 +230,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: DROP TABLE serde_regex1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@serde_regex1
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out Fri Nov 7 22:14:43 2014
@@ -151,112 +151,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
#### A masked pattern was here ####
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-45.00 45
-45.00 45
-45.00 45
-45.00 45
-45.00 45
-79.00 79
-79.00 79
-79.00 79
-79.00 79
-79.00 79
-79.00 79
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-6.00 6
-6.00 6
-6.00 6
-6.00 6
-6.00 6
-6.00 6
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+45 45
+45 45
+45 45
+45 45
+45 45
+79 79
+79 79
+79 79
+79 79
+79 79
+79 79
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+6 6
+6 6
+6 6
+6 6
+6 6
+6 6
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
@@ -267,112 +267,112 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
#### A masked pattern was here ####
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-45.00 45
-45.00 45
-45.00 45
-45.00 45
-45.00 45
-79.00 79
-79.00 79
-79.00 79
-79.00 79
-79.00 79
-79.00 79
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-6.00 6
-6.00 6
-6.00 6
-6.00 6
-6.00 6
-6.00 6
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+45 45
+45 45
+45 45
+45 45
+45 45
+79 79
+79 79
+79 79
+79 79
+79 79
+79 79
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+6 6
+6 6
+6 6
+6 6
+6 6
+6 6
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec)
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
@@ -383,109 +383,109 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
#### A masked pattern was here ####
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-9.00 9
-45.00 45
-45.00 45
-45.00 45
-45.00 45
-45.00 45
-79.00 79
-79.00 79
-79.00 79
-79.00 79
-79.00 79
-79.00 79
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-17.00 17
-6.00 6
-6.00 6
-6.00 6
-6.00 6
-6.00 6
-6.00 6
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-62.00 62
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-64.00 64
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-89.00 89
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-70.00 70
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
-14.00 14
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+9 9
+45 45
+45 45
+45 45
+45 45
+45 45
+79 79
+79 79
+79 79
+79 79
+79 79
+79 79
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+17 17
+6 6
+6 6
+6 6
+6 6
+6 6
+6 6
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+62 62
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+64 64
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+89 89
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+70 70
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
+14 14
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/update_all_types.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/update_all_types.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/update_all_types.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/update_all_types.q.out Fri Nov 7 22:14:43 2014
@@ -87,16 +87,16 @@ POSTHOOK: query: select * from acid_uat
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_uat
#### A masked pattern was here ####
-11 NULL -1073279343 -1595604468 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
+11 NULL -1073279343 -1595604468 11.0 NULL 11 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
NULL -7382 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1970-01-01 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false
-11 NULL -1072910839 2048385991 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
+11 NULL -1072910839 2048385991 11.0 NULL 11 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
NULL 8373 -1072081801 1864027286 NULL 8373.0 NULL NULL 1970-01-01 dPkN74F7 dPkN74F7 4KWs6gw7lv2WYd66P true
NULL -5470 -1072076362 1864027286 NULL -5470.0 NULL NULL 1970-01-01 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true
--51 NULL -1071480828 -1401575336 -51.0 NULL -51.0 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
-8 NULL -1071363017 1349676361 8.0 NULL 8.0 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
+-51 NULL -1071480828 -1401575336 -51.0 NULL -51 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
+8 NULL -1071363017 1349676361 8.0 NULL 8 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
NULL -741 -1070883071 -1645852809 NULL -741.0 NULL NULL 1970-01-01 0ruyd6Y50JpdGRf6HqD 0ruyd6Y50JpdGRf6HqD xH7445Rals48VOulSyR5F false
NULL -947 -1070551679 1864027286 NULL -947.0 NULL NULL 1970-01-01 iUR3Q iUR3Q 4KWs6gw7lv2WYd66P false
-11 NULL -1069736047 -453772520 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
+11 NULL -1069736047 -453772520 11.0 NULL 11 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
PREHOOK: query: update acid_uat set
ti = 1,
si = 2,
@@ -141,15 +141,15 @@ POSTHOOK: query: select * from acid_uat
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_uat
#### A masked pattern was here ####
-11 NULL -1073279343 -1595604468 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
+11 NULL -1073279343 -1595604468 11.0 NULL 11 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
NULL -7382 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1970-01-01 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false
-11 NULL -1072910839 2048385991 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
+11 NULL -1072910839 2048385991 11.0 NULL 11 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
NULL 8373 -1072081801 1864027286 NULL 8373.0 NULL NULL 1970-01-01 dPkN74F7 dPkN74F7 4KWs6gw7lv2WYd66P true
NULL -5470 -1072076362 1864027286 NULL -5470.0 NULL NULL 1970-01-01 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true
--51 NULL -1071480828 -1401575336 -51.0 NULL -51.0 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
-8 NULL -1071363017 1349676361 8.0 NULL 8.0 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
+-51 NULL -1071480828 -1401575336 -51.0 NULL -51 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
+8 NULL -1071363017 1349676361 8.0 NULL 8 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
NULL -947 -1070551679 1864027286 NULL -947.0 NULL NULL 1970-01-01 iUR3Q iUR3Q 4KWs6gw7lv2WYd66P false
-11 NULL -1069736047 -453772520 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
+11 NULL -1069736047 -453772520 11.0 NULL 11 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
1 2 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
PREHOOK: query: update acid_uat set
ti = ti * 2,
@@ -175,13 +175,13 @@ POSTHOOK: query: select * from acid_uat
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_uat
#### A masked pattern was here ####
-11 NULL -1073279343 -1595604468 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
+11 NULL -1073279343 -1595604468 11.0 NULL 11 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
NULL -7382 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1970-01-01 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false
-11 NULL -1072910839 2048385991 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
+11 NULL -1072910839 2048385991 11.0 NULL 11 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
NULL 8373 -1072081801 1864027286 NULL 8373.0 NULL NULL 1970-01-01 dPkN74F7 dPkN74F7 4KWs6gw7lv2WYd66P true
NULL -5470 -1072076362 1864027286 NULL -5470.0 NULL NULL 1970-01-01 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true
--102 -51 -1071480828 -1401575336 -51.0 -51.0 -51.0 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
-8 NULL -1071363017 1349676361 8.0 NULL 8.0 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
+-102 -51 -1071480828 -1401575336 -51.0 -51.0 -51 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
+8 NULL -1071363017 1349676361 8.0 NULL 8 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
NULL -947 -1070551679 1864027286 NULL -947.0 NULL NULL 1970-01-01 iUR3Q iUR3Q 4KWs6gw7lv2WYd66P false
-11 NULL -1069736047 -453772520 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
+11 NULL -1069736047 -453772520 11.0 NULL 11 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
1 2 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
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_between_in.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_between_in.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_between_in.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_between_in.q.out Fri Nov 7 22:14:43 2014
@@ -699,19 +699,19 @@ POSTHOOK: Input: default@decimal_date_te
-18.5162162162
-17.3216216216
-16.7243243243
--16.1270270270
+-16.127027027
-15.5297297297
-10.7513513514
-9.5567567568
-8.3621621622
--5.9729729730
+-5.972972973
-3.5837837838
4.1810810811
4.7783783784
4.7783783784
5.3756756757
-5.9729729730
-5.9729729730
+5.972972973
+5.972972973
11.3486486486
11.3486486486
11.9459459459
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_data_types.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_data_types.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_data_types.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_data_types.q.out Fri Nov 7 22:14:43 2014
@@ -157,7 +157,7 @@ POSTHOOK: query: SELECT t, si, i, b, f,
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over1korc
#### A masked pattern was here ####
-108 301 65536 4294967357 90.05 17.59 true ethan johnson 2013-03-01 09:11:58.703271 75.70 undecided
+108 301 65536 4294967357 90.05 17.59 true ethan johnson 2013-03-01 09:11:58.703271 75.7 undecided
118 497 65536 4294967381 50.32 12.72 false david nixon 2013-03-01 09:11:58.703285 83.48 values clariffication
18 280 65536 4294967320 32.92 45.94 false holly white 2013-03-01 09:11:58.703086 58.86 topology
69 489 65536 4294967404 33.52 17.99 false oscar ichabod 2013-03-01 09:11:58.703247 32.68 topology
@@ -250,7 +250,7 @@ POSTHOOK: query: SELECT t, si, i, b, f,
POSTHOOK: type: QUERY
POSTHOOK: Input: default@over1korc
#### A masked pattern was here ####
-108 301 65536 4294967357 90.05 17.59 true ethan johnson 2013-03-01 09:11:58.703271 75.70 undecided
+108 301 65536 4294967357 90.05 17.59 true ethan johnson 2013-03-01 09:11:58.703271 75.7 undecided
118 497 65536 4294967381 50.32 12.72 false david nixon 2013-03-01 09:11:58.703285 83.48 values clariffication
18 280 65536 4294967320 32.92 45.94 false holly white 2013-03-01 09:11:58.703086 58.86 topology
69 489 65536 4294967404 33.52 17.99 false oscar ichabod 2013-03-01 09:11:58.703247 32.68 topology
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_2.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_2.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_2.q.out Fri Nov 7 22:14:43 2014
@@ -1605,7 +1605,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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_3.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_3.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_3.q.out Fri Nov 7 22:14:43 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,13 +294,13 @@ 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.000000000000000000 0 0 0
-0.000000000000000000 0 0 0
0 0 0 0
-0 0 0.000000000000000000 0
0 0 0 0
-0 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.01 0 0.01 0
@@ -311,14 +311,14 @@ POSTHOOK: Input: default@decimal_3
0.33 0 0.33 0
0.333 0 0.333 0
1 1 1 1
-1 1 1.0 1
-1 1 1.000000000000000000 1
-1.0 1 1.000000000000000000 1
-1.0 1 1.0 1
-1.0 1 1 1
-1.000000000000000000 1 1.000000000000000000 1
-1.000000000000000000 1 1 1
-1.000000000000000000 1 1.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.12 1 1.12 1
1.122 1 1.122 1
2 2 2 2
@@ -334,20 +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.14 3 3.140 4
-3.14 3 3.140 4
-3.14 3 3.140 4
-3.140 4 3.14 3
-3.140 4 3.14 3
-3.140 4 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
@@ -359,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
@@ -371,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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_4.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_4.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_4.q.out Fri Nov 7 22:14:43 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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_5.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_5.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_5.q.out Fri Nov 7 22:14:43 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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_6.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_6.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_6.q.out Fri Nov 7 22:14:43 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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out Fri Nov 7 22:14:43 2014
@@ -115,9 +115,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
@@ -219,9 +219,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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_cast.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_cast.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_cast.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_cast.q.out Fri Nov 7 22:14:43 2014
@@ -29,13 +29,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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_expressions.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_expressions.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_expressions.q.out Fri Nov 7 22:14:43 2014
@@ -40,12 +40,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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_mapjoin.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_mapjoin.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_mapjoin.q.out Fri Nov 7 22:14:43 2014
@@ -109,26 +109,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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_precision.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_precision.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_precision.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_precision.q.out Fri Nov 7 22:14:43 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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_trailing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_trailing.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_trailing.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_trailing.q.out Fri Nov 7 22:14:43 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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_decimal_udf.q.out Fri Nov 7 22:14:43 2014
@@ -97,7 +97,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-8800
NULL
-0.0000000000
+0
0
200
20
@@ -116,7 +116,7 @@ NULL
-0.6
-0.66
-0.666
-2.0
+2
4
6.28
-2.24
@@ -124,15 +124,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
@@ -180,7 +180,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
0
NULL
-0.0000000000
+0
0
200
20
@@ -199,7 +199,7 @@ NULL
-0.3
-0.33
-0.333
-2.0
+2
4
6.14
-2.12
@@ -207,15 +207,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
@@ -430,42 +430,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
@@ -513,7 +513,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-8800
NULL
-0.0000000000
+0
0
0
0
@@ -532,7 +532,7 @@ NULL
-0.3
-0.33
-0.333
-0.0
+0
0
0.14
-0.12
@@ -540,15 +540,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
@@ -763,7 +763,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
19360000
NULL
-0.00000000000000000000
+0
0
10000
100
@@ -782,7 +782,7 @@ NULL
0.09
0.1089
0.110889
-1.00
+1
4
9.8596
1.2544
@@ -790,13 +790,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
@@ -853,7 +853,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
@@ -861,15 +861,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
@@ -917,26 +917,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
@@ -944,15 +944,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
@@ -1370,7 +1370,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
@@ -1574,7 +1574,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
4400
NULL
-0.0000000000
+0
0
100
10
@@ -1593,7 +1593,7 @@ NULL
0.3
0.33
0.333
-1.0
+1
2
3.14
1.12
@@ -1601,15 +1601,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
@@ -1696,23 +1696,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
@@ -1762,7 +1762,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
4400
NULL
-0.0000000000
+0
0
-100
-10
@@ -1781,7 +1781,7 @@ NULL
0.3
0.33
0.333
--1.0
+-1
-2
-3.14
1.12
@@ -1789,15 +1789,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
@@ -1829,7 +1829,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4400
NULL
-0.0000000000
+0
0
100
10
@@ -1848,7 +1848,7 @@ NULL
-0.3
-0.33
-0.333
-1.0
+1
2
3.14
-1.12
@@ -1856,15 +1856,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
@@ -2082,42 +2082,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
@@ -2257,38 +2257,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
@@ -2608,7 +2608,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
@@ -2679,7 +2679,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/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/tez/vector_reduce_groupby_decimal.q.out Fri Nov 7 22:14:43 2014
@@ -132,7 +132,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
@@ -140,14 +140,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
@@ -158,12 +158,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/branches/branch-0.14/ql/src/test/results/clientpositive/udf_case.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/udf_case.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/udf_case.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/udf_case.q.out Fri Nov 7 22:14:43 2014
@@ -208,4 +208,4 @@ FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-123.0 123.0 abcd
+123 123.0 abcd
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/udf_when.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/udf_when.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/udf_when.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/udf_when.q.out Fri Nov 7 22:14:43 2014
@@ -191,4 +191,4 @@ FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-123.0 123.0 abcd
+123 123.0 abcd
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/update_all_types.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/update_all_types.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/update_all_types.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/update_all_types.q.out Fri Nov 7 22:14:43 2014
@@ -87,16 +87,16 @@ POSTHOOK: query: select * from acid_uat
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_uat
#### A masked pattern was here ####
-11 NULL -1073279343 -1595604468 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
+11 NULL -1073279343 -1595604468 11.0 NULL 11 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
NULL -7382 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1970-01-01 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false
-11 NULL -1072910839 2048385991 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
+11 NULL -1072910839 2048385991 11.0 NULL 11 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
NULL 8373 -1072081801 1864027286 NULL 8373.0 NULL NULL 1970-01-01 dPkN74F7 dPkN74F7 4KWs6gw7lv2WYd66P true
NULL -5470 -1072076362 1864027286 NULL -5470.0 NULL NULL 1970-01-01 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true
--51 NULL -1071480828 -1401575336 -51.0 NULL -51.0 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
-8 NULL -1071363017 1349676361 8.0 NULL 8.0 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
+-51 NULL -1071480828 -1401575336 -51.0 NULL -51 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
+8 NULL -1071363017 1349676361 8.0 NULL 8 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
NULL -741 -1070883071 -1645852809 NULL -741.0 NULL NULL 1970-01-01 0ruyd6Y50JpdGRf6HqD 0ruyd6Y50JpdGRf6HqD xH7445Rals48VOulSyR5F false
NULL -947 -1070551679 1864027286 NULL -947.0 NULL NULL 1970-01-01 iUR3Q iUR3Q 4KWs6gw7lv2WYd66P false
-11 NULL -1069736047 -453772520 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
+11 NULL -1069736047 -453772520 11.0 NULL 11 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
PREHOOK: query: update acid_uat set
ti = 1,
si = 2,
@@ -141,15 +141,15 @@ POSTHOOK: query: select * from acid_uat
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_uat
#### A masked pattern was here ####
-11 NULL -1073279343 -1595604468 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
+11 NULL -1073279343 -1595604468 11.0 NULL 11 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
NULL -7382 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1970-01-01 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false
-11 NULL -1072910839 2048385991 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
+11 NULL -1072910839 2048385991 11.0 NULL 11 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
NULL 8373 -1072081801 1864027286 NULL 8373.0 NULL NULL 1970-01-01 dPkN74F7 dPkN74F7 4KWs6gw7lv2WYd66P true
NULL -5470 -1072076362 1864027286 NULL -5470.0 NULL NULL 1970-01-01 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true
--51 NULL -1071480828 -1401575336 -51.0 NULL -51.0 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
-8 NULL -1071363017 1349676361 8.0 NULL 8.0 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
+-51 NULL -1071480828 -1401575336 -51.0 NULL -51 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
+8 NULL -1071363017 1349676361 8.0 NULL 8 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
NULL -947 -1070551679 1864027286 NULL -947.0 NULL NULL 1970-01-01 iUR3Q iUR3Q 4KWs6gw7lv2WYd66P false
-11 NULL -1069736047 -453772520 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
+11 NULL -1069736047 -453772520 11.0 NULL 11 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
1 2 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
PREHOOK: query: update acid_uat set
ti = ti * 2,
@@ -175,13 +175,13 @@ POSTHOOK: query: select * from acid_uat
POSTHOOK: type: QUERY
POSTHOOK: Input: default@acid_uat
#### A masked pattern was here ####
-11 NULL -1073279343 -1595604468 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
+11 NULL -1073279343 -1595604468 11.0 NULL 11 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
NULL -7382 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1970-01-01 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false
-11 NULL -1072910839 2048385991 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
+11 NULL -1072910839 2048385991 11.0 NULL 11 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
NULL 8373 -1072081801 1864027286 NULL 8373.0 NULL NULL 1970-01-01 dPkN74F7 dPkN74F7 4KWs6gw7lv2WYd66P true
NULL -5470 -1072076362 1864027286 NULL -5470.0 NULL NULL 1970-01-01 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true
--102 -51 -1071480828 -1401575336 -51.0 -51.0 -51.0 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
-8 NULL -1071363017 1349676361 8.0 NULL 8.0 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
+-102 -51 -1071480828 -1401575336 -51.0 -51.0 -51 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
+8 NULL -1071363017 1349676361 8.0 NULL 8 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
NULL -947 -1070551679 1864027286 NULL -947.0 NULL NULL 1970-01-01 iUR3Q iUR3Q 4KWs6gw7lv2WYd66P false
-11 NULL -1069736047 -453772520 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
+11 NULL -1069736047 -453772520 11.0 NULL 11 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
1 2 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
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_aggregate_9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_aggregate_9.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_aggregate_9.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_aggregate_9.q.out Fri Nov 7 22:14:43 2014
@@ -164,4 +164,4 @@ POSTHOOK: query: select min(dc), max(dc)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@vectortab2korc
#### A masked pattern was here ####
--4997414117561.546875 4994550248722.298828 -10252745435816.024410 -5399023399.587163986308583465
+-4997414117561.546875 4994550248722.298828 -10252745435816.02441 -5399023399.587163986308583465
Modified: hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_between_in.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_between_in.q.out?rev=1637473&r1=1637472&r2=1637473&view=diff
==============================================================================
--- hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_between_in.q.out (original)
+++ hive/branches/branch-0.14/ql/src/test/results/clientpositive/vector_between_in.q.out Fri Nov 7 22:14:43 2014
@@ -643,19 +643,19 @@ POSTHOOK: Input: default@decimal_date_te
-18.5162162162
-17.3216216216
-16.7243243243
--16.1270270270
+-16.127027027
-15.5297297297
-10.7513513514
-9.5567567568
-8.3621621622
--5.9729729730
+-5.972972973
-3.5837837838
4.1810810811
4.7783783784
4.7783783784
5.3756756757
-5.9729729730
-5.9729729730
+5.972972973
+5.972972973
11.3486486486
11.3486486486
11.9459459459