You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by px...@apache.org on 2017/04/23 03:46:47 UTC
[3/5] hive git commit: HIVE-16421 Runtime filtering breaks user-level
explain (Pengcheng Xiong, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/eaa439e3/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/explainuser_2.q.out b/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
index c291473..2a27479 100644
--- a/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
@@ -2044,511 +2044,216 @@ SELECT x.key, y.value
FROM src1 x JOIN src1 y ON (x.key = y.key)
JOIN (select key, value from src1 union all select key, value from src union all select key, value from src union all select key, value from src)z ON (x.value = z.value)
POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
+Plan optimized by CBO.
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Map 1 <- Map 6 (BROADCAST_EDGE), Union 2 (CONTAINS)
- Map 12 <- Union 9 (CONTAINS)
- Map 13 <- Union 9 (CONTAINS)
- Map 16 <- Map 17 (BROADCAST_EDGE)
- Map 18 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
- Map 19 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
- Map 20 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
- Map 21 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
- Map 5 <- Map 6 (BROADCAST_EDGE), Union 2 (CONTAINS)
- Map 8 <- Union 9 (CONTAINS)
- Reducer 10 <- Map 14 (SIMPLE_EDGE), Union 9 (SIMPLE_EDGE)
- Reducer 11 <- Map 15 (SIMPLE_EDGE), Reducer 10 (SIMPLE_EDGE), Union 4 (CONTAINS)
- Reducer 3 <- Map 7 (SIMPLE_EDGE), Union 2 (SIMPLE_EDGE), Union 4 (CONTAINS)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: src1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col0 (type: string)
- 1 _col1 (type: string)
- outputColumnNames: _col1
- input vertices:
- 1 Map 6
- Statistics: Num rows: 577 Data size: 6053 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 577 Data size: 6053 Basic stats: COMPLETE Column stats: NONE
- Execution mode: llap
- LLAP IO: no inputs
- Map 12
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 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: 1025 Data size: 10815 Basic stats: COMPLETE Column stats: NONE
- Execution mode: llap
- LLAP IO: no inputs
- Map 13
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 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: 1025 Data size: 10815 Basic stats: COMPLETE Column stats: NONE
- Execution mode: llap
- LLAP IO: no inputs
- Map 14
- Map Operator Tree:
- TableScan
- alias: x
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 15
- Map Operator Tree:
- TableScan
- alias: y
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 16
- Map Operator Tree:
- TableScan
- alias: x
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col0 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col1, _col3
- input vertices:
- 1 Map 17
- Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col3 (type: string)
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col3 (type: string)
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col3 (type: string)
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col3 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 17
- Map Operator Tree:
- TableScan
- alias: y
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: key is not null (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 25 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: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 18
- Map Operator Tree:
- TableScan
- alias: src1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col3
- input vertices:
- 0 Map 16
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Execution mode: llap
- LLAP IO: no inputs
- Map 19
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col3
- input vertices:
- 0 Map 16
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Execution mode: llap
- LLAP IO: no inputs
- Map 20
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col3
- input vertices:
- 0 Map 16
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Execution mode: llap
- LLAP IO: no inputs
- Map 21
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col3
- input vertices:
- 0 Map 16
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Execution mode: llap
- LLAP IO: no inputs
- Map 5
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col0 (type: string)
- 1 _col1 (type: string)
- outputColumnNames: _col1
- input vertices:
- 1 Map 6
- Statistics: Num rows: 577 Data size: 6053 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 577 Data size: 6053 Basic stats: COMPLETE Column stats: NONE
- Execution mode: llap
- LLAP IO: no inputs
- Map 6
- Map Operator Tree:
- TableScan
- alias: x
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 7
- Map Operator Tree:
- TableScan
- alias: y
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 8
- Map Operator Tree:
- TableScan
- alias: src1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 25 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: 1025 Data size: 10815 Basic stats: COMPLETE Column stats: NONE
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 10
- Execution mode: llap
- Reduce Operator Tree:
- Merge Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col0 (type: string)
- 1 _col1 (type: string)
- outputColumnNames: _col1
- Statistics: Num rows: 1127 Data size: 11896 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 1127 Data size: 11896 Basic stats: COMPLETE Column stats: NONE
- Reducer 11
- Execution mode: llap
- Reduce Operator Tree:
- Merge Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col1, _col4
- Statistics: Num rows: 1239 Data size: 13085 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col1 (type: string), _col4 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1239 Data size: 13085 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Reducer 3
- Execution mode: llap
- Reduce Operator Tree:
- Merge Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col1, _col4
- Statistics: Num rows: 634 Data size: 6658 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col1 (type: string), _col4 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 634 Data size: 6658 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- Union 2
- Vertex: Union 2
- Union 4
- Vertex: Union 4
- Union 9
- Vertex: Union 9
+Vertex dependency in root stage
+Map 1 <- Map 6 (BROADCAST_EDGE), Union 2 (CONTAINS)
+Map 12 <- Union 9 (CONTAINS)
+Map 13 <- Union 9 (CONTAINS)
+Map 16 <- Map 17 (BROADCAST_EDGE)
+Map 18 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
+Map 19 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
+Map 20 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
+Map 21 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
+Map 5 <- Map 6 (BROADCAST_EDGE), Union 2 (CONTAINS)
+Map 8 <- Union 9 (CONTAINS)
+Reducer 10 <- Map 14 (SIMPLE_EDGE), Union 9 (SIMPLE_EDGE)
+Reducer 11 <- Map 15 (SIMPLE_EDGE), Reducer 10 (SIMPLE_EDGE), Union 4 (CONTAINS)
+Reducer 3 <- Map 7 (SIMPLE_EDGE), Union 2 (SIMPLE_EDGE), Union 4 (CONTAINS)
- Stage: Stage-0
- Fetch Operator
- limit: -1
- Processor Tree:
- ListSink
+Stage-0
+ Fetch Operator
+ limit:-1
+ Stage-1
+ Union 4
+ <-Map 18 [CONTAINS] llap
+ File Output Operator [FS_78]
+ Select Operator [SEL_76] (rows=1677 width=10)
+ Output:["_col0","_col1"]
+ Map Join Operator [MAPJOIN_123] (rows=1677 width=10)
+ Conds:RS_73._col1=SEL_56._col0(Inner),Output:["_col0","_col3"]
+ <-Map 16 [BROADCAST_EDGE] llap
+ BROADCAST [RS_73]
+ PartitionCols:_col1
+ Map Join Operator [MAPJOIN_122] (rows=27 width=7)
+ Conds:SEL_50._col0=RS_71._col0(Inner),Output:["_col0","_col1","_col3"]
+ <-Map 17 [BROADCAST_EDGE] llap
+ BROADCAST [RS_71]
+ PartitionCols:_col0
+ Select Operator [SEL_53] (rows=25 width=7)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_113] (rows=25 width=7)
+ predicate:key is not null
+ TableScan [TS_51] (rows=25 width=7)
+ default@src1,y,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Select Operator [SEL_50] (rows=25 width=7)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_112] (rows=25 width=7)
+ predicate:(key is not null and value is not null)
+ TableScan [TS_48] (rows=25 width=7)
+ default@src1,x,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Select Operator [SEL_56] (rows=25 width=7)
+ Output:["_col0"]
+ Filter Operator [FIL_114] (rows=25 width=7)
+ predicate:value is not null
+ TableScan [TS_54] (rows=25 width=7)
+ Output:["value"]
+ <-Map 19 [CONTAINS] llap
+ File Output Operator [FS_78]
+ Select Operator [SEL_76] (rows=1677 width=10)
+ Output:["_col0","_col1"]
+ Map Join Operator [MAPJOIN_123] (rows=1677 width=10)
+ Conds:RS_128._col1=SEL_59._col0(Inner),Output:["_col0","_col3"]
+ <-Map 16 [BROADCAST_EDGE] llap
+ BROADCAST [RS_128]
+ PartitionCols:_col1
+ Please refer to the previous Map Join Operator [MAPJOIN_122]
+ <-Select Operator [SEL_59] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_115] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_57] (rows=500 width=10)
+ Output:["value"]
+ <-Map 20 [CONTAINS] llap
+ File Output Operator [FS_78]
+ Select Operator [SEL_76] (rows=1677 width=10)
+ Output:["_col0","_col1"]
+ Map Join Operator [MAPJOIN_123] (rows=1677 width=10)
+ Conds:RS_129._col1=SEL_64._col0(Inner),Output:["_col0","_col3"]
+ <-Map 16 [BROADCAST_EDGE] llap
+ BROADCAST [RS_129]
+ PartitionCols:_col1
+ Please refer to the previous Map Join Operator [MAPJOIN_122]
+ <-Select Operator [SEL_64] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_116] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_62] (rows=500 width=10)
+ Output:["value"]
+ <-Map 21 [CONTAINS] llap
+ File Output Operator [FS_78]
+ Select Operator [SEL_76] (rows=1677 width=10)
+ Output:["_col0","_col1"]
+ Map Join Operator [MAPJOIN_123] (rows=1677 width=10)
+ Conds:RS_130._col1=SEL_68._col0(Inner),Output:["_col0","_col3"]
+ <-Map 16 [BROADCAST_EDGE] llap
+ BROADCAST [RS_130]
+ PartitionCols:_col1
+ Please refer to the previous Map Join Operator [MAPJOIN_122]
+ <-Select Operator [SEL_68] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_117] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_66] (rows=500 width=10)
+ Output:["value"]
+ <-Reducer 11 [CONTAINS] llap
+ File Output Operator [FS_78]
+ Select Operator [SEL_45] (rows=1239 width=10)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_121] (rows=1239 width=10)
+ Conds:RS_42._col1=RS_43._col0(Inner),Output:["_col1","_col4"]
+ <-Map 15 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_43]
+ PartitionCols:_col0
+ Select Operator [SEL_38] (rows=500 width=10)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_111] (rows=500 width=10)
+ predicate:key is not null
+ TableScan [TS_36] (rows=500 width=10)
+ default@src,y,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Reducer 10 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_42]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_120] (rows=1127 width=10)
+ Conds:Union 9._col0=RS_40._col1(Inner),Output:["_col1"]
+ <-Map 14 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_40]
+ PartitionCols:_col1
+ Select Operator [SEL_35] (rows=500 width=10)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_110] (rows=500 width=10)
+ predicate:(key is not null and value is not null)
+ TableScan [TS_33] (rows=500 width=10)
+ default@src,x,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Union 9 [SIMPLE_EDGE]
+ <-Map 12 [CONTAINS] llap
+ Reduce Output Operator [RS_39]
+ PartitionCols:_col0
+ Select Operator [SEL_26] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_108] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_24] (rows=500 width=10)
+ Output:["value"]
+ <-Map 13 [CONTAINS] llap
+ Reduce Output Operator [RS_39]
+ PartitionCols:_col0
+ Select Operator [SEL_31] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_109] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_29] (rows=500 width=10)
+ Output:["value"]
+ <-Map 8 [CONTAINS] llap
+ Reduce Output Operator [RS_39]
+ PartitionCols:_col0
+ Select Operator [SEL_23] (rows=25 width=7)
+ Output:["_col0"]
+ Filter Operator [FIL_107] (rows=25 width=7)
+ predicate:value is not null
+ TableScan [TS_21] (rows=25 width=7)
+ Output:["value"]
+ <-Reducer 3 [CONTAINS] llap
+ File Output Operator [FS_78]
+ Select Operator [SEL_20] (rows=634 width=10)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_119] (rows=634 width=10)
+ Conds:Union 2._col1=RS_18._col0(Inner),Output:["_col1","_col4"]
+ <-Map 7 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_18]
+ PartitionCols:_col0
+ Select Operator [SEL_13] (rows=500 width=10)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_106] (rows=500 width=10)
+ predicate:key is not null
+ TableScan [TS_11] (rows=500 width=10)
+ default@src,y,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Union 2 [SIMPLE_EDGE]
+ <-Map 1 [CONTAINS] llap
+ Reduce Output Operator [RS_17]
+ PartitionCols:_col1
+ Map Join Operator [MAPJOIN_118] (rows=577 width=10)
+ Conds:SEL_2._col0=RS_15._col1(Inner),Output:["_col1"]
+ <-Map 6 [BROADCAST_EDGE] llap
+ BROADCAST [RS_15]
+ PartitionCols:_col1
+ Select Operator [SEL_10] (rows=25 width=7)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_105] (rows=25 width=7)
+ predicate:(key is not null and value is not null)
+ TableScan [TS_8] (rows=25 width=7)
+ default@src1,x,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Select Operator [SEL_2] (rows=25 width=7)
+ Output:["_col0"]
+ Filter Operator [FIL_103] (rows=25 width=7)
+ predicate:value is not null
+ TableScan [TS_0] (rows=25 width=7)
+ Output:["value"]
+ <-Map 5 [CONTAINS] llap
+ Reduce Output Operator [RS_17]
+ PartitionCols:_col1
+ Map Join Operator [MAPJOIN_118] (rows=577 width=10)
+ Conds:SEL_5._col0=RS_124._col1(Inner),Output:["_col1"]
+ <-Map 6 [BROADCAST_EDGE] llap
+ BROADCAST [RS_124]
+ PartitionCols:_col1
+ Please refer to the previous Select Operator [SEL_10]
+ <-Select Operator [SEL_5] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_104] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_3] (rows=500 width=10)
+ Output:["value"]
PREHOOK: query: explain
SELECT x.key, y.value
@@ -2921,655 +2626,274 @@ INSERT OVERWRITE TABLE a SELECT tmp.key, tmp.value
INSERT OVERWRITE TABLE b SELECT tmp.key, tmp.value
INSERT OVERWRITE TABLE c SELECT tmp.key, tmp.value
POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-3 is a root stage
- Stage-4 depends on stages: Stage-3
- Stage-0 depends on stages: Stage-4
- Stage-5 depends on stages: Stage-0
- Stage-1 depends on stages: Stage-4
- Stage-6 depends on stages: Stage-1
- Stage-2 depends on stages: Stage-4
- Stage-7 depends on stages: Stage-2
-
-STAGE PLANS:
- Stage: Stage-3
- Tez
-#### A masked pattern was here ####
- Edges:
- Map 1 <- Map 6 (BROADCAST_EDGE), Union 2 (CONTAINS)
- Map 12 <- Union 9 (CONTAINS)
- Map 13 <- Union 9 (CONTAINS)
- Map 16 <- Map 17 (BROADCAST_EDGE)
- Map 18 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
- Map 19 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
- Map 20 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
- Map 21 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
- Map 5 <- Map 6 (BROADCAST_EDGE), Union 2 (CONTAINS)
- Map 8 <- Union 9 (CONTAINS)
- Reducer 10 <- Map 14 (SIMPLE_EDGE), Union 9 (SIMPLE_EDGE)
- Reducer 11 <- Map 15 (SIMPLE_EDGE), Reducer 10 (SIMPLE_EDGE), Union 4 (CONTAINS)
- Reducer 3 <- Map 7 (SIMPLE_EDGE), Union 2 (SIMPLE_EDGE), Union 4 (CONTAINS)
-#### A masked pattern was here ####
- Vertices:
- Map 1
- Map Operator Tree:
- TableScan
- alias: src1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col0 (type: string)
- 1 _col1 (type: string)
- outputColumnNames: _col1
- input vertices:
- 1 Map 6
- Statistics: Num rows: 577 Data size: 6053 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 577 Data size: 6053 Basic stats: COMPLETE Column stats: NONE
- Execution mode: llap
- LLAP IO: no inputs
- Map 12
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 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: 1025 Data size: 10815 Basic stats: COMPLETE Column stats: NONE
- Execution mode: llap
- LLAP IO: no inputs
- Map 13
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 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: 1025 Data size: 10815 Basic stats: COMPLETE Column stats: NONE
- Execution mode: llap
- LLAP IO: no inputs
- Map 14
- Map Operator Tree:
- TableScan
- alias: x
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 15
- Map Operator Tree:
- TableScan
- alias: y
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 16
- Map Operator Tree:
- TableScan
- alias: x
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col0 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col1, _col3
- input vertices:
- 1 Map 17
- Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col3 (type: string)
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col3 (type: string)
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col3 (type: string)
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 27 Data size: 210 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col3 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 17
- Map Operator Tree:
- TableScan
- alias: y
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: key is not null (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 25 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: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 18
- Map Operator Tree:
- TableScan
- alias: src1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col3
- input vertices:
- 0 Map 16
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.a
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.b
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.c
- Execution mode: llap
- LLAP IO: no inputs
- Map 19
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col3
- input vertices:
- 0 Map 16
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.a
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.b
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.c
- Execution mode: llap
- LLAP IO: no inputs
- Map 20
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col3
- input vertices:
- 0 Map 16
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.a
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.b
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.c
- Execution mode: llap
- LLAP IO: no inputs
- Map 21
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col0, _col3
- input vertices:
- 0 Map 16
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col0 (type: string), _col3 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1677 Data size: 17739 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.a
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.b
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.c
- Execution mode: llap
- LLAP IO: no inputs
- Map 5
- Map Operator Tree:
- TableScan
- alias: src
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Map Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col0 (type: string)
- 1 _col1 (type: string)
- outputColumnNames: _col1
- input vertices:
- 1 Map 6
- Statistics: Num rows: 577 Data size: 6053 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 577 Data size: 6053 Basic stats: COMPLETE Column stats: NONE
- Execution mode: llap
- LLAP IO: no inputs
- Map 6
- Map Operator Tree:
- TableScan
- alias: x
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: (key is not null and value is not null) (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 7
- Map Operator Tree:
- TableScan
- alias: y
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: key is not null (type: boolean)
- Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 500 Data size: 5312 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: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col1 (type: string)
- Execution mode: llap
- LLAP IO: no inputs
- Map 8
- Map Operator Tree:
- TableScan
- alias: src1
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator
- predicate: value is not null (type: boolean)
- Statistics: Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: value (type: string)
- outputColumnNames: _col0
- Statistics: Num rows: 25 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: 1025 Data size: 10815 Basic stats: COMPLETE Column stats: NONE
- Execution mode: llap
- LLAP IO: no inputs
- Reducer 10
- Execution mode: llap
- Reduce Operator Tree:
- Merge Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col0 (type: string)
- 1 _col1 (type: string)
- outputColumnNames: _col1
- Statistics: Num rows: 1127 Data size: 11896 Basic stats: COMPLETE Column stats: NONE
- Reduce Output Operator
- key expressions: _col1 (type: string)
- sort order: +
- Map-reduce partition columns: _col1 (type: string)
- Statistics: Num rows: 1127 Data size: 11896 Basic stats: COMPLETE Column stats: NONE
- Reducer 11
- Execution mode: llap
- Reduce Operator Tree:
- Merge Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col1, _col4
- Statistics: Num rows: 1239 Data size: 13085 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col1 (type: string), _col4 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 1239 Data size: 13085 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.a
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.b
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.c
- Reducer 3
- Execution mode: llap
- Reduce Operator Tree:
- Merge Join Operator
- condition map:
- Inner Join 0 to 1
- keys:
- 0 _col1 (type: string)
- 1 _col0 (type: string)
- outputColumnNames: _col1, _col4
- Statistics: Num rows: 634 Data size: 6658 Basic stats: COMPLETE Column stats: NONE
- Select Operator
- expressions: _col1 (type: string), _col4 (type: string)
- outputColumnNames: _col0, _col1
- Statistics: Num rows: 634 Data size: 6658 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.a
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.b
- File Output Operator
- compressed: false
- Statistics: Num rows: 3550 Data size: 37482 Basic stats: COMPLETE Column stats: NONE
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.c
- Union 2
- Vertex: Union 2
- Union 4
- Vertex: Union 4
- Union 9
- Vertex: Union 9
-
- Stage: Stage-4
- Dependency Collection
-
- Stage: Stage-0
- Move Operator
- tables:
- replace: true
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.a
-
- Stage: Stage-5
- Stats-Aggr Operator
-
- Stage: Stage-1
- Move Operator
- tables:
- replace: true
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.b
-
- Stage: Stage-6
- Stats-Aggr Operator
+Plan optimized by CBO.
- Stage: Stage-2
- Move Operator
- tables:
- replace: true
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.c
+Vertex dependency in root stage
+Map 1 <- Map 6 (BROADCAST_EDGE), Union 2 (CONTAINS)
+Map 12 <- Union 9 (CONTAINS)
+Map 13 <- Union 9 (CONTAINS)
+Map 16 <- Map 17 (BROADCAST_EDGE)
+Map 18 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
+Map 19 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
+Map 20 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
+Map 21 <- Map 16 (BROADCAST_EDGE), Union 4 (CONTAINS)
+Map 5 <- Map 6 (BROADCAST_EDGE), Union 2 (CONTAINS)
+Map 8 <- Union 9 (CONTAINS)
+Reducer 10 <- Map 14 (SIMPLE_EDGE), Union 9 (SIMPLE_EDGE)
+Reducer 11 <- Map 15 (SIMPLE_EDGE), Reducer 10 (SIMPLE_EDGE), Union 4 (CONTAINS)
+Reducer 3 <- Map 7 (SIMPLE_EDGE), Union 2 (SIMPLE_EDGE), Union 4 (CONTAINS)
- Stage: Stage-7
- Stats-Aggr Operator
+Stage-5
+ Stats-Aggr Operator
+ Stage-0
+ Move Operator
+ table:{"name:":"default.a"}
+ Stage-4
+ Dependency Collection{}
+ Stage-3
+ Union 4
+ <-Map 18 [CONTAINS] llap
+ File Output Operator [FS_79]
+ table:{"name:":"default.a"}
+ Select Operator [SEL_76] (rows=1677 width=10)
+ Output:["_col0","_col1"]
+ Map Join Operator [MAPJOIN_128] (rows=1677 width=10)
+ Conds:RS_73._col1=SEL_56._col0(Inner),Output:["_col0","_col3"]
+ <-Map 16 [BROADCAST_EDGE] llap
+ BROADCAST [RS_73]
+ PartitionCols:_col1
+ Map Join Operator [MAPJOIN_127] (rows=27 width=7)
+ Conds:SEL_50._col0=RS_71._col0(Inner),Output:["_col0","_col1","_col3"]
+ <-Map 17 [BROADCAST_EDGE] llap
+ BROADCAST [RS_71]
+ PartitionCols:_col0
+ Select Operator [SEL_53] (rows=25 width=7)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_118] (rows=25 width=7)
+ predicate:key is not null
+ TableScan [TS_51] (rows=25 width=7)
+ default@src1,y,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Select Operator [SEL_50] (rows=25 width=7)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_117] (rows=25 width=7)
+ predicate:(key is not null and value is not null)
+ TableScan [TS_48] (rows=25 width=7)
+ default@src1,x,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Select Operator [SEL_56] (rows=25 width=7)
+ Output:["_col0"]
+ Filter Operator [FIL_119] (rows=25 width=7)
+ predicate:value is not null
+ TableScan [TS_54] (rows=25 width=7)
+ Output:["value"]
+ File Output Operator [FS_81]
+ table:{"name:":"default.b"}
+ Please refer to the previous Select Operator [SEL_76]
+ File Output Operator [FS_83]
+ table:{"name:":"default.c"}
+ Please refer to the previous Select Operator [SEL_76]
+ <-Map 19 [CONTAINS] llap
+ File Output Operator [FS_79]
+ table:{"name:":"default.a"}
+ Select Operator [SEL_76] (rows=1677 width=10)
+ Output:["_col0","_col1"]
+ Map Join Operator [MAPJOIN_128] (rows=1677 width=10)
+ Conds:RS_133._col1=SEL_59._col0(Inner),Output:["_col0","_col3"]
+ <-Map 16 [BROADCAST_EDGE] llap
+ BROADCAST [RS_133]
+ PartitionCols:_col1
+ Please refer to the previous Map Join Operator [MAPJOIN_127]
+ <-Select Operator [SEL_59] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_120] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_57] (rows=500 width=10)
+ Output:["value"]
+ File Output Operator [FS_81]
+ table:{"name:":"default.b"}
+ Please refer to the previous Select Operator [SEL_76]
+ File Output Operator [FS_83]
+ table:{"name:":"default.c"}
+ Please refer to the previous Select Operator [SEL_76]
+ <-Map 20 [CONTAINS] llap
+ File Output Operator [FS_79]
+ table:{"name:":"default.a"}
+ Select Operator [SEL_76] (rows=1677 width=10)
+ Output:["_col0","_col1"]
+ Map Join Operator [MAPJOIN_128] (rows=1677 width=10)
+ Conds:RS_134._col1=SEL_64._col0(Inner),Output:["_col0","_col3"]
+ <-Map 16 [BROADCAST_EDGE] llap
+ BROADCAST [RS_134]
+ PartitionCols:_col1
+ Please refer to the previous Map Join Operator [MAPJOIN_127]
+ <-Select Operator [SEL_64] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_121] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_62] (rows=500 width=10)
+ Output:["value"]
+ File Output Operator [FS_81]
+ table:{"name:":"default.b"}
+ Please refer to the previous Select Operator [SEL_76]
+ File Output Operator [FS_83]
+ table:{"name:":"default.c"}
+ Please refer to the previous Select Operator [SEL_76]
+ <-Map 21 [CONTAINS] llap
+ File Output Operator [FS_79]
+ table:{"name:":"default.a"}
+ Select Operator [SEL_76] (rows=1677 width=10)
+ Output:["_col0","_col1"]
+ Map Join Operator [MAPJOIN_128] (rows=1677 width=10)
+ Conds:RS_135._col1=SEL_68._col0(Inner),Output:["_col0","_col3"]
+ <-Map 16 [BROADCAST_EDGE] llap
+ BROADCAST [RS_135]
+ PartitionCols:_col1
+ Please refer to the previous Map Join Operator [MAPJOIN_127]
+ <-Select Operator [SEL_68] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_122] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_66] (rows=500 width=10)
+ Output:["value"]
+ File Output Operator [FS_81]
+ table:{"name:":"default.b"}
+ Please refer to the previous Select Operator [SEL_76]
+ File Output Operator [FS_83]
+ table:{"name:":"default.c"}
+ Please refer to the previous Select Operator [SEL_76]
+ <-Reducer 11 [CONTAINS] llap
+ File Output Operator [FS_79]
+ table:{"name:":"default.a"}
+ Select Operator [SEL_45] (rows=1239 width=10)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_126] (rows=1239 width=10)
+ Conds:RS_42._col1=RS_43._col0(Inner),Output:["_col1","_col4"]
+ <-Map 15 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_43]
+ PartitionCols:_col0
+ Select Operator [SEL_38] (rows=500 width=10)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_116] (rows=500 width=10)
+ predicate:key is not null
+ TableScan [TS_36] (rows=500 width=10)
+ default@src,y,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Reducer 10 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_42]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_125] (rows=1127 width=10)
+ Conds:Union 9._col0=RS_40._col1(Inner),Output:["_col1"]
+ <-Map 14 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_40]
+ PartitionCols:_col1
+ Select Operator [SEL_35] (rows=500 width=10)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_115] (rows=500 width=10)
+ predicate:(key is not null and value is not null)
+ TableScan [TS_33] (rows=500 width=10)
+ default@src,x,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Union 9 [SIMPLE_EDGE]
+ <-Map 12 [CONTAINS] llap
+ Reduce Output Operator [RS_39]
+ PartitionCols:_col0
+ Select Operator [SEL_26] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_113] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_24] (rows=500 width=10)
+ Output:["value"]
+ <-Map 13 [CONTAINS] llap
+ Reduce Output Operator [RS_39]
+ PartitionCols:_col0
+ Select Operator [SEL_31] (rows=500 width=10)
+ Output:["_col0"]
+ Filter Operator [FIL_114] (rows=500 width=10)
+ predicate:value is not null
+ TableScan [TS_29] (rows=500 width=10)
+ Output:["value"]
+ <-Map 8 [CONTAINS] llap
+ Reduce Output Operator [RS_39]
+ PartitionCols:_col0
+ Select Operator [SEL_23] (rows=25 width=7)
+ Output:["_col0"]
+ Filter Operator [FIL_112] (rows=25 width=7)
+ predicate:value is not null
+ TableScan [TS_21] (rows=25 width=7)
+ Output:["value"]
+ File Output Operator [FS_81]
+ table:{"name:":"default.b"}
+ Please refer to the previous Select Operator [SEL_45]
+ File Output Operator [FS_83]
+ table:{"name:":"default.c"}
+ Please refer to the previous Select Operator [SEL_45]
+ <-Reducer 3 [CONTAINS] llap
+ File Output Operator [FS_79]
+ table:{"name:":"default.a"}
+ Select Operator [SEL_20] (rows=634 width=10)
+ Output:["_col0","_col1"]
+ Merge Join Operator [MERGEJOIN_124] (rows=634 width=10)
+ Conds:Union 2._col1=RS_18._col0(Inner),Output:["_col1","_col4"]
+ <-Map 7 [SIMPLE_EDGE] llap
+ SHUFFLE [RS_18]
+ PartitionCols:_col0
+ Select Operator [SEL_13] (rows=500 width=10)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_111] (rows=500 width=10)
+ predicate:key is not null
+ TableScan [TS_11] (rows=500 width=10)
+ default@src,y,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Union 2 [SIMPLE_EDGE]
+ <-Map 1 [CONTAINS] llap
+ Reduce Output Operator [RS_17]
+ PartitionCols:_col1
+ Map Join Operator [MAPJOIN_123] (rows=577 width=10)
+ Conds:SEL_2._col0=RS_15._col1(Inner),Output:["_col1"]
+ <-Map 6 [BROADCAST_EDGE] llap
+ BROADCAST [RS_15]
+ PartitionCols:_col1
+ Select Operator [SEL_10] (rows=25 width=7)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_110] (rows=25 width=7)
+ predicate:(key is not null and value is not null)
+ TableScan [TS_8] (rows=25 width=7)
+ default@src1,x,Tbl:COMPLETE,Col:NONE,Output:["key","value"]
+ <-Select Operator [
<TRUNCATED>