You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/09/24 09:03:38 UTC
svn commit: r1627235 [8/9] - in /hive/trunk: itests/src/test/resources/
itests/util/src/main/java/org/apache/hadoop/hive/ql/
metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/
ql/if/ ql/src/gen/thrift/gen-cpp/ ql/src/gen/thrift...
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/correlationoptimizer1.q.out Wed Sep 24 07:03:35 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:
- Join Operator
+ Merge 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:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -502,7 +502,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -651,7 +651,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -791,7 +791,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -925,7 +925,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -1065,7 +1065,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -1199,7 +1199,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -1336,7 +1336,7 @@ STAGE PLANS:
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -1460,7 +1460,7 @@ STAGE PLANS:
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -1593,7 +1593,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
@@ -1727,7 +1727,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
@@ -1867,7 +1867,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
@@ -2001,7 +2001,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
@@ -2143,7 +2143,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
@@ -2277,7 +2277,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
@@ -2420,7 +2420,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2561,7 +2561,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2703,7 +2703,7 @@ STAGE PLANS:
Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2843,7 +2843,7 @@ STAGE PLANS:
Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/cross_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/cross_join.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/cross_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/cross_join.q.out Wed Sep 24 07:03:35 2014
@@ -1,4 +1,4 @@
-Warning: Shuffle Join JOIN[4][tables = [src, src2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[7][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:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -61,7 +61,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join JOIN[4][tables = [src, src2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[7][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:
- Join Operator
+ Merge 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:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out Wed Sep 24 07:03:35 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 JOIN[4][tables = [a, b]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[7][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:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -86,7 +86,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join JOIN[10][tables = [d1, d2, a]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[18][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:
- Join Operator
+ Merge 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:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -182,7 +182,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join JOIN[16][tables = [a, od1]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[25][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:
- Join Operator
+ Merge 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:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -308,8 +308,8 @@ STAGE PLANS:
Processor Tree:
ListSink
-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
+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
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:
- Join Operator
+ Merge 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:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -420,7 +420,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join JOIN[21][tables = [ss, od1]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[30][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:
- Join Operator
+ Merge 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:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/dynamic_partition_pruning.q.out Wed Sep 24 07:03:35 2014
@@ -244,7 +244,7 @@ STAGE PLANS:
Target Vertex: Map 1
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -349,7 +349,7 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -516,7 +516,7 @@ STAGE PLANS:
Target Vertex: Map 1
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -531,7 +531,7 @@ STAGE PLANS:
Statistics: Num rows: 2200 Data size: 23372 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -658,7 +658,7 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -673,7 +673,7 @@ STAGE PLANS:
Statistics: Num rows: 2200 Data size: 23372 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -824,7 +824,7 @@ STAGE PLANS:
Target Vertex: Map 1
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -929,7 +929,7 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -1062,7 +1062,7 @@ STAGE PLANS:
Target Vertex: Map 1
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -1167,7 +1167,7 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -1301,7 +1301,7 @@ STAGE PLANS:
Target Vertex: Map 1
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -1424,7 +1424,7 @@ STAGE PLANS:
Target Vertex: Map 1
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -1532,7 +1532,7 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -1640,7 +1640,7 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -1776,7 +1776,7 @@ STAGE PLANS:
Target Vertex: Map 1
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -1918,7 +1918,7 @@ STAGE PLANS:
Statistics: Num rows: 1000 Data size: 184000 Basic stats: COMPLETE Column stats: COMPLETE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2007,7 +2007,7 @@ POSTHOOK: Input: default@srcpart@ds=2008
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
1000
-Warning: Shuffle Join JOIN[4][tables = [srcpart, srcpart_date_hour]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[13][tables = [srcpart, srcpart_date_hour]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: -- non-equi join
EXPLAIN select count(*) from srcpart, srcpart_date_hour where (srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11) and (srcpart.ds = srcpart_date_hour.ds or srcpart.hr = srcpart_date_hour.hr)
PREHOOK: type: QUERY
@@ -2050,7 +2050,7 @@ STAGE PLANS:
value expressions: ds (type: string), hr (type: string)
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2097,7 +2097,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join JOIN[4][tables = [srcpart, srcpart_date_hour]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[13][tables = [srcpart, srcpart_date_hour]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select count(*) from srcpart, srcpart_date_hour where (srcpart_date_hour.date = '2008-04-08' and srcpart_date_hour.hour = 11) and (srcpart.ds = srcpart_date_hour.ds or srcpart.hr = srcpart_date_hour.hr)
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
@@ -2191,7 +2191,7 @@ STAGE PLANS:
Target Vertex: Map 1
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2298,7 +2298,7 @@ STAGE PLANS:
value expressions: date (type: string)
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -2402,7 +2402,7 @@ STAGE PLANS:
Target Vertex: Map 1
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -2486,7 +2486,7 @@ STAGE PLANS:
value expressions: date (type: string)
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
@@ -2625,7 +2625,7 @@ STAGE PLANS:
Target Vertex: Map 1
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2640,7 +2640,7 @@ STAGE PLANS:
Statistics: Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
Reducer 3
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2751,7 +2751,7 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2764,7 +2764,7 @@ STAGE PLANS:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reducer 3
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -2925,7 +2925,7 @@ STAGE PLANS:
Target Vertex: Map 6
Reducer 4
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -3122,7 +3122,7 @@ STAGE PLANS:
Target Vertex: Map 6
Reducer 4
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -3412,7 +3412,7 @@ STAGE PLANS:
Target Vertex: Map 8
Reducer 4
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -4671,7 +4671,7 @@ STAGE PLANS:
value expressions: date (type: string)
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Outer Join 0 to 1
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out Wed Sep 24 07:03:35 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/join0.q.out Wed Sep 24 07:03:35 2014
@@ -1,4 +1,4 @@
-Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[15][tables = [src1, src2]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: EXPLAIN
SELECT src1.key as k1, src1.value as v1,
src2.key as k2, src2.value as v2 FROM
@@ -61,7 +61,7 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string)
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -97,7 +97,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[15][tables = [src1, src2]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: EXPLAIN FORMATTED
SELECT src1.key as k1, src1.value as v1,
src2.key as k2, src2.value as v2 FROM
@@ -115,7 +115,7 @@ SELECT src1.key as k1, src1.value as v1,
SORT BY k1, v1, k2, v2
POSTHOOK: type: QUERY
#### A masked pattern was here ####
-Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[15][tables = [src1, src2]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: SELECT src1.key as k1, src1.value as v1,
src2.key as k2, src2.value as v2 FROM
(SELECT * FROM src WHERE src.key < 10) src1
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/join1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/join1.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/join1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/join1.q.out Wed Sep 24 07:03:35 2014
@@ -56,7 +56,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/limit_pushdown.q.out Wed Sep 24 07:03:35 2014
@@ -887,7 +887,7 @@ STAGE PLANS:
value expressions: _col1 (type: bigint)
Reducer 3
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/metadataonly1.q.out Wed Sep 24 07:03:35 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/mrr.q.out Wed Sep 24 07:03:35 2014
@@ -439,7 +439,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -1426,7 +1426,7 @@ STAGE PLANS:
value expressions: _col1 (type: bigint)
Reducer 4
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
Inner Join 0 to 2
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out Wed Sep 24 07:03:35 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/subquery_exists.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/subquery_exists.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/subquery_exists.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/subquery_exists.q.out Wed Sep 24 07:03:35 2014
@@ -66,7 +66,7 @@ STAGE PLANS:
Statistics: Num rows: 42 Data size: 446 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/subquery_in.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/subquery_in.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/subquery_in.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/subquery_in.q.out Wed Sep 24 07:03:35 2014
@@ -159,7 +159,7 @@ STAGE PLANS:
value expressions: value (type: string)
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -276,7 +276,7 @@ STAGE PLANS:
Statistics: Num rows: 42 Data size: 446 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -439,7 +439,7 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
Reducer 4
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -545,7 +545,7 @@ STAGE PLANS:
value expressions: p_mfgr (type: string), p_size (type: int)
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -714,7 +714,7 @@ STAGE PLANS:
Statistics: Num rows: 42 Data size: 446 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
@@ -901,7 +901,7 @@ STAGE PLANS:
Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
@@ -917,7 +917,7 @@ STAGE PLANS:
value expressions: _col0 (type: int), _col3 (type: int)
Reducer 3
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Semi Join 0 to 1
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out Wed Sep 24 07:03:35 2014
@@ -63,7 +63,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/tez_join_tests.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/tez_join_tests.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/tez_join_tests.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/tez_join_tests.q.out Wed Sep 24 07:03:35 2014
@@ -52,7 +52,7 @@ STAGE PLANS:
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -83,7 +83,7 @@ STAGE PLANS:
value expressions: _col0 (type: string)
Reducer 4
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out?rev=1627235&r1=1627234&r2=1627235&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out Wed Sep 24 07:03:35 2014
@@ -52,7 +52,7 @@ STAGE PLANS:
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Reducer 2
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Left Outer Join0 to 1
condition expressions:
@@ -83,7 +83,7 @@ STAGE PLANS:
value expressions: _col0 (type: string)
Reducer 4
Reduce Operator Tree:
- Join Operator
+ Merge Join Operator
condition map:
Right Outer Join0 to 1
condition expressions:
Added: hive/trunk/ql/src/test/results/clientpositive/tez/tez_smb_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/tez_smb_1.q.out?rev=1627235&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/tez_smb_1.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/tez_smb_1.q.out Wed Sep 24 07:03:35 2014
@@ -0,0 +1,689 @@
+PREHOOK: query: CREATE TABLE srcbucket_mapjoin(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@srcbucket_mapjoin
+POSTHOOK: query: CREATE TABLE srcbucket_mapjoin(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@srcbucket_mapjoin
+PREHOOK: query: CREATE TABLE tab_part (key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tab_part
+POSTHOOK: query: CREATE TABLE tab_part (key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tab_part
+PREHOOK: query: CREATE TABLE srcbucket_mapjoin_part (key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@srcbucket_mapjoin_part
+POSTHOOK: query: CREATE TABLE srcbucket_mapjoin_part (key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@srcbucket_mapjoin_part
+PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin partition(ds='2008-04-08')
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@srcbucket_mapjoin
+POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin partition(ds='2008-04-08')
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@srcbucket_mapjoin
+POSTHOOK: Output: default@srcbucket_mapjoin@ds=2008-04-08
+PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin partition(ds='2008-04-08')
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@srcbucket_mapjoin@ds=2008-04-08
+POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin partition(ds='2008-04-08')
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@srcbucket_mapjoin@ds=2008-04-08
+PREHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@srcbucket_mapjoin_part
+POSTHOOK: query: load data local inpath '../../data/files/srcbucket20.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@srcbucket_mapjoin_part
+POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
+PREHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
+POSTHOOK: query: load data local inpath '../../data/files/srcbucket21.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
+PREHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
+POSTHOOK: query: load data local inpath '../../data/files/srcbucket22.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
+PREHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
+POSTHOOK: query: load data local inpath '../../data/files/srcbucket23.txt' INTO TABLE srcbucket_mapjoin_part partition(ds='2008-04-08')
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@srcbucket_mapjoin_part@ds=2008-04-08
+PREHOOK: query: insert overwrite table tab_part partition (ds='2008-04-08')
+select key,value from srcbucket_mapjoin_part
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcbucket_mapjoin_part
+PREHOOK: Input: default@srcbucket_mapjoin_part@ds=2008-04-08
+PREHOOK: Output: default@tab_part@ds=2008-04-08
+POSTHOOK: query: insert overwrite table tab_part partition (ds='2008-04-08')
+select key,value from srcbucket_mapjoin_part
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcbucket_mapjoin_part
+POSTHOOK: Input: default@srcbucket_mapjoin_part@ds=2008-04-08
+POSTHOOK: Output: default@tab_part@ds=2008-04-08
+POSTHOOK: Lineage: tab_part PARTITION(ds=2008-04-08).key SIMPLE [(srcbucket_mapjoin_part)srcbucket_mapjoin_part.FieldSchema(name:key, type:int, comment:null), ]
+POSTHOOK: Lineage: tab_part PARTITION(ds=2008-04-08).value SIMPLE [(srcbucket_mapjoin_part)srcbucket_mapjoin_part.FieldSchema(name:value, type:string, comment:null), ]
+PREHOOK: query: CREATE TABLE tab(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tab
+POSTHOOK: query: CREATE TABLE tab(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@tab
+PREHOOK: query: insert overwrite table tab partition (ds='2008-04-08')
+select key,value from srcbucket_mapjoin
+PREHOOK: type: QUERY
+PREHOOK: Input: default@srcbucket_mapjoin
+PREHOOK: Input: default@srcbucket_mapjoin@ds=2008-04-08
+PREHOOK: Output: default@tab@ds=2008-04-08
+POSTHOOK: query: insert overwrite table tab partition (ds='2008-04-08')
+select key,value from srcbucket_mapjoin
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcbucket_mapjoin
+POSTHOOK: Input: default@srcbucket_mapjoin@ds=2008-04-08
+POSTHOOK: Output: default@tab@ds=2008-04-08
+POSTHOOK: Lineage: tab PARTITION(ds=2008-04-08).key SIMPLE [(srcbucket_mapjoin)srcbucket_mapjoin.FieldSchema(name:key, type:int, comment:null), ]
+POSTHOOK: Lineage: tab PARTITION(ds=2008-04-08).value SIMPLE [(srcbucket_mapjoin)srcbucket_mapjoin.FieldSchema(name:value, type:string, comment:null), ]
+PREHOOK: query: explain
+select count(*) from tab s1 join tab s3 on s1.key=s3.key
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select count(*) from tab s1 join tab s3 on s1.key=s3.key
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+ Edges:
+ Reducer 2 <- Map 1 (SIMPLE_EDGE)
+#### A masked pattern was here ####
+ Vertices:
+ Map 1
+ Map Operator Tree:
+ TableScan
+ alias: s3
+ Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: key is not null (type: boolean)
+ Statistics: Num rows: 121 Data size: 1283 Basic stats: COMPLETE Column stats: NONE
+ Map Operator Tree:
+ TableScan
+ alias: s1
+ Statistics: Num rows: 242 Data size: 2566 Basic stats: COMPLETE Column stats: NONE
+ Filter Operator
+ predicate: key is not null (type: boolean)
+ Statistics: Num rows: 121 Data size: 1283 Basic stats: COMPLETE Column stats: NONE
+ Merge Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0
+ 1
+ keys:
+ 0 key (type: int)
+ 1 key (type: int)
+ Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
+ Group By Operator
+ aggregations: count()
+ mode: hash
+ outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Reduce Output Operator
+ sort order:
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: bigint)
+ Reducer 2
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations: count(VALUE._col0)
+ mode: mergepartial
+ outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: _col0 (type: bigint)
+ outputColumnNames: _col0
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: select s1.key, s1.value, s3.value from tab s1 join tab s3 on s1.key=s3.key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tab
+PREHOOK: Input: default@tab@ds=2008-04-08
+#### A masked pattern was here ####
+POSTHOOK: query: select s1.key, s1.value, s3.value from tab s1 join tab s3 on s1.key=s3.key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tab
+POSTHOOK: Input: default@tab@ds=2008-04-08
+#### A masked pattern was here ####
+0 val_0 val_0
+0 val_0 val_0
+0 val_0 val_0
+0 val_0 val_0
+0 val_0 val_0
+0 val_0 val_0
+0 val_0 val_0
+0 val_0 val_0
+0 val_0 val_0
+2 val_2 val_2
+4 val_4 val_4
+8 val_8 val_8
+20 val_20 val_20
+24 val_24 val_24
+24 val_24 val_24
+24 val_24 val_24
+24 val_24 val_24
+26 val_26 val_26
+26 val_26 val_26
+26 val_26 val_26
+26 val_26 val_26
+28 val_28 val_28
+42 val_42 val_42
+42 val_42 val_42
+42 val_42 val_42
+42 val_42 val_42
+44 val_44 val_44
+64 val_64 val_64
+66 val_66 val_66
+80 val_80 val_80
+82 val_82 val_82
+84 val_84 val_84
+84 val_84 val_84
+84 val_84 val_84
+84 val_84 val_84
+86 val_86 val_86
+114 val_114 val_114
+116 val_116 val_116
+118 val_118 val_118
+118 val_118 val_118
+118 val_118 val_118
+118 val_118 val_118
+134 val_134 val_134
+134 val_134 val_134
+134 val_134 val_134
+134 val_134 val_134
+136 val_136 val_136
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+138 val_138 val_138
+150 val_150 val_150
+152 val_152 val_152
+152 val_152 val_152
+152 val_152 val_152
+152 val_152 val_152
+156 val_156 val_156
+158 val_158 val_158
+170 val_170 val_170
+172 val_172 val_172
+172 val_172 val_172
+172 val_172 val_172
+172 val_172 val_172
+174 val_174 val_174
+174 val_174 val_174
+174 val_174 val_174
+174 val_174 val_174
+176 val_176 val_176
+176 val_176 val_176
+176 val_176 val_176
+176 val_176 val_176
+178 val_178 val_178
+190 val_190 val_190
+192 val_192 val_192
+194 val_194 val_194
+196 val_196 val_196
+200 val_200 val_200
+200 val_200 val_200
+200 val_200 val_200
+200 val_200 val_200
+202 val_202 val_202
+208 val_208 val_208
+208 val_208 val_208
+208 val_208 val_208
+208 val_208 val_208
+208 val_208 val_208
+208 val_208 val_208
+208 val_208 val_208
+208 val_208 val_208
+208 val_208 val_208
+222 val_222 val_222
+224 val_224 val_224
+224 val_224 val_224
+224 val_224 val_224
+224 val_224 val_224
+226 val_226 val_226
+228 val_228 val_228
+242 val_242 val_242
+242 val_242 val_242
+242 val_242 val_242
+242 val_242 val_242
+244 val_244 val_244
+248 val_248 val_248
+260 val_260 val_260
+262 val_262 val_262
+266 val_266 val_266
+280 val_280 val_280
+280 val_280 val_280
+280 val_280 val_280
+280 val_280 val_280
+282 val_282 val_282
+282 val_282 val_282
+282 val_282 val_282
+282 val_282 val_282
+284 val_284 val_284
+286 val_286 val_286
+288 val_288 val_288
+288 val_288 val_288
+288 val_288 val_288
+288 val_288 val_288
+310 val_310 val_310
+316 val_316 val_316
+316 val_316 val_316
+316 val_316 val_316
+316 val_316 val_316
+316 val_316 val_316
+316 val_316 val_316
+316 val_316 val_316
+316 val_316 val_316
+316 val_316 val_316
+318 val_318 val_318
+318 val_318 val_318
+318 val_318 val_318
+318 val_318 val_318
+318 val_318 val_318
+318 val_318 val_318
+318 val_318 val_318
+318 val_318 val_318
+318 val_318 val_318
+332 val_332 val_332
+336 val_336 val_336
+338 val_338 val_338
+356 val_356 val_356
+374 val_374 val_374
+378 val_378 val_378
+392 val_392 val_392
+394 val_394 val_394
+396 val_396 val_396
+396 val_396 val_396
+396 val_396 val_396
+396 val_396 val_396
+396 val_396 val_396
+396 val_396 val_396
+396 val_396 val_396
+396 val_396 val_396
+396 val_396 val_396
+400 val_400 val_400
+402 val_402 val_402
+404 val_404 val_404
+404 val_404 val_404
+404 val_404 val_404
+404 val_404 val_404
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+406 val_406 val_406
+424 val_424 val_424
+424 val_424 val_424
+424 val_424 val_424
+424 val_424 val_424
+444 val_444 val_444
+446 val_446 val_446
+448 val_448 val_448
+460 val_460 val_460
+462 val_462 val_462
+462 val_462 val_462
+462 val_462 val_462
+462 val_462 val_462
+466 val_466 val_466
+466 val_466 val_466
+466 val_466 val_466
+466 val_466 val_466
+466 val_466 val_466
+466 val_466 val_466
+466 val_466 val_466
+466 val_466 val_466
+466 val_466 val_466
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+468 val_468 val_468
+480 val_480 val_480
+480 val_480 val_480
+480 val_480 val_480
+480 val_480 val_480
+480 val_480 val_480
+480 val_480 val_480
+480 val_480 val_480
+480 val_480 val_480
+480 val_480 val_480
+482 val_482 val_482
+484 val_484 val_484
+11 val_11 val_11
+15 val_15 val_15
+15 val_15 val_15
+15 val_15 val_15
+15 val_15 val_15
+17 val_17 val_17
+19 val_19 val_19
+33 val_33 val_33
+35 val_35 val_35
+35 val_35 val_35
+35 val_35 val_35
+35 val_35 val_35
+35 val_35 val_35
+35 val_35 val_35
+35 val_35 val_35
+35 val_35 val_35
+35 val_35 val_35
+37 val_37 val_37
+37 val_37 val_37
+37 val_37 val_37
+37 val_37 val_37
+51 val_51 val_51
+51 val_51 val_51
+51 val_51 val_51
+51 val_51 val_51
+53 val_53 val_53
+57 val_57 val_57
+77 val_77 val_77
+95 val_95 val_95
+95 val_95 val_95
+95 val_95 val_95
+95 val_95 val_95
+97 val_97 val_97
+97 val_97 val_97
+97 val_97 val_97
+97 val_97 val_97
+103 val_103 val_103
+103 val_103 val_103
+103 val_103 val_103
+103 val_103 val_103
+105 val_105 val_105
+125 val_125 val_125
+125 val_125 val_125
+125 val_125 val_125
+125 val_125 val_125
+129 val_129 val_129
+129 val_129 val_129
+129 val_129 val_129
+129 val_129 val_129
+143 val_143 val_143
+145 val_145 val_145
+149 val_149 val_149
+149 val_149 val_149
+149 val_149 val_149
+149 val_149 val_149
+163 val_163 val_163
+165 val_165 val_165
+165 val_165 val_165
+165 val_165 val_165
+165 val_165 val_165
+167 val_167 val_167
+167 val_167 val_167
+167 val_167 val_167
+167 val_167 val_167
+167 val_167 val_167
+167 val_167 val_167
+167 val_167 val_167
+167 val_167 val_167
+167 val_167 val_167
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+169 val_169 val_169
+181 val_181 val_181
+183 val_183 val_183
+187 val_187 val_187
+187 val_187 val_187
+187 val_187 val_187
+187 val_187 val_187
+187 val_187 val_187
+187 val_187 val_187
+187 val_187 val_187
+187 val_187 val_187
+187 val_187 val_187
+189 val_189 val_189
+213 val_213 val_213
+213 val_213 val_213
+213 val_213 val_213
+213 val_213 val_213
+217 val_217 val_217
+217 val_217 val_217
+217 val_217 val_217
+217 val_217 val_217
+219 val_219 val_219
+219 val_219 val_219
+219 val_219 val_219
+219 val_219 val_219
+233 val_233 val_233
+233 val_233 val_233
+233 val_233 val_233
+233 val_233 val_233
+235 val_235 val_235
+237 val_237 val_237
+237 val_237 val_237
+237 val_237 val_237
+237 val_237 val_237
+239 val_239 val_239
+239 val_239 val_239
+239 val_239 val_239
+239 val_239 val_239
+255 val_255 val_255
+255 val_255 val_255
+255 val_255 val_255
+255 val_255 val_255
+257 val_257 val_257
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+273 val_273 val_273
+275 val_275 val_275
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+277 val_277 val_277
+291 val_291 val_291
+305 val_305 val_305
+307 val_307 val_307
+307 val_307 val_307
+307 val_307 val_307
+307 val_307 val_307
+309 val_309 val_309
+309 val_309 val_309
+309 val_309 val_309
+309 val_309 val_309
+321 val_321 val_321
+321 val_321 val_321
+321 val_321 val_321
+321 val_321 val_321
+323 val_323 val_323
+325 val_325 val_325
+325 val_325 val_325
+325 val_325 val_325
+325 val_325 val_325
+327 val_327 val_327
+327 val_327 val_327
+327 val_327 val_327
+327 val_327 val_327
+327 val_327 val_327
+327 val_327 val_327
+327 val_327 val_327
+327 val_327 val_327
+327 val_327 val_327
+341 val_341 val_341
+345 val_345 val_345
+365 val_365 val_365
+367 val_367 val_367
+367 val_367 val_367
+367 val_367 val_367
+367 val_367 val_367
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+369 val_369 val_369
+389 val_389 val_389
+411 val_411 val_411
+413 val_413 val_413
+413 val_413 val_413
+413 val_413 val_413
+413 val_413 val_413
+417 val_417 val_417
+417 val_417 val_417
+417 val_417 val_417
+417 val_417 val_417
+417 val_417 val_417
+417 val_417 val_417
+417 val_417 val_417
+417 val_417 val_417
+417 val_417 val_417
+419 val_419 val_419
+431 val_431 val_431
+431 val_431 val_431
+431 val_431 val_431
+431 val_431 val_431
+431 val_431 val_431
+431 val_431 val_431
+431 val_431 val_431
+431 val_431 val_431
+431 val_431 val_431
+435 val_435 val_435
+437 val_437 val_437
+439 val_439 val_439
+439 val_439 val_439
+439 val_439 val_439
+439 val_439 val_439
+453 val_453 val_453
+455 val_455 val_455
+457 val_457 val_457
+459 val_459 val_459
+459 val_459 val_459
+459 val_459 val_459
+459 val_459 val_459
+475 val_475 val_475
+477 val_477 val_477
+479 val_479 val_479
+491 val_491 val_491
+493 val_493 val_493
+495 val_495 val_495
+497 val_497 val_497
+PREHOOK: query: select count(*) from tab s2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@tab
+PREHOOK: Input: default@tab@ds=2008-04-08
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from tab s2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@tab
+POSTHOOK: Input: default@tab@ds=2008-04-08
+#### A masked pattern was here ####
+242