为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
/*"set_var.connector_scan_use_query_mem_ratio" = '0.1',"sqlid" = '1747880159093-ai1c',"instanceid" = 'QbBz6XRDsY-7OKQ6K',"set_var.phased_scheduler_max_concurrency" = '1',"logid" = '3Jctp3NzBm',"tag" = 'QbBz6XRDsY-7OKQ6K',"set_var.enable_phased_scheduler" = 'true',"fabric-jobId" = '17d1771f-fdb6-2ab5-ae8d-c49c86659800',"set_var.pipeline_dop" = '1'*/ INSERT /*+ SET_VAR("enable_phased_scheduler"= 'true', "phased_scheduler_max_concurrency"= '1', "pipeline_dop"= '1', "connector_scan_use_query_mem_ratio"= '0.1') */
INTO `cubeappdata`.`_tmp_1747880158621_turbo_vdw_dws_mot_fee_share_result_info_f_flat` (`first_fee_class`, `province_name`, `second_fee_class`, `third_fee_class`, `yuce_tenant_id1`, `age_group`, `category`, `is_best_sell`, `is_high_aftersale`, `is_inv_back`, `is_potential`, `is_profit`, `outer_code`, `pic`, `product_name`, `spec_code0`, `spec_id0`, `spec_name`, `yuce_tenant_id2`, `channel`, `commander`, `company`, `shop_code0`, `shop_name`, `yuce_tenant_id0`, `bill_date`, `cost`, `dc`, `fee_item`, `pay_time`, `product_code`, `product_id`, `sale_order_id`, `send_time`, `shop_code`, `spec_code`, `spec_id`, `yuce_cube_shop_id`, `yuce_tenant_id`, `expert_id`, `expert_name`, `sale_order_id0`, `traffic_genre`, `yuce_tenant_id3`) (SELECT `t7`.`first_fee_class`, `t7`.`province_name`, `t7`.`second_fee_class`, `t7`.`third_fee_class`, `t7`.`yuce_tenant_id1`, `t7`.`age_group`, `t7`.`category`, `t7`.`is_best_sell`, `t7`.`is_high_aftersale`, `t7`.`is_inv_back`, `t7`.`is_potential`, `t7`.`is_profit`, `t7`.`outer_code`, `t7`.`pic`, `t7`.`product_name`, `t7`.`spec_code0`, `t7`.`spec_id0`, `t7`.`spec_name`, `t7`.`yuce_tenant_id2`, `t7`.`channel`, `t7`.`commander`, `t7`.`company`, `t7`.`shop_code0`, `t7`.`shop_name`, `t7`.`yuce_tenant_id0`, `t7`.`bill_date`, `t7`.`cost`, `t7`.`dc`, `t7`.`fee_item`, `t7`.`pay_time`, `t7`.`product_code`, `t7`.`product_id`, `t7`.`sale_order_id`, `t7`.`send_time`, `t7`.`shop_code`, `t7`.`spec_code`, `t7`.`spec_id`, `t7`.`yuce_cube_shop_id`, `t7`.`yuce_tenant_id`, `dws_trd_sale_order_prop_stat_info_f`.`expert_id`, `dws_trd_sale_order_prop_stat_info_f`.`expert_name`, `dws_trd_sale_order_prop_stat_info_f`.`sale_order_id` AS `sale_order_id0`, `dws_trd_sale_order_prop_stat_info_f`.`traffic_genre`, `dws_trd_sale_order_prop_stat_info_f`.`yuce_tenant_id` AS `yuce_tenant_id3`
FROM ((SELECT `bill_date` AS `bill_date`, `sale_order_id` AS `sale_order_id`, `shop_code` AS `shop_code`, `product_id` AS `product_id`, `spec_id` AS `spec_id`, `product_code` AS `product_code`, `spec_code` AS `spec_code`, `fee_item` AS `fee_item`, `dc` AS `dc`, `cost` AS `cost`, `pay_time` AS `pay_time`, `send_time` AS `send_time`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `shop_code0` AS `shop_code0`, `shop_name` AS `shop_name`, `company` AS `company`, `channel` AS `channel`, `commander` AS `commander`, `yuce_tenant_id0` AS `yuce_tenant_id0`, `first_fee_class` AS `first_fee_class`, `second_fee_class` AS `second_fee_class`, `third_fee_class` AS `third_fee_class`, `province_name` AS `province_name`, `yuce_tenant_id1` AS `yuce_tenant_id1`, `spec_id0`, `product_name` AS `product_name`, `spec_code0`, `spec_name` AS `spec_name`, `category` AS `category`, `pic` AS `pic`, `age_group` AS `age_group`, `is_best_sell` AS `is_best_sell`, `is_potential` AS `is_potential`, `is_profit` AS `is_profit`, `is_inv_back` AS `is_inv_back`, `is_high_aftersale` AS `is_high_aftersale`, `outer_code` AS `outer_code`, `yuce_tenant_id2`, `$f91`
FROM (SELECT `t4`.`bill_date`, `t4`.`sale_order_id`, `t4`.`shop_code`, `t4`.`product_id`, `t4`.`spec_id`, `t4`.`product_code`, `t4`.`spec_code`, `t4`.`fee_item`, `t4`.`dc`, `t4`.`cost`, `t4`.`pay_time`, `t4`.`send_time`, `t4`.`yuce_cube_shop_id`, `t4`.`yuce_tenant_id`, `t4`.`shop_code0`, `t4`.`shop_name`, `t4`.`company`, `t4`.`channel`, `t4`.`commander`, `t4`.`yuce_tenant_id0`, `t4`.`first_fee_class`, `t4`.`second_fee_class`, `t4`.`third_fee_class`, `t4`.`province_name`, `t4`.`yuce_tenant_id1`, `dim_product_spec`.`spec_id` AS `spec_id0`, `dim_product_spec`.`product_name`, `dim_product_spec`.`spec_code` AS `spec_code0`, `dim_product_spec`.`spec_name`, `dim_product_spec`.`category`, `dim_product_spec`.`pic`, `dim_product_spec`.`age_group`, `dim_product_spec`.`is_best_sell`, `dim_product_spec`.`is_potential`, `dim_product_spec`.`is_profit`, `dim_product_spec`.`is_inv_back`, `dim_product_spec`.`is_high_aftersale`, `dim_product_spec`.`outer_code`, `dim_product_spec`.`yuce_tenant_id` AS `yuce_tenant_id2`, CONCAT(CONCAT(CASE WHEN `t4`.`sale_order_id` IS NOT NULL THEN `t4`.`sale_order_id` ELSE '' END, '--'), CASE WHEN `t4`.`yuce_tenant_id` IS NOT NULL THEN `t4`.`yuce_tenant_id` ELSE '' END) AS `$f91`
FROM ((SELECT `bill_date` AS `bill_date`, `sale_order_id` AS `sale_order_id`, `shop_code` AS `shop_code`, `product_id` AS `product_id`, `spec_id` AS `spec_id`, `product_code` AS `product_code`, `spec_code` AS `spec_code`, `fee_item` AS `fee_item`, `dc` AS `dc`, `cost` AS `cost`, `pay_time` AS `pay_time`, `send_time` AS `send_time`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `shop_code0` AS `shop_code0`, `shop_name` AS `shop_name`, `company` AS `company`, `channel` AS `channel`, `commander` AS `commander`, `yuce_tenant_id0` AS `yuce_tenant_id0`, `first_fee_class` AS `first_fee_class`, `second_fee_class` AS `second_fee_class`, `third_fee_class` AS `third_fee_class`, `province_name` AS `province_name`, `yuce_tenant_id1`, `$f45`
FROM (SELECT `t1`.`bill_date`, `t1`.`sale_order_id`, `t1`.`shop_code`, `t1`.`product_id`, `t1`.`spec_id`, `t1`.`product_code`, `t1`.`spec_code`, `t1`.`fee_item`, `t1`.`dc`, `t1`.`cost`, `t1`.`pay_time`, `t1`.`send_time`, `t1`.`yuce_cube_shop_id`, `t1`.`yuce_tenant_id`, `t1`.`shop_code0`, `t1`.`shop_name`, `t1`.`company`, `t1`.`channel`, `t1`.`commander`, `t1`.`yuce_tenant_id0`, `dim_fee_class`.`first_fee_class`, `dim_fee_class`.`second_fee_class`, `dim_fee_class`.`third_fee_class`, `dim_fee_class`.`province_name`, `dim_fee_class`.`yuce_tenant_id` AS `yuce_tenant_id1`, CONCAT(CONCAT(CONCAT(CONCAT(CASE WHEN `t1`.`spec_id` IS NOT NULL THEN `t1`.`spec_id` ELSE '' END, '--'), CASE WHEN `t1`.`spec_code` IS NOT NULL THEN `t1`.`spec_code` ELSE '' END), '--'), CASE WHEN `t1`.`yuce_tenant_id` IS NOT NULL THEN `t1`.`yuce_tenant_id` ELSE '' END) AS `$f45`
FROM ((SELECT `bill_date` AS `bill_date`, `sale_order_id` AS `sale_order_id`, `shop_code` AS `shop_code`, `product_id` AS `product_id`, `spec_id` AS `spec_id`, `product_code` AS `product_code`, `spec_code` AS `spec_code`, `fee_item` AS `fee_item`, `dc` AS `dc`, `cost` AS `cost`, `pay_time` AS `pay_time`, `send_time` AS `send_time`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `shop_code0`, `shop_name` AS `shop_name`, `company` AS `company`, `channel` AS `channel`, `commander` AS `commander`, `yuce_tenant_id0`, `$f39`
FROM (SELECT `dws_mot_fee_share_result_info_f`.`bill_date`, `dws_mot_fee_share_result_info_f`.`sale_order_id`, `dws_mot_fee_share_result_info_f`.`shop_code`, `dws_mot_fee_share_result_info_f`.`product_id`, `dws_mot_fee_share_result_info_f`.`spec_id`, `dws_mot_fee_share_result_info_f`.`product_code`, `dws_mot_fee_share_result_info_f`.`spec_code`, `dws_mot_fee_share_result_info_f`.`fee_item`, `dws_mot_fee_share_result_info_f`.`dc`, `dws_mot_fee_share_result_info_f`.`cost`, `dws_mot_fee_share_result_info_f`.`pay_time`, `dws_mot_fee_share_result_info_f`.`send_time`, `dws_mot_fee_share_result_info_f`.`yuce_cube_shop_id`, `dws_mot_fee_share_result_info_f`.`yuce_tenant_id`, `dim_shop`.`shop_code` AS `shop_code0`, `dim_shop`.`shop_name`, `dim_shop`.`company`, `dim_shop`.`channel`, `dim_shop`.`commander`, `dim_shop`.`yuce_tenant_id` AS `yuce_tenant_id0`, CONCAT(CONCAT(CASE WHEN `dws_mot_fee_share_result_info_f`.`fee_item` IS NOT NULL THEN `dws_mot_fee_share_result_info_f`.`fee_item` ELSE '' END, '--'), CASE WHEN `dws_mot_fee_share_result_info_f`.`yuce_tenant_id` IS NOT NULL THEN `dws_mot_fee_share_result_info_f`.`yuce_tenant_id` ELSE '' END) AS `$f39`
FROM ((SELECT `bill_date` AS `bill_date`, `sale_order_id` AS `sale_order_id`, `shop_code` AS `shop_code`, `product_id` AS `product_id`, `spec_id` AS `spec_id`, `product_code` AS `product_code`, `spec_code` AS `spec_code`, `fee_item` AS `fee_item`, `dc` AS `dc`, `cost` AS `cost`, `pay_time` AS `pay_time`, `send_time` AS `send_time`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `$f17`
FROM (SELECT `dws_mot_fee_share_result_info_f`.`bill_date`, `dws_mot_fee_share_result_info_f`.`sale_order_id`, `dws_mot_fee_share_result_info_f`.`shop_code`, `dws_mot_fee_share_result_info_f`.`product_id`, `dws_mot_fee_share_result_info_f`.`spec_id`, `dws_mot_fee_share_result_info_f`.`product_code`, `dws_mot_fee_share_result_info_f`.`spec_code`, `dws_mot_fee_share_result_info_f`.`fee_item`, `dws_mot_fee_share_result_info_f`.`dc`, `dws_mot_fee_share_result_info_f`.`cost`, `dws_mot_fee_share_result_info_f`.`pay_time`, `dws_mot_fee_share_result_info_f`.`send_time`, `dws_mot_fee_share_result_info_f`.`yuce_cube_shop_id`, `dws_mot_fee_share_result_info_f`.`yuce_tenant_id`, CONCAT(CONCAT(CASE WHEN `dws_mot_fee_share_result_info_f`.`shop_code` IS NOT NULL THEN `dws_mot_fee_share_result_info_f`.`shop_code` ELSE '' END, '--'), CASE WHEN `dws_mot_fee_share_result_info_f`.`yuce_tenant_id` IS NOT NULL THEN `dws_mot_fee_share_result_info_f`.`yuce_tenant_id` ELSE '' END) AS `$f17`
FROM `lake`.`saas_datalake`.`dws_mot_fee_share_result_info_f`) AS `dws_mot_fee_share_result_info_f`) AS `dws_mot_fee_share_result_info_f` LEFT JOIN (SELECT `shop_code` AS `shop_code`, `shop_name` AS `shop_name`, `company` AS `company`, `channel` AS `channel`, `commander` AS `commander`, `yuce_tenant_id` AS `yuce_tenant_id`, `$f22`
FROM (SELECT `dim_shop`.`shop_code`, `dim_shop`.`shop_name`, `dim_shop`.`company`, `dim_shop`.`channel`, `dim_shop`.`commander`, `dim_shop`.`yuce_tenant_id`, CONCAT(CONCAT(CASE WHEN `dim_shop`.`shop_code` IS NOT NULL THEN `dim_shop`.`shop_code` ELSE '' END, '--'), CASE WHEN `dim_shop`.`yuce_tenant_id` IS NOT NULL THEN `dim_shop`.`yuce_tenant_id` ELSE '' END) AS `$f22`
FROM `lake`.`saas_datalake`.`dim_shop`) AS `dim_shop`) AS `dim_shop` ON `dws_mot_fee_share_result_info_f`.`$f17` = `dim_shop`.`$f22`)) AS `t0`) AS `t1` LEFT JOIN (SELECT `first_fee_class` AS `first_fee_class`, `second_fee_class` AS `second_fee_class`, `third_fee_class` AS `third_fee_class`, `province_name` AS `province_name`, `yuce_tenant_id` AS `yuce_tenant_id`, `$f6`
FROM (SELECT `dim_fee_class`.`first_fee_class`, `dim_fee_class`.`second_fee_class`, `dim_fee_class`.`third_fee_class`, `dim_fee_class`.`province_name`, `dim_fee_class`.`yuce_tenant_id`, CONCAT(CONCAT(CASE WHEN `dim_fee_class`.`province_name` IS NOT NULL THEN `dim_fee_class`.`province_name` ELSE '' END, '--'), CASE WHEN `dim_fee_class`.`yuce_tenant_id` IS NOT NULL THEN `dim_fee_class`.`yuce_tenant_id` ELSE '' END) AS `$f6`
FROM `lake`.`saas_datalake`.`dim_fee_class`) AS `dim_fee_class`) AS `dim_fee_class` ON `t1`.`$f39` = `dim_fee_class`.`$f6`)) AS `t3`) AS `t4` LEFT JOIN (SELECT `spec_id` AS `spec_id`, `product_name` AS `product_name`, `spec_code` AS `spec_code`, `spec_name` AS `spec_name`, `category` AS `category`, `pic` AS `pic`, `age_group` AS `age_group`, `is_best_sell` AS `is_best_sell`, `is_potential` AS `is_potential`, `is_profit` AS `is_profit`, `is_inv_back` AS `is_inv_back`, `is_high_aftersale` AS `is_high_aftersale`, `outer_code` AS `outer_code`, `yuce_tenant_id` AS `yuce_tenant_id`, `$f46`
FROM (SELECT `dim_product_spec`.`spec_id`, `dim_product_spec`.`product_name`, `dim_product_spec`.`spec_code`, `dim_product_spec`.`spec_name`, `dim_product_spec`.`category`, `dim_product_spec`.`pic`, `dim_product_spec`.`age_group`, `dim_product_spec`.`is_best_sell`, `dim_product_spec`.`is_potential`, `dim_product_spec`.`is_profit`, `dim_product_spec`.`is_inv_back`, `dim_product_spec`.`is_high_aftersale`, `dim_product_spec`.`outer_code`, `dim_product_spec`.`yuce_tenant_id`, CONCAT(CONCAT(CONCAT(CONCAT(CASE WHEN `dim_product_spec`.`spec_id` IS NOT NULL THEN `dim_product_spec`.`spec_id` ELSE '' END, '--'), CASE WHEN `dim_product_spec`.`spec_code` IS NOT NULL THEN `dim_product_spec`.`spec_code` ELSE '' END), '--'), CASE WHEN `dim_product_spec`.`yuce_tenant_id` IS NOT NULL THEN `dim_product_spec`.`yuce_tenant_id` ELSE '' END) AS `$f46`
FROM `lake`.`saas_datalake`.`dim_product_spec`) AS `dim_product_spec`) AS `dim_product_spec` ON `t4`.`$f45` = `dim_product_spec`.`$f46`)) AS `t6`) AS `t7` LEFT JOIN (SELECT `sale_order_id` AS `sale_order_id`, `expert_id` AS `expert_id`, `expert_name` AS `expert_name`, `traffic_genre` AS `traffic_genre`, `yuce_tenant_id` AS `yuce_tenant_id`, `$f11`
FROM (SELECT `dws_trd_sale_order_prop_stat_info_f`.`sale_order_id`, `dws_trd_sale_order_prop_stat_info_f`.`expert_id`, `dws_trd_sale_order_prop_stat_info_f`.`expert_name`, `dws_trd_sale_order_prop_stat_info_f`.`traffic_genre`, `dws_trd_sale_order_prop_stat_info_f`.`yuce_tenant_id`, CONCAT(CONCAT(CASE WHEN `dws_trd_sale_order_prop_stat_info_f`.`sale_order_id` IS NOT NULL THEN `dws_trd_sale_order_prop_stat_info_f`.`sale_order_id` ELSE '' END, '--'), CASE WHEN `dws_trd_sale_order_prop_stat_info_f`.`yuce_tenant_id` IS NOT NULL THEN `dws_trd_sale_order_prop_stat_info_f`.`yuce_tenant_id` ELSE '' END) AS `$f11`
【背景】做过哪些操作？
【业务影响】线上 任务执行失败
【是否存算分离】否
【StarRocks版本】例如：3.3.12
【集群规模】例如：3fe（3 follower+0observer）+3be
【机器信息】CPU虚拟核/内存/网卡，例如：8C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群16-可乐鸡或者邮箱，谢谢
【附件】
- 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