You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/11/23 06:59:26 UTC
svn commit: r1641162 [10/24] - in /hive/trunk:
hbase-handler/src/test/results/positive/
metastore/src/java/org/apache/hadoop/hive/metastore/
ql/src/java/org/apache/hadoop/hive/ql/parse/
ql/src/test/results/clientnegative/ ql/src/test/results/clientposi...
Modified: hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multiMapJoin1.q.out Sun Nov 23 05:59:20 2014
@@ -181,12 +181,12 @@ JOIN
smallTbl2 on (firstjoin.value1 = smallTbl2.value)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-7 is a root stage
- Stage-2 depends on stages: Stage-7
- Stage-0 depends on stages: Stage-2
+ Stage-8 is a root stage
+ Stage-3 depends on stages: Stage-8
+ Stage-0 depends on stages: Stage-3
STAGE PLANS:
- Stage: Stage-7
+ Stage: Stage-8
Map Reduce Local Work
Alias -> Map Local Tables:
firstjoin:smalltbl1
@@ -225,7 +225,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 value (type: string)
- Stage: Stage-2
+ Stage: Stage-3
Map Reduce
Map Operator Tree:
TableScan
@@ -314,8 +314,8 @@ POSTHOOK: Input: default@bigtbl
POSTHOOK: Input: default@smalltbl1
POSTHOOK: Input: default@smalltbl2
#### A masked pattern was here ####
-RUN: Stage-7:MAPREDLOCAL
-RUN: Stage-2:MAPRED
+RUN: Stage-8:MAPREDLOCAL
+RUN: Stage-3:MAPRED
580
PREHOOK: query: -- Now run a query with two-way join, which should be converted into a
-- map-join followed by groupby - two MR jobs overall
@@ -340,12 +340,12 @@ JOIN
smallTbl2 on (firstjoin.value1 = smallTbl2.value)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-7 is a root stage
- Stage-2 depends on stages: Stage-7
- Stage-0 depends on stages: Stage-2
+ Stage-8 is a root stage
+ Stage-3 depends on stages: Stage-8
+ Stage-0 depends on stages: Stage-3
STAGE PLANS:
- Stage: Stage-7
+ Stage: Stage-8
Map Reduce Local Work
Alias -> Map Local Tables:
firstjoin:smalltbl1
@@ -384,7 +384,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 value (type: string)
- Stage: Stage-2
+ Stage: Stage-3
Map Reduce
Map Operator Tree:
TableScan
@@ -473,8 +473,8 @@ POSTHOOK: Input: default@bigtbl
POSTHOOK: Input: default@smalltbl1
POSTHOOK: Input: default@smalltbl2
#### A masked pattern was here ####
-RUN: Stage-7:MAPREDLOCAL
-RUN: Stage-2:MAPRED
+RUN: Stage-8:MAPREDLOCAL
+RUN: Stage-3:MAPRED
580
PREHOOK: query: -- Now run a query with two-way join, which should first be converted into a
-- map-join followed by groupby and then finally into a single MR job.
@@ -503,12 +503,12 @@ smallTbl2 on (firstjoin.value1 = smallTb
group by smallTbl2.key
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-7 is a root stage
- Stage-2 depends on stages: Stage-7
- Stage-0 depends on stages: Stage-2
+ Stage-8 is a root stage
+ Stage-3 depends on stages: Stage-8
+ Stage-0 depends on stages: Stage-3
STAGE PLANS:
- Stage: Stage-7
+ Stage: Stage-8
Map Reduce Local Work
Alias -> Map Local Tables:
firstjoin:smalltbl1
@@ -547,7 +547,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 value (type: string)
- Stage: Stage-2
+ Stage: Stage-3
Map Reduce
Map Operator Tree:
TableScan
@@ -643,8 +643,8 @@ POSTHOOK: Input: default@bigtbl
POSTHOOK: Input: default@smalltbl1
POSTHOOK: Input: default@smalltbl2
#### A masked pattern was here ####
-RUN: Stage-7:MAPREDLOCAL
-RUN: Stage-2:MAPRED
+RUN: Stage-8:MAPREDLOCAL
+RUN: Stage-3:MAPRED
270
10
10
@@ -798,38 +798,38 @@ FROM (SELECT join2.key1 as key1,
JOIN smallTbl4 ON (join3.key3 = smallTbl4.key)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-20 is a root stage , consists of Stage-27, Stage-28, Stage-5
- Stage-27 has a backup stage: Stage-5
- Stage-18 depends on stages: Stage-27
- Stage-17 depends on stages: Stage-5, Stage-18, Stage-19 , consists of Stage-25, Stage-26, Stage-1
- Stage-25 has a backup stage: Stage-1
- Stage-15 depends on stages: Stage-25
- Stage-14 depends on stages: Stage-1, Stage-15, Stage-16 , consists of Stage-23, Stage-24, Stage-2
- Stage-23 has a backup stage: Stage-2
- Stage-12 depends on stages: Stage-23
- Stage-11 depends on stages: Stage-2, Stage-12, Stage-13 , consists of Stage-21, Stage-22, Stage-3
- Stage-21 has a backup stage: Stage-3
- Stage-9 depends on stages: Stage-21
- Stage-4 depends on stages: Stage-3, Stage-9, Stage-10
- Stage-22 has a backup stage: Stage-3
+ Stage-21 is a root stage , consists of Stage-28, Stage-29, Stage-1
+ Stage-28 has a backup stage: Stage-1
+ Stage-19 depends on stages: Stage-28
+ Stage-18 depends on stages: Stage-1, Stage-19, Stage-20 , consists of Stage-26, Stage-27, Stage-2
+ Stage-26 has a backup stage: Stage-2
+ Stage-16 depends on stages: Stage-26
+ Stage-15 depends on stages: Stage-2, Stage-16, Stage-17 , consists of Stage-24, Stage-25, Stage-3
+ Stage-24 has a backup stage: Stage-3
+ Stage-13 depends on stages: Stage-24
+ Stage-12 depends on stages: Stage-3, Stage-13, Stage-14 , consists of Stage-22, Stage-23, Stage-4
+ Stage-22 has a backup stage: Stage-4
Stage-10 depends on stages: Stage-22
+ Stage-5 depends on stages: Stage-4, Stage-10, Stage-11
+ Stage-23 has a backup stage: Stage-4
+ Stage-11 depends on stages: Stage-23
+ Stage-4
+ Stage-25 has a backup stage: Stage-3
+ Stage-14 depends on stages: Stage-25
Stage-3
- Stage-24 has a backup stage: Stage-2
- Stage-13 depends on stages: Stage-24
+ Stage-27 has a backup stage: Stage-2
+ Stage-17 depends on stages: Stage-27
Stage-2
- Stage-26 has a backup stage: Stage-1
- Stage-16 depends on stages: Stage-26
+ Stage-29 has a backup stage: Stage-1
+ Stage-20 depends on stages: Stage-29
Stage-1
- Stage-28 has a backup stage: Stage-5
- Stage-19 depends on stages: Stage-28
- Stage-5
- Stage-0 depends on stages: Stage-4
+ Stage-0 depends on stages: Stage-5
STAGE PLANS:
- Stage: Stage-20
+ Stage: Stage-21
Conditional Operator
- Stage: Stage-27
+ Stage: Stage-28
Map Reduce Local Work
Alias -> Map Local Tables:
join3:join2:join1:smalltbl1
@@ -849,7 +849,7 @@ STAGE PLANS:
0 key1 (type: string)
1 key (type: string)
- Stage: Stage-18
+ Stage: Stage-19
Map Reduce
Map Operator Tree:
TableScan
@@ -878,10 +878,10 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-17
+ Stage: Stage-18
Conditional Operator
- Stage: Stage-25
+ Stage: Stage-26
Map Reduce Local Work
Alias -> Map Local Tables:
join3:join2:smalltbl2
@@ -901,7 +901,7 @@ STAGE PLANS:
0 _col3 (type: string)
1 value (type: string)
- Stage: Stage-15
+ Stage: Stage-16
Map Reduce
Map Operator Tree:
TableScan
@@ -924,10 +924,10 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-14
+ Stage: Stage-15
Conditional Operator
- Stage: Stage-23
+ Stage: Stage-24
Map Reduce Local Work
Alias -> Map Local Tables:
join3:smalltbl3
@@ -947,7 +947,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 key (type: string)
- Stage: Stage-12
+ Stage: Stage-13
Map Reduce
Map Operator Tree:
TableScan
@@ -970,10 +970,10 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-11
+ Stage: Stage-12
Conditional Operator
- Stage: Stage-21
+ Stage: Stage-22
Map Reduce Local Work
Alias -> Map Local Tables:
smalltbl4
@@ -993,7 +993,7 @@ STAGE PLANS:
0 _col2 (type: string)
1 key (type: string)
- Stage: Stage-9
+ Stage: Stage-10
Map Reduce
Map Operator Tree:
TableScan
@@ -1023,7 +1023,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-4
+ Stage: Stage-5
Map Reduce
Map Operator Tree:
TableScan
@@ -1049,7 +1049,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Stage: Stage-22
+ Stage: Stage-23
Map Reduce Local Work
Alias -> Map Local Tables:
$INTNAME
@@ -1066,7 +1066,7 @@ STAGE PLANS:
0 _col2 (type: string)
1 key (type: string)
- Stage: Stage-10
+ Stage: Stage-11
Map Reduce
Map Operator Tree:
TableScan
@@ -1099,7 +1099,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Map Operator Tree:
TableScan
@@ -1145,7 +1145,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-24
+ Stage: Stage-25
Map Reduce Local Work
Alias -> Map Local Tables:
join3:$INTNAME
@@ -1162,7 +1162,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 key (type: string)
- Stage: Stage-13
+ Stage: Stage-14
Map Reduce
Map Operator Tree:
TableScan
@@ -1188,7 +1188,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-2
+ Stage: Stage-3
Map Reduce
Map Operator Tree:
TableScan
@@ -1225,7 +1225,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-26
+ Stage: Stage-27
Map Reduce Local Work
Alias -> Map Local Tables:
join3:join2:$INTNAME
@@ -1242,7 +1242,7 @@ STAGE PLANS:
0 _col3 (type: string)
1 value (type: string)
- Stage: Stage-16
+ Stage: Stage-17
Map Reduce
Map Operator Tree:
TableScan
@@ -1268,10 +1268,17 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-1
+ Stage: Stage-2
Map Reduce
Map Operator Tree:
TableScan
+ Reduce Output Operator
+ key expressions: _col3 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col3 (type: string)
+ Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col4 (type: string)
+ TableScan
alias: smalltbl2
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -1283,13 +1290,6 @@ STAGE PLANS:
Map-reduce partition columns: value (type: string)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: string)
- TableScan
- Reduce Output Operator
- key expressions: _col3 (type: string)
- sort order: +
- Map-reduce partition columns: _col3 (type: string)
- Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col4 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
@@ -1306,7 +1306,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-28
+ Stage: Stage-29
Map Reduce Local Work
Alias -> Map Local Tables:
join3:join2:join1:bigtbl
@@ -1326,7 +1326,7 @@ STAGE PLANS:
0 key1 (type: string)
1 key (type: string)
- Stage: Stage-19
+ Stage: Stage-20
Map Reduce
Map Operator Tree:
TableScan
@@ -1355,7 +1355,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-5
+ Stage: Stage-1
Map Reduce
Map Operator Tree:
TableScan
@@ -1483,19 +1483,19 @@ POSTHOOK: Input: default@smalltbl2
POSTHOOK: Input: default@smalltbl3
POSTHOOK: Input: default@smalltbl4
#### A masked pattern was here ####
-RUN: Stage-20:CONDITIONAL
-RUN: Stage-27:MAPREDLOCAL
-RUN: Stage-18:MAPRED
-RUN: Stage-17:CONDITIONAL
-RUN: Stage-25:MAPREDLOCAL
-RUN: Stage-15:MAPRED
-RUN: Stage-14:CONDITIONAL
-RUN: Stage-23:MAPREDLOCAL
-RUN: Stage-12:MAPRED
-RUN: Stage-11:CONDITIONAL
-RUN: Stage-21:MAPREDLOCAL
-RUN: Stage-9:MAPRED
-RUN: Stage-4:MAPRED
+RUN: Stage-21:CONDITIONAL
+RUN: Stage-28:MAPREDLOCAL
+RUN: Stage-19:MAPRED
+RUN: Stage-18:CONDITIONAL
+RUN: Stage-26:MAPREDLOCAL
+RUN: Stage-16:MAPRED
+RUN: Stage-15:CONDITIONAL
+RUN: Stage-24:MAPREDLOCAL
+RUN: Stage-13:MAPRED
+RUN: Stage-12:CONDITIONAL
+RUN: Stage-22:MAPREDLOCAL
+RUN: Stage-10:MAPRED
+RUN: Stage-5:MAPRED
247580 247580 247580 548662743780 548662743780 247580 247580 247580
PREHOOK: query: -- Enable noconditionaltask and set the size of hive.auto.convert.join.noconditionaltask.size
-- to 10000, which is large enough to fit all four small tables (smallTbl1 to smallTbl4).
@@ -1570,12 +1570,12 @@ FROM (SELECT join2.key1 as key1,
JOIN smallTbl4 ON (join3.key3 = smallTbl4.key)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-13 is a root stage
- Stage-4 depends on stages: Stage-13
- Stage-0 depends on stages: Stage-4
+ Stage-14 is a root stage
+ Stage-5 depends on stages: Stage-14
+ Stage-0 depends on stages: Stage-5
STAGE PLANS:
- Stage: Stage-13
+ Stage: Stage-14
Map Reduce Local Work
Alias -> Map Local Tables:
join3:join2:join1:smalltbl1
@@ -1648,7 +1648,7 @@ STAGE PLANS:
0 _col2 (type: string)
1 key (type: string)
- Stage: Stage-4
+ Stage: Stage-5
Map Reduce
Map Operator Tree:
TableScan
@@ -1820,8 +1820,8 @@ POSTHOOK: Input: default@smalltbl2
POSTHOOK: Input: default@smalltbl3
POSTHOOK: Input: default@smalltbl4
#### A masked pattern was here ####
-RUN: Stage-13:MAPREDLOCAL
-RUN: Stage-4:MAPRED
+RUN: Stage-14:MAPREDLOCAL
+RUN: Stage-5:MAPRED
247580 247580 247580 548662743780 548662743780 247580 247580 247580
PREHOOK: query: -- Enable noconditionaltask and set the size of hive.auto.convert.join.noconditionaltask.size
-- to 200, which is large enough to fit two small tables. We will have two jobs to evaluate this
@@ -1898,14 +1898,14 @@ FROM (SELECT join2.key1 as key1,
JOIN smallTbl4 ON (join3.key3 = smallTbl4.key)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-14 is a root stage
- Stage-11 depends on stages: Stage-14
- Stage-13 depends on stages: Stage-11
- Stage-4 depends on stages: Stage-13
- Stage-0 depends on stages: Stage-4
+ Stage-15 is a root stage
+ Stage-12 depends on stages: Stage-15
+ Stage-14 depends on stages: Stage-12
+ Stage-5 depends on stages: Stage-14
+ Stage-0 depends on stages: Stage-5
STAGE PLANS:
- Stage: Stage-14
+ Stage: Stage-15
Map Reduce Local Work
Alias -> Map Local Tables:
join3:join2:join1:smalltbl1
@@ -1944,7 +1944,7 @@ STAGE PLANS:
0 _col3 (type: string)
1 value (type: string)
- Stage: Stage-11
+ Stage: Stage-12
Map Reduce
Map Operator Tree:
TableScan
@@ -1988,7 +1988,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-13
+ Stage: Stage-14
Map Reduce Local Work
Alias -> Map Local Tables:
join3:smalltbl3
@@ -2027,7 +2027,7 @@ STAGE PLANS:
0 _col2 (type: string)
1 key (type: string)
- Stage: Stage-4
+ Stage: Stage-5
Map Reduce
Map Operator Tree:
TableScan
@@ -2168,10 +2168,10 @@ POSTHOOK: Input: default@smalltbl2
POSTHOOK: Input: default@smalltbl3
POSTHOOK: Input: default@smalltbl4
#### A masked pattern was here ####
+RUN: Stage-15:MAPREDLOCAL
+RUN: Stage-12:MAPRED
RUN: Stage-14:MAPREDLOCAL
-RUN: Stage-11:MAPRED
-RUN: Stage-13:MAPREDLOCAL
-RUN: Stage-4:MAPRED
+RUN: Stage-5:MAPRED
247580 247580 247580 548662743780 548662743780 247580 247580 247580
PREHOOK: query: -- Enable noconditionaltask and but set the size of hive.auto.convert.join.noconditionaltask.size
-- to 0. The plan will be the same as the one with a disabled nonconditionaltask.
@@ -2244,38 +2244,38 @@ FROM (SELECT join2.key1 as key1,
JOIN smallTbl4 ON (join3.key3 = smallTbl4.key)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-20 is a root stage , consists of Stage-27, Stage-28, Stage-5
- Stage-27 has a backup stage: Stage-5
- Stage-18 depends on stages: Stage-27
- Stage-17 depends on stages: Stage-5, Stage-18, Stage-19 , consists of Stage-25, Stage-26, Stage-1
- Stage-25 has a backup stage: Stage-1
- Stage-15 depends on stages: Stage-25
- Stage-14 depends on stages: Stage-1, Stage-15, Stage-16 , consists of Stage-23, Stage-24, Stage-2
- Stage-23 has a backup stage: Stage-2
- Stage-12 depends on stages: Stage-23
- Stage-11 depends on stages: Stage-2, Stage-12, Stage-13 , consists of Stage-21, Stage-22, Stage-3
- Stage-21 has a backup stage: Stage-3
- Stage-9 depends on stages: Stage-21
- Stage-4 depends on stages: Stage-3, Stage-9, Stage-10
- Stage-22 has a backup stage: Stage-3
+ Stage-21 is a root stage , consists of Stage-28, Stage-29, Stage-1
+ Stage-28 has a backup stage: Stage-1
+ Stage-19 depends on stages: Stage-28
+ Stage-18 depends on stages: Stage-1, Stage-19, Stage-20 , consists of Stage-26, Stage-27, Stage-2
+ Stage-26 has a backup stage: Stage-2
+ Stage-16 depends on stages: Stage-26
+ Stage-15 depends on stages: Stage-2, Stage-16, Stage-17 , consists of Stage-24, Stage-25, Stage-3
+ Stage-24 has a backup stage: Stage-3
+ Stage-13 depends on stages: Stage-24
+ Stage-12 depends on stages: Stage-3, Stage-13, Stage-14 , consists of Stage-22, Stage-23, Stage-4
+ Stage-22 has a backup stage: Stage-4
Stage-10 depends on stages: Stage-22
+ Stage-5 depends on stages: Stage-4, Stage-10, Stage-11
+ Stage-23 has a backup stage: Stage-4
+ Stage-11 depends on stages: Stage-23
+ Stage-4
+ Stage-25 has a backup stage: Stage-3
+ Stage-14 depends on stages: Stage-25
Stage-3
- Stage-24 has a backup stage: Stage-2
- Stage-13 depends on stages: Stage-24
+ Stage-27 has a backup stage: Stage-2
+ Stage-17 depends on stages: Stage-27
Stage-2
- Stage-26 has a backup stage: Stage-1
- Stage-16 depends on stages: Stage-26
+ Stage-29 has a backup stage: Stage-1
+ Stage-20 depends on stages: Stage-29
Stage-1
- Stage-28 has a backup stage: Stage-5
- Stage-19 depends on stages: Stage-28
- Stage-5
- Stage-0 depends on stages: Stage-4
+ Stage-0 depends on stages: Stage-5
STAGE PLANS:
- Stage: Stage-20
+ Stage: Stage-21
Conditional Operator
- Stage: Stage-27
+ Stage: Stage-28
Map Reduce Local Work
Alias -> Map Local Tables:
join3:join2:join1:smalltbl1
@@ -2295,7 +2295,7 @@ STAGE PLANS:
0 key1 (type: string)
1 key (type: string)
- Stage: Stage-18
+ Stage: Stage-19
Map Reduce
Map Operator Tree:
TableScan
@@ -2324,10 +2324,10 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-17
+ Stage: Stage-18
Conditional Operator
- Stage: Stage-25
+ Stage: Stage-26
Map Reduce Local Work
Alias -> Map Local Tables:
join3:join2:smalltbl2
@@ -2347,7 +2347,7 @@ STAGE PLANS:
0 _col3 (type: string)
1 value (type: string)
- Stage: Stage-15
+ Stage: Stage-16
Map Reduce
Map Operator Tree:
TableScan
@@ -2370,10 +2370,10 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-14
+ Stage: Stage-15
Conditional Operator
- Stage: Stage-23
+ Stage: Stage-24
Map Reduce Local Work
Alias -> Map Local Tables:
join3:smalltbl3
@@ -2393,7 +2393,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 key (type: string)
- Stage: Stage-12
+ Stage: Stage-13
Map Reduce
Map Operator Tree:
TableScan
@@ -2416,10 +2416,10 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-11
+ Stage: Stage-12
Conditional Operator
- Stage: Stage-21
+ Stage: Stage-22
Map Reduce Local Work
Alias -> Map Local Tables:
smalltbl4
@@ -2439,7 +2439,7 @@ STAGE PLANS:
0 _col2 (type: string)
1 key (type: string)
- Stage: Stage-9
+ Stage: Stage-10
Map Reduce
Map Operator Tree:
TableScan
@@ -2469,7 +2469,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-4
+ Stage: Stage-5
Map Reduce
Map Operator Tree:
TableScan
@@ -2495,7 +2495,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Stage: Stage-22
+ Stage: Stage-23
Map Reduce Local Work
Alias -> Map Local Tables:
$INTNAME
@@ -2512,7 +2512,7 @@ STAGE PLANS:
0 _col2 (type: string)
1 key (type: string)
- Stage: Stage-10
+ Stage: Stage-11
Map Reduce
Map Operator Tree:
TableScan
@@ -2545,7 +2545,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-3
+ Stage: Stage-4
Map Reduce
Map Operator Tree:
TableScan
@@ -2591,7 +2591,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-24
+ Stage: Stage-25
Map Reduce Local Work
Alias -> Map Local Tables:
join3:$INTNAME
@@ -2608,7 +2608,7 @@ STAGE PLANS:
0 _col1 (type: string)
1 key (type: string)
- Stage: Stage-13
+ Stage: Stage-14
Map Reduce
Map Operator Tree:
TableScan
@@ -2634,7 +2634,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-2
+ Stage: Stage-3
Map Reduce
Map Operator Tree:
TableScan
@@ -2671,7 +2671,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-26
+ Stage: Stage-27
Map Reduce Local Work
Alias -> Map Local Tables:
join3:join2:$INTNAME
@@ -2688,7 +2688,7 @@ STAGE PLANS:
0 _col3 (type: string)
1 value (type: string)
- Stage: Stage-16
+ Stage: Stage-17
Map Reduce
Map Operator Tree:
TableScan
@@ -2714,10 +2714,17 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-1
+ Stage: Stage-2
Map Reduce
Map Operator Tree:
TableScan
+ Reduce Output Operator
+ key expressions: _col3 (type: string)
+ sort order: +
+ Map-reduce partition columns: _col3 (type: string)
+ Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col4 (type: string)
+ TableScan
alias: smalltbl2
Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
Filter Operator
@@ -2729,13 +2736,6 @@ STAGE PLANS:
Map-reduce partition columns: value (type: string)
Statistics: Num rows: 5 Data size: 35 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: string)
- TableScan
- Reduce Output Operator
- key expressions: _col3 (type: string)
- sort order: +
- Map-reduce partition columns: _col3 (type: string)
- Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col4 (type: string)
Reduce Operator Tree:
Join Operator
condition map:
@@ -2752,7 +2752,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-28
+ Stage: Stage-29
Map Reduce Local Work
Alias -> Map Local Tables:
join3:join2:join1:bigtbl
@@ -2772,7 +2772,7 @@ STAGE PLANS:
0 key1 (type: string)
1 key (type: string)
- Stage: Stage-19
+ Stage: Stage-20
Map Reduce
Map Operator Tree:
TableScan
@@ -2801,7 +2801,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-5
+ Stage: Stage-1
Map Reduce
Map Operator Tree:
TableScan
@@ -2929,17 +2929,17 @@ POSTHOOK: Input: default@smalltbl2
POSTHOOK: Input: default@smalltbl3
POSTHOOK: Input: default@smalltbl4
#### A masked pattern was here ####
-RUN: Stage-20:CONDITIONAL
-RUN: Stage-27:MAPREDLOCAL
-RUN: Stage-18:MAPRED
-RUN: Stage-17:CONDITIONAL
-RUN: Stage-25:MAPREDLOCAL
-RUN: Stage-15:MAPRED
-RUN: Stage-14:CONDITIONAL
-RUN: Stage-23:MAPREDLOCAL
-RUN: Stage-12:MAPRED
-RUN: Stage-11:CONDITIONAL
-RUN: Stage-21:MAPREDLOCAL
-RUN: Stage-9:MAPRED
-RUN: Stage-4:MAPRED
+RUN: Stage-21:CONDITIONAL
+RUN: Stage-28:MAPREDLOCAL
+RUN: Stage-19:MAPRED
+RUN: Stage-18:CONDITIONAL
+RUN: Stage-26:MAPREDLOCAL
+RUN: Stage-16:MAPRED
+RUN: Stage-15:CONDITIONAL
+RUN: Stage-24:MAPREDLOCAL
+RUN: Stage-13:MAPRED
+RUN: Stage-12:CONDITIONAL
+RUN: Stage-22:MAPREDLOCAL
+RUN: Stage-10:MAPRED
+RUN: Stage-5:MAPRED
247580 247580 247580 548662743780 548662743780 247580 247580 247580
Modified: hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multiMapJoin2.q.out Sun Nov 23 05:59:20 2014
@@ -63,7 +63,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: x2
+ alias: x1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -86,7 +86,7 @@ STAGE PLANS:
sort order: +
Statistics: Num rows: 550 Data size: 5842 Basic stats: COMPLETE Column stats: NONE
TableScan
- alias: x1
+ alias: x2
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -262,13 +262,13 @@ STAGE PLANS:
Stage: Stage-9
Map Reduce Local Work
Alias -> Map Local Tables:
- null-subquery1:tmp-subquery1:y1
+ null-subquery2:tmp-subquery2:y2
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- null-subquery1:tmp-subquery1:y1
+ null-subquery2:tmp-subquery2:y2
TableScan
- alias: y1
+ alias: y2
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -285,7 +285,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: x1
+ alias: x2
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -313,13 +313,13 @@ STAGE PLANS:
Stage: Stage-8
Map Reduce Local Work
Alias -> Map Local Tables:
- null-subquery2:tmp-subquery2:y2
+ null-subquery1:tmp-subquery1:y1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- null-subquery2:tmp-subquery2:y2
+ null-subquery1:tmp-subquery1:y1
TableScan
- alias: y2
+ alias: y1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -343,7 +343,7 @@ STAGE PLANS:
sort order: +
Statistics: Num rows: 550 Data size: 5842 Basic stats: COMPLETE Column stats: NONE
TableScan
- alias: x2
+ alias: x1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -505,13 +505,13 @@ FROM (SELECT x1.key AS key FROM src1 x1
ORDER BY tmp.key
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-4 is a root stage
- Stage-6 depends on stages: Stage-4
+ Stage-1 is a root stage
+ Stage-6 depends on stages: Stage-1
Stage-2 depends on stages: Stage-6
Stage-0 depends on stages: Stage-2
STAGE PLANS:
- Stage: Stage-4
+ Stage: Stage-1
Map Reduce
Map Operator Tree:
TableScan
@@ -638,7 +638,7 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
-RUN: Stage-4:MAPRED
+RUN: Stage-1:MAPRED
RUN: Stage-6:MAPREDLOCAL
RUN: Stage-2:MAPRED
@@ -751,13 +751,13 @@ STAGE PLANS:
Stage: Stage-17
Map Reduce Local Work
Alias -> Map Local Tables:
- tmp2:y2
+ tmp1:y1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- tmp2:y2
+ tmp1:y1
TableScan
- alias: y2
+ alias: y1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -774,7 +774,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: x2
+ alias: x1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -821,11 +821,11 @@ STAGE PLANS:
Stage: Stage-15
Map Reduce Local Work
Alias -> Map Local Tables:
- $INTNAME
+ $INTNAME1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $INTNAME
+ $INTNAME1
TableScan
HashTable Sink Operator
condition expressions:
@@ -911,11 +911,11 @@ STAGE PLANS:
Stage: Stage-16
Map Reduce Local Work
Alias -> Map Local Tables:
- $INTNAME1
+ $INTNAME
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $INTNAME1
+ $INTNAME
TableScan
HashTable Sink Operator
condition expressions:
@@ -993,13 +993,13 @@ STAGE PLANS:
Stage: Stage-18
Map Reduce Local Work
Alias -> Map Local Tables:
- tmp1:y1
+ tmp2:y2
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- tmp1:y1
+ tmp2:y2
TableScan
- alias: y1
+ alias: y2
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1016,7 +1016,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: x1
+ alias: x2
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1197,7 +1197,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: x2
+ alias: x1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1224,7 +1224,7 @@ STAGE PLANS:
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
TableScan
- alias: x1
+ alias: x2
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1426,21 +1426,21 @@ GROUP BY tmp1.key
ORDER BY key, cnt
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-7 is a root stage
- Stage-10 depends on stages: Stage-2, Stage-7 , consists of Stage-12, Stage-13, Stage-3
- Stage-12 has a backup stage: Stage-3
+ Stage-1 is a root stage
+ Stage-10 depends on stages: Stage-1, Stage-6 , consists of Stage-12, Stage-13, Stage-2
+ Stage-12 has a backup stage: Stage-2
Stage-8 depends on stages: Stage-12
- Stage-4 depends on stages: Stage-3, Stage-8, Stage-9
- Stage-5 depends on stages: Stage-4
- Stage-13 has a backup stage: Stage-3
+ Stage-3 depends on stages: Stage-2, Stage-8, Stage-9
+ Stage-4 depends on stages: Stage-3
+ Stage-13 has a backup stage: Stage-2
Stage-9 depends on stages: Stage-13
- Stage-3
+ Stage-2
Stage-14 is a root stage
- Stage-2 depends on stages: Stage-14
- Stage-0 depends on stages: Stage-5
+ Stage-6 depends on stages: Stage-14
+ Stage-0 depends on stages: Stage-4
STAGE PLANS:
- Stage: Stage-7
+ Stage: Stage-1
Map Reduce
Map Operator Tree:
TableScan
@@ -1478,11 +1478,11 @@ STAGE PLANS:
Stage: Stage-12
Map Reduce Local Work
Alias -> Map Local Tables:
- $INTNAME
+ $INTNAME1
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $INTNAME
+ $INTNAME1
TableScan
HashTable Sink Operator
condition expressions:
@@ -1520,7 +1520,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-4
+ Stage: Stage-3
Map Reduce
Map Operator Tree:
TableScan
@@ -1544,7 +1544,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-5
+ Stage: Stage-4
Map Reduce
Map Operator Tree:
TableScan
@@ -1568,11 +1568,11 @@ STAGE PLANS:
Stage: Stage-13
Map Reduce Local Work
Alias -> Map Local Tables:
- $INTNAME1
+ $INTNAME
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- $INTNAME1
+ $INTNAME
TableScan
HashTable Sink Operator
condition expressions:
@@ -1610,7 +1610,7 @@ STAGE PLANS:
Local Work:
Map Reduce Local Work
- Stage: Stage-3
+ Stage: Stage-2
Map Reduce
Map Operator Tree:
TableScan
@@ -1618,13 +1618,13 @@ STAGE PLANS:
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
TableScan
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -1669,7 +1669,7 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
- Stage: Stage-2
+ Stage: Stage-6
Map Reduce
Map Operator Tree:
TableScan
@@ -1748,14 +1748,14 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
-RUN: Stage-7:MAPRED
+RUN: Stage-1:MAPRED
RUN: Stage-14:MAPREDLOCAL
-RUN: Stage-2:MAPRED
+RUN: Stage-6:MAPRED
RUN: Stage-10:CONDITIONAL
RUN: Stage-12:MAPREDLOCAL
RUN: Stage-8:MAPRED
+RUN: Stage-3:MAPRED
RUN: Stage-4:MAPRED
-RUN: Stage-5:MAPRED
128 1
146 1
150 1
@@ -1804,13 +1804,13 @@ GROUP BY tmp1.key
ORDER BY key, cnt
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-7 is a root stage
- Stage-2 depends on stages: Stage-7
- Stage-3 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-3
+ Stage-6 is a root stage
+ Stage-1 depends on stages: Stage-6
+ Stage-2 depends on stages: Stage-1
+ Stage-0 depends on stages: Stage-2
STAGE PLANS:
- Stage: Stage-7
+ Stage: Stage-6
Map Reduce Local Work
Alias -> Map Local Tables:
tmp2:y2
@@ -1832,7 +1832,7 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
- Stage: Stage-2
+ Stage: Stage-1
Map Reduce
Map Operator Tree:
TableScan
@@ -1942,7 +1942,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-3
+ Stage: Stage-2
Map Reduce
Map Operator Tree:
TableScan
@@ -1997,9 +1997,9 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
-RUN: Stage-7:MAPREDLOCAL
+RUN: Stage-6:MAPREDLOCAL
+RUN: Stage-1:MAPRED
RUN: Stage-2:MAPRED
-RUN: Stage-3:MAPRED
128 1
146 1
150 1
@@ -2194,21 +2194,21 @@ POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-17 is a root stage
Stage-2 depends on stages: Stage-17
- Stage-16 depends on stages: Stage-2, Stage-7
+ Stage-16 depends on stages: Stage-2, Stage-8
Stage-4 depends on stages: Stage-16
Stage-18 is a root stage
- Stage-7 depends on stages: Stage-18
+ Stage-8 depends on stages: Stage-18
Stage-0 depends on stages: Stage-4
STAGE PLANS:
Stage: Stage-17
Map Reduce Local Work
Alias -> Map Local Tables:
- null-subquery2:x-subquery2:tmp:a
+ null-subquery1:x-subquery1:tmp:a
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- null-subquery2:x-subquery2:tmp:a
+ null-subquery1:x-subquery1:tmp:a
TableScan
alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -2374,11 +2374,11 @@ STAGE PLANS:
Stage: Stage-18
Map Reduce Local Work
Alias -> Map Local Tables:
- null-subquery1:x-subquery1:tmp:a
+ null-subquery2:x-subquery2:tmp:a
Fetch Operator
limit: -1
Alias -> Map Local Operator Tree:
- null-subquery1:x-subquery1:tmp:a
+ null-subquery2:x-subquery2:tmp:a
TableScan
alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
@@ -2393,7 +2393,7 @@ STAGE PLANS:
0 key (type: string)
1 key (type: string)
- Stage: Stage-7
+ Stage: Stage-8
Map Reduce
Map Operator Tree:
TableScan
@@ -2471,7 +2471,7 @@ POSTHOOK: Input: default@src
RUN: Stage-17:MAPREDLOCAL
RUN: Stage-18:MAPREDLOCAL
RUN: Stage-2:MAPRED
-RUN: Stage-7:MAPRED
+RUN: Stage-8:MAPRED
RUN: Stage-16:MAPREDLOCAL
RUN: Stage-4:MAPRED
0
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out Sun Nov 23 05:59:20 2014
@@ -49,12 +49,12 @@ src12 b ON (a.key = b.key) JOIN
(SELECT * FROM (SELECT * FROM src13 UNION ALL SELECT * FROM src14)a )c ON c.value = b.value
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-8 is a root stage
- Stage-6 depends on stages: Stage-8
- Stage-0 depends on stages: Stage-6
+ Stage-7 is a root stage
+ Stage-5 depends on stages: Stage-7
+ Stage-0 depends on stages: Stage-5
STAGE PLANS:
- Stage: Stage-8
+ Stage: Stage-7
Map Reduce Local Work
Alias -> Map Local Tables:
a
@@ -122,7 +122,7 @@ STAGE PLANS:
0 _col6 (type: string)
1 _col1 (type: string)
- Stage: Stage-6
+ Stage: Stage-5
Map Reduce
Map Operator Tree:
TableScan
Modified: hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out Sun Nov 23 05:59:20 2014
@@ -12,7 +12,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: src2
+ alias: src1
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
@@ -22,7 +22,7 @@ STAGE PLANS:
Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
value expressions: key (type: string), value (type: string)
TableScan
- alias: src1
+ alias: src2
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key < 10) (type: boolean)
Modified: hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nonblock_op_deduplicate.q.out Sun Nov 23 05:59:20 2014
@@ -41,7 +41,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join JOIN[11][tables = [tmp2, tmp3]] in Stage 'Stage-2:MAPRED' is a cross product
+Warning: Shuffle Join JOIN[11][tables = [tmp2, tmp3]] in Stage 'Stage-1:MAPRED' is a cross product
PREHOOK: query: -- This test query is introduced for HIVE-4968.
-- First, we do not convert the join to MapJoin.
EXPLAIN
@@ -67,12 +67,12 @@ FROM (SELECT tmp2.key as key, tmp2.value
) tmp4
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-2 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-2
+ Stage-2 is a root stage
+ Stage-1 depends on stages: Stage-2
+ Stage-0 depends on stages: Stage-1
STAGE PLANS:
- Stage: Stage-1
+ Stage: Stage-2
Map Reduce
Map Operator Tree:
TableScan
@@ -102,15 +102,10 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-2
+ Stage: Stage-1
Map Reduce
Map Operator Tree:
TableScan
- Reduce Output Operator
- sort order:
- Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
- value expressions: _col0 (type: bigint)
- TableScan
alias: src1
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Select Operator
@@ -121,6 +116,11 @@ STAGE PLANS:
sort order:
Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
value expressions: _col0 (type: string), _col1 (type: string)
+ TableScan
+ Reduce Output Operator
+ sort order:
+ Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
+ value expressions: _col0 (type: bigint)
Reduce Operator Tree:
Join Operator
condition map:
@@ -148,7 +148,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Shuffle Join JOIN[11][tables = [tmp2, tmp3]] in Stage 'Stage-2:MAPRED' is a cross product
+Warning: Shuffle Join JOIN[11][tables = [tmp2, tmp3]] in Stage 'Stage-1:MAPRED' is a cross product
PREHOOK: query: SELECT tmp4.key as key, tmp4.value as value, tmp4.count as count
FROM (SELECT tmp2.key as key, tmp2.value as value, tmp3.count as count
FROM (SELECT *
@@ -196,7 +196,7 @@ POSTHOOK: Input: default@src1
406 val_406 25
66 val_66 25
98 val_98 25
-Warning: Map Join MAPJOIN[17][bigTable=?] in task 'Stage-4:MAPRED' is a cross product
+Warning: Map Join MAPJOIN[17][bigTable=?] in task 'Stage-3:MAPRED' is a cross product
PREHOOK: query: -- Then, we convert the join to MapJoin.
EXPLAIN
SELECT tmp4.key as key, tmp4.value as value, tmp4.count as count
@@ -220,13 +220,13 @@ FROM (SELECT tmp2.key as key, tmp2.value
) tmp4
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-5 depends on stages: Stage-1
- Stage-4 depends on stages: Stage-5
- Stage-0 depends on stages: Stage-4
+ Stage-2 is a root stage
+ Stage-4 depends on stages: Stage-2
+ Stage-3 depends on stages: Stage-4
+ Stage-0 depends on stages: Stage-3
STAGE PLANS:
- Stage: Stage-1
+ Stage: Stage-2
Map Reduce
Map Operator Tree:
TableScan
@@ -256,7 +256,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
- Stage: Stage-5
+ Stage: Stage-4
Map Reduce Local Work
Alias -> Map Local Tables:
tmp4:tmp2:tmp1:src1
@@ -279,7 +279,7 @@ STAGE PLANS:
0
1
- Stage: Stage-4
+ Stage: Stage-3
Map Reduce
Map Operator Tree:
TableScan
@@ -314,7 +314,7 @@ STAGE PLANS:
Processor Tree:
ListSink
-Warning: Map Join MAPJOIN[17][bigTable=?] in task 'Stage-4:MAPRED' is a cross product
+Warning: Map Join MAPJOIN[17][bigTable=?] in task 'Stage-3:MAPRED' is a cross product
PREHOOK: query: SELECT tmp4.key as key, tmp4.value as value, tmp4.count as count
FROM (SELECT tmp2.key as key, tmp2.value as value, tmp3.count as count
FROM (SELECT *
Modified: hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out Sun Nov 23 05:59:20 2014
@@ -1067,7 +1067,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: src2
+ alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
@@ -1079,7 +1079,7 @@ STAGE PLANS:
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
- alias: src
+ alias: src2
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
Modified: hive/trunk/ql/src/test/results/clientpositive/optimize_nullscan.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/optimize_nullscan.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/optimize_nullscan.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/optimize_nullscan.q.out Sun Nov 23 05:59:20 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/optional_outer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/optional_outer.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/optional_outer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/optional_outer.q.out Sun Nov 23 05:59:20 2014
@@ -11,7 +11,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: b
+ alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -20,7 +20,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
- alias: a
+ alias: b
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -68,7 +68,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: b
+ alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -77,7 +77,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
- alias: a
+ alias: b
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -125,7 +125,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: b
+ alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -134,7 +134,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
- alias: a
+ alias: b
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -182,7 +182,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: b
+ alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -191,7 +191,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
- alias: a
+ alias: b
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -239,7 +239,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: b
+ alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -248,7 +248,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
- alias: a
+ alias: b
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -296,7 +296,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: b
+ alias: a
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
@@ -305,7 +305,7 @@ STAGE PLANS:
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
value expressions: value (type: string)
TableScan
- alias: a
+ alias: b
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: string)
Modified: hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/outer_join_ppr.q.out Sun Nov 23 05:59:20 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out Sun Nov 23 05:59:20 2014
@@ -73,28 +73,28 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: p2
- Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
+ alias: p1
+ Statistics: Num rows: 2 Data size: 4 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: int)
sort order: +
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
- value expressions: myvalue (type: string)
+ Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE
TableScan
- alias: p1
- Statistics: Num rows: 2 Data size: 4 Basic stats: COMPLETE Column stats: NONE
+ alias: p2
+ Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: key is not null (type: boolean)
- Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: key (type: int)
sort order: +
Map-reduce partition columns: key (type: int)
- Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
+ value expressions: myvalue (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/pcr.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/pcr.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/pcr.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/pcr.q.out Sun Nov 23 05:59:20 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd2.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd2.q.out Sun Nov 23 05:59:20 2014
@@ -343,7 +343,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: y
+ alias: x
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 20) (type: boolean)
@@ -352,8 +352,9 @@ STAGE PLANS:
key expressions: '20' (type: string)
sort order: +
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
TableScan
- alias: x
+ alias: y
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 20) (type: boolean)
@@ -362,7 +363,6 @@ STAGE PLANS:
key expressions: '20' (type: string)
sort order: +
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Sun Nov 23 05:59:20 2014
@@ -71,7 +71,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: y
+ alias: x
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 20) (type: boolean)
@@ -80,8 +80,9 @@ STAGE PLANS:
key expressions: '20' (type: string)
sort order: +
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
TableScan
- alias: x
+ alias: y
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 20) (type: boolean)
@@ -90,7 +91,6 @@ STAGE PLANS:
key expressions: '20' (type: string)
sort order: +
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
@@ -217,7 +217,7 @@ STAGE PLANS:
Map Reduce
Map Operator Tree:
TableScan
- alias: y
+ alias: x
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 20) (type: boolean)
@@ -226,8 +226,9 @@ STAGE PLANS:
key expressions: '20' (type: string)
sort order: +
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ value expressions: value (type: string)
TableScan
- alias: x
+ alias: y
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (key = 20) (type: boolean)
@@ -236,7 +237,6 @@ STAGE PLANS:
key expressions: '20' (type: string)
sort order: +
Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- value expressions: value (type: string)
Reduce Operator Tree:
Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out Sun Nov 23 05:59:20 2014
@@ -31,39 +31,39 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((((key > '2') and (key < '400')) and (key <> '4')) and (key > '20')) (type: boolean)
- Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4')) (type: boolean)
+ Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col0 < '400') (type: boolean)
- Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 42 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 42 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: string)
TableScan
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4')) (type: boolean)
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((key > '2') and (key < '400')) and (key <> '4')) and (key > '20')) (type: boolean)
+ Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ expressions: key (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col0 < '400') (type: boolean)
- Statistics: Num rows: 4 Data size: 42 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 4 Data size: 42 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
@@ -161,33 +161,33 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((((key > '2') and (key < '400')) and (key <> '4')) and (key > '20')) (type: boolean)
- Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4')) (type: boolean)
+ Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ expressions: key (type: string), value (type: string)
+ outputColumnNames: _col0, _col1
+ Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ value expressions: _col1 (type: string)
TableScan
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4')) (type: boolean)
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((key > '2') and (key < '400')) and (key <> '4')) and (key > '20')) (type: boolean)
+ Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ expressions: key (type: string)
+ outputColumnNames: _col0
+ Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
+ Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
condition map:
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join.q.out Sun Nov 23 05:59:20 2014
@@ -28,39 +28,39 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((((key > '2') and (key < '400')) and (key <> '4')) and (key > '20')) (type: boolean)
- Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4')) (type: boolean)
+ Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col0 < '400') (type: boolean)
- Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 42 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 4 Data size: 42 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
TableScan
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4')) (type: boolean)
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((key > '2') and (key < '400')) and (key <> '4')) and (key > '20')) (type: boolean)
+ Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col0 < '400') (type: boolean)
- Statistics: Num rows: 4 Data size: 42 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 4 Data size: 42 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 6 Data size: 63 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
@@ -560,33 +560,33 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((((key > '2') and (key < '400')) and (key <> '4')) and (key > '20')) (type: boolean)
- Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ predicate: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4')) (type: boolean)
+ Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
TableScan
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: (((((key > '1') and (key < '400')) and (key > '20')) and ((value < 'val_50') or (key > '2'))) and (key <> '4')) (type: boolean)
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((key > '2') and (key < '400')) and (key <> '4')) and (key > '20')) (type: boolean)
+ Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 12 Data size: 127 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 18 Data size: 191 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out?rev=1641162&r1=1641161&r2=1641162&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out Sun Nov 23 05:59:20 2014
@@ -35,39 +35,39 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((((key <> '305') and (key < '400')) and (key <> '14')) and (key <> '311')) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((((key <> '302') and (key < '400')) and value is not null) and (key <> '311')) and ((value <> 'val_50') or (key > '1'))) and (key <> '14')) (type: boolean)
+ Statistics: Num rows: 110 Data size: 1168 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 110 Data size: 1168 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col0 < '400') (type: boolean)
- Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 36 Data size: 382 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 36 Data size: 382 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
TableScan
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((((((key <> '302') and (key < '400')) and value is not null) and (key <> '311')) and ((value <> 'val_50') or (key > '1'))) and (key <> '14')) (type: boolean)
- Statistics: Num rows: 110 Data size: 1168 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((key <> '305') and (key < '400')) and (key <> '14')) and (key <> '311')) (type: boolean)
+ Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 110 Data size: 1168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Filter Operator
predicate: (_col0 < '400') (type: boolean)
- Statistics: Num rows: 36 Data size: 382 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 36 Data size: 382 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator
@@ -1728,33 +1728,33 @@ STAGE PLANS:
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((((key <> '305') and (key < '400')) and (key <> '14')) and (key <> '311')) (type: boolean)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((((key <> '302') and (key < '400')) and value is not null) and (key <> '311')) and ((value <> 'val_50') or (key > '1'))) and (key <> '14')) (type: boolean)
+ Statistics: Num rows: 110 Data size: 1168 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 110 Data size: 1168 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 110 Data size: 1168 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
TableScan
alias: src
Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((((((key <> '302') and (key < '400')) and value is not null) and (key <> '311')) and ((value <> 'val_50') or (key > '1'))) and (key <> '14')) (type: boolean)
- Statistics: Num rows: 110 Data size: 1168 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((key <> '305') and (key < '400')) and (key <> '14')) and (key <> '311')) (type: boolean)
+ Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: key (type: string), value (type: string)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 110 Data size: 1168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: string)
sort order: +
Map-reduce partition columns: _col0 (type: string)
- Statistics: Num rows: 110 Data size: 1168 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: string)
Reduce Operator Tree:
Join Operator