You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/07/23 02:50:40 UTC
svn commit: r1505870 [2/2] - in /hive/trunk/ql/src:
java/org/apache/hadoop/hive/ql/exec/ java/org/apache/hadoop/hive/ql/lib/
java/org/apache/hadoop/hive/ql/optimizer/
java/org/apache/hadoop/hive/ql/parse/ java/org/apache/hadoop/hive/ql/plan/
test/queri...
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin1.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin1.q.out Tue Jul 23 00:50:39 2013
@@ -338,13 +338,13 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-9 is a root stage
Stage-1 depends on stages: Stage-9
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-9
@@ -481,10 +481,10 @@ STAGE PLANS:
Truncated Path -> Alias:
/srcbucket_mapjoin [a]
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -512,11 +512,11 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -582,7 +582,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -648,7 +648,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin2.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin2.q.out Tue Jul 23 00:50:39 2013
@@ -79,13 +79,13 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-9 is a root stage
Stage-1 depends on stages: Stage-9
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-9
@@ -225,10 +225,10 @@ STAGE PLANS:
Truncated Path -> Alias:
/srcbucket_mapjoin_part/ds=2008-04-08 [a]
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -256,11 +256,11 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -326,7 +326,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -392,7 +392,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
@@ -1272,13 +1272,13 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-9 is a root stage
Stage-1 depends on stages: Stage-9
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-9
@@ -1423,10 +1423,10 @@ STAGE PLANS:
Truncated Path -> Alias:
/srcbucket_mapjoin_part/ds=2008-04-08 [a]
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -1459,11 +1459,11 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -1544,7 +1544,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -1625,7 +1625,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin3.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin3.q.out Tue Jul 23 00:50:39 2013
@@ -96,13 +96,13 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-9 is a root stage
Stage-1 depends on stages: Stage-9
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-9
@@ -242,10 +242,10 @@ STAGE PLANS:
Truncated Path -> Alias:
/srcbucket_mapjoin_part_2/ds=2008-04-08 [a]
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -273,11 +273,11 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -343,7 +343,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -409,7 +409,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin4.q.out Tue Jul 23 00:50:39 2013
@@ -96,13 +96,13 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-9 is a root stage
Stage-1 depends on stages: Stage-9
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-9
@@ -239,10 +239,10 @@ STAGE PLANS:
Truncated Path -> Alias:
/srcbucket_mapjoin [a]
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -270,11 +270,11 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -340,7 +340,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -406,7 +406,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative.q.out Tue Jul 23 00:50:39 2013
@@ -62,13 +62,13 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-9 is a root stage
Stage-1 depends on stages: Stage-9
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-9
@@ -197,10 +197,10 @@ STAGE PLANS:
Truncated Path -> Alias:
/srcbucket_mapjoin [a]
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -228,11 +228,11 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -298,7 +298,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -364,7 +364,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketmapjoin_negative2.q.out Tue Jul 23 00:50:39 2013
@@ -69,13 +69,13 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-9 is a root stage
Stage-1 depends on stages: Stage-9
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-9
@@ -212,10 +212,10 @@ STAGE PLANS:
Truncated Path -> Alias:
/srcbucket_mapjoin [a]
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -243,11 +243,11 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -313,7 +313,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -379,7 +379,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_2.q.out Tue Jul 23 00:50:39 2013
@@ -111,7 +111,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -160,7 +160,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
@@ -290,7 +290,7 @@ STAGE DEPENDENCIES:
Stage-7 has a backup stage: Stage-1
Stage-4 depends on stages: Stage-7
Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
Stage-8 has a backup stage: Stage-1
Stage-5 depends on stages: Stage-8
Stage-1
@@ -383,7 +383,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
Stage: Stage-8
@@ -665,7 +665,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -714,7 +714,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_4.q.out Tue Jul 23 00:50:39 2013
@@ -73,7 +73,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -124,7 +124,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
@@ -271,7 +271,7 @@ STAGE DEPENDENCIES:
Stage-7 has a backup stage: Stage-1
Stage-4 depends on stages: Stage-7
Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
Stage-8 has a backup stage: Stage-1
Stage-5 depends on stages: Stage-8
Stage-1
@@ -364,7 +364,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
Stage: Stage-8
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_5.q.out Tue Jul 23 00:50:39 2013
@@ -75,7 +75,7 @@ STAGE DEPENDENCIES:
Stage-7 has a backup stage: Stage-1
Stage-4 depends on stages: Stage-7
Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
Stage-8 has a backup stage: Stage-1
Stage-5 depends on stages: Stage-8
Stage-1
@@ -168,7 +168,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
Stage: Stage-8
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_6.q.out Tue Jul 23 00:50:39 2013
@@ -78,7 +78,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -129,7 +129,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
@@ -454,7 +454,7 @@ STAGE DEPENDENCIES:
Stage-7 has a backup stage: Stage-1
Stage-4 depends on stages: Stage-7
Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
Stage-8 has a backup stage: Stage-1
Stage-5 depends on stages: Stage-8
Stage-1
@@ -555,7 +555,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
Stage: Stage-8
@@ -1028,7 +1028,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -1079,7 +1079,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
@@ -1251,7 +1251,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -1302,7 +1302,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
@@ -1513,7 +1513,7 @@ STAGE DEPENDENCIES:
Stage-7 has a backup stage: Stage-1
Stage-4 depends on stages: Stage-7
Stage-0 depends on stages: Stage-1, Stage-4, Stage-5
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
Stage-8 has a backup stage: Stage-1
Stage-5 depends on stages: Stage-8
Stage-1
@@ -1614,7 +1614,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table4
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
Stage: Stage-8
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_7.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_7.q.out Tue Jul 23 00:50:39 2013
@@ -75,7 +75,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -128,7 +128,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_8.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/bucketsortoptimize_insert_8.q.out Tue Jul 23 00:50:39 2013
@@ -73,7 +73,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -124,7 +124,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
@@ -240,7 +240,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -291,7 +291,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.test_table3
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer3.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer3.q.out Tue Jul 23 00:50:39 2013
@@ -670,7 +670,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
-#### A masked pattern was here ####
+ $INTNAME
Reduce Output Operator
key expressions:
expr: _col0
@@ -683,7 +683,7 @@ STAGE PLANS:
value expressions:
expr: _col1
type: bigint
-#### A masked pattern was here ####
+ $INTNAME1
Reduce Output Operator
key expressions:
expr: _col0
@@ -1547,7 +1547,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
-#### A masked pattern was here ####
+ $INTNAME
Reduce Output Operator
key expressions:
expr: _col0
@@ -1560,7 +1560,7 @@ STAGE PLANS:
value expressions:
expr: _col1
type: string
-#### A masked pattern was here ####
+ $INTNAME1
Reduce Output Operator
key expressions:
expr: _col0
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer6.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer6.q.out Tue Jul 23 00:50:39 2013
@@ -733,7 +733,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
-#### A masked pattern was here ####
+ $INTNAME
Reduce Output Operator
key expressions:
expr: _col0
@@ -746,7 +746,7 @@ STAGE PLANS:
value expressions:
expr: _col1
type: bigint
-#### A masked pattern was here ####
+ $INTNAME1
Reduce Output Operator
key expressions:
expr: _col0
@@ -4891,7 +4891,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
-#### A masked pattern was here ####
+ $INTNAME
Reduce Output Operator
key expressions:
expr: _col0
@@ -5236,7 +5236,7 @@ STAGE PLANS:
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
-#### A masked pattern was here ####
+ $INTNAME
Reduce Output Operator
key expressions:
expr: _col0
@@ -5253,7 +5253,7 @@ STAGE PLANS:
type: string
expr: _col2
type: bigint
-#### A masked pattern was here ####
+ $INTNAME1
Reduce Output Operator
key expressions:
expr: _col0
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer7.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer7.q.out Tue Jul 23 00:50:39 2013
@@ -349,7 +349,7 @@ STAGE PLANS:
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
-#### A masked pattern was here ####
+ $INTNAME
Reduce Output Operator
key expressions:
expr: _col0
@@ -871,7 +871,7 @@ STAGE PLANS:
Stage: Stage-1
Map Reduce
Alias -> Map Operator Tree:
-#### A masked pattern was here ####
+ $INTNAME
Reduce Output Operator
key expressions:
expr: _col0
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_distinct.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_distinct.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_distinct.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_distinct.q.out Tue Jul 23 00:50:39 2013
@@ -16,7 +16,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-4 is a root stage
Stage-1 depends on stages: Stage-4
- Stage-2 depends on stages: Stage-1
+ Stage-3 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
@@ -96,7 +96,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- Stage: Stage-2
+ Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -315,7 +315,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-4 is a root stage
Stage-1 depends on stages: Stage-4
- Stage-2 depends on stages: Stage-1
+ Stage-3 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
@@ -388,7 +388,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- Stage: Stage-2
+ Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out Tue Jul 23 00:50:39 2013
@@ -247,14 +247,14 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-9 depends on stages: Stage-0
- Stage-2 depends on stages: Stage-9
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-9 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-9
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-1
@@ -298,10 +298,10 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
name: default.smb_mapjoin9_results
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -324,10 +324,10 @@ STAGE PLANS:
name: smb_mapjoin9_results
isExternal: false
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -339,7 +339,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
name: default.smb_mapjoin9_results
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -351,7 +351,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
name: default.smb_mapjoin9_results
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out Tue Jul 23 00:50:39 2013
@@ -61,7 +61,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -198,7 +198,7 @@ STAGE PLANS:
name: default.test_table3
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_12.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_12.q.out Tue Jul 23 00:50:39 2013
@@ -81,7 +81,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -220,7 +220,7 @@ STAGE PLANS:
name: default.test_table3
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
@@ -306,7 +306,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-0
+ Stage-3 depends on stages: Stage-0
STAGE PLANS:
Stage: Stage-1
@@ -455,7 +455,7 @@ STAGE PLANS:
name: default.test_table3
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_14.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_14.q.out Tue Jul 23 00:50:39 2013
@@ -160,7 +160,7 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
+ Stage-3 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
@@ -232,7 +232,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- Stage: Stage-2
+ Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
Added: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out?rev=1505870&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out Tue Jul 23 00:50:39 2013
@@ -0,0 +1,371 @@
+PREHOOK: query: create table smb_bucket_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table smb_bucket_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@smb_bucket_1
+PREHOOK: query: create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table smb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@smb_bucket_2
+PREHOOK: query: create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table smb_bucket_3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS STORED AS RCFILE
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@smb_bucket_3
+PREHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1
+PREHOOK: type: LOAD
+PREHOOK: Output: default@smb_bucket_1
+POSTHOOK: query: load data local inpath '../data/files/smbbucket_1.rc' overwrite into table smb_bucket_1
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@smb_bucket_1
+PREHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2
+PREHOOK: type: LOAD
+PREHOOK: Output: default@smb_bucket_2
+POSTHOOK: query: load data local inpath '../data/files/smbbucket_2.rc' overwrite into table smb_bucket_2
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@smb_bucket_2
+PREHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3
+PREHOOK: type: LOAD
+PREHOOK: Output: default@smb_bucket_3
+POSTHOOK: query: load data local inpath '../data/files/smbbucket_3.rc' overwrite into table smb_bucket_3
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@smb_bucket_3
+PREHOOK: query: explain
+select * from (select a.key from smb_bucket_1 a join smb_bucket_2 b on (a.key = b.key) where a.key = 5) t1 left outer join (select c.key from smb_bucket_2 c join smb_bucket_3 d on (c.key = d.key) where c.key=5) t2 on (t1.key=t2.key) where t2.key=5
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select * from (select a.key from smb_bucket_1 a join smb_bucket_2 b on (a.key = b.key) where a.key = 5) t1 left outer join (select c.key from smb_bucket_2 c join smb_bucket_3 d on (c.key = d.key) where c.key=5) t2 on (t1.key=t2.key) where t2.key=5
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL a) key) 5)))) t1) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME smb_bucket_2) c) (TOK_TABREF (TOK_TABNAME smb_bucket_3) d) (= (. (TOK_TABLE_OR_COL c) key) (. (TOK_TABLE_OR_COL d) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL c) key))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL c) key) 5)))) t2) (= (. (TOK_TABLE_OR_COL t1) key) (. (TOK_TABLE_OR_COL t2) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (= (. (TOK_TABLE_OR_COL t2) key) 5))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1, Stage-4
+ Stage-4 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ t1:a
+ TableScan
+ alias: a
+ Filter Operator
+ predicate:
+ expr: (key = 5)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: int
+ tag: 0
+ value expressions:
+ expr: key
+ type: int
+ t1:b
+ TableScan
+ alias: b
+ Filter Operator
+ predicate:
+ expr: (key = 5)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: int
+ tag: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {VALUE._col0}
+ 1
+ handleSkewJoin: false
+ outputColumnNames: _col0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ $INTNAME
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: int
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: int
+ $INTNAME1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: int
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: int
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {VALUE._col0}
+ 1 {VALUE._col0}
+ handleSkewJoin: false
+ outputColumnNames: _col0, _col1
+ Filter Operator
+ predicate:
+ expr: (_col1 = 5)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: int
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-4
+ Map Reduce
+ Alias -> Map Operator Tree:
+ t2:c
+ TableScan
+ alias: c
+ Filter Operator
+ predicate:
+ expr: (key = 5)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: int
+ tag: 0
+ value expressions:
+ expr: key
+ type: int
+ t2:d
+ TableScan
+ alias: d
+ Filter Operator
+ predicate:
+ expr: (key = 5)
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: int
+ tag: 1
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {VALUE._col0}
+ 1
+ handleSkewJoin: false
+ outputColumnNames: _col0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: -- explain
+-- select * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join src c on a.key=c.value
+
+-- select a.key from smb_bucket_1 a
+
+explain
+select * from (select a.key from smb_bucket_1 a join smb_bucket_2 b on (a.key = b.key) where a.key = 5) t1 left outer join (select c.key from smb_bucket_2 c join smb_bucket_3 d on (c.key = d.key) where c.key=5) t2 on (t1.key=t2.key) where t2.key=5
+PREHOOK: type: QUERY
+POSTHOOK: query: -- explain
+-- select * from smb_bucket_1 a left outer join smb_bucket_2 b on a.key = b.key left outer join src c on a.key=c.value
+
+-- select a.key from smb_bucket_1 a
+
+explain
+select * from (select a.key from smb_bucket_1 a join smb_bucket_2 b on (a.key = b.key) where a.key = 5) t1 left outer join (select c.key from smb_bucket_2 c join smb_bucket_3 d on (c.key = d.key) where c.key=5) t2 on (t1.key=t2.key) where t2.key=5
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_LEFTOUTERJOIN (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME smb_bucket_1) a) (TOK_TABREF (TOK_TABNAME smb_bucket_2) b) (= (. (TOK_TABLE_OR_COL a) key) (. (TOK_TABLE_OR_COL b) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) key))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL a) key) 5)))) t1) (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_TABREF (TOK_TABNAME smb_bucket_2) c) (TOK_TABREF (TOK_TABNAME smb_bucket_3) d) (= (. (TOK_TABLE_OR_COL c) key) (. (TOK_TABLE_OR_COL d) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL c) key))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL c) key) 5)))) t2) (= (. (TOK_TABLE_OR_COL t1) key) (. (TOK_TABLE_OR_COL t2) key)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (= (. (TOK_TABLE_OR_COL t2) key) 5))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ t1:a
+ TableScan
+ alias: a
+ Filter Operator
+ predicate:
+ expr: (key = 5)
+ type: boolean
+ Sorted Merge Bucket Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[key]]
+ outputColumnNames: _col0
+ Position of Big Table: 0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ outputColumnNames: _col0
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: int
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: int
+ t2:c
+ TableScan
+ alias: c
+ Filter Operator
+ predicate:
+ expr: (key = 5)
+ type: boolean
+ Sorted Merge Bucket Map Join Operator
+ condition map:
+ Inner Join 0 to 1
+ condition expressions:
+ 0 {key}
+ 1
+ handleSkewJoin: false
+ keys:
+ 0 [Column[key]]
+ 1 [Column[key]]
+ outputColumnNames: _col0
+ Position of Big Table: 0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ outputColumnNames: _col0
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: int
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: int
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: int
+ Reduce Operator Tree:
+ Join Operator
+ condition map:
+ Left Outer Join0 to 1
+ condition expressions:
+ 0 {VALUE._col0}
+ 1 {VALUE._col0}
+ handleSkewJoin: false
+ outputColumnNames: _col0, _col1
+ Filter Operator
+ predicate:
+ expr: (_col1 = 5)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: _col0
+ type: int
+ expr: _col1
+ type: int
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: select * from (select a.key from smb_bucket_1 a join smb_bucket_2 b on (a.key = b.key) where a.key = 5) t1 left outer join (select c.key from smb_bucket_2 c join smb_bucket_3 d on (c.key = d.key) where c.key=5) t2 on (t1.key=t2.key) where t2.key=5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@smb_bucket_1
+PREHOOK: Input: default@smb_bucket_2
+PREHOOK: Input: default@smb_bucket_3
+#### A masked pattern was here ####
+POSTHOOK: query: select * from (select a.key from smb_bucket_1 a join smb_bucket_2 b on (a.key = b.key) where a.key = 5) t1 left outer join (select c.key from smb_bucket_2 c join smb_bucket_3 d on (c.key = d.key) where c.key=5) t2 on (t1.key=t2.key) where t2.key=5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@smb_bucket_1
+POSTHOOK: Input: default@smb_bucket_2
+POSTHOOK: Input: default@smb_bucket_3
+#### A masked pattern was here ####
Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_6.q.out Tue Jul 23 00:50:39 2013
@@ -1316,13 +1316,13 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-1
@@ -1363,10 +1363,10 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.smb_join_results
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -1382,10 +1382,10 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.smb_join_results
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -1398,7 +1398,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.smb_join_results
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -1411,7 +1411,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.smb_join_results
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
@@ -2858,13 +2858,13 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-1
@@ -2909,10 +2909,10 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.smb_join_results
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -2928,10 +2928,10 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.smb_join_results
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -2944,7 +2944,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.smb_join_results
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -2957,7 +2957,7 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: default.smb_join_results
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true
Modified: hive/trunk/ql/src/test/results/clientpositive/stats11.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats11.q.out?rev=1505870&r1=1505869&r2=1505870&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats11.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats11.q.out Tue Jul 23 00:50:39 2013
@@ -283,13 +283,13 @@ ABSTRACT SYNTAX TREE:
STAGE DEPENDENCIES:
Stage-9 is a root stage
Stage-1 depends on stages: Stage-9
- Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
- Stage-4
- Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
- Stage-2 depends on stages: Stage-0
- Stage-3
+ Stage-8 depends on stages: Stage-1 , consists of Stage-5, Stage-4, Stage-6
Stage-5
- Stage-6 depends on stages: Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4, Stage-7
+ Stage-3 depends on stages: Stage-0
+ Stage-4
+ Stage-6
+ Stage-7 depends on stages: Stage-6
STAGE PLANS:
Stage: Stage-9
@@ -426,10 +426,10 @@ STAGE PLANS:
Truncated Path -> Alias:
/srcbucket_mapjoin [a]
- Stage: Stage-7
+ Stage: Stage-8
Conditional Operator
- Stage: Stage-4
+ Stage: Stage-5
Move Operator
files:
hdfs directory: true
@@ -457,11 +457,11 @@ STAGE PLANS:
name: default.bucketmapjoin_tmp_result
#### A masked pattern was here ####
- Stage: Stage-2
+ Stage: Stage-3
Stats-Aggr Operator
#### A masked pattern was here ####
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -527,7 +527,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-5
+ Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
#### A masked pattern was here ####
@@ -593,7 +593,7 @@ STAGE PLANS:
Truncated Path -> Alias:
#### A masked pattern was here ####
- Stage: Stage-6
+ Stage: Stage-7
Move Operator
files:
hdfs directory: true