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/10/06 05:44:26 UTC
svn commit: r1629562 [28/38] - in /hive/branches/spark: ./ accumulo-handler/
beeline/ beeline/src/java/org/apache/hive/beeline/ bin/ext/ common/
common/src/java/org/apache/hadoop/hive/conf/
common/src/test/org/apache/hadoop/hive/common/type/ contrib/sr...
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out Mon Oct 6 03:44:13 2014
@@ -145,8 +145,6 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col7
- input vertices:
- 0 Map 2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col7 (type: string)
@@ -224,8 +222,6 @@ STAGE PLANS:
0 _col1 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
- input vertices:
- 0 Reducer 3
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col0 (type: double), _col3 (type: string)
@@ -341,8 +337,6 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col6, _col7
- input vertices:
- 1 Map 4
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col6 (type: int), _col7 (type: string)
@@ -396,8 +390,6 @@ STAGE PLANS:
0 _col1 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
- input vertices:
- 1 Map 1
Statistics: Num rows: 150 Data size: 1600 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col0 (type: double), _col3 (type: string)
@@ -458,8 +450,6 @@ STAGE PLANS:
0 _col1 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
- input vertices:
- 0 Reducer 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: int), _col0 (type: double), _col3 (type: string)
@@ -490,8 +480,6 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1
- input vertices:
- 1 Map 4
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string)
@@ -616,9 +604,6 @@ STAGE PLANS:
1 key (type: int)
2 key (type: int)
outputColumnNames: _col0, _col1, _col7
- input vertices:
- 1 Map 1
- 2 Map 2
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col7 (type: string)
@@ -689,8 +674,6 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1
- input vertices:
- 1 Map 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string)
@@ -706,8 +689,6 @@ STAGE PLANS:
0 _col0 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
- input vertices:
- 1 Map 1
Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col3 (type: string)
@@ -782,8 +763,6 @@ STAGE PLANS:
0 _col0 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
- input vertices:
- 0 Reducer 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: double), _col3 (type: string)
@@ -885,8 +864,6 @@ STAGE PLANS:
0 _col0 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col3
- input vertices:
- 0 Reducer 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: double), _col3 (type: string)
@@ -981,8 +958,6 @@ STAGE PLANS:
0 value (type: string)
1 value (type: string)
outputColumnNames: _col0, _col1, _col7
- input vertices:
- 0 Map 2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col7 (type: string)
@@ -1075,8 +1050,6 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1, _col6
- input vertices:
- 0 Map 2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string)
@@ -1157,8 +1130,6 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1
- input vertices:
- 0 Map 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -1170,8 +1141,6 @@ STAGE PLANS:
0 _col1 (type: string)
1 value (type: string)
outputColumnNames: _col0, _col12
- input vertices:
- 1 Map 1
Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col12 (type: int)
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out Mon Oct 6 03:44:13 2014
@@ -155,8 +155,6 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1
- input vertices:
- 0 Map 3
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Map Join Operator
condition map:
@@ -168,8 +166,6 @@ STAGE PLANS:
0 _col1 (type: string)
1 value (type: string)
outputColumnNames: _col0, _col12
- input vertices:
- 1 Map 1
Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col12 (type: int)
@@ -262,8 +258,6 @@ STAGE PLANS:
0 UDFToDouble(key) (type: double)
1 UDFToDouble(key) (type: double)
outputColumnNames: _col0, _col1, _col6
- input vertices:
- 0 Map 2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string)
@@ -336,8 +330,6 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1
- input vertices:
- 1 Map 2
Statistics: Num rows: 91 Data size: 969 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int)
@@ -413,8 +405,6 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1
- input vertices:
- 1 Map 2
Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int)
@@ -507,8 +497,6 @@ STAGE PLANS:
0 _col0 (type: int)
1 _col0 (type: int)
outputColumnNames: _col0, _col1
- input vertices:
- 0 Map 1
Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int)
@@ -562,8 +550,6 @@ STAGE PLANS:
0 _col0 (type: int)
1 key (type: int)
outputColumnNames: _col0, _col1
- input vertices:
- 0 Reducer 3
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: int), _col1 (type: int)
@@ -655,8 +641,6 @@ STAGE PLANS:
0 UDFToDouble(_col0) (type: double)
1 UDFToDouble(key) (type: double)
outputColumnNames: _col0, _col2
- input vertices:
- 0 Reducer 3
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col2 (type: string)
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out Mon Oct 6 03:44:13 2014
@@ -61,7 +61,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -201,7 +201,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -352,8 +352,6 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0
- input vertices:
- 0 Map 1
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
@@ -502,7 +500,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -651,7 +649,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -791,7 +789,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -925,7 +923,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -1065,7 +1063,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -1199,7 +1197,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -1336,7 +1334,7 @@ STAGE PLANS:
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -1460,7 +1458,7 @@ STAGE PLANS:
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -1593,7 +1591,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
@@ -1727,7 +1725,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
@@ -1867,7 +1865,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
@@ -2001,7 +1999,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
@@ -2143,7 +2141,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
@@ -2277,7 +2275,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
@@ -2420,7 +2418,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2561,7 +2559,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2703,7 +2701,7 @@ STAGE PLANS:
Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2843,7 +2841,7 @@ STAGE PLANS:
Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_join.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_join.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_join.q.out Mon Oct 6 03:44:13 2014
@@ -1,4 +1,4 @@
-Warning: Shuffle Join MERGEJOIN[7][tables = [src, src2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join JOIN[4][tables = [src, src2]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: -- current
explain select src.key from src join src src2
PREHOOK: type: QUERY
@@ -35,7 +35,7 @@ STAGE PLANS:
value expressions: key (type: string)
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -61,7 +61,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[7][tables = [src, src2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join JOIN[4][tables = [src, src2]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: -- ansi cross join
explain select src.key from src cross join src src2
PREHOOK: type: QUERY
@@ -98,7 +98,7 @@ STAGE PLANS:
value expressions: key (type: string)
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -169,7 +169,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out Mon Oct 6 03:44:13 2014
@@ -24,7 +24,7 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
POSTHOOK: Output: default@B
-Warning: Shuffle Join MERGEJOIN[7][tables = [a, b]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join JOIN[4][tables = [a, b]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select * from A join B
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from A join B
@@ -60,7 +60,7 @@ STAGE PLANS:
value expressions: key (type: string), value (type: string)
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -86,7 +86,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[18][tables = [d1, d2, a]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join JOIN[10][tables = [d1, d2, a]] in Stage 'Reducer 3' is a cross product
PREHOOK: query: explain select * from B d1 join B d2 on d1.key = d2.key join A
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from B d1 join B d2 on d1.key = d2.key join A
@@ -142,7 +142,7 @@ STAGE PLANS:
value expressions: key (type: string), value (type: string)
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -156,7 +156,7 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
Reducer 3
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -182,7 +182,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[25][tables = [a, od1]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join JOIN[16][tables = [a, od1]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select * from A join
(select d1.key
from B d1 join B d2 on d1.key = d2.key
@@ -243,7 +243,7 @@ STAGE PLANS:
value expressions: key (type: string), value (type: string)
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -282,7 +282,7 @@ STAGE PLANS:
value expressions: _col0 (type: string)
Reducer 4
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -308,8 +308,8 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[18][tables = [d1, d2]] in Stage 'Reducer 2' is a cross product
-Warning: Shuffle Join MERGEJOIN[19][tables = [a, od1]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join JOIN[4][tables = [d1, d2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join JOIN[14][tables = [a, od1]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select * from A join (select d1.key from B d1 join B d2 where 1 = 1 group by d1.key) od1
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from A join (select d1.key from B d1 join B d2 where 1 = 1 group by d1.key) od1
@@ -355,7 +355,7 @@ STAGE PLANS:
value expressions: key (type: string), value (type: string)
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -394,7 +394,7 @@ STAGE PLANS:
value expressions: _col0 (type: string)
Reducer 4
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -420,7 +420,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join MERGEJOIN[30][tables = [ss, od1]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join JOIN[21][tables = [ss, od1]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select * from
(select A.key from A group by key) ss join
(select d1.key from B d1 join B d2 on d1.key = d2.key where 1 = 1 group by d1.key) od1
@@ -490,7 +490,7 @@ STAGE PLANS:
Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -529,7 +529,7 @@ STAGE PLANS:
value expressions: _col0 (type: string)
Reducer 4
Reduce Operator Tree:
- Merge Join Operator
+ Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out?rev=1629562&r1=1629561&r2=1629562&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out Mon Oct 6 03:44:13 2014
@@ -64,8 +64,6 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col5, _col6
- input vertices:
- 1 Map 1
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
@@ -120,8 +118,6 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0, _col1, _col5, _col6
- input vertices:
- 1 Map 2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
sort order:
@@ -156,8 +152,6 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
- input vertices:
- 0 Map 1
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string)
@@ -219,8 +213,6 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0
- input vertices:
- 1 Map 3
Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
@@ -264,8 +256,6 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col5
- input vertices:
- 1 Reducer 2
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
@@ -334,8 +324,6 @@ STAGE PLANS:
0
1
outputColumnNames: _col0
- input vertices:
- 1 Map 3
Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
@@ -374,8 +362,6 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1, _col5
- input vertices:
- 1 Reducer 2
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
@@ -450,8 +436,6 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
outputColumnNames: _col0
- input vertices:
- 1 Map 3
Statistics: Num rows: 1 Data size: 125 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
@@ -535,8 +519,6 @@ STAGE PLANS:
0
1
outputColumnNames: _col0, _col1
- input vertices:
- 1 Reducer 2
Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)