| Warning: Shuffle Join MERGEJOIN[40][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product |
| PREHOOK: query: explain |
| select key, count(*) |
| from src |
| group by key |
| having key not in |
| ( select key from src s1 |
| where s1.key > '12' |
| ) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain |
| select key, count(*) |
| from src |
| group by key |
| having key not in |
| ( select key from src s1 |
| where s1.key > '12' |
| ) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 5 (SIMPLE_EDGE) |
| Reducer 3 <- Reducer 2 (XPROD_EDGE), Reducer 4 (XPROD_EDGE) |
| Reducer 4 <- Map 1 (CUSTOM_SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: src |
| Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: string) |
| outputColumnNames: key |
| Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| aggregations: count() |
| keys: key (type: string) |
| minReductionHashAggr: 0.4 |
| mode: hash |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 316 Data size: 30020 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Statistics: Num rows: 316 Data size: 30020 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: bigint) |
| Filter Operator |
| predicate: (key > '12') (type: boolean) |
| Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| aggregations: count(), count(key) |
| minReductionHashAggr: 0.99 |
| mode: hash |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: bigint), _col1 (type: bigint) |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 5 |
| Map Operator Tree: |
| TableScan |
| alias: s1 |
| filterExpr: (key > '12') (type: boolean) |
| Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (key > '12') (type: boolean) |
| Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| keys: key (type: string) |
| minReductionHashAggr: 0.4 |
| mode: hash |
| outputColumnNames: _col0 |
| Statistics: Num rows: 105 Data size: 9135 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Statistics: Num rows: 105 Data size: 9135 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Reduce Operator Tree: |
| Group By Operator |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 105 Data size: 9135 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string), true (type: boolean) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 105 Data size: 9555 Basic stats: COMPLETE Column stats: COMPLETE |
| Dummy Store |
| Execution mode: llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0) |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 316 Data size: 30020 Basic stats: COMPLETE Column stats: COMPLETE |
| Merge Join Operator |
| condition map: |
| Left Outer Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col1, _col3 |
| Statistics: Num rows: 421 Data size: 40419 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 421 Data size: 40419 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: string), _col1 (type: bigint), _col3 (type: boolean) |
| Reducer 3 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 |
| 1 |
| outputColumnNames: _col0, _col1, _col3, _col4, _col5 |
| Statistics: Num rows: 421 Data size: 47155 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string), _col1 (type: bigint), _col4 (type: bigint), _col5 (type: bigint), _col3 (type: boolean) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col5 |
| Statistics: Num rows: 421 Data size: 47155 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ((_col2 = 0L) or (_col5 is null and (_col3 >= _col2) and _col0 is not null)) (type: boolean) |
| Statistics: Num rows: 421 Data size: 47155 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string), _col1 (type: bigint) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 421 Data size: 39995 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 421 Data size: 39995 Basic stats: COMPLETE Column stats: COMPLETE |
| 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 4 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0), count(VALUE._col1) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: bigint), _col1 (type: bigint) |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: explain |
| select b.p_mfgr, min(p_retailprice) |
| from part b |
| group by b.p_mfgr |
| having b.p_mfgr not in |
| (select p_mfgr |
| from (select p_mfgr, min(p_retailprice) l, max(p_retailprice) r, avg(p_retailprice) a from part group by p_mfgr) a |
| where min(p_retailprice) = l and r - l > 600 |
| ) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@part |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain |
| select b.p_mfgr, min(p_retailprice) |
| from part b |
| group by b.p_mfgr |
| having b.p_mfgr not in |
| (select p_mfgr |
| from (select p_mfgr, min(p_retailprice) l, max(p_retailprice) r, avg(p_retailprice) a from part group by p_mfgr) a |
| where min(p_retailprice) = l and r - l > 600 |
| ) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@part |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE) |
| Reducer 3 <- Reducer 2 (SIMPLE_EDGE), Reducer 6 (SIMPLE_EDGE) |
| Reducer 4 <- Reducer 3 (SIMPLE_EDGE), Reducer 7 (SIMPLE_EDGE) |
| Reducer 5 <- Map 1 (SIMPLE_EDGE) |
| Reducer 6 <- Reducer 5 (SIMPLE_EDGE) |
| Reducer 7 <- Map 1 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: b |
| Statistics: Num rows: 26 Data size: 2756 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: p_mfgr (type: string), p_retailprice (type: double) |
| outputColumnNames: p_mfgr, p_retailprice |
| Statistics: Num rows: 26 Data size: 2756 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| aggregations: min(p_retailprice) |
| keys: p_mfgr (type: string) |
| minReductionHashAggr: 0.8076923 |
| mode: hash |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 5 Data size: 530 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Statistics: Num rows: 5 Data size: 530 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: double) |
| Group By Operator |
| aggregations: min(p_retailprice), max(p_retailprice) |
| keys: p_mfgr (type: string) |
| minReductionHashAggr: 0.8076923 |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: double), _col2 (type: double) |
| Filter Operator |
| predicate: p_mfgr is not null (type: boolean) |
| Statistics: Num rows: 26 Data size: 2756 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| aggregations: min(p_retailprice), max(p_retailprice) |
| keys: p_mfgr (type: string) |
| minReductionHashAggr: 0.8076923 |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: double), _col2 (type: double) |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: min(VALUE._col0) |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 5 Data size: 530 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col1 (type: double) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col1 (type: double) |
| Statistics: Num rows: 5 Data size: 530 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: string) |
| Reducer 3 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Left Outer Join 0 to 1 |
| keys: |
| 0 _col1 (type: double) |
| 1 _col0 (type: double) |
| outputColumnNames: _col0, _col1, _col3, _col4 |
| Statistics: Num rows: 6 Data size: 668 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: string), _col1 (type: double) |
| null sort order: zz |
| sort order: ++ |
| Map-reduce partition columns: _col0 (type: string), _col1 (type: double) |
| Statistics: Num rows: 6 Data size: 668 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col3 (type: bigint), _col4 (type: bigint) |
| Reducer 4 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Left Outer Join 0 to 1 |
| keys: |
| 0 _col0 (type: string), _col1 (type: double) |
| 1 _col0 (type: string), _col2 (type: double) |
| outputColumnNames: _col0, _col1, _col3, _col4, _col6 |
| Statistics: Num rows: 7 Data size: 798 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (_col3 is null or (_col3 = 0L) or (_col6 is not null or _col0 is null or (_col4 < _col3)) is not true) (type: boolean) |
| Statistics: Num rows: 7 Data size: 798 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string), _col1 (type: double) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 7 Data size: 742 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 7 Data size: 742 Basic stats: COMPLETE Column stats: COMPLETE |
| 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 5 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: min(VALUE._col0), max(VALUE._col1) |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (((_col2 - _col1) > 600.0D) and _col1 is not null) (type: boolean) |
| Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string), _col1 (type: double) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| aggregations: count(), count(_col0) |
| keys: _col1 (type: double) |
| minReductionHashAggr: 0.4 |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: double) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: double) |
| Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: bigint), _col2 (type: bigint) |
| Reducer 6 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0), count(VALUE._col1) |
| keys: KEY._col0 (type: double) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: double) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: double) |
| Statistics: Num rows: 1 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: bigint), _col2 (type: bigint) |
| Reducer 7 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: min(VALUE._col0), max(VALUE._col1) |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (((_col2 - _col1) > 600.0D) and _col1 is not null) (type: boolean) |
| Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string), true (type: boolean), _col1 (type: double) |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 1 Data size: 110 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: string), _col2 (type: double) |
| null sort order: zz |
| sort order: ++ |
| Map-reduce partition columns: _col0 (type: string), _col2 (type: double) |
| Statistics: Num rows: 1 Data size: 110 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: boolean) |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: select b.p_mfgr, min(p_retailprice) |
| from part b |
| group by b.p_mfgr |
| having b.p_mfgr not in |
| (select p_mfgr |
| from (select p_mfgr, min(p_retailprice) l, max(p_retailprice) r, avg(p_retailprice) a from part group by p_mfgr) a |
| where min(p_retailprice) = l and r - l > 600 |
| ) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@part |
| #### A masked pattern was here #### |
| POSTHOOK: query: select b.p_mfgr, min(p_retailprice) |
| from part b |
| group by b.p_mfgr |
| having b.p_mfgr not in |
| (select p_mfgr |
| from (select p_mfgr, min(p_retailprice) l, max(p_retailprice) r, avg(p_retailprice) a from part group by p_mfgr) a |
| where min(p_retailprice) = l and r - l > 600 |
| ) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@part |
| #### A masked pattern was here #### |
| Manufacturer#1 1173.15 |
| Manufacturer#2 1690.68 |
| Warning: Shuffle Join MERGEJOIN[45][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product |
| PREHOOK: query: explain |
| select b.p_mfgr, min(p_retailprice) |
| from part b |
| group by b.p_mfgr |
| having b.p_mfgr not in |
| (select p_mfgr |
| from part a |
| group by p_mfgr |
| having max(p_retailprice) - min(p_retailprice) > 600 |
| ) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@part |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain |
| select b.p_mfgr, min(p_retailprice) |
| from part b |
| group by b.p_mfgr |
| having b.p_mfgr not in |
| (select p_mfgr |
| from part a |
| group by p_mfgr |
| having max(p_retailprice) - min(p_retailprice) > 600 |
| ) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@part |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 6 (SIMPLE_EDGE) |
| Reducer 3 <- Reducer 2 (XPROD_EDGE), Reducer 5 (XPROD_EDGE) |
| Reducer 4 <- Map 1 (SIMPLE_EDGE) |
| Reducer 5 <- Reducer 4 (CUSTOM_SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: b |
| Statistics: Num rows: 26 Data size: 2756 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: p_mfgr (type: string), p_retailprice (type: double) |
| outputColumnNames: p_mfgr, p_retailprice |
| Statistics: Num rows: 26 Data size: 2756 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| aggregations: min(p_retailprice) |
| keys: p_mfgr (type: string) |
| minReductionHashAggr: 0.8076923 |
| mode: hash |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 5 Data size: 530 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Statistics: Num rows: 5 Data size: 530 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: double) |
| Group By Operator |
| aggregations: max(p_retailprice), min(p_retailprice) |
| keys: p_mfgr (type: string) |
| minReductionHashAggr: 0.8076923 |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: double), _col2 (type: double) |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 6 |
| Map Operator Tree: |
| TableScan |
| alias: a |
| filterExpr: p_mfgr is not null (type: boolean) |
| Statistics: Num rows: 26 Data size: 2756 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: p_mfgr is not null (type: boolean) |
| Statistics: Num rows: 26 Data size: 2756 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| aggregations: max(p_retailprice), min(p_retailprice) |
| keys: p_mfgr (type: string) |
| minReductionHashAggr: 0.8076923 |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: double), _col2 (type: double) |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: max(VALUE._col0), min(VALUE._col1) |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ((_col1 - _col2) > 600.0D) (type: boolean) |
| Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string), true (type: boolean) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 1 Data size: 102 Basic stats: COMPLETE Column stats: COMPLETE |
| Dummy Store |
| Execution mode: llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: min(VALUE._col0) |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 5 Data size: 530 Basic stats: COMPLETE Column stats: COMPLETE |
| Merge Join Operator |
| condition map: |
| Left Outer Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col1, _col3 |
| Statistics: Num rows: 6 Data size: 644 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 6 Data size: 644 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: string), _col1 (type: double), _col3 (type: boolean) |
| Reducer 3 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 |
| 1 |
| outputColumnNames: _col0, _col1, _col3, _col4, _col5 |
| Statistics: Num rows: 6 Data size: 740 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string), _col1 (type: double), _col4 (type: bigint), _col5 (type: bigint), _col3 (type: boolean) |
| outputColumnNames: _col0, _col1, _col2, _col3, _col5 |
| Statistics: Num rows: 6 Data size: 740 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ((_col2 = 0L) or (_col5 is null and (_col3 >= _col2) and _col0 is not null)) (type: boolean) |
| Statistics: Num rows: 6 Data size: 740 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string), _col1 (type: double) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 6 Data size: 636 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 6 Data size: 636 Basic stats: COMPLETE Column stats: COMPLETE |
| 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 4 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: max(VALUE._col0), min(VALUE._col1) |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 5 Data size: 570 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ((_col1 - _col2) > 600.0D) (type: boolean) |
| Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 1 Data size: 114 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| aggregations: count(), count(_col0) |
| minReductionHashAggr: 0.4 |
| mode: hash |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: bigint), _col1 (type: bigint) |
| Reducer 5 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0), count(VALUE._col1) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: bigint), _col1 (type: bigint) |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| Warning: Shuffle Join MERGEJOIN[45][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product |
| PREHOOK: query: select b.p_mfgr, min(p_retailprice) |
| from part b |
| group by b.p_mfgr |
| having b.p_mfgr not in |
| (select p_mfgr |
| from part a |
| group by p_mfgr |
| having max(p_retailprice) - min(p_retailprice) > 600 |
| ) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@part |
| #### A masked pattern was here #### |
| POSTHOOK: query: select b.p_mfgr, min(p_retailprice) |
| from part b |
| group by b.p_mfgr |
| having b.p_mfgr not in |
| (select p_mfgr |
| from part a |
| group by p_mfgr |
| having max(p_retailprice) - min(p_retailprice) > 600 |
| ) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@part |
| #### A masked pattern was here #### |
| Manufacturer#1 1173.15 |
| Manufacturer#2 1690.68 |
| PREHOOK: query: CREATE TABLE t1_n145 (c1 INT, c2 CHAR(100)) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@t1_n145 |
| POSTHOOK: query: CREATE TABLE t1_n145 (c1 INT, c2 CHAR(100)) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@t1_n145 |
| PREHOOK: query: INSERT INTO t1_n145 VALUES (null,null), (1,''), (2,'abcde'), (100,'abcdefghij') |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@t1_n145 |
| POSTHOOK: query: INSERT INTO t1_n145 VALUES (null,null), (1,''), (2,'abcde'), (100,'abcdefghij') |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@t1_n145 |
| POSTHOOK: Lineage: t1_n145.c1 SCRIPT [] |
| POSTHOOK: Lineage: t1_n145.c2 SCRIPT [] |
| PREHOOK: query: CREATE TABLE t2_n85 (c1 INT) |
| PREHOOK: type: CREATETABLE |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@t2_n85 |
| POSTHOOK: query: CREATE TABLE t2_n85 (c1 INT) |
| POSTHOOK: type: CREATETABLE |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@t2_n85 |
| PREHOOK: query: INSERT INTO t2_n85 VALUES (null), (2), (100) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: _dummy_database@_dummy_table |
| PREHOOK: Output: default@t2_n85 |
| POSTHOOK: query: INSERT INTO t2_n85 VALUES (null), (2), (100) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: _dummy_database@_dummy_table |
| POSTHOOK: Output: default@t2_n85 |
| POSTHOOK: Lineage: t2_n85.c1 SCRIPT [] |
| Warning: Shuffle Join MERGEJOIN[38][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product |
| PREHOOK: query: explain SELECT c1 FROM t1_n145 group by c1 having c1 NOT IN (SELECT c1 FROM t2_n85) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@t1_n145 |
| PREHOOK: Input: default@t2_n85 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain SELECT c1 FROM t1_n145 group by c1 having c1 NOT IN (SELECT c1 FROM t2_n85) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@t1_n145 |
| POSTHOOK: Input: default@t2_n85 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) |
| Reducer 3 <- Reducer 2 (XPROD_EDGE), Reducer 6 (XPROD_EDGE) |
| Reducer 6 <- Map 4 (CUSTOM_SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: t1_n145 |
| Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: c1 (type: int) |
| outputColumnNames: c1 |
| Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| keys: c1 (type: int) |
| minReductionHashAggr: 0.4 |
| mode: hash |
| outputColumnNames: _col0 |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 4 |
| Map Operator Tree: |
| TableScan |
| alias: t2_n85 |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: c1 is not null (type: boolean) |
| Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| keys: c1 (type: int) |
| minReductionHashAggr: 0.4 |
| mode: hash |
| outputColumnNames: _col0 |
| Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: c1 (type: int) |
| outputColumnNames: c1 |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| aggregations: count(), count(c1) |
| minReductionHashAggr: 0.6666666 |
| mode: hash |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: bigint), _col1 (type: bigint) |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Reduce Operator Tree: |
| Group By Operator |
| keys: KEY._col0 (type: int) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: int), true (type: boolean) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Dummy Store |
| Execution mode: llap |
| Reduce Operator Tree: |
| Group By Operator |
| keys: KEY._col0 (type: int) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| Merge Join Operator |
| condition map: |
| Left Outer Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0, _col2 |
| Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 3 Data size: 24 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: int), _col2 (type: boolean) |
| Reducer 3 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 |
| 1 |
| outputColumnNames: _col0, _col2, _col3, _col4 |
| Statistics: Num rows: 3 Data size: 72 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: int), _col3 (type: bigint), _col4 (type: bigint), _col2 (type: boolean) |
| outputColumnNames: _col0, _col1, _col2, _col4 |
| Statistics: Num rows: 3 Data size: 72 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: ((_col1 = 0L) or (_col4 is null and (_col2 >= _col1) and _col0 is not null)) (type: boolean) |
| Statistics: Num rows: 3 Data size: 72 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| 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 6 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0), count(VALUE._col1) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| null sort order: |
| sort order: |
| Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: bigint), _col1 (type: bigint) |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| Warning: Shuffle Join MERGEJOIN[38][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product |
| PREHOOK: query: SELECT c1 FROM t1_n145 group by c1 having c1 NOT IN (SELECT c1 FROM t2_n85) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@t1_n145 |
| PREHOOK: Input: default@t2_n85 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT c1 FROM t1_n145 group by c1 having c1 NOT IN (SELECT c1 FROM t2_n85) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@t1_n145 |
| POSTHOOK: Input: default@t2_n85 |
| #### A masked pattern was here #### |
| PREHOOK: query: explain SELECT c1 FROM t1_n145 group by c1 having c1 NOT IN (SELECT c1 FROM t2_n85 where t1_n145.c1=t2_n85.c1) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@t1_n145 |
| PREHOOK: Input: default@t2_n85 |
| #### A masked pattern was here #### |
| POSTHOOK: query: explain SELECT c1 FROM t1_n145 group by c1 having c1 NOT IN (SELECT c1 FROM t2_n85 where t1_n145.c1=t2_n85.c1) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@t1_n145 |
| POSTHOOK: Input: default@t2_n85 |
| #### A masked pattern was here #### |
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
| #### A masked pattern was here #### |
| Edges: |
| Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 4 (SIMPLE_EDGE) |
| Reducer 3 <- Reducer 2 (SIMPLE_EDGE), Reducer 6 (SIMPLE_EDGE) |
| Reducer 6 <- Map 4 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: t1_n145 |
| Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: c1 (type: int) |
| outputColumnNames: c1 |
| Statistics: Num rows: 4 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| keys: c1 (type: int) |
| minReductionHashAggr: 0.4 |
| mode: hash |
| outputColumnNames: _col0 |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 4 |
| Map Operator Tree: |
| TableScan |
| alias: t2_n85 |
| filterExpr: c1 is not null (type: boolean) |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: c1 is not null (type: boolean) |
| Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE |
| Group By Operator |
| aggregations: count(), count(c1) |
| keys: c1 (type: int) |
| minReductionHashAggr: 0.4 |
| mode: hash |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 2 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 2 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: bigint), _col2 (type: bigint) |
| Group By Operator |
| keys: c1 (type: int) |
| minReductionHashAggr: 0.4 |
| mode: hash |
| outputColumnNames: _col0 |
| Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Reduce Operator Tree: |
| Group By Operator |
| aggregations: count(VALUE._col0), count(VALUE._col1) |
| keys: KEY._col0 (type: int) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1, _col2 |
| Statistics: Num rows: 2 Data size: 40 Basic stats: COMPLETE Column stats: COMPLETE |
| Dummy Store |
| Execution mode: llap |
| Reduce Operator Tree: |
| Group By Operator |
| keys: KEY._col0 (type: int) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| Merge Join Operator |
| condition map: |
| Left Outer Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col0 (type: int) |
| outputColumnNames: _col0, _col2, _col3 |
| Statistics: Num rows: 3 Data size: 60 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col0 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: int) |
| Statistics: Num rows: 3 Data size: 60 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col2 (type: bigint), _col3 (type: bigint) |
| Reducer 3 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Left Outer Join 0 to 1 |
| keys: |
| 0 _col0 (type: int) |
| 1 _col1 (type: int) |
| outputColumnNames: _col0, _col2, _col3, _col4 |
| Statistics: Num rows: 3 Data size: 72 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (_col2 is null or (_col2 = 0L) or (_col4 is not null or _col0 is null or (_col3 < _col2)) is not true) (type: boolean) |
| Statistics: Num rows: 3 Data size: 72 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: int) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 3 Data size: 12 Basic stats: COMPLETE Column stats: COMPLETE |
| 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 6 |
| Execution mode: vectorized, llap |
| Reduce Operator Tree: |
| Group By Operator |
| keys: KEY._col0 (type: int) |
| mode: mergepartial |
| outputColumnNames: _col0 |
| Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: true (type: boolean), _col0 (type: int) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| Reduce Output Operator |
| key expressions: _col1 (type: int) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col1 (type: int) |
| Statistics: Num rows: 2 Data size: 16 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col0 (type: boolean) |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT c1 FROM t1_n145 group by c1 having c1 NOT IN (SELECT c1 FROM t2_n85 where t1_n145.c1=t2_n85.c1) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@t1_n145 |
| PREHOOK: Input: default@t2_n85 |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT c1 FROM t1_n145 group by c1 having c1 NOT IN (SELECT c1 FROM t2_n85 where t1_n145.c1=t2_n85.c1) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@t1_n145 |
| POSTHOOK: Input: default@t2_n85 |
| #### A masked pattern was here #### |
| 1 |
| NULL |
| PREHOOK: query: DROP TABLE t1_n145 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@t1_n145 |
| PREHOOK: Output: default@t1_n145 |
| POSTHOOK: query: DROP TABLE t1_n145 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@t1_n145 |
| POSTHOOK: Output: default@t1_n145 |
| PREHOOK: query: DROP TABLE t2_n85 |
| PREHOOK: type: DROPTABLE |
| PREHOOK: Input: default@t2_n85 |
| PREHOOK: Output: default@t2_n85 |
| POSTHOOK: query: DROP TABLE t2_n85 |
| POSTHOOK: type: DROPTABLE |
| POSTHOOK: Input: default@t2_n85 |
| POSTHOOK: Output: default@t2_n85 |