| PREHOOK: query: EXPLAIN |
| SELECT src1.c1, src2.c4 |
| FROM |
| (SELECT src.key as c1, src.value as c2 from src) src1 |
| JOIN |
| (SELECT src.key as c3, src.value as c4 from src) src2 |
| ON src1.c1 = src2.c3 AND src1.c1 < 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN |
| SELECT src1.c1, src2.c4 |
| FROM |
| (SELECT src.key as c1, src.value as c2 from src) src1 |
| JOIN |
| (SELECT src.key as c3, src.value as c4 from src) src2 |
| ON src1.c1 = src2.c3 AND src1.c1 < 100 |
| 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 3 (SIMPLE_EDGE) |
| #### A masked pattern was here #### |
| Vertices: |
| Map 1 |
| Map Operator Tree: |
| TableScan |
| alias: src |
| filterExpr: (UDFToDouble(key) < 100.0D) (type: boolean) |
| Statistics: Num rows: 500 Data size: 43500 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (UDFToDouble(key) < 100.0D) (type: boolean) |
| Statistics: Num rows: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: string) |
| outputColumnNames: _col0 |
| Statistics: Num rows: 166 Data size: 14442 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: 166 Data size: 14442 Basic stats: COMPLETE Column stats: COMPLETE |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Map 3 |
| Map Operator Tree: |
| TableScan |
| alias: src |
| filterExpr: (UDFToDouble(key) < 100.0D) (type: boolean) |
| Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE |
| Filter Operator |
| predicate: (UDFToDouble(key) < 100.0D) (type: boolean) |
| Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: key (type: string), value (type: string) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 166 Data size: 29548 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: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE |
| value expressions: _col1 (type: string) |
| Execution mode: vectorized, llap |
| LLAP IO: all inputs |
| Reducer 2 |
| Execution mode: llap |
| Reduce Operator Tree: |
| Merge Join Operator |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col2 |
| Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE |
| Select Operator |
| expressions: _col0 (type: string), _col2 (type: string) |
| outputColumnNames: _col0, _col1 |
| Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE |
| File Output Operator |
| compressed: false |
| Statistics: Num rows: 166 Data size: 29548 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 |
| |
| Stage: Stage-0 |
| Fetch Operator |
| limit: -1 |
| Processor Tree: |
| ListSink |
| |
| PREHOOK: query: SELECT src1.c1, src2.c4 |
| FROM |
| (SELECT src.key as c1, src.value as c2 from src) src1 |
| JOIN |
| (SELECT src.key as c3, src.value as c4 from src) src2 |
| ON src1.c1 = src2.c3 AND src1.c1 < 100 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: SELECT src1.c1, src2.c4 |
| FROM |
| (SELECT src.key as c1, src.value as c2 from src) src1 |
| JOIN |
| (SELECT src.key as c3, src.value as c4 from src) src2 |
| ON src1.c1 = src2.c3 AND src1.c1 < 100 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| 0 val_0 |
| 0 val_0 |
| 0 val_0 |
| 0 val_0 |
| 0 val_0 |
| 0 val_0 |
| 0 val_0 |
| 0 val_0 |
| 0 val_0 |
| 10 val_10 |
| 11 val_11 |
| 12 val_12 |
| 12 val_12 |
| 12 val_12 |
| 12 val_12 |
| 15 val_15 |
| 15 val_15 |
| 15 val_15 |
| 15 val_15 |
| 17 val_17 |
| 18 val_18 |
| 18 val_18 |
| 18 val_18 |
| 18 val_18 |
| 19 val_19 |
| 2 val_2 |
| 20 val_20 |
| 24 val_24 |
| 24 val_24 |
| 24 val_24 |
| 24 val_24 |
| 26 val_26 |
| 26 val_26 |
| 26 val_26 |
| 26 val_26 |
| 27 val_27 |
| 28 val_28 |
| 30 val_30 |
| 33 val_33 |
| 34 val_34 |
| 35 val_35 |
| 35 val_35 |
| 35 val_35 |
| 35 val_35 |
| 35 val_35 |
| 35 val_35 |
| 35 val_35 |
| 35 val_35 |
| 35 val_35 |
| 37 val_37 |
| 37 val_37 |
| 37 val_37 |
| 37 val_37 |
| 4 val_4 |
| 41 val_41 |
| 42 val_42 |
| 42 val_42 |
| 42 val_42 |
| 42 val_42 |
| 43 val_43 |
| 44 val_44 |
| 47 val_47 |
| 5 val_5 |
| 5 val_5 |
| 5 val_5 |
| 5 val_5 |
| 5 val_5 |
| 5 val_5 |
| 5 val_5 |
| 5 val_5 |
| 5 val_5 |
| 51 val_51 |
| 51 val_51 |
| 51 val_51 |
| 51 val_51 |
| 53 val_53 |
| 54 val_54 |
| 57 val_57 |
| 58 val_58 |
| 58 val_58 |
| 58 val_58 |
| 58 val_58 |
| 64 val_64 |
| 65 val_65 |
| 66 val_66 |
| 67 val_67 |
| 67 val_67 |
| 67 val_67 |
| 67 val_67 |
| 69 val_69 |
| 70 val_70 |
| 70 val_70 |
| 70 val_70 |
| 70 val_70 |
| 70 val_70 |
| 70 val_70 |
| 70 val_70 |
| 70 val_70 |
| 70 val_70 |
| 72 val_72 |
| 72 val_72 |
| 72 val_72 |
| 72 val_72 |
| 74 val_74 |
| 76 val_76 |
| 76 val_76 |
| 76 val_76 |
| 76 val_76 |
| 77 val_77 |
| 78 val_78 |
| 8 val_8 |
| 80 val_80 |
| 82 val_82 |
| 83 val_83 |
| 83 val_83 |
| 83 val_83 |
| 83 val_83 |
| 84 val_84 |
| 84 val_84 |
| 84 val_84 |
| 84 val_84 |
| 85 val_85 |
| 86 val_86 |
| 87 val_87 |
| 9 val_9 |
| 90 val_90 |
| 90 val_90 |
| 90 val_90 |
| 90 val_90 |
| 90 val_90 |
| 90 val_90 |
| 90 val_90 |
| 90 val_90 |
| 90 val_90 |
| 92 val_92 |
| 95 val_95 |
| 95 val_95 |
| 95 val_95 |
| 95 val_95 |
| 96 val_96 |
| 97 val_97 |
| 97 val_97 |
| 97 val_97 |
| 97 val_97 |
| 98 val_98 |
| 98 val_98 |
| 98 val_98 |
| 98 val_98 |
