| PREHOOK: query: CREATE VIEW V1_n8 AS SELECT key, value from src |
| PREHOOK: type: CREATEVIEW |
| PREHOOK: Input: default@src |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@V1_n8 |
| POSTHOOK: query: CREATE VIEW V1_n8 AS SELECT key, value from src |
| POSTHOOK: type: CREATEVIEW |
| POSTHOOK: Input: default@src |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@V1_n8 |
| POSTHOOK: Lineage: V1_n8.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: V1_n8.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: CREATE VIEW V2_n3 AS SELECT ds, key, value FROM srcpart WHERE ds IS NOT NULL |
| PREHOOK: type: CREATEVIEW |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@V2_n3 |
| POSTHOOK: query: CREATE VIEW V2_n3 AS SELECT ds, key, value FROM srcpart WHERE ds IS NOT NULL |
| POSTHOOK: type: CREATEVIEW |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@V2_n3 |
| POSTHOOK: Lineage: V2_n3.ds SIMPLE [(srcpart)srcpart.FieldSchema(name:ds, type:string, comment:null), ] |
| POSTHOOK: Lineage: V2_n3.key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: V2_n3.value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: CREATE VIEW V3_n1 AS |
| SELECT src1.key, src2.value FROM V2_n3 src1 |
| JOIN src src2 ON src1.key = src2.key WHERE src1.ds IS NOT NULL |
| PREHOOK: type: CREATEVIEW |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Input: default@v2_n3 |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@V3_n1 |
| POSTHOOK: query: CREATE VIEW V3_n1 AS |
| SELECT src1.key, src2.value FROM V2_n3 src1 |
| JOIN src src2 ON src1.key = src2.key WHERE src1.ds IS NOT NULL |
| POSTHOOK: type: CREATEVIEW |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Input: default@v2_n3 |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@V3_n1 |
| POSTHOOK: Lineage: V3_n1.key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: V3_n1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: CREATE VIEW V4_n1 AS |
| SELECT src1.key, src2.value as value1, src3.value as value2 |
| FROM V1_n8 src1 JOIN V2_n3 src2 on src1.key = src2.key JOIN src src3 ON src2.key = src3.key |
| PREHOOK: type: CREATEVIEW |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Input: default@v1_n8 |
| PREHOOK: Input: default@v2_n3 |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@V4_n1 |
| POSTHOOK: query: CREATE VIEW V4_n1 AS |
| SELECT src1.key, src2.value as value1, src3.value as value2 |
| FROM V1_n8 src1 JOIN V2_n3 src2 on src1.key = src2.key JOIN src src3 ON src2.key = src3.key |
| POSTHOOK: type: CREATEVIEW |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Input: default@v1_n8 |
| POSTHOOK: Input: default@v2_n3 |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@V4_n1 |
| POSTHOOK: Lineage: V4_n1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: V4_n1.value1 SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] |
| POSTHOOK: Lineage: V4_n1.value2 SIMPLE [(src)src3.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: EXPLAIN LOGICAL |
| SELECT key, count(1) FROM srcpart WHERE ds IS NOT NULL GROUP BY key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@srcpart |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN LOGICAL |
| SELECT key, count(1) FROM srcpart WHERE ds IS NOT NULL GROUP BY key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@srcpart |
| #### A masked pattern was here #### |
| LOGICAL PLAN: |
| srcpart |
| TableScan (TS_0) |
| alias: srcpart |
| filterExpr: ds is not null (type: boolean) |
| Select Operator (SEL_2) |
| expressions: key (type: string) |
| outputColumnNames: key |
| Group By Operator (GBY_3) |
| aggregations: count() |
| keys: key (type: string) |
| minReductionHashAggr: 0.99 |
| mode: hash |
| outputColumnNames: _col0, _col1 |
| Reduce Output Operator (RS_4) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| value expressions: _col1 (type: bigint) |
| Group By Operator (GBY_5) |
| aggregations: count(VALUE._col0) |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1 |
| File Output Operator (FS_7) |
| compressed: false |
| 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 |
| |
| PREHOOK: query: EXPLAIN LOGICAL |
| SELECT key, count(1) FROM (SELECT key, value FROM src) subq1 GROUP BY key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN LOGICAL |
| SELECT key, count(1) FROM (SELECT key, value FROM src) subq1 GROUP BY key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| LOGICAL PLAN: |
| src |
| TableScan (TS_0) |
| alias: src |
| Select Operator (SEL_1) |
| expressions: key (type: string) |
| outputColumnNames: key |
| Group By Operator (GBY_2) |
| aggregations: count() |
| keys: key (type: string) |
| minReductionHashAggr: 0.99 |
| mode: hash |
| outputColumnNames: _col0, _col1 |
| Reduce Output Operator (RS_3) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| value expressions: _col1 (type: bigint) |
| Group By Operator (GBY_4) |
| aggregations: count(VALUE._col0) |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1 |
| File Output Operator (FS_6) |
| compressed: false |
| 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 |
| |
| PREHOOK: query: EXPLAIN LOGICAL |
| SELECT * FROM ( |
| SELECT key, value FROM src UNION ALL SELECT key, value FROM srcpart WHERE ds IS NOT NULL |
| ) S1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@srcpart |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN LOGICAL |
| SELECT * FROM ( |
| SELECT key, value FROM src UNION ALL SELECT key, value FROM srcpart WHERE ds IS NOT NULL |
| ) S1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@srcpart |
| #### A masked pattern was here #### |
| LOGICAL PLAN: |
| $hdt$_0-subquery1:src |
| TableScan (TS_0) |
| alias: src |
| Select Operator (SEL_1) |
| expressions: key (type: string), value (type: string) |
| outputColumnNames: _col0, _col1 |
| Union (UNION_5) |
| File Output Operator (FS_7) |
| compressed: false |
| 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 |
| $hdt$_0-subquery2:srcpart |
| TableScan (TS_2) |
| alias: srcpart |
| filterExpr: ds is not null (type: boolean) |
| Select Operator (SEL_4) |
| expressions: key (type: string), value (type: string) |
| outputColumnNames: _col0, _col1 |
| Union (UNION_5) |
| |
| PREHOOK: query: EXPLAIN LOGICAL |
| SELECT S1.key, S2.value FROM src S1 JOIN srcpart S2 ON S1.key = S2.key WHERE ds IS NOT NULL |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@srcpart |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN LOGICAL |
| SELECT S1.key, S2.value FROM src S1 JOIN srcpart S2 ON S1.key = S2.key WHERE ds IS NOT NULL |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@srcpart |
| #### A masked pattern was here #### |
| LOGICAL PLAN: |
| $hdt$_0:s1 |
| TableScan (TS_0) |
| alias: s1 |
| filterExpr: (key is not null and (key) IN (RS[7])) (type: boolean) |
| Filter Operator (FIL_13) |
| predicate: (key is not null and (key) IN (RS[7])) (type: boolean) |
| Select Operator (SEL_2) |
| expressions: key (type: string) |
| outputColumnNames: _col0 |
| Reduce Output Operator (RS_6) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Join Operator (JOIN_8) |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col2 |
| Select Operator (SEL_9) |
| expressions: _col0 (type: string), _col2 (type: string) |
| outputColumnNames: _col0, _col1 |
| File Output Operator (FS_10) |
| compressed: false |
| 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 |
| $hdt$_1:s2 |
| TableScan (TS_3) |
| alias: s2 |
| filterExpr: (key is not null and (key) IN (RS[6])) (type: boolean) |
| Filter Operator (FIL_14) |
| predicate: (key is not null and (key) IN (RS[6])) (type: boolean) |
| Select Operator (SEL_5) |
| expressions: key (type: string), value (type: string) |
| outputColumnNames: _col0, _col1 |
| Reduce Output Operator (RS_7) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| value expressions: _col1 (type: string) |
| Join Operator (JOIN_8) |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col2 |
| |
| PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V1_n8 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@v1_n8 |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V1_n8 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@v1_n8 |
| #### A masked pattern was here #### |
| LOGICAL PLAN: |
| src |
| TableScan (TS_0) |
| alias: src |
| properties: |
| insideView TRUE |
| Select Operator (SEL_1) |
| expressions: key (type: string), value (type: string) |
| outputColumnNames: _col0, _col1 |
| ListSink (LIST_SINK_3) |
| |
| PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V2_n3 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 |
| PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 |
| PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 |
| PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 |
| PREHOOK: Input: default@v2_n3 |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V2_n3 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 |
| POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 |
| POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 |
| POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 |
| POSTHOOK: Input: default@v2_n3 |
| #### A masked pattern was here #### |
| LOGICAL PLAN: |
| srcpart |
| TableScan (TS_0) |
| alias: srcpart |
| filterExpr: ds is not null (type: boolean) |
| properties: |
| insideView TRUE |
| Select Operator (SEL_2) |
| expressions: ds (type: string), key (type: string), value (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| ListSink (LIST_SINK_5) |
| |
| PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V3_n1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Input: default@v2_n3 |
| PREHOOK: Input: default@v3_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V3_n1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Input: default@v2_n3 |
| POSTHOOK: Input: default@v3_n1 |
| #### A masked pattern was here #### |
| LOGICAL PLAN: |
| $hdt$_0:srcpart |
| TableScan (TS_0) |
| alias: srcpart |
| filterExpr: (key is not null and (key) IN (RS[7])) (type: boolean) |
| properties: |
| insideView TRUE |
| Filter Operator (FIL_13) |
| predicate: (key is not null and (key) IN (RS[7])) (type: boolean) |
| Select Operator (SEL_2) |
| expressions: key (type: string) |
| outputColumnNames: _col0 |
| Reduce Output Operator (RS_6) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Join Operator (JOIN_8) |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col2 |
| Select Operator (SEL_9) |
| expressions: _col0 (type: string), _col2 (type: string) |
| outputColumnNames: _col0, _col1 |
| File Output Operator (FS_10) |
| compressed: false |
| 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 |
| $hdt$_1:src2 |
| TableScan (TS_3) |
| alias: src2 |
| filterExpr: (key is not null and (key) IN (RS[6])) (type: boolean) |
| properties: |
| insideView TRUE |
| Filter Operator (FIL_14) |
| predicate: (key is not null and (key) IN (RS[6])) (type: boolean) |
| Select Operator (SEL_5) |
| expressions: key (type: string), value (type: string) |
| outputColumnNames: _col0, _col1 |
| Reduce Output Operator (RS_7) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| value expressions: _col1 (type: string) |
| Join Operator (JOIN_8) |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col2 |
| |
| PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V4_n1 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Input: default@v1_n8 |
| PREHOOK: Input: default@v2_n3 |
| PREHOOK: Input: default@v4_n1 |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V4_n1 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Input: default@v1_n8 |
| POSTHOOK: Input: default@v2_n3 |
| POSTHOOK: Input: default@v4_n1 |
| #### A masked pattern was here #### |
| LOGICAL PLAN: |
| $hdt$_0:srcpart |
| TableScan (TS_0) |
| alias: srcpart |
| filterExpr: (key is not null and (key) IN (RS[10]) and (key) IN (RS[13])) (type: boolean) |
| properties: |
| insideView TRUE |
| Filter Operator (FIL_22) |
| predicate: (key is not null and (key) IN (RS[10]) and (key) IN (RS[13])) (type: boolean) |
| Select Operator (SEL_2) |
| expressions: key (type: string), value (type: string) |
| outputColumnNames: _col0, _col1 |
| Reduce Output Operator (RS_9) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| value expressions: _col1 (type: string) |
| Join Operator (JOIN_11) |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| Reduce Output Operator (RS_12) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| value expressions: _col1 (type: string), _col2 (type: string) |
| Join Operator (JOIN_14) |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col1, _col2, _col4 |
| Select Operator (SEL_15) |
| expressions: _col2 (type: string), _col1 (type: string), _col4 (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| File Output Operator (FS_16) |
| compressed: false |
| 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 |
| $hdt$_1:src |
| TableScan (TS_3) |
| alias: src |
| filterExpr: (key is not null and (key) IN (RS[9]) and (key) IN (RS[13])) (type: boolean) |
| properties: |
| insideView TRUE |
| Filter Operator (FIL_23) |
| predicate: (key is not null and (key) IN (RS[9]) and (key) IN (RS[13])) (type: boolean) |
| Select Operator (SEL_5) |
| expressions: key (type: string) |
| outputColumnNames: _col0 |
| Reduce Output Operator (RS_10) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| Join Operator (JOIN_11) |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| $hdt$_2:src3 |
| TableScan (TS_6) |
| alias: src3 |
| filterExpr: (key is not null and (key) IN (RS[12]) and (key) IN (RS[9]) and (key) IN (RS[10])) (type: boolean) |
| properties: |
| insideView TRUE |
| Filter Operator (FIL_24) |
| predicate: (key is not null and (key) IN (RS[12]) and (key) IN (RS[9]) and (key) IN (RS[10])) (type: boolean) |
| Select Operator (SEL_8) |
| expressions: key (type: string), value (type: string) |
| outputColumnNames: _col0, _col1 |
| Reduce Output Operator (RS_13) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| value expressions: _col1 (type: string) |
| Join Operator (JOIN_14) |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col1, _col2, _col4 |
| |
| PREHOOK: query: CREATE VIEW V5_n0 as SELECT * FROM srcpart where ds = '10' |
| PREHOOK: type: CREATEVIEW |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Output: database:default |
| PREHOOK: Output: default@V5_n0 |
| POSTHOOK: query: CREATE VIEW V5_n0 as SELECT * FROM srcpart where ds = '10' |
| POSTHOOK: type: CREATEVIEW |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Output: database:default |
| POSTHOOK: Output: default@V5_n0 |
| POSTHOOK: Lineage: V5_n0.ds SIMPLE [] |
| POSTHOOK: Lineage: V5_n0.hr SIMPLE [(srcpart)srcpart.FieldSchema(name:hr, type:string, comment:null), ] |
| POSTHOOK: Lineage: V5_n0.key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] |
| POSTHOOK: Lineage: V5_n0.value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] |
| PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V5_n0 |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@srcpart |
| PREHOOK: Input: default@v5_n0 |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN LOGICAL SELECT * FROM V5_n0 |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@srcpart |
| POSTHOOK: Input: default@v5_n0 |
| #### A masked pattern was here #### |
| LOGICAL PLAN: |
| srcpart |
| TableScan (TS_0) |
| alias: srcpart |
| filterExpr: (ds = '10') (type: boolean) |
| properties: |
| insideView TRUE |
| Filter Operator (FIL_4) |
| predicate: (ds = '10') (type: boolean) |
| Select Operator (SEL_2) |
| expressions: key (type: string), value (type: string), '10' (type: string), hr (type: string) |
| outputColumnNames: _col0, _col1, _col2, _col3 |
| ListSink (LIST_SINK_5) |
| |
| PREHOOK: query: EXPLAIN LOGICAL SELECT s1.key, s1.cnt, s2.value FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src s2 ON (s1.key = s2.key) ORDER BY s1.key |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@src |
| #### A masked pattern was here #### |
| POSTHOOK: query: EXPLAIN LOGICAL SELECT s1.key, s1.cnt, s2.value FROM (SELECT key, count(value) as cnt FROM src GROUP BY key) s1 JOIN src s2 ON (s1.key = s2.key) ORDER BY s1.key |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@src |
| #### A masked pattern was here #### |
| LOGICAL PLAN: |
| $hdt$_0:src |
| TableScan (TS_0) |
| alias: src |
| filterExpr: (key is not null and (key) IN (RS[11])) (type: boolean) |
| Filter Operator (FIL_19) |
| predicate: (key is not null and (key) IN (RS[11])) (type: boolean) |
| Group By Operator (GBY_3) |
| aggregations: count(value) |
| keys: key (type: string) |
| minReductionHashAggr: 0.99 |
| mode: hash |
| outputColumnNames: _col0, _col1 |
| Reduce Output Operator (RS_4) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| value expressions: _col1 (type: bigint) |
| Group By Operator (GBY_5) |
| aggregations: count(VALUE._col0) |
| keys: KEY._col0 (type: string) |
| mode: mergepartial |
| outputColumnNames: _col0, _col1 |
| Reduce Output Operator (RS_10) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| value expressions: _col1 (type: bigint) |
| Join Operator (JOIN_12) |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col1, _col3 |
| Select Operator (SEL_13) |
| expressions: _col0 (type: string), _col1 (type: bigint), _col3 (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| Reduce Output Operator (RS_14) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| value expressions: _col1 (type: bigint), _col2 (type: string) |
| Select Operator (SEL_15) |
| expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: bigint), VALUE._col1 (type: string) |
| outputColumnNames: _col0, _col1, _col2 |
| File Output Operator (FS_16) |
| compressed: false |
| 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 |
| $hdt$_1:s2 |
| TableScan (TS_7) |
| alias: s2 |
| filterExpr: (key is not null and (key) IN (RS[10])) (type: boolean) |
| Filter Operator (FIL_20) |
| predicate: (key is not null and (key) IN (RS[10])) (type: boolean) |
| Select Operator (SEL_9) |
| expressions: key (type: string), value (type: string) |
| outputColumnNames: _col0, _col1 |
| Reduce Output Operator (RS_11) |
| key expressions: _col0 (type: string) |
| null sort order: z |
| sort order: + |
| Map-reduce partition columns: _col0 (type: string) |
| value expressions: _col1 (type: string) |
| Join Operator (JOIN_12) |
| condition map: |
| Inner Join 0 to 1 |
| keys: |
| 0 _col0 (type: string) |
| 1 _col0 (type: string) |
| outputColumnNames: _col0, _col1, _col3 |
| |