Plan optimized by CBO. Vertex dependency in root stage Map 1 <- Map 4 (BROADCAST_EDGE) Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE), Map 5 (CUSTOM_SIMPLE_EDGE) Reducer 3 <- Reducer 2 (SIMPLE_EDGE) Stage-0 Fetch Operator limit:-1 Stage-1 Reducer 3 vectorized, llap File Output Operator [FS_67] compressed:false Statistics:Num rows: 48 Data size: 9696 Basic stats: COMPLETE Column stats: COMPLETE 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"} Select Operator [OP_66] outputColumnNames:["_col0","_col1","_col2","_col3"] Statistics:Num rows: 48 Data size: 9696 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator [OP_65] | aggregations:["sum(VALUE._col0)"] | keys:KEY._col0 (type: string), KEY._col1 (type: int) | outputColumnNames:["_col0","_col1","_col2"] | Statistics:Num rows: 48 Data size: 5184 Basic stats: COMPLETE Column stats: COMPLETE |<-Reducer 2 [SIMPLE_EDGE] vectorized, llap Reduce Output Operator [RS_24] key expressions:_col0 (type: string), _col1 (type: int) Map-reduce partition columns:_col0 (type: string), _col1 (type: int) sort order:++ Statistics:Num rows: 1440 Data size: 155520 Basic stats: COMPLETE Column stats: COMPLETE value expressions:_col2 (type: double) Group By Operator [OP_64] aggregations:["sum(_col2)"] keys:_col0 (type: string), _col1 (type: int) outputColumnNames:["_col0","_col1","_col2"] Statistics:Num rows: 1440 Data size: 155520 Basic stats: COMPLETE Column stats: COMPLETE Select Operator [OP_63] outputColumnNames:["_col0","_col1","_col2"] Statistics:Num rows: 47777647 Data size: 7453312932 Basic stats: COMPLETE Column stats: COMPLETE Map Join Operator [MAPJOIN_62] | condition map:[{"":"Inner Join 0 to 1"}] | keys:{"Reducer 2":"KEY.reducesinkkey0 (type: bigint), KEY.reducesinkkey1 (type: int), KEY.reducesinkkey2 (type: int)","Map 5":"KEY.reducesinkkey0 (type: bigint), KEY.reducesinkkey1 (type: int), KEY.reducesinkkey2 (type: int)"} | outputColumnNames:["_col1","_col3","_col5"] | Statistics:Num rows: 47777647 Data size: 7453312932 Basic stats: COMPLETE Column stats: COMPLETE |<-Map 5 [CUSTOM_SIMPLE_EDGE] vectorized, llap | Reduce Output Operator [RS_61] | key expressions:_col1 (type: bigint), year(_col2) (type: int), month(_col2) (type: int) | Map-reduce partition columns:_col1 (type: bigint), year(_col2) (type: int), month(_col2) (type: int) | sort order:+++ | Statistics:Num rows: 61362604 Data size: 4172657072 Basic stats: COMPLETE Column stats: COMPLETE | value expressions:_col0 (type: float), _col2 (type: date) | Select Operator [OP_60] | outputColumnNames:["_col0","_col1","_col2"] | Statistics:Num rows: 61362604 Data size: 4172657072 Basic stats: COMPLETE Column stats: COMPLETE | Filter Operator [FIL_59] | predicate:((a_id is not null and month(e_date) BETWEEN 4 AND 7) and month(e_date) is not null) (type: boolean) | Statistics:Num rows: 61362604 Data size: 4172657072 Basic stats: COMPLETE Column stats: COMPLETE | TableScan [TS_6] | alias:t | Statistics:Num rows: 122725209 Data size: 8345314212 Basic stats: COMPLETE Column stats: COMPLETE |<-Map 1 [CUSTOM_SIMPLE_EDGE] vectorized, llap Reduce Output Operator [RS_58] key expressions:_col0 (type: bigint), year(_col2) (type: int), month(_col2) (type: int) Map-reduce partition columns:_col0 (type: bigint), year(_col2) (type: int), month(_col2) (type: int) sort order:+++ Statistics:Num rows: 50289673 Data size: 8046347680 Basic stats: COMPLETE Column stats: COMPLETE value expressions:_col1 (type: string) Map Join Operator [MAPJOIN_57] | condition map:[{"":"Left Semi Join 0 to 1"}] | keys:{"Map 1":"_col1 (type: string)","Map 4":"_col0 (type: string)"} | outputColumnNames:["_col0","_col1","_col2"] | Statistics:Num rows: 50289673 Data size: 8046347680 Basic stats: COMPLETE Column stats: COMPLETE |<-Map 4 [BROADCAST_EDGE] vectorized, llap | Reduce Output Operator [RS_14] | key expressions:_col0 (type: string) | Map-reduce partition columns:_col0 (type: string) | sort order:+ | Statistics:Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE | Group By Operator [OP_54] | keys:_col0 (type: string) | outputColumnNames:["_col0"] | Statistics:Num rows: 1 Data size: 96 Basic stats: COMPLETE Column stats: COMPLETE | Select Operator [OP_53] | outputColumnNames:["_col0"] | Statistics:Num rows: 3 Data size: 288 Basic stats: COMPLETE Column stats: COMPLETE | Filter Operator [FIL_52] | predicate:(account_type = 'l a') (type: boolean) | Statistics:Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats: COMPLETE | TableScan [TS_3] | alias:at | Statistics:Num rows: 13 Data size: 1274 Basic stats: COMPLETE Column stats: COMPLETE |<-Select Operator [OP_56] outputColumnNames:["_col0","_col1","_col2"] Statistics:Num rows: 50289673 Data size: 8046347680 Basic stats: COMPLETE Column stats: COMPLETE Filter Operator [FIL_55] predicate:(((a_id is not null and (account_type = 'l a')) and year(e_date) is not null) and month(e_date) is not null) (type: boolean) Statistics:Num rows: 50289673 Data size: 8197216699 Basic stats: COMPLETE Column stats: COMPLETE TableScan [TS_0] alias:a Statistics:Num rows: 201158695 Data size: 32788867285 Basic stats: COMPLETE Column stats: COMPLETE