You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/08/24 05:43:57 UTC
svn commit: r1620103 [15/27] - in /hive/branches/spark: ./ accumulo-handler/
common/src/java/org/apache/hadoop/hive/ant/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/test/org/apache/hadoop/hive/common/type/ data/files/
hcatalog/stream...
Modified: hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_1.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_1.q.out Sun Aug 24 03:43:48 2014
@@ -52,10 +52,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0} {VALUE._col1}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -117,7 +117,7 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -133,7 +133,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
TableScan
alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -146,12 +146,12 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {VALUE._col6}
1 {VALUE._col0} {VALUE._col1}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -284,10 +284,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -406,10 +406,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_2.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_2.q.out Sun Aug 24 03:43:48 2014
@@ -63,10 +63,10 @@ STAGE PLANS:
keys:
0
1
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -112,7 +112,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
HashTable Sink Operator
condition expressions:
- 0 {_col0} {_col1} {_col4} {_col5}
+ 0 {_col0} {_col1} {_col5} {_col6}
1 {key} {value}
keys:
0
@@ -150,21 +150,21 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1} {_col4} {_col5}
+ 0 {_col0} {_col1} {_col5} {_col6}
1 {key} {value}
keys:
0
1
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -309,10 +309,10 @@ STAGE PLANS:
keys:
0
1
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -446,10 +446,10 @@ STAGE PLANS:
keys:
0
1
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_2.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_2.q.out Sun Aug 24 03:43:48 2014
@@ -264,7 +264,7 @@ POSTHOOK: query: select cast(0.999999999
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_2
#### A masked pattern was here ####
-1
+1.0
PREHOOK: query: select cast('0.99999999999999999999' as decimal(20,20)) from decimal_2
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_2
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_3.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_3.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_3.q.out Sun Aug 24 03:43:48 2014
@@ -33,7 +33,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
NULL 0
--1234567890.123456789 -1234567890
+-1234567890.1234567890 -1234567890
-4400 4400
-1255.49 -1255
-1.122 -11
@@ -42,7 +42,7 @@ NULL 0
-0.333 0
-0.33 0
-0.3 0
-0 0
+0.000000000000000000 0
0 0
0 0
0.01 0
@@ -53,8 +53,8 @@ NULL 0
0.33 0
0.333 0
1 1
-1 1
-1 1
+1.0 1
+1.000000000000000000 1
1.12 1
1.122 1
2 2
@@ -62,14 +62,14 @@ NULL 0
3.14 3
3.14 3
3.14 3
-3.14 4
+3.140 4
10 10
20 20
100 100
-124 124
+124.00 124
125.2 125
200 200
-1234567890.12345678 1234567890
+1234567890.1234567800 1234567890
PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key DESC, value DESC
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -78,14 +78,14 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
-1234567890.12345678 1234567890
+1234567890.1234567800 1234567890
200 200
125.2 125
-124 124
+124.00 124
100 100
20 20
10 10
-3.14 4
+3.140 4
3.14 3
3.14 3
3.14 3
@@ -93,8 +93,8 @@ POSTHOOK: Input: default@decimal_3
2 2
1.122 1
1.12 1
-1 1
-1 1
+1.000000000000000000 1
+1.0 1
1 1
0.333 0
0.33 0
@@ -105,7 +105,7 @@ POSTHOOK: Input: default@decimal_3
0.01 0
0 0
0 0
-0 0
+0.000000000000000000 0
-0.3 0
-0.33 0
-0.333 0
@@ -114,7 +114,7 @@ POSTHOOK: Input: default@decimal_3
-1.122 -11
-1255.49 -1255
-4400 4400
--1234567890.123456789 -1234567890
+-1234567890.1234567890 -1234567890
NULL 0
PREHOOK: query: SELECT * FROM DECIMAL_3 ORDER BY key, value
PREHOOK: type: QUERY
@@ -125,7 +125,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
NULL 0
--1234567890.123456789 -1234567890
+-1234567890.1234567890 -1234567890
-4400 4400
-1255.49 -1255
-1.122 -11
@@ -134,7 +134,7 @@ NULL 0
-0.333 0
-0.33 0
-0.3 0
-0 0
+0.000000000000000000 0
0 0
0 0
0.01 0
@@ -145,8 +145,8 @@ NULL 0
0.33 0
0.333 0
1 1
-1 1
-1 1
+1.0 1
+1.000000000000000000 1
1.12 1
1.122 1
2 2
@@ -154,14 +154,14 @@ NULL 0
3.14 3
3.14 3
3.14 3
-3.14 4
+3.140 4
10 10
20 20
100 100
-124 124
+124.00 124
125.2 125
200 200
-1234567890.12345678 1234567890
+1234567890.1234567800 1234567890
PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_3 ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -171,7 +171,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
NULL
--1234567890.123456789
+-1234567890.1234567890
-4400
-1255.49
-1.122
@@ -179,7 +179,7 @@ NULL
-0.333
-0.33
-0.3
-0
+0.000000000000000000
0.01
0.02
0.1
@@ -195,10 +195,10 @@ NULL
10
20
100
-124
+124.00
125.2
200
-1234567890.12345678
+1234567890.1234567800
PREHOOK: query: SELECT key, sum(value) FROM DECIMAL_3 GROUP BY key ORDER BY key
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -208,7 +208,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
NULL 0
--1234567890.123456789 -1234567890
+-1234567890.1234567890 -1234567890
-4400 4400
-1255.49 -1255
-1.122 -11
@@ -216,7 +216,7 @@ NULL 0
-0.333 0
-0.33 0
-0.3 0
-0 0
+0.000000000000000000 0
0.01 0
0.02 0
0.1 0
@@ -232,10 +232,10 @@ NULL 0
10 10
20 20
100 100
-124 124
+124.00 124
125.2 125
200 200
-1234567890.12345678 1234567890
+1234567890.1234567800 1234567890
PREHOOK: query: SELECT value, sum(key) FROM DECIMAL_3 GROUP BY value ORDER BY value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -244,23 +244,23 @@ POSTHOOK: query: SELECT value, sum(key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
--1234567890 -1234567890.123456789
+-1234567890 -1234567890.1234567890
-1255 -1255.49
-11 -1.122
-1 -2.24
-0 0.33
-1 5.242
+0 0.330000000000000000
+1 5.242000000000000000
2 4
3 9.42
-4 3.14
+4 3.140
10 10
20 20
100 100
-124 124
+124 124.00
125 125.2
200 200
4400 -4400
-1234567890 1234567890.12345678
+1234567890 1234567890.1234567800
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
@@ -269,7 +269,7 @@ POSTHOOK: query: SELECT * FROM DECIMAL_3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_3
#### A masked pattern was here ####
--1234567890.123456789 -1234567890 -1234567890.123456789 -1234567890
+-1234567890.1234567890 -1234567890 -1234567890.1234567890 -1234567890
-4400 4400 -4400 4400
-1255.49 -1255 -1255.49 -1255
-1.122 -11 -1.122 -11
@@ -280,11 +280,7 @@ POSTHOOK: Input: default@decimal_3
-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.000000000000000000 0 0.000000000000000000 0
0 0 0 0
0 0 0 0
0 0 0 0
@@ -297,14 +293,8 @@ POSTHOOK: Input: default@decimal_3
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.0 1 1.0 1
+1.000000000000000000 1 1.000000000000000000 1
1.12 1 1.12 1
1.122 1 1.122 1
2 2 2 2
@@ -320,20 +310,14 @@ 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.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
+3.140 4 3.140 4
10 10 10 10
20 20 20 20
100 100 100 100
-124 124 124 124
+124.00 124 124.00 124
125.2 125 125.2 125
200 200 200 200
-1234567890.12345678 1234567890 1234567890.12345678 1234567890
+1234567890.1234567800 1234567890 1234567890.1234567800 1234567890
PREHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.14 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -345,7 +329,7 @@ POSTHOOK: Input: default@decimal_3
3.14 3
3.14 3
3.14 3
-3.14 4
+3.140 4
PREHOOK: query: SELECT * FROM DECIMAL_3 WHERE key=3.140 ORDER BY key, value
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_3
@@ -357,7 +341,7 @@ POSTHOOK: Input: default@decimal_3
3.14 3
3.14 3
3.14 3
-3.14 4
+3.140 4
PREHOOK: query: DROP TABLE DECIMAL_3
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_3
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_4.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_4.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_4.q.out Sun Aug 24 03:43:48 2014
@@ -57,7 +57,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@decimal_4_1
#### A masked pattern was here ####
NULL 0
--1234567890.123456789 -1234567890
+-1234567890.1234567890 -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 0
+0.0000000000000000000000000 0
0 0
0 0
0.01 0
@@ -78,7 +78,7 @@ NULL 0
0.333 0
0.9999999999999999999999999 1
1 1
-1 1
+1.0 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.14 4
+3.140 4
10 10
20 20
100 100
-124 124
+124.00 124
125.2 125
200 200
-1234567890.12345678 1234567890
+1234567890.1234567800 1234567890
PREHOOK: query: SELECT * FROM DECIMAL_4_2 ORDER BY key
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.123456789 -3703703670.370370367
+-1234567890.1234567890 -3703703670.3703703670
-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 0
+0.0000000000000000000000000 0.0000000000000000000000000
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 3
+1.0 3.0
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.14 9.42
+3.140 9.420
10 30
20 60
100 300
-124 372
+124.00 372.00
125.2 375.6
200 600
-1234567890.12345678 3703703670.37037034
+1234567890.1234567800 3703703670.3703703400
PREHOOK: query: DROP TABLE DECIMAL_4_1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@decimal_4_1
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_5.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_5.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_5.q.out Sun Aug 24 03:43:48 2014
@@ -43,7 +43,7 @@ NULL
-0.333
-0.33
-0.3
-0
+0.00000
0
0
0.01
@@ -54,8 +54,8 @@ NULL
0.33
0.333
1
-1
-1
+1.0
+1.00000
1.12
1.122
2
@@ -63,11 +63,11 @@ NULL
3.14
3.14
3.14
-3.14
+3.140
10
20
100
-124
+124.00
125.2
200
PREHOOK: query: SELECT DISTINCT key FROM DECIMAL_5 ORDER BY key
@@ -86,7 +86,7 @@ NULL
-0.333
-0.33
-0.3
-0
+0.00000
0.01
0.02
0.1
@@ -102,7 +102,7 @@ NULL
10
20
100
-124
+124.00
125.2
200
PREHOOK: query: SELECT cast(key as decimal) FROM DECIMAL_5
@@ -161,7 +161,7 @@ POSTHOOK: Input: default@decimal_5
#### A masked pattern was here ####
NULL
NULL
-0
+0.000
0
100
10
@@ -180,7 +180,7 @@ NULL
-0.3
-0.33
-0.333
-1
+1.0
2
3.14
-1.12
@@ -188,13 +188,13 @@ NULL
-1.122
1.12
1.122
-124
+124.00
125.2
NULL
3.14
3.14
-3.14
-1
+3.140
+1.000
NULL
NULL
PREHOOK: query: DROP TABLE DECIMAL_5
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out Sun Aug 24 03:43:48 2014
@@ -91,16 +91,16 @@ NULL
-0.333
-0.3
-0.3
-0
-0
+0.00000
+0.0000
0
0
0.333
0.333
-1
-1
-1
-1
+1.0
+1.0
+1.0000
+1.00000
1.12
1.12
1.122
@@ -111,14 +111,14 @@ NULL
3.14
3.14
3.14
-3.14
-3.14
+3.140
+3.140
10
10
10.7343
10.73433
-124
-124
+124.00
+124.00
125.2
125.2
23232.23435
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_precision.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_precision.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_precision.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_precision.q.out Sun Aug 24 03:43:48 2014
@@ -76,13 +76,13 @@ NULL
NULL
NULL
NULL
+0.0000000000
+0.0000000000
+0.0000000000
+0.0000000000
0
-0
-0
-0
-0
-0.123456789
-0.123456789
+0.1234567890
+0.1234567890
1.2345678901
1.2345678901
1.2345678901
@@ -106,7 +106,7 @@ NULL
123456789.0123456
123456789.0123456789
1234567890.123456
-1234567890.123456789
+1234567890.1234567890
PREHOOK: query: SELECT dec, dec + 1, dec - 1 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -159,13 +159,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 1 -1
-0 1 -1
-0 1 -1
-0 1 -1
-0.123456789 1.123456789 -0.876543211
-0.123456789 1.123456789 -0.876543211
+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
@@ -189,7 +189,7 @@ NULL NULL NULL
123456789.0123456 123456790.0123456 123456788.0123456
123456789.0123456789 123456790.0123456789 123456788.0123456789
1234567890.123456 1234567891.123456 1234567889.123456
-1234567890.123456789 1234567891.123456789 1234567889.123456789
+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
@@ -242,13 +242,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 0 0
-0 0 0
-0 0 0
-0 0 0
-0.123456789 0.246913578 0.041152263
-0.123456789 0.246913578 0.041152263
+0.1234567890 0.2469135780 0.041152263
+0.1234567890 0.2469135780 0.041152263
1.2345678901 2.4691357802 0.411522630033
1.2345678901 2.4691357802 0.411522630033
1.2345678901 2.4691357802 0.411522630033
@@ -258,9 +258,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.135780247 411.522630041167
-1234.5678901235 2469.135780247 411.522630041167
-1234.5678901235 2469.135780247 411.522630041167
+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
@@ -272,7 +272,7 @@ NULL NULL NULL
123456789.0123456 246913578.0246912 41152263.0041152
123456789.0123456789 246913578.0246913578 41152263.0041152263
1234567890.123456 2469135780.246912 411522630.041152
-1234567890.123456789 2469135780.246913578 411522630.041152263
+1234567890.1234567890 2469135780.2469135780 411522630.041152263
PREHOOK: query: SELECT dec, dec / 9 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -325,13 +325,13 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
+0.0000000000 0
+0.0000000000 0
+0.0000000000 0
+0.0000000000 0
0 0
-0 0
-0 0
-0 0
-0 0
-0.123456789 0.013717421
-0.123456789 0.013717421
+0.1234567890 0.013717421
+0.1234567890 0.013717421
1.2345678901 0.137174210011
1.2345678901 0.137174210011
1.2345678901 0.137174210011
@@ -355,7 +355,7 @@ NULL NULL
123456789.0123456 13717421.001371733333
123456789.0123456789 13717421.0013717421
1234567890.123456 137174210.013717333333
-1234567890.123456789 137174210.013717421
+1234567890.1234567890 137174210.013717421
PREHOOK: query: SELECT dec, dec / 27 FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -408,13 +408,13 @@ NULL NULL
NULL NULL
NULL NULL
NULL NULL
+0.0000000000 0
+0.0000000000 0
+0.0000000000 0
+0.0000000000 0
0 0
-0 0
-0 0
-0 0
-0 0
-0.123456789 0.0045724736667
-0.123456789 0.0045724736667
+0.1234567890 0.0045724736667
+0.1234567890 0.0045724736667
1.2345678901 0.0457247366704
1.2345678901 0.0457247366704
1.2345678901 0.0457247366704
@@ -438,7 +438,7 @@ NULL NULL
123456789.0123456 4572473.6671239111111
123456789.0123456789 4572473.6671239140333
1234567890.123456 45724736.6712391111111
-1234567890.123456789 45724736.6712391403333
+1234567890.1234567890 45724736.6712391403333
PREHOOK: query: SELECT dec, dec * dec FROM DECIMAL_PRECISION ORDER BY dec
PREHOOK: type: QUERY
PREHOOK: Input: default@decimal_precision
@@ -491,13 +491,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 0
-0 0
-0 0
-0 0
-0.123456789 0.015241578750190521
-0.123456789 0.015241578750190521
+0.1234567890 0.01524157875019052100
+0.1234567890 0.01524157875019052100
1.2345678901 1.52415787526596567801
1.2345678901 1.52415787526596567801
1.2345678901 1.52415787526596567801
@@ -521,7 +521,7 @@ NULL NULL
123456789.0123456 15241578753238817.26870921383936
123456789.0123456789 15241578753238836.75019051998750190521
1234567890.123456 NULL
-1234567890.123456789 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
Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_udf.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/decimal_udf.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_udf.q.out Sun Aug 24 03:43:48 2014
@@ -57,7 +57,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-8800
NULL
-0
+0.0000000000
0
200
20
@@ -76,7 +76,7 @@ NULL
-0.6
-0.66
-0.666
-2
+2.0
4
6.28
-2.24
@@ -84,15 +84,15 @@ NULL
-2.244
2.24
2.244
-248
+248.00
250.4
-2510.98
6.28
6.28
-6.28
-2
--2469135780.246913578
-2469135780.24691356
+6.280
+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
@@ -124,7 +124,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
0
NULL
-0
+0.0000000000
0
200
20
@@ -143,7 +143,7 @@ NULL
-0.3
-0.33
-0.333
-2
+2.0
4
6.14
-2.12
@@ -151,15 +151,15 @@ NULL
-12.122
2.12
2.122
-248
+248.00
250.2
-2510.49
6.14
6.14
-7.14
-2
--2469135780.123456789
-2469135780.12345678
+7.140
+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
@@ -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
-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.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
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
+0.0000000000
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
+0.00
0.2
-0.49
0.14
0.14
--0.86
-0
--0.123456789
-0.12345678
+-0.860
+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
@@ -597,7 +597,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
19360000
NULL
-0
+0.00000000000000000000
0
10000
100
@@ -616,7 +616,7 @@ NULL
0.09
0.1089
0.110889
-1
+1.00
4
9.8596
1.2544
@@ -624,13 +624,13 @@ NULL
1.258884
1.2544
1.258884
-15376
+15376.0000
15675.04
1576255.1401
9.8596
9.8596
-9.8596
-1
+9.859600
+1.00000000000000000000
NULL
NULL
PREHOOK: query: EXPLAIN SELECT key * value FROM DECIMAL_UDF
@@ -664,26 +664,26 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-19360000
NULL
-0
+0.0000000000
0
10000
100
1
-0
-0
+0.0
+0.00
40000
400
4
0
-0
-0
-0
-0
-0
-0
-0
-0
-1
+0.0
+0.00
+0.0
+0.00
+0.000
+0.0
+0.00
+0.000
+1.0
4
9.42
1.12
@@ -691,15 +691,15 @@ NULL
12.342
1.12
1.122
-15376
-15650
+15376.00
+15650.0
1575639.95
9.42
9.42
-12.56
-1
-1524157875171467887.50190521
-1524157875171467876.3907942
+12.560
+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
@@ -1023,7 +1023,7 @@ POSTHOOK: Input: default@decimal_udf
0.785
1
1.0000000001
-1.00000000009999999271
+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
@@ -1180,7 +1180,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
4400
NULL
-0
+0.0000000000
0
100
10
@@ -1199,7 +1199,7 @@ NULL
0.3
0.33
0.333
-1
+1.0
2
3.14
1.12
@@ -1207,15 +1207,15 @@ NULL
1.122
1.12
1.122
-124
+124.00
125.2
1255.49
3.14
3.14
-3.14
-1
-1234567890.123456789
-1234567890.12345678
+3.140
+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
@@ -1304,23 +1304,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.123456789
+-1234567890 -1234567890.123456789 -1234567890.123456789 -1234567890.1234567890
-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
+0 0.02538461538461538461538 0.02538461538462 0.3300000000
+1 1.0484 1.0484 5.2420000000
2 2 2 4
3 3.14 3.14 9.42
-4 3.14 3.14 3.14
+4 3.14 3.14 3.140
10 10 10 10
20 20 20 20
100 100 100 100
-124 124 124 124
+124 124 124 124.00
125 125.2 125.2 125.2
200 200 200 200
4400 -4400 -4400 -4400
-1234567890 1234567890.12345678 1234567890.12345678 1234567890.12345678
+1234567890 1234567890.12345678 1234567890.12345678 1234567890.1234567800
PREHOOK: query: -- negative
EXPLAIN SELECT -key FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -1354,7 +1354,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
4400
NULL
-0
+0.0000000000
0
-100
-10
@@ -1373,7 +1373,7 @@ NULL
0.3
0.33
0.333
--1
+-1.0
-2
-3.14
1.12
@@ -1381,15 +1381,15 @@ NULL
1.122
-1.12
-1.122
--124
+-124.00
-125.2
1255.49
-3.14
-3.14
--3.14
--1
-1234567890.123456789
--1234567890.12345678
+-3.140
+-1.0000000000
+1234567890.1234567890
+-1234567890.1234567800
PREHOOK: query: -- positive
EXPLAIN SELECT +key FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -1423,7 +1423,7 @@ POSTHOOK: Input: default@decimal_udf
#### A masked pattern was here ####
-4400
NULL
-0
+0.0000000000
0
100
10
@@ -1442,7 +1442,7 @@ NULL
-0.3
-0.33
-0.333
-1
+1.0
2
3.14
-1.12
@@ -1450,15 +1450,15 @@ NULL
-1.122
1.12
1.122
-124
+124.00
125.2
-1255.49
3.14
3.14
-3.14
-1
--1234567890.123456789
-1234567890.12345678
+3.140
+1.0000000000
+-1234567890.1234567890
+1234567890.1234567800
PREHOOK: query: -- ceiling
EXPlAIN SELECT CEIL(key) FROM DECIMAL_UDF
PREHOOK: type: QUERY
@@ -1628,42 +1628,42 @@ POSTHOOK: query: SELECT ROUND(key, 2) FR
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
@@ -1772,38 +1772,38 @@ NULL
NULL
1
1
-0
-0
-0
+0.0
+0.00
+0.000
1
1
0
NULL
+0.0
+0.00
+0.10
+0.010
+0.0010
+0.10
+0.010
+0.0010
+0.0
0
-0
-0.1
-0.01
-0.001
-0.1
-0.01
-0.001
-0
-0
-1
+1.00
-0.12
-0.12
-0.122
0.44
0.439
-1
-1
+1.00
+1.0
-626.745
-1
-1
-1
-0
+1.00
+1.00
+1.000
+0.0000000000
-617283944.0617283945
-1
+1.0000000000
PREHOOK: query: -- stddev, var
EXPLAIN SELECT value, stddev(key), variance(key) FROM DECIMAL_UDF GROUP BY value
PREHOOK: type: QUERY
@@ -2095,7 +2095,7 @@ POSTHOOK: query: SELECT MIN(key) FROM DE
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
@@ -2158,7 +2158,7 @@ POSTHOOK: query: SELECT MAX(key) FROM DE
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
Modified: hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out Sun Aug 24 03:43:48 2014
@@ -375,10 +375,10 @@ s1
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator (SEL_8)
- expressions: _col0 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator (FS_9)
@@ -407,7 +407,7 @@ s2
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
PREHOOK: query: -- With views
Modified: hive/branches/spark/ql/src/test/results/clientpositive/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/filter_join_breaktask.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/filter_join_breaktask.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/filter_join_breaktask.q.out Sun Aug 24 03:43:48 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/index_auto_self_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/index_auto_self_join.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/index_auto_self_join.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/index_auto_self_join.q.out Sun Aug 24 03:43:48 2014
@@ -47,10 +47,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: string)
+ expressions: _col0 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -198,10 +198,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col4 (type: string)
+ expressions: _col0 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 1 Data size: 220 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out Sun Aug 24 03:43:48 2014
@@ -416,9 +416,9 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Select Operator
- expressions: _col0 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1
File Output Operator
compressed: false
@@ -571,13 +571,13 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col5
+ outputColumnNames: _col6
Select Operator
- expressions: _col5 (type: string)
- outputColumnNames: _col5
+ expressions: _col6 (type: string)
+ outputColumnNames: _col6
Group By Operator
aggregations: count()
- keys: _col5 (type: string)
+ keys: _col6 (type: string)
mode: hash
outputColumnNames: _col0, _col1
Reduce Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/innerjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/innerjoin.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/innerjoin.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/innerjoin.q.out Sun Aug 24 03:43:48 2014
@@ -57,10 +57,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col5 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col6 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/input23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input23.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/input23.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/input23.q.out Sun Aug 24 03:43:48 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join1.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join1.q.out Sun Aug 24 03:43:48 2014
@@ -53,10 +53,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col5 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col6 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join14.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join14.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join14.q.out Sun Aug 24 03:43:48 2014
@@ -57,10 +57,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 11 Data size: 1102 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col5 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col6 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 11 Data size: 1102 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join15.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join15.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join15.q.out Sun Aug 24 03:43:48 2014
@@ -44,10 +44,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join17.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/join17.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join17.q.out Sun Aug 24 03:43:48 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join2.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join2.q.out Sun Aug 24 03:43:48 2014
@@ -53,10 +53,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (_col0 + _col4) is not null (type: boolean)
+ predicate: (_col0 + _col5) is not null (type: boolean)
Statistics: Num rows: 16 Data size: 1649 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -70,9 +70,9 @@ STAGE PLANS:
Map Operator Tree:
TableScan
Reduce Output Operator
- key expressions: (_col0 + _col4) (type: double)
+ key expressions: (_col0 + _col5) (type: double)
sort order: +
- Map-reduce partition columns: (_col0 + _col4) (type: double)
+ Map-reduce partition columns: (_col0 + _col5) (type: double)
Statistics: Num rows: 16 Data size: 1649 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string)
TableScan
@@ -94,10 +94,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0}
1 {VALUE._col1}
- outputColumnNames: _col0, _col9
+ outputColumnNames: _col0, _col11
Statistics: Num rows: 17 Data size: 1813 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col9 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col11 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 17 Data size: 1813 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join20.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join20.q.out Sun Aug 24 03:43:48 2014
@@ -61,10 +61,10 @@ STAGE PLANS:
0
1
2 {(KEY.reducesinkkey0 < 20)}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -722,10 +722,10 @@ STAGE PLANS:
0
1
2 {(KEY.reducesinkkey0 < 20)}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join21.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join21.q.out Sun Aug 24 03:43:48 2014
@@ -56,10 +56,10 @@ STAGE PLANS:
0 {(KEY.reducesinkkey0 < 10)}
1
2 {(KEY.reducesinkkey0 < 10)}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join22.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join22.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join22.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join22.q.out Sun Aug 24 03:43:48 2014
@@ -84,10 +84,10 @@ STAGE PLANS:
condition expressions:
0
1 {VALUE._col2}
- outputColumnNames: _col7
+ outputColumnNames: _col8
Statistics: Num rows: 34 Data size: 3515 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col7 (type: string)
+ expressions: _col8 (type: string)
outputColumnNames: _col0
Statistics: Num rows: 34 Data size: 3515 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join23.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join23.q.out Sun Aug 24 03:43:48 2014
@@ -41,10 +41,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0} {VALUE._col1}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join25.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join25.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join25.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join25.q.out Sun Aug 24 03:43:48 2014
@@ -72,10 +72,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col5
+ outputColumnNames: _col0, _col1, _col6
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), _col5 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join26.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join26.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/join26.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join26.q.out Sun Aug 24 03:43:48 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join27.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join27.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join27.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join27.q.out Sun Aug 24 03:43:48 2014
@@ -72,10 +72,10 @@ STAGE PLANS:
keys:
0 value (type: string)
1 value (type: string)
- outputColumnNames: _col0, _col1, _col5
+ outputColumnNames: _col0, _col1, _col6
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), _col5 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join3.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join3.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join3.q.out Sun Aug 24 03:43:48 2014
@@ -66,10 +66,10 @@ STAGE PLANS:
0 {KEY.reducesinkkey0}
1
2 {VALUE._col0}
- outputColumnNames: _col0, _col9
+ outputColumnNames: _col0, _col11
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col9 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col11 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join32.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join32.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/join32.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join32.q.out Sun Aug 24 03:43:48 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join32_lessSize.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join32_lessSize.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/join32_lessSize.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join32_lessSize.q.out Sun Aug 24 03:43:48 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join33.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join33.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/join33.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join33.q.out Sun Aug 24 03:43:48 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join36.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join36.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join36.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join36.q.out Sun Aug 24 03:43:48 2014
@@ -112,10 +112,10 @@ STAGE PLANS:
keys:
0 key (type: int)
1 key (type: int)
- outputColumnNames: _col0, _col1, _col5
+ outputColumnNames: _col0, _col1, _col6
Statistics: Num rows: 170 Data size: 817 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: int), _col5 (type: int)
+ expressions: _col0 (type: int), _col1 (type: int), _col6 (type: int)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 170 Data size: 817 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join37.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join37.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join37.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join37.q.out Sun Aug 24 03:43:48 2014
@@ -72,10 +72,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col5
+ outputColumnNames: _col0, _col1, _col6
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), _col5 (type: string)
+ expressions: UDFToInteger(_col0) (type: int), _col1 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join38.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join38.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join38.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join38.q.out Sun Aug 24 03:43:48 2014
@@ -94,15 +94,15 @@ STAGE PLANS:
keys:
0 '111' (type: string)
1 '111' (type: string)
- outputColumnNames: _col1, _col9
+ outputColumnNames: _col1, _col10
Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col9 (type: string)
- outputColumnNames: _col1, _col9
+ expressions: _col1 (type: string), _col10 (type: string)
+ outputColumnNames: _col1, _col10
Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count(1)
- keys: _col1 (type: string), _col9 (type: string)
+ keys: _col1 (type: string), _col10 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 15 Data size: 1598 Basic stats: COMPLETE Column stats: NONE
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join39.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join39.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join39.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join39.q.out Sun Aug 24 03:43:48 2014
@@ -73,10 +73,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 _col0 (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join40.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join40.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join40.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join40.q.out Sun Aug 24 03:43:48 2014
@@ -44,10 +44,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -684,10 +684,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -1805,10 +1805,10 @@ STAGE PLANS:
0
1
2 {(KEY.reducesinkkey0 < 20)}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -2466,10 +2466,10 @@ STAGE PLANS:
0
1
2 {(KEY.reducesinkkey0 < 20)}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -3119,10 +3119,10 @@ STAGE PLANS:
keys:
0 key (type: string)
1 _col0 (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join41.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join41.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join41.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join41.q.out Sun Aug 24 03:43:48 2014
@@ -47,10 +47,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 3 Data size: 23 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 3 Data size: 23 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -122,10 +122,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
Statistics: Num rows: 3 Data size: 23 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 3 Data size: 23 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join9.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
Files hive/branches/spark/ql/src/test/results/clientpositive/join9.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join9.q.out Sun Aug 24 03:43:48 2014 differ
Modified: hive/branches/spark/ql/src/test/results/clientpositive/join_alt_syntax.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join_alt_syntax.q.out?rev=1620103&r1=1620102&r2=1620103&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/join_alt_syntax.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/join_alt_syntax.q.out Sun Aug 24 03:43:48 2014
@@ -76,10 +76,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col1}
1 {VALUE._col1}
- outputColumnNames: _col1, _col12
+ outputColumnNames: _col1, _col13
Statistics: Num rows: 34 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col12 (type: string)
+ expressions: _col1 (type: string), _col13 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 34 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -154,13 +154,13 @@ STAGE PLANS:
0 {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0}
2 {KEY.reducesinkkey0}
- outputColumnNames: _col1, _col12, _col23
+ outputColumnNames: _col1, _col13, _col25
Statistics: Num rows: 35 Data size: 3601 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((_col1 = _col12) and (_col12 = _col23)) (type: boolean)
+ predicate: ((_col1 = _col13) and (_col13 = _col25)) (type: boolean)
Statistics: Num rows: 8 Data size: 823 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col12 (type: string), _col23 (type: string)
+ expressions: _col1 (type: string), _col13 (type: string), _col25 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 8 Data size: 823 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -239,13 +239,13 @@ STAGE PLANS:
0 {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0}
2 {KEY.reducesinkkey0}
- outputColumnNames: _col1, _col11, _col13
+ outputColumnNames: _col1, _col12, _col14
Statistics: Num rows: 35 Data size: 3601 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((_col1 = _col11) and (_col11 = _col13)) (type: boolean)
+ predicate: ((_col1 = _col12) and (_col12 = _col14)) (type: boolean)
Statistics: Num rows: 8 Data size: 823 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col11 (type: string), _col13 (type: string)
+ expressions: _col1 (type: string), _col12 (type: string), _col14 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 8 Data size: 823 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -304,10 +304,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0} {VALUE._col1}
- outputColumnNames: _col0, _col1, _col11, _col12
+ outputColumnNames: _col0, _col1, _col12, _col13
Statistics: Num rows: 33 Data size: 3490 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((_col11 + _col0) = _col0) and _col12 is not null) (type: boolean)
+ predicate: (((_col12 + _col0) = _col0) and _col13 is not null) (type: boolean)
Statistics: Num rows: 8 Data size: 846 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -332,25 +332,25 @@ STAGE PLANS:
Statistics: Num rows: 16 Data size: 1637 Basic stats: COMPLETE Column stats: NONE
TableScan
Reduce Output Operator
- key expressions: _col12 (type: string)
+ key expressions: _col13 (type: string)
sort order: +
- Map-reduce partition columns: _col12 (type: string)
+ Map-reduce partition columns: _col13 (type: string)
Statistics: Num rows: 8 Data size: 846 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: string), _col11 (type: int)
+ value expressions: _col0 (type: int), _col1 (type: string), _col12 (type: int)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col11} {KEY.reducesinkkey0}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col12} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col11, _col12, _col23
+ outputColumnNames: _col0, _col1, _col12, _col13, _col25
Statistics: Num rows: 17 Data size: 1800 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((_col11 + _col0) = _col0) and (_col23 = _col12)) (type: boolean)
+ predicate: (((_col12 + _col0) = _col0) and (_col25 = _col13)) (type: boolean)
Statistics: Num rows: 4 Data size: 423 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col12 (type: string), _col23 (type: string)
+ expressions: _col1 (type: string), _col13 (type: string), _col25 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 4 Data size: 423 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -416,7 +416,7 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey1} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey1} {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col11, _col12
+ outputColumnNames: _col0, _col1, _col12, _col13
Statistics: Num rows: 8 Data size: 930 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -441,19 +441,19 @@ STAGE PLANS:
Statistics: Num rows: 16 Data size: 1637 Basic stats: COMPLETE Column stats: NONE
TableScan
Reduce Output Operator
- key expressions: _col12 (type: string)
+ key expressions: _col13 (type: string)
sort order: +
- Map-reduce partition columns: _col12 (type: string)
+ Map-reduce partition columns: _col13 (type: string)
Statistics: Num rows: 8 Data size: 930 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: string), _col11 (type: int)
+ value expressions: _col0 (type: int), _col1 (type: string), _col12 (type: int)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col11} {KEY.reducesinkkey0}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col12} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col11, _col12, _col23
+ outputColumnNames: _col0, _col1, _col12, _col13, _col25
Statistics: Num rows: 17 Data size: 1800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -483,21 +483,21 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 17 Data size: 1800 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string), _col11 (type: int), _col12 (type: string), _col23 (type: string)
+ value expressions: _col1 (type: string), _col12 (type: int), _col13 (type: string), _col25 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col10} {VALUE._col11} {VALUE._col22}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col11} {VALUE._col12} {VALUE._col24}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col11, _col12, _col23, _col33, _col34
+ outputColumnNames: _col0, _col1, _col12, _col13, _col25, _col36, _col37
Statistics: Num rows: 18 Data size: 1980 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((_col12 = _col23) and (_col0 = _col33)) and (_col0 = _col11)) (type: boolean)
+ predicate: (((_col13 = _col25) and (_col0 = _col36)) and (_col0 = _col12)) (type: boolean)
Statistics: Num rows: 2 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col12 (type: string), _col23 (type: string), _col34 (type: string)
+ expressions: _col1 (type: string), _col13 (type: string), _col25 (type: string), _col37 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 2 Data size: 220 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -563,7 +563,7 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey1} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey1} {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col11, _col12
+ outputColumnNames: _col0, _col1, _col12, _col13
Statistics: Num rows: 8 Data size: 930 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -588,19 +588,19 @@ STAGE PLANS:
Statistics: Num rows: 16 Data size: 1637 Basic stats: COMPLETE Column stats: NONE
TableScan
Reduce Output Operator
- key expressions: _col12 (type: string)
+ key expressions: _col13 (type: string)
sort order: +
- Map-reduce partition columns: _col12 (type: string)
+ Map-reduce partition columns: _col13 (type: string)
Statistics: Num rows: 8 Data size: 930 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: int), _col1 (type: string), _col11 (type: int)
+ value expressions: _col0 (type: int), _col1 (type: string), _col12 (type: int)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col11} {KEY.reducesinkkey0}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col12} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col11, _col12, _col23
+ outputColumnNames: _col0, _col1, _col12, _col13, _col25
Statistics: Num rows: 17 Data size: 1800 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -630,21 +630,21 @@ STAGE PLANS:
sort order: +
Map-reduce partition columns: _col0 (type: int)
Statistics: Num rows: 17 Data size: 1800 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string), _col11 (type: int), _col12 (type: string), _col23 (type: string)
+ value expressions: _col1 (type: string), _col12 (type: int), _col13 (type: string), _col25 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col10} {VALUE._col11} {VALUE._col22}
+ 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col11} {VALUE._col12} {VALUE._col24}
1 {KEY.reducesinkkey0} {VALUE._col0}
- outputColumnNames: _col0, _col1, _col11, _col12, _col23, _col33, _col34
+ outputColumnNames: _col0, _col1, _col12, _col13, _col25, _col36, _col37
Statistics: Num rows: 18 Data size: 1980 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((_col12 = _col23) and (_col0 = _col33)) and (_col0 = _col11)) (type: boolean)
+ predicate: (((_col13 = _col25) and (_col0 = _col36)) and (_col0 = _col12)) (type: boolean)
Statistics: Num rows: 2 Data size: 220 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col1 (type: string), _col12 (type: string), _col23 (type: string), _col34 (type: string)
+ expressions: _col1 (type: string), _col13 (type: string), _col25 (type: string), _col37 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 2 Data size: 220 Basic stats: COMPLETE Column stats: NONE
File Output Operator