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 2014/04/03 23:40:23 UTC
svn commit: r1584410 [4/6] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/ conf/
ql/src/test/results/clientnegative/ ql/src/test/results/clientpositive/
Modified: hive/trunk/ql/src/test/results/clientpositive/join_reorder4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_reorder4.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_reorder4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_reorder4.q.out Thu Apr 3 21:40:21 2014
@@ -48,10 +48,48 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ STREAMTABLE(a) */ a.*, b.*, c.* from T1 a join T2 b on a.key1=b.key2 join T3 c on a.key1=c.key3
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-4 is a root stage
+ Stage-5 is a root stage
+ Stage-4 depends on stages: Stage-5
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-5
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ a
+ Fetch Operator
+ limit: -1
+ c
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ a
+ TableScan
+ alias: a
+ Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key1} {val1}
+ 1 {key2} {val2}
+ 2 {key3} {val3}
+ keys:
+ 0 key1 (type: string)
+ 1 key2 (type: string)
+ 2 key3 (type: string)
+ c
+ TableScan
+ alias: c
+ Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key1} {val1}
+ 1 {key2} {val2}
+ 2 {key3} {val3}
+ keys:
+ 0 key1 (type: string)
+ 1 key2 (type: string)
+ 2 key3 (type: string)
+
Stage: Stage-4
Map Reduce
Map Operator Tree:
@@ -85,22 +123,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- a
- Fetch Operator
- limit: -1
- c
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- a
- TableScan
- alias: a
- Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- c
- TableScan
- alias: c
- Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -124,10 +146,48 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ STREAMTABLE(b) */ a.*, b.*, c.* from T1 a join T2 b on a.key1=b.key2 join T3 c on a.key1=c.key3
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-4 is a root stage
+ Stage-5 is a root stage
+ Stage-4 depends on stages: Stage-5
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-5
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ a
+ Fetch Operator
+ limit: -1
+ c
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ a
+ TableScan
+ alias: a
+ Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key1} {val1}
+ 1 {key2} {val2}
+ 2 {key3} {val3}
+ keys:
+ 0 key1 (type: string)
+ 1 key2 (type: string)
+ 2 key3 (type: string)
+ c
+ TableScan
+ alias: c
+ Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key1} {val1}
+ 1 {key2} {val2}
+ 2 {key3} {val3}
+ keys:
+ 0 key1 (type: string)
+ 1 key2 (type: string)
+ 2 key3 (type: string)
+
Stage: Stage-4
Map Reduce
Map Operator Tree:
@@ -161,22 +221,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- a
- Fetch Operator
- limit: -1
- c
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- a
- TableScan
- alias: a
- Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- c
- TableScan
- alias: c
- Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -200,10 +244,48 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ STREAMTABLE(c) */ a.*, b.*, c.* from T1 a join T2 b on a.key1=b.key2 join T3 c on a.key1=c.key3
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-4 is a root stage
+ Stage-5 is a root stage
+ Stage-4 depends on stages: Stage-5
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-5
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ a
+ Fetch Operator
+ limit: -1
+ c
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ a
+ TableScan
+ alias: a
+ Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key1} {val1}
+ 1 {key2} {val2}
+ 2 {key3} {val3}
+ keys:
+ 0 key1 (type: string)
+ 1 key2 (type: string)
+ 2 key3 (type: string)
+ c
+ TableScan
+ alias: c
+ Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key1} {val1}
+ 1 {key2} {val2}
+ 2 {key3} {val3}
+ keys:
+ 0 key1 (type: string)
+ 1 key2 (type: string)
+ 2 key3 (type: string)
+
Stage: Stage-4
Map Reduce
Map Operator Tree:
@@ -237,22 +319,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- a
- Fetch Operator
- limit: -1
- c
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- a
- TableScan
- alias: a
- Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
- c
- TableScan
- alias: c
- Statistics: Num rows: 0 Data size: 20 Basic stats: PARTIAL Column stats: NONE
Stage: Stage-0
Fetch Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/join_star.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_star.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_star.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_star.q.out Thu Apr 3 21:40:21 2014
@@ -123,10 +123,30 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select m1, m2, f2 from fact join dim1 on fact.d1=dim1.f1
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-3 is a root stage
+ Stage-4 is a root stage
+ Stage-3 depends on stages: Stage-4
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-4
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ dim1
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ dim1
+ TableScan
+ alias: dim1
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {m1} {m2}
+ 1 {f2}
+ keys:
+ 0 d1 (type: int)
+ 1 f1 (type: int)
+
Stage: Stage-3
Map Reduce
Map Operator Tree:
@@ -157,15 +177,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- dim1
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- dim1
- TableScan
- alias: dim1
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -196,10 +207,44 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select m1, m2, f2, f4 from fact join dim1 on fact.d1=dim1.f1 join dim2 on fact.d2=dim2.f3
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-4 is a root stage
+ Stage-6 is a root stage
+ Stage-4 depends on stages: Stage-6
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-6
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ dim1
+ Fetch Operator
+ limit: -1
+ dim2
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ dim1
+ TableScan
+ alias: dim1
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {m1} {m2} {d2}
+ 1 {f2}
+ keys:
+ 0 d1 (type: int)
+ 1 f1 (type: int)
+ dim2
+ TableScan
+ alias: dim2
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col7} {_col0} {_col1}
+ 1 {f4}
+ keys:
+ 0 _col3 (type: int)
+ 1 f3 (type: int)
+
Stage: Stage-4
Map Reduce
Map Operator Tree:
@@ -241,22 +286,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- dim1
- Fetch Operator
- limit: -1
- dim2
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- dim1
- TableScan
- alias: dim1
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- dim2
- TableScan
- alias: dim2
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -289,10 +318,44 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select m1, m2, f2, f4 from fact join dim1 on fact.d1= dim1.f1 join dim2 on dim1.f2 = dim2.f3
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-4 is a root stage
+ Stage-6 is a root stage
+ Stage-4 depends on stages: Stage-6
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-6
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ dim1
+ Fetch Operator
+ limit: -1
+ dim2
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ dim1
+ TableScan
+ alias: dim1
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {m1} {m2}
+ 1 {f2}
+ keys:
+ 0 d1 (type: int)
+ 1 f1 (type: int)
+ dim2
+ TableScan
+ alias: dim2
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col7} {_col0} {_col1}
+ 1 {f4}
+ keys:
+ 0 _col7 (type: int)
+ 1 f3 (type: int)
+
Stage: Stage-4
Map Reduce
Map Operator Tree:
@@ -334,22 +397,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- dim1
- Fetch Operator
- limit: -1
- dim2
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- dim1
- TableScan
- alias: dim1
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- dim2
- TableScan
- alias: dim2
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -382,10 +429,44 @@ PREHOOK: type: QUERY
POSTHOOK: query: explain select m1, m2, f2, f4 from fact Left outer join dim1 on fact.d1= dim1.f1 Left outer join dim2 on dim1.f2 = dim2.f3
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-4 is a root stage
+ Stage-6 is a root stage
+ Stage-4 depends on stages: Stage-6
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-6
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ dim1
+ Fetch Operator
+ limit: -1
+ dim2
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ dim1
+ TableScan
+ alias: dim1
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {m1} {m2}
+ 1 {f2}
+ keys:
+ 0 d1 (type: int)
+ 1 f1 (type: int)
+ dim2
+ TableScan
+ alias: dim2
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col7} {_col0} {_col1}
+ 1 {f4}
+ keys:
+ 0 _col7 (type: int)
+ 1 f3 (type: int)
+
Stage: Stage-4
Map Reduce
Map Operator Tree:
@@ -427,22 +508,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- dim1
- Fetch Operator
- limit: -1
- dim2
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- dim1
- TableScan
- alias: dim1
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- dim2
- TableScan
- alias: dim2
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -491,10 +556,118 @@ POSTHOOK: query: explain Select m1, m2,
Left outer Join dim7 on dim6.f12 = dim7.f13
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-12 is a root stage
+ Stage-18 is a root stage
+ Stage-12 depends on stages: Stage-18
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-18
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ dim1
+ Fetch Operator
+ limit: -1
+ dim2
+ Fetch Operator
+ limit: -1
+ dim3
+ Fetch Operator
+ limit: -1
+ dim4
+ Fetch Operator
+ limit: -1
+ dim5
+ Fetch Operator
+ limit: -1
+ dim6
+ Fetch Operator
+ limit: -1
+ dim7
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ dim1
+ TableScan
+ alias: dim1
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {m1} {m2} {d2}
+ 1 {f2}
+ keys:
+ 0 d1 (type: int)
+ 1 f1 (type: int)
+ dim2
+ TableScan
+ alias: dim2
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col7} {_col0} {_col1} {_col3}
+ 1 {f4}
+ keys:
+ 0 _col7 (type: int)
+ 1 f3 (type: int)
+ dim3
+ TableScan
+ alias: dim3
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col11} {_col1} {_col4} {_col5}
+ 1 {f6}
+ keys:
+ 0 _col7 (type: int)
+ 1 f5 (type: int)
+ dim4
+ TableScan
+ alias: dim4
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col15} {_col1} {_col5} {_col8} {_col9}
+ 1 {f8}
+ 2 {f12}
+ keys:
+ 0 _col15 (type: int)
+ 1 f7 (type: int)
+ 2 f11 (type: int)
+ dim5
+ TableScan
+ alias: dim5
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col1} {_col5} {_col9} {_col12} {_col13} {_col23} {_col19}
+ 1 {f10}
+ keys:
+ 0 _col19 (type: int)
+ 1 f9 (type: int)
+ dim6
+ TableScan
+ alias: dim6
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col15} {_col1} {_col5} {_col8} {_col9}
+ 1 {f8}
+ 2 {f12}
+ keys:
+ 0 _col15 (type: int)
+ 1 f7 (type: int)
+ 2 f11 (type: int)
+ dim7
+ TableScan
+ alias: dim7
+ Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col1} {_col5} {_col9} {_col12} {_col13} {_col19} {_col27} {_col23}
+ 1 {f14}
+ keys:
+ 0 _col19 (type: int)
+ 1 f13 (type: int)
+
Stage: Stage-12
Map Reduce
Map Operator Tree:
@@ -583,57 +756,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- dim1
- Fetch Operator
- limit: -1
- dim2
- Fetch Operator
- limit: -1
- dim3
- Fetch Operator
- limit: -1
- dim4
- Fetch Operator
- limit: -1
- dim5
- Fetch Operator
- limit: -1
- dim6
- Fetch Operator
- limit: -1
- dim7
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- dim1
- TableScan
- alias: dim1
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- dim2
- TableScan
- alias: dim2
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- dim3
- TableScan
- alias: dim3
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- dim4
- TableScan
- alias: dim4
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- dim5
- TableScan
- alias: dim5
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- dim6
- TableScan
- alias: dim6
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
- dim7
- TableScan
- alias: dim7
- Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin1.q.out Thu Apr 3 21:40:21 2014
@@ -30,10 +30,33 @@ EXPLAIN
SELECT /*+ MAPJOIN(a) */ * FROM src a RIGHT OUTER JOIN src b on a.key=b.key AND true limit 10
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-3 is a root stage
+ Stage-1 depends on stages: Stage-3
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-3
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ a
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ a
+ TableScan
+ alias: a
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ filter predicates:
+ 0
+ 1 {true}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+
Stage: Stage-1
Map Reduce
Map Operator Tree:
@@ -70,15 +93,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- a
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- a
- TableScan
- alias: a
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -111,10 +125,33 @@ EXPLAIN
SELECT /*+ MAPJOIN(a) */ * FROM src a RIGHT OUTER JOIN src b on a.key=b.key AND b.key * 10 < '1000' limit 10
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-3 is a root stage
+ Stage-1 depends on stages: Stage-3
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-3
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ a
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ a
+ TableScan
+ alias: a
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ filter predicates:
+ 0
+ 1 {((key * 10) < '1000')}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+
Stage: Stage-1
Map Reduce
Map Operator Tree:
@@ -151,15 +188,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- a
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- a
- TableScan
- alias: a
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -194,10 +222,33 @@ SELECT /*+ MAPJOIN(a) */ * FROM src a RI
(select key, named_struct('key', key, 'value', value) as kv from src) b on a.key=b.key AND b.kv.key > 200 limit 10
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-3 is a root stage
+ Stage-1 depends on stages: Stage-3
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-3
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ a
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ a
+ TableScan
+ alias: a
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key} {value}
+ 1 {_col0} {_col1}
+ filter predicates:
+ 0
+ 1 {(_col1.key > 200)}
+ keys:
+ 0 key (type: string)
+ 1 _col0 (type: string)
+
Stage: Stage-1
Map Reduce
Map Operator Tree:
@@ -238,15 +289,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- a
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- a
- TableScan
- alias: a
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -467,10 +509,30 @@ SELECT /*+ MAPJOIN(a) */ * FROM src a RI
(select key, named_struct('key', key, 'value', value) as kv from src) b on a.key=b.key AND b.kv.key > 200 limit 10
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-3 is a root stage
+ Stage-1 depends on stages: Stage-3
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-3
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ a
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ a
+ TableScan
+ alias: a
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key} {value}
+ 1 {_col0} {_col1}
+ keys:
+ 0 key (type: string)
+ 1 _col0 (type: string)
+
Stage: Stage-1
Map Reduce
Map Operator Tree:
@@ -511,15 +573,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- a
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- a
- TableScan
- alias: a
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
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=1584410&r1=1584409&r2=1584410&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 Thu Apr 3 21:40:21 2014
@@ -11,11 +11,31 @@ ON ( c.key=d.key AND c.ds='2008-04-08' A
SELECT /*+ MAPJOIN(d) */ DISTINCT c.value
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-4 is a root stage
+ Stage-1 depends on stages: Stage-4
Stage-3 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-4
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ d
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ d
+ TableScan
+ alias: d
+ Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {value}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+
Stage: Stage-1
Map Reduce
Map Operator Tree:
@@ -49,15 +69,6 @@ STAGE PLANS:
Statistics: Num rows: 127 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- d
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- d
- TableScan
- alias: d
- Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string)
@@ -143,10 +154,30 @@ ON ( c.key=d.key AND c.ds='2008-04-08' A
SELECT /*+ MAPJOIN(d) */ DISTINCT c.value
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-3 is a root stage
+ Stage-1 depends on stages: Stage-3
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-3
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ d
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ d
+ TableScan
+ alias: d
+ Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {value}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+
Stage: Stage-1
Map Reduce
Map Operator Tree:
@@ -180,15 +211,6 @@ STAGE PLANS:
Statistics: Num rows: 127 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- d
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- d
- TableScan
- alias: d
- Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string)
@@ -252,11 +274,31 @@ ON ( c.key=d.key AND c.ds='2008-04-08' A
SELECT /*+ MAPJOIN(d) */ DISTINCT c.value
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-4 is a root stage
+ Stage-1 depends on stages: Stage-4
Stage-3 depends on stages: Stage-1
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-4
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ d
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ d
+ TableScan
+ alias: d
+ Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {value}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+
Stage: Stage-1
Map Reduce
Map Operator Tree:
@@ -285,15 +327,6 @@ STAGE PLANS:
Statistics: Num rows: 127 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- d
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- d
- TableScan
- alias: d
- Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string)
@@ -379,10 +412,30 @@ ON ( c.key=d.key AND c.ds='2008-04-08' A
SELECT /*+ MAPJOIN(d) */ DISTINCT c.value
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-3 is a root stage
+ Stage-1 depends on stages: Stage-3
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-3
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ d
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ d
+ TableScan
+ alias: d
+ Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {value}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+
Stage: Stage-1
Map Reduce
Map Operator Tree:
@@ -411,15 +464,6 @@ STAGE PLANS:
Statistics: Num rows: 127 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- d
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- d
- TableScan
- alias: d
- Statistics: Num rows: 116 Data size: 11624 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
keys: KEY._col0 (type: string)
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_hook.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_hook.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_hook.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_hook.q.out Thu Apr 3 21:40:21 2014
@@ -11,7 +11,8 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@src1
PREHOOK: Output: default@dest1
-[MapJoinCounter PostHook] COMMON_JOIN: 0 HINTED_MAPJOIN: 1 HINTED_MAPJOIN_LOCAL: 0 CONVERTED_MAPJOIN: 0 CONVERTED_MAPJOIN_LOCAL: 0 BACKUP_COMMON_JOIN: 0
+[MapJoinCounter PostHook] COMMON_JOIN: 0 HINTED_MAPJOIN: 1 HINTED_MAPJOIN_LOCAL: 1 CONVERTED_MAPJOIN: 0 CONVERTED_MAPJOIN_LOCAL: 0 BACKUP_COMMON_JOIN: 0
+RUN: Stage-4:MAPREDLOCAL
RUN: Stage-1:MAPRED
RUN: Stage-0:MOVE
RUN: Stage-2:STATS
@@ -20,7 +21,8 @@ INSERT OVERWRITE TABLE dest1 SELECT src1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest1
-[MapJoinCounter PostHook] COMMON_JOIN: 0 HINTED_MAPJOIN: 1 HINTED_MAPJOIN_LOCAL: 0 CONVERTED_MAPJOIN: 0 CONVERTED_MAPJOIN_LOCAL: 0 BACKUP_COMMON_JOIN: 0
+[MapJoinCounter PostHook] COMMON_JOIN: 0 HINTED_MAPJOIN: 1 HINTED_MAPJOIN_LOCAL: 1 CONVERTED_MAPJOIN: 0 CONVERTED_MAPJOIN_LOCAL: 0 BACKUP_COMMON_JOIN: 0
+RUN: Stage-6:MAPREDLOCAL
RUN: Stage-5:MAPRED
RUN: Stage-0:MOVE
RUN: Stage-2:STATS
@@ -35,21 +37,21 @@ PREHOOK: Input: default@srcpart@ds=2008-
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
PREHOOK: Output: default@dest1
-Execution failed with exit status: 2
+Execution failed with exit status: 3
Obtaining error information
Task failed!
Task ID:
- Stage-4
+ Stage-7
Logs:
#### A masked pattern was here ####
-FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
+FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.mr.MapRedTask
-[MapJoinCounter PostHook] COMMON_JOIN: 0 HINTED_MAPJOIN: 0 HINTED_MAPJOIN_LOCAL: 0 CONVERTED_MAPJOIN: 1 CONVERTED_MAPJOIN_LOCAL: 0 BACKUP_COMMON_JOIN: 1
+[MapJoinCounter PostHook] COMMON_JOIN: 0 HINTED_MAPJOIN: 0 HINTED_MAPJOIN_LOCAL: 0 CONVERTED_MAPJOIN: 0 CONVERTED_MAPJOIN_LOCAL: 1 BACKUP_COMMON_JOIN: 1
RUN: Stage-6:CONDITIONAL
-RUN: Stage-4:MAPRED
+RUN: Stage-7:MAPREDLOCAL
RUN: Stage-1:MAPRED
RUN: Stage-0:MOVE
RUN: Stage-2:STATS
@@ -58,36 +60,36 @@ INSERT OVERWRITE TABLE dest1 SELECT src1
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest1
-Execution failed with exit status: 2
+Execution failed with exit status: 3
Obtaining error information
Task failed!
Task ID:
- Stage-10
+ Stage-14
Logs:
#### A masked pattern was here ####
-FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
+FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.mr.MapRedTask
-Execution failed with exit status: 2
+Execution failed with exit status: 3
Obtaining error information
Task failed!
Task ID:
- Stage-6
+ Stage-12
Logs:
#### A masked pattern was here ####
-FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
+FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
ATTEMPT: Execute BackupTask: org.apache.hadoop.hive.ql.exec.mr.MapRedTask
-[MapJoinCounter PostHook] COMMON_JOIN: 0 HINTED_MAPJOIN: 0 HINTED_MAPJOIN_LOCAL: 0 CONVERTED_MAPJOIN: 2 CONVERTED_MAPJOIN_LOCAL: 0 BACKUP_COMMON_JOIN: 2
+[MapJoinCounter PostHook] COMMON_JOIN: 0 HINTED_MAPJOIN: 0 HINTED_MAPJOIN_LOCAL: 0 CONVERTED_MAPJOIN: 0 CONVERTED_MAPJOIN_LOCAL: 2 BACKUP_COMMON_JOIN: 2
RUN: Stage-11:CONDITIONAL
-RUN: Stage-10:MAPRED
+RUN: Stage-14:MAPREDLOCAL
RUN: Stage-1:MAPRED
RUN: Stage-8:CONDITIONAL
-RUN: Stage-6:MAPRED
+RUN: Stage-12:MAPREDLOCAL
RUN: Stage-2:MAPRED
RUN: Stage-0:MOVE
RUN: Stage-3:STATS
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out Thu Apr 3 21:40:21 2014
@@ -7,10 +7,44 @@ POSTHOOK: query: -- Since the inputs are
explain select srcpart.key from srcpart join src on (srcpart.value=src.value) join src1 on (srcpart.key=src1.key)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-5 is a root stage
+ Stage-7 is a root stage
+ Stage-5 depends on stages: Stage-7
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-7
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ src
+ Fetch Operator
+ limit: -1
+ src1
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ src
+ TableScan
+ alias: src
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key}
+ 1
+ keys:
+ 0 value (type: string)
+ 1 value (type: string)
+ src1
+ TableScan
+ alias: src1
+ Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col0}
+ 1
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
+
Stage: Stage-5
Map Reduce
Map Operator Tree:
@@ -52,22 +86,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src
- Fetch Operator
- limit: -1
- src1
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src
- TableScan
- alias: src
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
- src1
- TableScan
- alias: src1
- Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -91,6 +109,9 @@ STAGE PLANS:
src
Fetch Operator
limit: -1
+ src1
+ Fetch Operator
+ limit: -1
Alias -> Map Local Operator Tree:
src
TableScan
@@ -106,6 +127,17 @@ STAGE PLANS:
keys:
0 value (type: string)
1 value (type: string)
+ src1
+ TableScan
+ alias: src1
+ Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col0}
+ 1
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
Stage: Stage-5
Map Reduce
@@ -151,17 +183,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src
- src1
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src
- src1
- TableScan
- alias: src1
- Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -214,11 +235,32 @@ POSTHOOK: query: explain
select count(*) from srcpart join src on (srcpart.value=src.value) join src src1 on (srcpart.key=src1.key) group by ds
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-7 is a root stage
- Stage-3 depends on stages: Stage-7
+ Stage-9 is a root stage
+ Stage-7 depends on stages: Stage-9
+ Stage-8 depends on stages: Stage-7
+ Stage-3 depends on stages: Stage-8
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-9
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ src
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ src
+ TableScan
+ alias: src
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key} {ds}
+ 1
+ keys:
+ 0 value (type: string)
+ 1 value (type: string)
+
Stage: Stage-7
Map Reduce
Map Operator Tree:
@@ -244,15 +286,25 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src
- TableScan
- alias: src
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+
+ Stage: Stage-8
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ src1
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ src1
+ TableScan
+ alias: src1
+ Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col2}
+ 1
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
Stage: Stage-3
Map Reduce
@@ -287,15 +339,6 @@ STAGE PLANS:
value expressions: _col1 (type: bigint)
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src1
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src1
- TableScan
- alias: src1
- Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Group By Operator
aggregations: count(VALUE._col0)
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_memcheck.q.out Thu Apr 3 21:40:21 2014
@@ -26,10 +26,30 @@ POSTHOOK: type: QUERY
POSTHOOK: Lineage: src0.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: src0.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
STAGE DEPENDENCIES:
- Stage-2 is a root stage
+ Stage-5 is a root stage
+ Stage-2 depends on stages: Stage-5
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-5
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ src1
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ src1
+ TableScan
+ alias: src1
+ Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+
Stage: Stage-2
Map Reduce
Map Operator Tree:
@@ -58,15 +78,6 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src1
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src1
- TableScan
- alias: src1
- Statistics: Num rows: 10 Data size: 70 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Extract
Statistics: Num rows: 11 Data size: 77 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery.q.out Thu Apr 3 21:40:21 2014
@@ -17,10 +17,44 @@ FROM
JOIN srcpart z ON (subq.key1 = z.key and z.ds='2008-04-08' and z.hr=11)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-5 is a root stage
+ Stage-7 is a root stage
+ Stage-5 depends on stages: Stage-7
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-7
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ subq:x
+ Fetch Operator
+ limit: -1
+ z
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ subq:x
+ TableScan
+ alias: x
+ Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ z
+ TableScan
+ alias: z
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col0}
+ 1 {value}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
+
Stage: Stage-5
Map Reduce
Map Operator Tree:
@@ -66,22 +100,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- subq:x
- Fetch Operator
- limit: -1
- z
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- subq:x
- TableScan
- alias: x
- Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- z
- TableScan
- alias: z
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Stage: Stage-0
Fetch Operator
@@ -235,10 +253,44 @@ FROM
order by subq.key1, z.value
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-3 is a root stage
+ Stage-8 is a root stage
+ Stage-3 depends on stages: Stage-8
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-8
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ subq:x
+ Fetch Operator
+ limit: -1
+ z
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ subq:x
+ TableScan
+ alias: x
+ Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key}
+ 1
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ z
+ TableScan
+ alias: z
+ Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col0}
+ 1 {value}
+ keys:
+ 0 _col0 (type: string)
+ 1 key (type: string)
+
Stage: Stage-3
Map Reduce
Map Operator Tree:
@@ -282,22 +334,6 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string)
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- subq:x
- Fetch Operator
- limit: -1
- z
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- subq:x
- TableScan
- alias: x
- Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- z
- TableScan
- alias: z
- Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Extract
Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_subquery2.q.out Thu Apr 3 21:40:21 2014
@@ -80,10 +80,44 @@ FROM
JOIN z ON (subq.key1 = z.id)
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
- Stage-5 is a root stage
+ Stage-7 is a root stage
+ Stage-5 depends on stages: Stage-7
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-7
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ subq:y
+ Fetch Operator
+ limit: -1
+ z
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ subq:y
+ TableScan
+ alias: y
+ Statistics: Num rows: 0 Data size: 6 Basic stats: PARTIAL Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {id} {name}
+ 1 {name} {id}
+ keys:
+ 0 id (type: int)
+ 1 id (type: int)
+ z
+ TableScan
+ alias: z
+ Statistics: Num rows: 0 Data size: 6 Basic stats: PARTIAL Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {_col0} {_col1} {_col2} {_col3}
+ 1 {id} {name}
+ keys:
+ 0 _col0 (type: int)
+ 1 id (type: int)
+
Stage: Stage-5
Map Reduce
Map Operator Tree:
@@ -129,22 +163,6 @@ STAGE PLANS:
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- subq:y
- Fetch Operator
- limit: -1
- z
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- subq:y
- TableScan
- alias: y
- Statistics: Num rows: 0 Data size: 6 Basic stats: PARTIAL Column stats: NONE
- z
- TableScan
- alias: z
- Statistics: Num rows: 0 Data size: 6 Basic stats: PARTIAL Column stats: NONE
Stage: Stage-0
Fetch Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out?rev=1584410&r1=1584409&r2=1584410&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/mapjoin_test_outer.q.out Thu Apr 3 21:40:21 2014
@@ -264,10 +264,48 @@ POSTHOOK: Lineage: dest_1.value SIMPLE [
POSTHOOK: Lineage: dest_2.key SIMPLE [(dest_1)dest_1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: dest_2.value SIMPLE [(dest_1)dest_1.FieldSchema(name:value, type:string, comment:null), ]
STAGE DEPENDENCIES:
- Stage-1 is a root stage
+ Stage-4 is a root stage
+ Stage-1 depends on stages: Stage-4
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-4
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ src1
+ Fetch Operator
+ limit: -1
+ src2
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ src1
+ TableScan
+ alias: src1
+ Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ 2 {key} {value}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
+ src2
+ TableScan
+ alias: src2
+ Statistics: Num rows: 1 Data size: 13 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ 2 {key} {value}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
+
Stage: Stage-1
Map Reduce
Map Operator Tree:
@@ -299,22 +337,6 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src1
- Fetch Operator
- limit: -1
- src2
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src1
- TableScan
- alias: src1
- Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- src2
- TableScan
- alias: src2
- Statistics: Num rows: 1 Data size: 13 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Extract
Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE
@@ -1102,10 +1124,48 @@ POSTHOOK: Lineage: dest_1.value SIMPLE [
POSTHOOK: Lineage: dest_2.key SIMPLE [(dest_1)dest_1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: dest_2.value SIMPLE [(dest_1)dest_1.FieldSchema(name:value, type:string, comment:null), ]
STAGE DEPENDENCIES:
- Stage-2 is a root stage
+ Stage-6 is a root stage
+ Stage-2 depends on stages: Stage-6
Stage-0 is a root stage
STAGE PLANS:
+ Stage: Stage-6
+ Map Reduce Local Work
+ Alias -> Map Local Tables:
+ src1
+ Fetch Operator
+ limit: -1
+ src2
+ Fetch Operator
+ limit: -1
+ Alias -> Map Local Operator Tree:
+ src1
+ TableScan
+ alias: src1
+ Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ 2 {key} {value}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
+ src2
+ TableScan
+ alias: src2
+ Statistics: Num rows: 1 Data size: 13 Basic stats: COMPLETE Column stats: NONE
+ HashTable Sink Operator
+ condition expressions:
+ 0 {key} {value}
+ 1 {key} {value}
+ 2 {key} {value}
+ keys:
+ 0 key (type: string)
+ 1 key (type: string)
+ 2 key (type: string)
+
Stage: Stage-2
Map Reduce
Map Operator Tree:
@@ -1137,22 +1197,6 @@ STAGE PLANS:
value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
Local Work:
Map Reduce Local Work
- Alias -> Map Local Tables:
- src1
- Fetch Operator
- limit: -1
- src2
- Fetch Operator
- limit: -1
- Alias -> Map Local Operator Tree:
- src1
- TableScan
- alias: src1
- Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
- src2
- TableScan
- alias: src2
- Statistics: Num rows: 1 Data size: 13 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Extract
Statistics: Num rows: 19 Data size: 88 Basic stats: COMPLETE Column stats: NONE