STAGE DEPENDENCIES: Stage-7 is a root stage Stage-2 depends on stages: Stage-7 Stage-0 is a root stage STAGE PLANS: Stage: Stage-7 Map Reduce Local Work Alias -> Map Local Tables: null-subquery1-subquery1:sq-subquery1-subquery1:tmp_test1 Fetch Operator limit: -1 null-subquery1-subquery2:sq-subquery1-subquery2:tmp_test2 Fetch Operator limit: -1 null-subquery2:sq-subquery2:tmp_test3 Fetch Operator limit: -1 Alias -> Map Local Operator Tree: null-subquery1-subquery1:sq-subquery1-subquery1:tmp_test1 TableScan alias: tmp_test1 Statistics: Num rows: 0 Data size: 36 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: col1 (type: string), null (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 36 Basic stats: PARTIAL Column stats: NONE Union Statistics: Num rows: 0 Data size: 136 Basic stats: PARTIAL Column stats: NONE HashTable Sink Operator condition expressions: 0 {_col0} {_col1} 1 keys: 0 _col0 (type: string) 1 col1 (type: string) null-subquery1-subquery2:sq-subquery1-subquery2:tmp_test2 TableScan alias: tmp_test2 Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: col1 (type: string), null (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE Union Statistics: Num rows: 0 Data size: 136 Basic stats: PARTIAL Column stats: NONE HashTable Sink Operator condition expressions: 0 {_col0} {_col1} 1 keys: 0 _col0 (type: string) 1 col1 (type: string) null-subquery2:sq-subquery2:tmp_test3 TableScan alias: tmp_test3 Statistics: Num rows: 0 Data size: 70 Basic stats: PARTIAL Column stats: NONE Select Operator expressions: col1 (type: string), col2 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 70 Basic stats: PARTIAL Column stats: NONE Union Statistics: Num rows: 0 Data size: 136 Basic stats: PARTIAL Column stats: NONE HashTable Sink Operator condition expressions: 0 {_col0} {_col1} 1 keys: 0 _col0 (type: string) 1 col1 (type: string) Stage: Stage-2 Map Reduce Map Operator Tree: TableScan alias: ta Statistics: Num rows: 266704 Data size: 26670420 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Inner Join 0 to 1 condition expressions: 0 {_col0} {_col1} 1 keys: 0 _col0 (type: string) 1 col1 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 293374 Data size: 29337462 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col1 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 293374 Data size: 29337462 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(DISTINCT _col1) keys: _col0 (type: string), _col1 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 293374 Data size: 29337462 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 293374 Data size: 29337462 Basic stats: COMPLETE Column stats: NONE Local Work: Map Reduce Local Work Reduce Operator Tree: Group By Operator aggregations: count(DISTINCT KEY._col1:0._col0) keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 Statistics: Num rows: 146687 Data size: 14668731 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string), _col1 (type: bigint) outputColumnNames: _col0, _col1 Statistics: Num rows: 146687 Data size: 14668731 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: true Statistics: Num rows: 146687 Data size: 14668731 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