"+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+ | Explain | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+ | STAGE DEPENDENCIES: | | Stage-1 is a root stage | | Stage-2 depends on stages: Stage-1 | | Stage-0 depends on stages: Stage-2 | | | | STAGE PLANS: | | Stage: Stage-1 | | Map Reduce | | Map Operator Tree: | | TableScan | | alias: odl_cal_event_pq | | filterExpr: ((rd = '2016-03-08') and (url like '%womenreward%')) (type: boolean) | | Statistics: Num rows: 237016132 Data size: 9717661412 Basic stats: COMPLETE Column stats: NONE | | Filter Operator | | predicate: (url like '%womenreward%') (type: boolean) | | Statistics: Num rows: 118508066 Data size: 4858830706 Basic stats: COMPLETE Column stats: NONE | | Select Operator | | expressions: CASE WHEN ((url like '%womenreward')) THEN ('PC') WHEN ((url like '%womenreward2')) THEN ('APP') WHEN ((url like '%womenreward3')) THEN ('H5') END (type: string), if user_id_post is null returnsguid_post (type: string) | | outputColumnNames: _col1, _col2 | | Statistics: Num rows: 118508066 Data size: 4858830706 Basic stats: COMPLETE Column stats: NONE | | Filter Operator | | predicate: (_col1) IN ('PC', 'APP', 'H5') (type: boolean) | | Statistics: Num rows: 59254033 Data size: 2429415353 Basic stats: COMPLETE Column stats: NONE | | Select Operator | | expressions: '2016-03-08' (type: string), _col1 (type: string), _col2 (type: string) | | outputColumnNames: _col0, _col1, _col2 | | Statistics: Num rows: 59254033 Data size: 2429415353 Basic stats: COMPLETE Column stats: NONE | | Group By Operator | | keys: _col0 (type: string), _col1 (type: string), _col2 (type: string) | | mode: hash | | outputColumnNames: _col0, _col1, _col2 | | Statistics: Num rows: 59254033 Data size: 2429415353 Basic stats: COMPLETE Column stats: NONE | | Reduce Output Operator | | key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string) | | sort order: +++ | | Map-reduce partition columns: _col0 (type: string), _col1 (type: string), _col2 (type: string) | | Statistics: Num rows: 59254033 Data size: 2429415353 Basic stats: COMPLETE Column stats: NONE | | Reduce Operator Tree: | | Group By Operator | | keys: KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: string) | | mode: mergepartial | | outputColumnNames: _col0, _col1, _col2 | | Statistics: Num rows: 29627016 Data size: 1214707656 Basic stats: COMPLETE Column stats: NONE | | Select Operator | | expressions: _col0 (type: string), _col1 (type: string) | | outputColumnNames: _col0, _col1 | | Statistics: Num rows: 29627016 Data size: 1214707656 Basic stats: COMPLETE Column stats: NONE | | File Output Operator | | compressed: true | | table: | | input format: org.apache.hadoop.mapred.SequenceFileInputFormat | | output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat | | serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe | | | | Stage: Stage-2 | | Map Reduce | | Map Operator Tree: | | TableScan | | Reduce Output Operator | | key expressions: _col0 (type: string), _col1 (type: string) | | sort order: ++ | | Map-reduce partition columns: _col0 (type: string), _col1 (type: string) | | Statistics: Num rows: 29627016 Data size: 1214707656 Basic stats: COMPLETE Column stats: NONE | | value expressions: _col1 (type: string) | | Reduce Operator Tree: | | Select Operator | | expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string) | | outputColumnNames: _col0, _col1 | | Statistics: Num rows: 29627016 Data size: 1214707656 Basic stats: COMPLETE Column stats: NONE | | Group By Operator | | aggregations: count() | | keys: _col0 (type: string), _col1 (type: string) | | mode: complete | | outputColumnNames: _col0, _col1, _col2 | | Statistics: Num rows: 14813508 Data size: 607353828 Basic stats: COMPLETE Column stats: NONE | | Select Operator | | expressions: _col0 (type: string), _col1 (type: string), null (type: void), _col2 (type: bigint) | | outputColumnNames: _col0, _col1, _col2, _col3 | | Statistics: Num rows: 14813508 Data size: 607353828 Basic stats: COMPLETE Column stats: NONE | | File Output Operator | | compressed: false | | Statistics: Num rows: 14813508 Data size: 607353828 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 | | | | Stage: Stage-0 | | Fetch Operator | | limit: -1 | | Processor Tree: | | ListSink | | | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+"