*************************** 1. row ***************************
id: Projection_5
estRows: 59701612.67
task: root
access object:
operator info: stat.st_broker_dealer_user_month_summary.ch_broker_id, stat.st_broker_dealer_user_month_summary.ch_dealer_id, stat.st_broker_dealer_user_month_summary.i_user_id, Column#22, Column#23, ifnull(Column#24, 0)->Column#27, ifnull(Column#25, 0)->Column#28, ifnull(round(div(Column#24, Column#25), 0), 0)->Column#29, Column#26, ifnull(round(div(Column#24, cast(Column#26, decimal(20,0) BINARY)), 0), 0)->Column#30, stat.st_broker_dealer_user_month_summary.ch_gender, stat.st_broker_dealer_user_month_summary.d_birthday, stat.st_broker_dealer_user_month_summary.i_is_china_id_card, stat.st_broker_dealer_user_month_summary.ch_region_code, stat.st_broker_dealer_user_month_summary.ch_province_code, stat.st_broker_dealer_user_month_summary.ch_city_code, stat.st_broker_dealer_user_month_summary.ch_county_code, stat.st_broker_dealer_user_month_summary.i_broker_type
*************************** 2. row ***************************
id: └─TableReader_34
estRows: 59701612.67
task: root
access object:
operator info: data:ExchangeSender_33
*************************** 3. row ***************************
id: └─ExchangeSender_33
estRows: 59701612.67
task: batchCop[tiflash]
access object:
operator info: ExchangeType: PassThrough
*************************** 4. row ***************************
id: └─Projection_29
estRows: 59701612.67
task: batchCop[tiflash]
access object:
operator info: Column#22, Column#23, Column#24, Column#25, Column#26, stat.st_broker_dealer_user_month_summary.ch_broker_id, stat.st_broker_dealer_user_month_summary.ch_dealer_id, stat.st_broker_dealer_user_month_summary.i_user_id, stat.st_broker_dealer_user_month_summary.ch_gender, stat.st_broker_dealer_user_month_summary.d_birthday, stat.st_broker_dealer_user_month_summary.i_is_china_id_card, stat.st_broker_dealer_user_month_summary.ch_region_code, stat.st_broker_dealer_user_month_summary.ch_province_code, stat.st_broker_dealer_user_month_summary.ch_city_code, stat.st_broker_dealer_user_month_summary.ch_county_code, stat.st_broker_dealer_user_month_summary.i_broker_type
*************************** 5. row ***************************
id: └─HashAgg_30
estRows: 59701612.67
task: batchCop[tiflash]
access object:
operator info: group by:stat.st_broker_dealer_user_month_summary.ch_broker_id, stat.st_broker_dealer_user_month_summary.ch_dealer_id, stat.st_broker_dealer_user_month_summary.i_user_id, funcs:min(Column#36)->Column#22, funcs:max(Column#37)->Column#23, funcs:sum(Column#38)->Column#24, funcs:sum(Column#39)->Column#25, funcs:count(distinct stat.st_broker_dealer_user_month_summary.i_date)->Column#26, funcs:firstrow(stat.st_broker_dealer_user_month_summary.ch_broker_id)->stat.st_broker_dealer_user_month_summary.ch_broker_id, funcs:firstrow(stat.st_broker_dealer_user_month_summary.ch_dealer_id)->stat.st_broker_dealer_user_month_summary.ch_dealer_id, funcs:firstrow(stat.st_broker_dealer_user_month_summary.i_user_id)->stat.st_broker_dealer_user_month_summary.i_user_id, funcs:firstrow(Column#43)->stat.st_broker_dealer_user_month_summary.ch_gender, funcs:firstrow(Column#44)->stat.st_broker_dealer_user_month_summary.d_birthday, funcs:firstrow(Column#45)->stat.st_broker_dealer_user_month_summary.i_is_china_id_card, funcs:firstrow(Column#46)->stat.st_broker_dealer_user_month_summary.ch_region_code, funcs:firstrow(Column#47)->stat.st_broker_dealer_user_month_summary.ch_province_code, funcs:firstrow(Column#48)->stat.st_broker_dealer_user_month_summary.ch_city_code, funcs:firstrow(Column#49)->stat.st_broker_dealer_user_month_summary.ch_county_code, funcs:firstrow(Column#50)->stat.st_broker_dealer_user_month_summary.i_broker_type
*************************** 6. row ***************************
id: └─ExchangeReceiver_32
estRows: 59701612.67
task: batchCop[tiflash]
access object:
operator info:
*************************** 7. row ***************************
id: └─ExchangeSender_31
estRows: 59701612.67
task: batchCop[tiflash]
access object:
operator info: ExchangeType: HashPartition, Hash Cols: stat.st_broker_dealer_user_month_summary.ch_broker_id, stat.st_broker_dealer_user_month_summary.ch_dealer_id, stat.st_broker_dealer_user_month_summary.i_user_id
*************************** 8. row ***************************
id: └─HashAgg_8
estRows: 59701612.67
task: batchCop[tiflash]
access object:
operator info: group by:Column#80, Column#81, Column#82, Column#83, funcs:min(Column#68)->Column#36, funcs:max(Column#69)->Column#37, funcs:sum(Column#70)->Column#38, funcs:sum(Column#71)->Column#39, funcs:firstrow(Column#72)->Column#43, funcs:firstrow(Column#73)->Column#44, funcs:firstrow(Column#74)->Column#45, funcs:firstrow(Column#75)->Column#46, funcs:firstrow(Column#76)->Column#47, funcs:firstrow(Column#77)->Column#48, funcs:firstrow(Column#78)->Column#49, funcs:firstrow(Column#79)->Column#50
*************************** 9. row ***************************
id: └─Projection_43
estRows: 219272946.50
task: batchCop[tiflash]
access object:
operator info: stat.st_broker_dealer_user_month_summary.i_date, stat.st_broker_dealer_user_month_summary.i_date, cast(stat.st_broker_dealer_user_month_summary.i_amount, decimal(41,0) BINARY)->Column#70, cast(stat.st_broker_dealer_user_month_summary.i_count, decimal(41,0) BINARY)->Column#71, stat.st_broker_dealer_user_month_summary.ch_gender, stat.st_broker_dealer_user_month_summary.d_birthday, stat.st_broker_dealer_user_month_summary.i_is_china_id_card, stat.st_broker_dealer_user_month_summary.ch_region_code, stat.st_broker_dealer_user_month_summary.ch_province_code, stat.st_broker_dealer_user_month_summary.ch_city_code, stat.st_broker_dealer_user_month_summary.ch_county_code, stat.st_broker_dealer_user_month_summary.i_broker_type, stat.st_broker_dealer_user_month_summary.ch_broker_id, stat.st_broker_dealer_user_month_summary.ch_dealer_id, stat.st_broker_dealer_user_month_summary.i_user_id, stat.st_broker_dealer_user_month_summary.i_date
*************************** 10. row ***************************
id: └─Selection_28
estRows: 219272946.50
task: batchCop[tiflash]
access object:
operator info: ge(stat.st_broker_dealer_user_month_summary.i_date, 201701), le(stat.st_broker_dealer_user_month_summary.i_date, 202110)
*************************** 11. row ***************************
id: └─TableFullScan_27
estRows: 223089445.00
task: batchCop[tiflash]
access object: table:st_broker_dealer_user_month_summary
operator info: keep order:false
11 rows in set, 1 warning (0.00 sec)
1 个赞