为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
比较简单的执行计划
sql:
SELECT `user_defined_brand_name` AS `user_defined_brand_name`, `qdbm` AS `qdbm`, `qd` AS `qd`, `OTB_channel` AS `OTB_channel`, `yjqybm` AS `yjqybm`, `yjqyjc` AS `yjqyjc`, `ejqybm` AS `ejqybm`, `ejqyjc` AS `ejqyjc`, `sjqybm` AS `sjqybm`, `sjqyjc` AS `sjqyjc`, `user_defined_platform` AS `user_defined_platform`, `shop_code` AS `shop_code`, `shop_name` AS `shop_name`, `nationality` AS `nationality`, `privince` AS `privince`, `city` AS `city`, `motion_channel` AS `motion_channel`, `diantai_id` AS `diantai_id`, `diantai` AS `diantai`, `dtfzxsxxdt` AS `dtfzxsxxdt`, `shop_square` AS `shop_square`, `dtfz` AS `dtfz`, `business_status` AS `business_status`, `shop_open_date` AS `shop_open_date`, `shop_end_date` AS `shop_end_date`, `open_year` AS `open_year`, `end_year` AS `end_year`, `area_charge` AS `area_charge`, `area_product_charge` AS `area_product_charge`, `member_id` AS `member_id`, `sale_order_id` AS `sale_order_id`, `sale_order_detail_id` AS `sale_order_detail_id`, `in_out_type` AS `in_out_type`, `sfo2o` AS `sfo2o`, `pay_time` AS `pay_time`, `zfny` AS `zfny`, `v_year` AS `v_year`, `v_quarter` AS `v_quarter`, `v_month` AS `v_month`, `v_week` AS `v_week`, `zfr` AS `zfr`, `order_type` AS `order_type`, `sale_year` AS `sale_year`, `user_defined_sale_year` AS `user_defined_sale_year`, `zdyxsn2` AS `zdyxsn2`, `new_old_type` AS `new_old_type`, `ss_fw` AS `ss_fw`, `season_assist` AS `season_assist`, `product_code` AS `product_code`, `product_name` AS `product_name`, `color_code` AS `color_code`, `color_name` AS `color_name`, `size_code` AS `size_code`, `size_name` AS `size_name`, `cml` AS `cml`, `pl2bm` AS `pl2bm`, `ejfl` AS `ejfl`, `yjxlbm` AS `yjxlbm`, `yjxl` AS `yjxl`, `xl2bm` AS `xl2bm`, `ejxl` AS `ejxl`, `sjxlbm` AS `sjxlbm`, `sjxl` AS `sjxl`, `five_big_category_id` AS `five_big_category_id`, `five_big_category_name` AS `five_big_category_name`, `five_big_category_mx_id` AS `five_big_category_mx_id`, `five_big_category_mx_name` AS `five_big_category_mx_name`, `pl1` AS `pl1`, `pl2` AS `pl2`, `sex_id` AS `sex_id`, `sex_name` AS `sex_name`, `is_gift` AS `is_gift`, `ext_actual_sale_amount` AS `ext_actual_sale_amount`, `sale_amount` AS `sale_amount`, `sale_discount_rate` AS `sale_discount_rate`, `ext_actual_sale_price` AS `ext_actual_sale_price`, `sale_price` AS `sale_price`, `sale_qty_kailas` AS `sale_qty_kailas`, `sale_amt_kailas` AS `sale_amt_kailas`, `zdysl` AS `zdysl`, `zdyje` AS `zdyje`, `is_calculate_last_year` AS `is_calculate_last_year`, `is_calculate_performance` AS `is_calculate_performance`, `remark` AS `remark`, `important_type` AS `important_type`, `KF` AS `KF`, `order_source` AS `order_source`, `channel_attributes_id` AS `channel_attributes_id`, `channel_attributes_name` AS `channel_attributes_name`, `destination_diantai` AS `destination_diantai`, `type2_name` AS `type2_name`, `type2_id` AS `type2_id`, `business_pro_name` AS `business_pro_name`, `jch` AS `jch`, `zrxjjdz` AS `zrxjjdz`, `frxjjdz` AS `frxjjdz`
FROM (SELECT `user_defined_brand_name`, `qdbm`, `qd`, `OTB_channel`, `yjqybm`, `yjqyjc`, `ejqybm`, `ejqyjc`, `sjqybm`, `sjqyjc`, `user_defined_platform`, `shop_code`, `shop_name`, `nationality`, `privince`, `city`, `motion_channel`, `diantai_id`, `diantai`, `dtfzxsxxdt`, `shop_square`, `dtfz`, `business_status`, `shop_open_date`, `shop_end_date`, `open_year`, `end_year`, `area_charge`, `area_product_charge`, `member_id`, `sale_order_id`, `sale_order_detail_id`, `in_out_type`, `sfo2o`, `pay_time`, `zfny`, `v_year`, `v_quarter`, `v_month`, `v_week`, `zfr`, `order_type`, `sale_year`, `user_defined_sale_year`, `zdyxsn2`, `new_old_type`, `ss_fw`, `season_assist`, `product_code`, `product_name`, `color_code`, `color_name`, `size_code`, `size_name`, `cml`, `pl2bm`, `ejfl`, `yjxlbm`, `yjxl`, `xl2bm`, `ejxl`, `sjxlbm`, `sjxl`, `five_big_category_id`, `five_big_category_name`, `five_big_category_mx_id`, `five_big_category_mx_name`, `pl1`, `pl2`, `sex_id`, `sex_name`, `is_gift`, `ext_actual_sale_amount`, `sale_amount`, `sale_discount_rate`, `ext_actual_sale_price`, `sale_price`, `sale_qty_kailas`, `sale_amt_kailas`, `zdysl`, `zdyje`, `is_calculate_last_year`, `is_calculate_performance`, `remark`, `important_type`, `KF`, `order_source`, `channel_attributes_id`, `channel_attributes_name`, `destination_diantai`, `type2_name`, `type2_id`, `business_pro_name`, `jch`, `zrxjjdz`, `frxjjdz`
FROM (SELECT `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_brand_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`qdbm`, `dwd_db_baisheng_sys_order_sale_detail_f`.`qd`, `dwd_db_baisheng_sys_order_sale_detail_f`.`OTB_channel`, `dwd_db_baisheng_sys_order_sale_detail_f`.`yjqybm`, `dwd_db_baisheng_sys_order_sale_detail_f`.`yjqyjc`, `dwd_db_baisheng_sys_order_sale_detail_f`.`ejqybm`, `dwd_db_baisheng_sys_order_sale_detail_f`.`ejqyjc`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sjqybm`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sjqyjc`, `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_platform`, `dwd_db_baisheng_sys_order_sale_detail_f`.`shop_code`, `dwd_db_baisheng_sys_order_sale_detail_f`.`shop_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`nationality`, `dwd_db_baisheng_sys_order_sale_detail_f`.`privince`, `dwd_db_baisheng_sys_order_sale_detail_f`.`city`, `dwd_db_baisheng_sys_order_sale_detail_f`.`motion_channel`, `dwd_db_baisheng_sys_order_sale_detail_f`.`diantai_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`diantai`, `dwd_db_baisheng_sys_order_sale_detail_f`.`dtfzxsxxdt`, `dwd_db_baisheng_sys_order_sale_detail_f`.`shop_square`, CAST(`dwd_db_baisheng_sys_order_sale_detail_f`.`dtfz` AS VARCHAR) AS `dtfz`, `dwd_db_baisheng_sys_order_sale_detail_f`.`business_status`, `dwd_db_baisheng_sys_order_sale_detail_f`.`shop_open_date`, `dwd_db_baisheng_sys_order_sale_detail_f`.`shop_end_date`, `dwd_db_baisheng_sys_order_sale_detail_f`.`open_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`end_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`area_charge`, `dwd_db_baisheng_sys_order_sale_detail_f`.`area_product_charge`, `dwd_db_baisheng_sys_order_sale_detail_f`.`member_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_order_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_order_detail_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`in_out_type`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sfo2o`, `dwd_db_baisheng_sys_order_sale_detail_f`.`pay_time`, CASE WHEN `dwd_db_baisheng_sys_order_sale_detail_f`.`zfny` IS NOT NULL THEN `dwd_db_baisheng_sys_order_sale_detail_f`.`zfny` ELSE `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`ny` END AS `zfny`, `dwd_db_baisheng_sys_order_sale_detail_f`.`v_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`v_quarter`, `dwd_db_baisheng_sys_order_sale_detail_f`.`v_month`, `dwd_db_baisheng_sys_order_sale_detail_f`.`v_week`, `dwd_db_baisheng_sys_order_sale_detail_f`.`zfr`, `dwd_db_baisheng_sys_order_sale_detail_f`.`order_type`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_sale_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`zdyxsn2`, `dwd_db_baisheng_sys_order_sale_detail_f`.`new_old_type`, `dwd_db_baisheng_sys_order_sale_detail_f`.`ss_fw`, `dwd_db_baisheng_sys_order_sale_detail_f`.`season_assist`, CASE WHEN `dwd_db_baisheng_sys_order_sale_detail_f`.`product_code` IS NOT NULL THEN `dwd_db_baisheng_sys_order_sale_detail_f`.`product_code` ELSE `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`kh` END AS `product_code`, `dwd_db_baisheng_sys_order_sale_detail_f`.`product_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`color_code`, `dwd_db_baisheng_sys_order_sale_detail_f`.`color_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`size_code`, `dwd_db_baisheng_sys_order_sale_detail_f`.`size_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`cml`, `dwd_db_baisheng_sys_order_sale_detail_f`.`pl2bm`, `dwd_db_baisheng_sys_order_sale_detail_f`.`lb2` AS `ejfl`, `dwd_db_baisheng_sys_order_sale_detail_f`.`yjxlbm`, `dwd_db_baisheng_sys_order_sale_detail_f`.`yjxl`, `dwd_db_baisheng_sys_order_sale_detail_f`.`xl2bm`, `dwd_db_baisheng_sys_order_sale_detail_f`.`ejxl`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sjxlbm`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sjxl`, `dwd_db_baisheng_sys_order_sale_detail_f`.`five_big_category_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`five_big_category_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`five_big_category_mx_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`five_big_category_mx_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`pl1`, `dwd_db_baisheng_sys_order_sale_detail_f`.`pl2`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sex_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sex_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`is_gift`, `dwd_db_baisheng_sys_order_sale_detail_f`.`ext_actual_sale_amount`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_amount`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_discount_rate`, `dwd_db_baisheng_sys_order_sale_detail_f`.`ext_actual_sale_price`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_price`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_qty_kailas`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_amt_kailas`, `dwd_db_baisheng_sys_order_sale_detail_f`.`zdysl`, `dwd_db_baisheng_sys_order_sale_detail_f`.`zdyje`, `dwd_db_baisheng_sys_order_sale_detail_f`.`is_calculate_last_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`is_calculate_performance`, `dwd_db_baisheng_sys_order_sale_detail_f`.`remark`, `dwd_db_baisheng_sys_order_sale_detail_f`.`important_type`, `dwd_db_baisheng_sys_order_sale_detail_f`.`KF`, `dwd_db_baisheng_sys_order_sale_detail_f`.`order_source`, `dwd_db_baisheng_sys_order_sale_detail_f`.`channel_attributes_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`channel_attributes_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`destination_diantai`, `dwd_db_baisheng_sys_order_sale_detail_f`.`type2_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`type2_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`business_pro_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`in_out_type2` AS `jch`, `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`zrxjjdz`, `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`frxjjdz`
FROM ((SELECT `user_defined_brand_name` AS `user_defined_brand_name`, `qdbm` AS `qdbm`, `qd` AS `qd`, `OTB_channel` AS `OTB_channel`, `yjqybm` AS `yjqybm`, `yjqyjc` AS `yjqyjc`, `ejqybm` AS `ejqybm`, `ejqyjc` AS `ejqyjc`, `sjqybm` AS `sjqybm`, `sjqyjc` AS `sjqyjc`, `user_defined_platform` AS `user_defined_platform`, `shop_code` AS `shop_code`, `shop_name` AS `shop_name`, `nationality` AS `nationality`, `privince` AS `privince`, `city` AS `city`, `motion_channel` AS `motion_channel`, `diantai_id` AS `diantai_id`, `diantai` AS `diantai`, `dtfzxsxxdt` AS `dtfzxsxxdt`, `shop_square` AS `shop_square`, `dtfz` AS `dtfz`, `business_status` AS `business_status`, `shop_open_date` AS `shop_open_date`, `shop_end_date` AS `shop_end_date`, `open_year` AS `open_year`, `end_year` AS `end_year`, `area_charge` AS `area_charge`, `area_product_charge` AS `area_product_charge`, `member_id` AS `member_id`, `sale_order_id` AS `sale_order_id`, `sale_order_detail_id` AS `sale_order_detail_id`, `in_out_type` AS `in_out_type`, `sfo2o` AS `sfo2o`, `pay_time` AS `pay_time`, `zfny` AS `zfny`, `v_year` AS `v_year`, `v_quarter` AS `v_quarter`, `v_month` AS `v_month`, `v_week` AS `v_week`, `zfr` AS `zfr`, `order_type` AS `order_type`, `sale_year` AS `sale_year`, `user_defined_sale_year` AS `user_defined_sale_year`, `zdyxsn2` AS `zdyxsn2`, `new_old_type` AS `new_old_type`, `ss_fw` AS `ss_fw`, `season_assist` AS `season_assist`, `product_code` AS `product_code`, `product_name` AS `product_name`, `color_code` AS `color_code`, `color_name` AS `color_name`, `size_code` AS `size_code`, `size_name` AS `size_name`, `cml` AS `cml`, `pl2bm` AS `pl2bm`, `lb2` AS `lb2`, `yjxlbm` AS `yjxlbm`, `yjxl` AS `yjxl`, `xl2bm` AS `xl2bm`, `ejxl` AS `ejxl`, `sjxlbm` AS `sjxlbm`, `sjxl` AS `sjxl`, `five_big_category_id` AS `five_big_category_id`, `five_big_category_name` AS `five_big_category_name`, `five_big_category_mx_id` AS `five_big_category_mx_id`, `five_big_category_mx_name` AS `five_big_category_mx_name`, `pl1` AS `pl1`, `pl2` AS `pl2`, `sex_id` AS `sex_id`, `sex_name` AS `sex_name`, `is_gift` AS `is_gift`, `ext_actual_sale_amount` AS `ext_actual_sale_amount`, `sale_amount` AS `sale_amount`, `sale_discount_rate` AS `sale_discount_rate`, `ext_actual_sale_price` AS `ext_actual_sale_price`, `sale_price` AS `sale_price`, `sale_qty_kailas` AS `sale_qty_kailas`, `sale_amt_kailas` AS `sale_amt_kailas`, `zdysl` AS `zdysl`, `zdyje` AS `zdyje`, `is_calculate_last_year` AS `is_calculate_last_year`, `is_calculate_performance` AS `is_calculate_performance`, `remark` AS `remark`, `important_type` AS `important_type`, `KF` AS `KF`, `order_source` AS `order_source`, `channel_attributes_id` AS `channel_attributes_id`, `channel_attributes_name` AS `channel_attributes_name`, `destination_diantai` AS `destination_diantai`, `type2_name` AS `type2_name`, `type2_id` AS `type2_id`, `business_pro_name` AS `business_pro_name`, `in_out_type2` AS `in_out_type2`, `$f94`
FROM (SELECT `user_defined_brand_name`, `qdbm`, `qd`, `OTB_channel`, `yjqybm`, `yjqyjc`, `ejqybm`, `ejqyjc`, `sjqybm`, `sjqyjc`, `user_defined_platform`, `shop_code`, `shop_name`, `nationality`, `privince`, `city`, `motion_channel`, `diantai_id`, `diantai`, `dtfzxsxxdt`, `shop_square`, `dtfz`, `business_status`, `shop_open_date`, `shop_end_date`, `open_year`, `end_year`, `area_charge`, `area_product_charge`, `member_id`, `sale_order_id`, `sale_order_detail_id`, `in_out_type`, `sfo2o`, `pay_time`, `zfny`, `v_year`, `v_quarter`, `v_month`, `v_week`, `zfr`, `order_type`, `sale_year`, `user_defined_sale_year`, `zdyxsn2`, `new_old_type`, `ss_fw`, `season_assist`, `product_code`, `product_name`, `color_code`, `color_name`, `size_code`, `size_name`, `cml`, `pl2bm`, `lb2`, `yjxlbm`, `yjxl`, `xl2bm`, `ejxl`, `sjxlbm`, `sjxl`, `five_big_category_id`, `five_big_category_name`, `five_big_category_mx_id`, `five_big_category_mx_name`, `pl1`, `pl2`, `sex_id`, `sex_name`, `is_gift`, `ext_actual_sale_amount`, `sale_amount`, `sale_discount_rate`, `ext_actual_sale_price`, `sale_price`, `sale_qty_kailas`, `sale_amt_kailas`, `zdysl`, `zdyje`, `is_calculate_last_year`, `is_calculate_performance`, `remark`, `important_type`, `KF`, `order_source`, `channel_attributes_id`, `channel_attributes_name`, `destination_diantai`, `type2_name`, `type2_id`, `business_pro_name`, `in_out_type2`, CONCAT(CONCAT(CASE WHEN `product_code` IS NOT NULL THEN `product_code` ELSE '' END, '--'), CASE WHEN `zfny` IS NOT NULL THEN `zfny` ELSE '' END) AS `$f94`
FROM (SELECT `user_defined_brand_name`, `qdbm`, `qd`, `OTB_channel`, `yjqybm`, `yjqyjc`, `ejqybm`, `ejqyjc`, `sjqybm`, `sjqyjc`, `user_defined_platform`, `shop_code`, `shop_name`, `nationality`, `privince`, `city`, `motion_channel`, `diantai_id`, `diantai`, `dtfzxsxxdt`, `shop_square`, CASE WHEN `dtfzxsxxdt` IN ('FUGA???', '?????', '?????', '?????', '?????') THEN '???' WHEN `dtfzxsxxdt` IN ('?????', '????', '????', '????') THEN '????' ELSE '???' END AS `dtfz`, `business_status`, `shop_open_date`, `shop_end_date`, `open_year`, `end_year`, `area_charge`, `area_product_charge`, `member_id`, `sale_order_id`, `sale_order_detail_id`, `in_out_type`, `sfo2o`, `pay_time`, `zfny`, `v_year`, `v_quarter`, `v_month`, `v_week`, `zfr`, `order_type`, `sale_year`, `user_defined_sale_year`, `zdyxsn2`, `new_old_type`, `ss_fw`, `season_assist`, `product_code`, `product_name`, `color_code`, `color_name`, `size_code`, `size_name`, `cml`, `pl2bm`, `lb2`, `yjxlbm`, `yjxl`, `xl2bm`, `ejxl`, `sjxlbm`, `sjxl`, `five_big_category_id`, `five_big_category_name`, `five_big_category_mx_id`, `five_big_category_mx_name`, `pl1`, `pl2`, `sex_id`, `sex_name`, `is_gift`, `ext_actual_sale_amount`, `sale_amount`, `sale_discount_rate`, `ext_actual_sale_price`, `sale_price`, `sale_qty_kailas`, `sale_amt_kailas`, `zdysl`, `zdyje`, `is_calculate_last_year`, `is_calculate_performance`, `remark`, `important_type`, `KF`, `order_source`, `channel_attributes_id`, `channel_attributes_name`, `destination_diantai`, `type2_name`, `type2_id`, `business_pro_name`, `in_out_type2`
FROM (SELECT `user_defined_brand_name`, `user_defined_level_id3` AS `qdbm`, `user_defined_level_name3` AS `qd`, `OTB_channel`, `level_id4` AS `yjqybm`, `level_simple_name4` AS `yjqyjc`, `level_id5` AS `ejqybm`, `level_simple_name5` AS `ejqyjc`, `level_id6` AS `sjqybm`, `level_simple_name6` AS `sjqyjc`, `user_defined_platform`, `shop_code`, `shop_name`, `nationality`, `privince`, `city`, `motion_channel`, `diantai_id`, `diantai`, CASE WHEN `user_defined_level_name3` IN ('???', '??(FUGA)', '???') THEN `diantai` WHEN `user_defined_level_name3` IN ('???', '??(FUGA)') THEN `destination_diantai` ELSE CAST(NULL AS VARCHAR) END AS `dtfzxsxxdt`, `shop_square`, `business_status`, `shop_open_date`, `shop_end_date`, `open_year`, `end_year`, `area_charge`, `area_product_charge`, `member_id`, `sale_order_id`, `sale_order_detail_id`, `in_out_type`, `is_o2o` AS `sfo2o`, `pay_time`, DATE_FORMAT(`pay_time`, '%Y-%m') AS `zfny`, `v_year`, `v_quarter`, `v_month`, `v_week`, `v_day` AS `zfr`, `order_type`, `sale_year`, `user_defined_sale_year`, `user_defined_sale_year2` AS `zdyxsn2`, `new_old_type`, `ss_fw`, `season_assist`, `product_code`, `product_name`, `color_code`, `color_name`, `size_code`, `size_name`, `size_name2` AS `cml`, `category_id2` AS `pl2bm`, `category_name2` AS `lb2`, `series_id1` AS `yjxlbm`, `series_name1` AS `yjxl`, `series_id2` AS `xl2bm`, `series_name2` AS `ejxl`, `series_id3` AS `sjxlbm`, `series_name3` AS `sjxl`, `five_big_category_id`, `five_big_category_name`, `five_big_category_mx_id`, `five_big_category_mx_name`, `kind_name1` AS `pl1`, `kind_name2` AS `pl2`, `sex_id`, `sex_name`, `is_gift`, `ext_actual_sale_amount`, `sale_amount`, `sale_discount_rate`, `ext_actual_sale_price`, `sale_price`, `sale_qty_kailas`, `sale_amt_kailas`, `user_defined_qty` AS `zdysl`, `user_defined_amt` AS `zdyje`, `is_calculate_last_year`, `is_calculate_performance`, `remark`, `important_type`, `KF`, `order_source`, `channel_attributes_id`, `channel_attributes_name`, `destination_diantai`, `type2_name`, `type2_id`, `business_pro_name`, `in_out_type2`
FROM (SELECT `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_brand_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_level_id3`, `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_level_name3`, `dwd_db_baisheng_sys_order_sale_detail_f`.`OTB_channel`, `dwd_db_baisheng_sys_order_sale_detail_f`.`level_id4`, `dwd_db_baisheng_sys_order_sale_detail_f`.`level_simple_name4`, `dwd_db_baisheng_sys_order_sale_detail_f`.`level_id5`, `dwd_db_baisheng_sys_order_sale_detail_f`.`level_simple_name5`, `dwd_db_baisheng_sys_order_sale_detail_f`.`level_id6`, `dwd_db_baisheng_sys_order_sale_detail_f`.`level_simple_name6`, `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_platform`, `dwd_db_baisheng_sys_order_sale_detail_f`.`shop_code`, `dwd_db_baisheng_sys_order_sale_detail_f`.`shop_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`nationality`, `dwd_db_baisheng_sys_order_sale_detail_f`.`privince`, `dwd_db_baisheng_sys_order_sale_detail_f`.`city`, `dwd_db_baisheng_sys_order_sale_detail_f`.`motion_channel`, `dwd_db_baisheng_sys_order_sale_detail_f`.`diantai_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`diantai`, `dwd_db_baisheng_sys_order_sale_detail_f`.`shop_square`, `dwd_db_baisheng_sys_order_sale_detail_f`.`business_status`, `dwd_db_baisheng_sys_order_sale_detail_f`.`shop_open_date`, `dwd_db_baisheng_sys_order_sale_detail_f`.`shop_end_date`, `dwd_db_baisheng_sys_order_sale_detail_f`.`open_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`end_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`area_charge`, `dwd_db_baisheng_sys_order_sale_detail_f`.`area_product_charge`, `dwd_db_baisheng_sys_order_sale_detail_f`.`member_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_order_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_order_detail_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`in_out_type`, `dwd_db_baisheng_sys_order_sale_detail_f`.`is_o2o`, `dwd_db_baisheng_sys_order_sale_detail_f`.`pay_time`, `dwd_db_baisheng_sys_order_sale_detail_f`.`v_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`v_quarter`, `dwd_db_baisheng_sys_order_sale_detail_f`.`v_month`, `dwd_db_baisheng_sys_order_sale_detail_f`.`v_week`, `dwd_db_baisheng_sys_order_sale_detail_f`.`v_day`, `dwd_db_baisheng_sys_order_sale_detail_f`.`order_type`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_sale_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_sale_year2`, `dwd_db_baisheng_sys_order_sale_detail_f`.`new_old_type`, `dwd_db_baisheng_sys_order_sale_detail_f`.`ss_fw`, `dwd_db_baisheng_sys_order_sale_detail_f`.`season_assist`, `dwd_db_baisheng_sys_order_sale_detail_f`.`product_code`, `dwd_db_baisheng_sys_order_sale_detail_f`.`product_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`color_code`, `dwd_db_baisheng_sys_order_sale_detail_f`.`color_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`size_code`, `dwd_db_baisheng_sys_order_sale_detail_f`.`size_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`size_name2`, `dwd_db_baisheng_sys_order_sale_detail_f`.`category_id2`, `dwd_db_baisheng_sys_order_sale_detail_f`.`category_name2`, `dwd_db_baisheng_sys_order_sale_detail_f`.`series_id1`, `dwd_db_baisheng_sys_order_sale_detail_f`.`series_name1`, `dwd_db_baisheng_sys_order_sale_detail_f`.`series_id2`, `dwd_db_baisheng_sys_order_sale_detail_f`.`series_name2`, `dwd_db_baisheng_sys_order_sale_detail_f`.`series_id3`, `dwd_db_baisheng_sys_order_sale_detail_f`.`series_name3`, `dwd_db_baisheng_sys_order_sale_detail_f`.`five_big_category_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`five_big_category_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`five_big_category_mx_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`five_big_category_mx_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`kind_name1`, `dwd_db_baisheng_sys_order_sale_detail_f`.`kind_name2`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sex_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sex_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`is_gift`, `dwd_db_baisheng_sys_order_sale_detail_f`.`ext_actual_sale_amount`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_amount`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_discount_rate`, `dwd_db_baisheng_sys_order_sale_detail_f`.`ext_actual_sale_price`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_price`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_qty_kailas`, `dwd_db_baisheng_sys_order_sale_detail_f`.`sale_amt_kailas`, `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_qty`, `dwd_db_baisheng_sys_order_sale_detail_f`.`user_defined_amt`, `dwd_db_baisheng_sys_order_sale_detail_f`.`is_calculate_last_year`, `dwd_db_baisheng_sys_order_sale_detail_f`.`is_calculate_performance`, `dwd_db_baisheng_sys_order_sale_detail_f`.`remark`, `dwd_db_baisheng_sys_order_sale_detail_f`.`important_type`, `dwd_db_baisheng_sys_order_sale_detail_f`.`order_source`, `dwd_db_baisheng_sys_order_sale_detail_f`.`destination_diantai`, `dwd_db_baisheng_sys_order_sale_detail_f`.`channel_attributes_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`channel_attributes_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`business_pro_name`, `dwd_db_baisheng_sys_order_sale_detail_f`.`in_out_type2`, `dwd_db_baisheng_sys_order_sale_detail_f`.`KF`, `dwd_db_baisheng_sys_order_sale_detail_f`.`type2_id`, `dwd_db_baisheng_sys_order_sale_detail_f`.`type2_name`
FROM `cubeappdata`.`dwd_db_baisheng_sys_order_sale_detail_f`) AS `dwd_db_baisheng_sys_order_sale_detail_f`
WHERE `user_defined_level_name3` IN ('???', '??(FUGA)', '???', '???', '??(FUGA)') AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%??%' ELSE TRUE END AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%??%' ELSE TRUE END AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%?%' ELSE TRUE END AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%??%' ELSE TRUE END AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%??%' ELSE TRUE END AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%??%' ELSE TRUE END AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%?%' ELSE TRUE END AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%??%' ELSE TRUE END AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%??%' ELSE TRUE END AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%??%' ELSE TRUE END AND CASE WHEN `remark` IS NOT NULL THEN `remark` NOT LIKE '%??%' ELSE TRUE END AND CASE WHEN `shop_name` IS NOT NULL THEN `shop_name` NOT LIKE '%VAUDE%' ELSE TRUE END AND CASE WHEN `shop_name` IS NOT NULL THEN `shop_name` NOT LIKE '%??%' ELSE TRUE END AND CASE WHEN `shop_name` IS NOT NULL THEN `shop_name` NOT LIKE '%VADUE%' ELSE TRUE END AND `ext_actual_sale_price` > 5) AS `dwd_db_baisheng_sys_order_sale_detail_f`) AS `dwd_db_baisheng_sys_order_sale_detail_f`) AS `dwd_db_baisheng_sys_order_sale_detail_f`) AS `dwd_db_baisheng_sys_order_sale_detail_f` INNER JOIN (SELECT `ny` AS `ny`, `kh` AS `kh`, `zrxjjdz` AS `zrxjjdz`, `frxjjdz` AS `frxjjdz`, `$f4`
FROM (SELECT `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`ny`, `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`kh`, `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`zrxjjdz`, `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`frxjjdz`, CONCAT(CONCAT(CASE WHEN `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`kh` IS NOT NULL THEN `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`kh` ELSE '' END, '--'), CASE WHEN `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`ny` IS NOT NULL THEN `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`ny` ELSE '' END) AS `$f4`
FROM `cubeappdata`.`UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`) AS `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`) AS `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12` ON `dwd_db_baisheng_sys_order_sale_detail_f`.`$f94` = `UD_2xOooQ0Ujd_PF0K4_prkjplkjzb12`.`$f4`)) AS `t0` LIMIT 200) AS `t3`
谓词信息
concat(concat(if(47: product_code IS NOT NULL, 47: product_code, ''), '--'),
if(date_format(34: pay_time,'%Y-%m') IS NOT NULL,
date_format(34: pay_time,'%Y-%m'),'')) IS NOT NULL,
4: user_defined_level_name3 IN ('???','??(FUGA)','???','???','??(FUGA)'),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%??%'),TRUE),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%??%'),TRUE),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%?%'),TRUE),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%??%'),TRUE),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%??%'),TRUE),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%??%'),TRUE),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%?%'),TRUE),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%??%'),TRUE),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%??%'),TRUE),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%??%'),TRUE),
if(82: remark IS NOT NULL, NOT (82: remark LIKE '%??%'),TRUE),
if(14: shop_name IS NOT NULL,NOT (14: shop_name LIKE '%VAUDE%'),TRUE),
if(14: shop_name IS NOT NULL,NOT (14: shop_name LIKE '%??%'),TRUE),
if(14: shop_name IS NOT NULL,NOT (14: shop_name LIKE '%VADUE%'),TRUE),
74: ext_actual_sale_price > 5.0
【背景】做过哪些操作？
【业务影响】
bi报表出不来
【是否存算分离】否
【StarRocks版本】例如：3.2.11
【集群规模】例如：3fe（1 follower+2observer）+5be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
- fe.log/beINFO/相应截图
- 慢查询：
- Profile信息，获取Profile，通过Profile分析查询瓶颈
- 并行度：show variables like ‘%parallel_fragment_exec_instance_num%’;
- pipeline是否开启：show variables like ‘%pipeline%’;
- be节点cpu和内存使用率截图
- 查询报错：
- query_dump，怎么获取query_dump文件
- be crash
- be.out
- coredump，如何获取coredump
- 外表查询报错
- be.out和fe.warn.log