为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
在排序和full join的时候会出现spill 内存占用过高
本来是内存数据落盘的, 结果消耗内存却很高.
exchange Sink算子的内存消耗也比较高
/*"sqlid" = '1740988790920-32gz',"set_var.spill_mode" = 'force',"itemid" = 'LH4iQOmh9G',"set_var.query_timeout" = '10800',"set_var.connector_io_tasks_per_scan_operator" = '2',"fabric-jobId" = '182fbe62-4611-7bff-d8da-eb52d094d300',"set_var.pipeline_dop" = '1',"set_var.chunk_size" = '1024'*/ INSERT /*+ SET_VAR("connector_io_tasks_per_scan_operator"= '2', "spill_mode"= 'auto', "chunk_size"= '1024', "pipeline_dop"= '1', "query_timeout"= '10800') */
OVERWRITE `lake`.`saas_datalake`.`tmp_ods_api_dd_sale_order_list_info_f` (`accept_order_status`, `shop_id`, `shop_name`, `open_id`, `order_id`, `order_level`, `biz`, `biz_desc`, `order_type`, `order_type_desc`, `trade_type`, `trade_type_desc`, `order_status`, `order_status_desc`, `main_status`, `main_status_desc`, `pay_time`, `order_expire_time`, `finish_time`, `create_time`, `update_time`, `cancel_reason`, `buyer_words`, `seller_words`, `b_type`, `b_type_desc`, `sub_b_type`, `sub_b_type_desc`, `app_id`, `pay_type`, `channel_payment_no`, `order_amount`, `pay_amount`, `post_amount`, `post_insurance_amount`, `modify_amount`, `modify_post_amount`, `promotion_amount`, `promotion_shop_amount`, `promotion_platform_amount`, `shop_cost_amount`, `platform_cost_amount`, `promotion_talent_amount`, `promotion_pay_amount`, `encrypt_post_tel`, `encrypt_post_receiver`, `post_addr`, `exp_ship_time`, `ship_time`, `logistics_info`, `sku_order_list`, `seller_remark_stars`, `order_phase_list`, `doudian_open_id`, `serial_number_list`, `promotion_redpack_amount`, `promotion_redpack_platform_amount`, `promotion_redpack_talent_amount`, `appointment_ship_time`, `d_car_shop_biz_data`, `shop_order_tag_ui`, `total_promotion_amount`, `post_origin_amount`, `post_promotion_amount`, `user_tag_ui`, `author_cost_amount`, `only_platform_cost_amount`, `promise_info`, `mask_post_receiver`, `mask_post_tel`, `mask_post_addr`, `user_coordinate`, `earliest_receipt_time`, `latest_receipt_time`, `early_arrival`, `target_arrival_time`, `packing_amount`, `supermarket_order_serial_no`, `tax_amount`, `address_tag_ui`, `mask_pay_tel`, `encrypt_pay_tel`, `greet_words`, `pay_tel`, `post_receiver`, `open_address_id`, `post_tel`, `origin_data`, `yuce_cube_shop_id`, `dt`, `yuce_tenant_id`) (SELECT `accept_order_status`, `shop_id`, `shop_name`, `open_id`, `order_id`, `order_level`, `biz`, `biz_desc`, `order_type`, `order_type_desc`, `trade_type`, `trade_type_desc`, `order_status`, `order_status_desc`, `main_status`, `main_status_desc`, `pay_time`, `order_expire_time`, `finish_time`, `create_time`, `update_time`, `cancel_reason`, `buyer_words`, `seller_words`, `b_type`, `b_type_desc`, `sub_b_type`, `sub_b_type_desc`, `app_id`, `pay_type`, `channel_payment_no`, `order_amount`, `pay_amount`, `post_amount`, `post_insurance_amount`, `modify_amount`, `modify_post_amount`, `promotion_amount`, `promotion_shop_amount`, `promotion_platform_amount`, `shop_cost_amount`, `platform_cost_amount`, `promotion_talent_amount`, `promotion_pay_amount`, `encrypt_post_tel`, `encrypt_post_receiver`, `post_addr`, `exp_ship_time`, `ship_time`, `logistics_info`, `sku_order_list`, `seller_remark_stars`, `order_phase_list`, `doudian_open_id`, `serial_number_list`, `promotion_redpack_amount`, `promotion_redpack_platform_amount`, `promotion_redpack_talent_amount`, `appointment_ship_time`, `d_car_shop_biz_data`, `shop_order_tag_ui`, `total_promotion_amount`, `post_origin_amount`, `post_promotion_amount`, `user_tag_ui`, `author_cost_amount`, `only_platform_cost_amount`, `promise_info`, `mask_post_receiver`, `mask_post_tel`, `mask_post_addr`, `user_coordinate`, `earliest_receipt_time`, `latest_receipt_time`, `early_arrival`, `target_arrival_time`, `packing_amount`, `supermarket_order_serial_no`, `tax_amount`, `address_tag_ui`, `mask_pay_tel`, `encrypt_pay_tel`, `greet_words`, `pay_tel`, `post_receiver`, `open_address_id`, `post_tel`, `origin_data`, `yuce_cube_shop_id`, `dt`, `yuce_tenant_id`
FROM (SELECT CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`accept_order_status` ELSE `t1`.`accept_order_status` END AS `accept_order_status`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`shop_id` ELSE `t1`.`shop_id` END AS `shop_id`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`shop_name` ELSE `t1`.`shop_name` END AS `shop_name`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`open_id` ELSE `t1`.`open_id` END AS `open_id`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`order_id` ELSE `t1`.`order_id` END AS `order_id`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`order_level` ELSE `t1`.`order_level` END AS `order_level`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`biz` ELSE `t1`.`biz` END AS `biz`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`biz_desc` ELSE `t1`.`biz_desc` END AS `biz_desc`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`order_type` ELSE `t1`.`order_type` END AS `order_type`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`order_type_desc` ELSE `t1`.`order_type_desc` END AS `order_type_desc`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`trade_type` ELSE `t1`.`trade_type` END AS `trade_type`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`trade_type_desc` ELSE `t1`.`trade_type_desc` END AS `trade_type_desc`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`order_status` ELSE `t1`.`order_status` END AS `order_status`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`order_status_desc` ELSE `t1`.`order_status_desc` END AS `order_status_desc`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`main_status` ELSE `t1`.`main_status` END AS `main_status`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`main_status_desc` ELSE `t1`.`main_status_desc` END AS `main_status_desc`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`pay_time` ELSE `t1`.`pay_time` END AS `pay_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`order_expire_time` ELSE `t1`.`order_expire_time` END AS `order_expire_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`finish_time` ELSE `t1`.`finish_time` END AS `finish_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`create_time` ELSE `t1`.`create_time` END AS `create_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`update_time` ELSE `t1`.`update_time` END AS `update_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`cancel_reason` ELSE `t1`.`cancel_reason` END AS `cancel_reason`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`buyer_words` ELSE `t1`.`buyer_words` END AS `buyer_words`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`seller_words` ELSE `t1`.`seller_words` END AS `seller_words`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`b_type` ELSE `t1`.`b_type` END AS `b_type`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`b_type_desc` ELSE `t1`.`b_type_desc` END AS `b_type_desc`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`sub_b_type` ELSE `t1`.`sub_b_type` END AS `sub_b_type`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`sub_b_type_desc` ELSE `t1`.`sub_b_type_desc` END AS `sub_b_type_desc`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`app_id` ELSE `t1`.`app_id` END AS `app_id`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`pay_type` ELSE `t1`.`pay_type` END AS `pay_type`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`channel_payment_no` ELSE `t1`.`channel_payment_no` END AS `channel_payment_no`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`order_amount` ELSE `t1`.`order_amount` END AS `order_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`pay_amount` ELSE `t1`.`pay_amount` END AS `pay_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`post_amount` ELSE `t1`.`post_amount` END AS `post_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`post_insurance_amount` ELSE `t1`.`post_insurance_amount` END AS `post_insurance_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`modify_amount` ELSE `t1`.`modify_amount` END AS `modify_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`modify_post_amount` ELSE `t1`.`modify_post_amount` END AS `modify_post_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`promotion_amount` ELSE `t1`.`promotion_amount` END AS `promotion_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`promotion_shop_amount` ELSE `t1`.`promotion_shop_amount` END AS `promotion_shop_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`promotion_platform_amount` ELSE `t1`.`promotion_platform_amount` END AS `promotion_platform_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`shop_cost_amount` ELSE `t1`.`shop_cost_amount` END AS `shop_cost_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`platform_cost_amount` ELSE `t1`.`platform_cost_amount` END AS `platform_cost_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`promotion_talent_amount` ELSE `t1`.`promotion_talent_amount` END AS `promotion_talent_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`promotion_pay_amount` ELSE `t1`.`promotion_pay_amount` END AS `promotion_pay_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`encrypt_post_tel` ELSE `t1`.`encrypt_post_tel` END AS `encrypt_post_tel`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`encrypt_post_receiver` ELSE `t1`.`encrypt_post_receiver` END AS `encrypt_post_receiver`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`post_addr` ELSE `t1`.`post_addr` END AS `post_addr`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`exp_ship_time` ELSE `t1`.`exp_ship_time` END AS `exp_ship_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`ship_time` ELSE `t1`.`ship_time` END AS `ship_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`logistics_info` ELSE `t1`.`logistics_info` END AS `logistics_info`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`sku_order_list` ELSE `t1`.`sku_order_list` END AS `sku_order_list`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`seller_remark_stars` ELSE `t1`.`seller_remark_stars` END AS `seller_remark_stars`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`order_phase_list` ELSE `t1`.`order_phase_list` END AS `order_phase_list`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`doudian_open_id` ELSE `t1`.`doudian_open_id` END AS `doudian_open_id`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`serial_number_list` ELSE `t1`.`serial_number_list` END AS `serial_number_list`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`promotion_redpack_amount` ELSE `t1`.`promotion_redpack_amount` END AS `promotion_redpack_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`promotion_redpack_platform_amount` ELSE `t1`.`promotion_redpack_platform_amount` END AS `promotion_redpack_platform_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`promotion_redpack_talent_amount` ELSE `t1`.`promotion_redpack_talent_amount` END AS `promotion_redpack_talent_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`appointment_ship_time` ELSE `t1`.`appointment_ship_time` END AS `appointment_ship_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`d_car_shop_biz_data` ELSE `t1`.`d_car_shop_biz_data` END AS `d_car_shop_biz_data`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`shop_order_tag_ui` ELSE `t1`.`shop_order_tag_ui` END AS `shop_order_tag_ui`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`total_promotion_amount` ELSE `t1`.`total_promotion_amount` END AS `total_promotion_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`post_origin_amount` ELSE `t1`.`post_origin_amount` END AS `post_origin_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`post_promotion_amount` ELSE `t1`.`post_promotion_amount` END AS `post_promotion_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`user_tag_ui` ELSE `t1`.`user_tag_ui` END AS `user_tag_ui`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`author_cost_amount` ELSE `t1`.`author_cost_amount` END AS `author_cost_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`only_platform_cost_amount` ELSE `t1`.`only_platform_cost_amount` END AS `only_platform_cost_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`promise_info` ELSE `t1`.`promise_info` END AS `promise_info`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`mask_post_receiver` ELSE `t1`.`mask_post_receiver` END AS `mask_post_receiver`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`mask_post_tel` ELSE `t1`.`mask_post_tel` END AS `mask_post_tel`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`mask_post_addr` ELSE `t1`.`mask_post_addr` END AS `mask_post_addr`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`user_coordinate` ELSE `t1`.`user_coordinate` END AS `user_coordinate`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`earliest_receipt_time` ELSE `t1`.`earliest_receipt_time` END AS `earliest_receipt_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`latest_receipt_time` ELSE `t1`.`latest_receipt_time` END AS `latest_receipt_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`early_arrival` ELSE `t1`.`early_arrival` END AS `early_arrival`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`target_arrival_time` ELSE `t1`.`target_arrival_time` END AS `target_arrival_time`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`packing_amount` ELSE `t1`.`packing_amount` END AS `packing_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`supermarket_order_serial_no` ELSE `t1`.`supermarket_order_serial_no` END AS `supermarket_order_serial_no`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`tax_amount` ELSE `t1`.`tax_amount` END AS `tax_amount`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`address_tag_ui` ELSE `t1`.`address_tag_ui` END AS `address_tag_ui`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`mask_pay_tel` ELSE `t1`.`mask_pay_tel` END AS `mask_pay_tel`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`encrypt_pay_tel` ELSE `t1`.`encrypt_pay_tel` END AS `encrypt_pay_tel`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`greet_words` ELSE `t1`.`greet_words` END AS `greet_words`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`pay_tel` ELSE `t1`.`pay_tel` END AS `pay_tel`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`post_receiver` ELSE `t1`.`post_receiver` END AS `post_receiver`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`open_address_id` ELSE `t1`.`open_address_id` END AS `open_address_id`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`post_tel` ELSE `t1`.`post_tel` END AS `post_tel`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`origin_data` ELSE `t1`.`origin_data` END AS `origin_data`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`yuce_cube_shop_id` ELSE `t1`.`yuce_cube_shop_id` END AS `yuce_cube_shop_id`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`dt` WHEN SUBSTRING(CAST(CASE WHEN CAST(`t1`.`pay_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`t1`.`pay_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`t1`.`pay_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`t1`.`pay_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`t1`.`pay_time` AS DECIMAL(38, 8))) AS DATETIME) END AS VARCHAR), 1, 10) IS NOT NULL THEN SUBSTRING(CAST(CASE WHEN CAST(`t1`.`pay_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`t1`.`pay_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`t1`.`pay_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`t1`.`pay_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`t1`.`pay_time` AS DECIMAL(38, 8))) AS DATETIME) END AS VARCHAR), 1, 10) ELSE '9999-12-31' END AS `dt`, CASE WHEN CASE WHEN `t1`.`update_time` IS NOT NULL THEN `t1`.`update_time` ELSE '' END < CASE WHEN `t3`.`update_time` IS NOT NULL THEN `t3`.`update_time` ELSE '' END THEN `t3`.`yuce_tenant_id` ELSE `t1`.`yuce_tenant_id` END AS `yuce_tenant_id`
FROM ((SELECT `accept_order_status` AS `accept_order_status`, `shop_id` AS `shop_id`, `shop_name` AS `shop_name`, `open_id` AS `open_id`, `order_id` AS `order_id`, `order_level` AS `order_level`, `biz` AS `biz`, `biz_desc` AS `biz_desc`, `order_type` AS `order_type`, `order_type_desc` AS `order_type_desc`, `trade_type` AS `trade_type`, `trade_type_desc` AS `trade_type_desc`, `order_status` AS `order_status`, `order_status_desc` AS `order_status_desc`, `main_status` AS `main_status`, `main_status_desc` AS `main_status_desc`, `pay_time` AS `pay_time`, `order_expire_time` AS `order_expire_time`, `finish_time` AS `finish_time`, `create_time` AS `create_time`, `update_time` AS `update_time`, `cancel_reason` AS `cancel_reason`, `buyer_words` AS `buyer_words`, `seller_words` AS `seller_words`, `b_type` AS `b_type`, `b_type_desc` AS `b_type_desc`, `sub_b_type` AS `sub_b_type`, `sub_b_type_desc` AS `sub_b_type_desc`, `app_id` AS `app_id`, `pay_type` AS `pay_type`, `channel_payment_no` AS `channel_payment_no`, `order_amount` AS `order_amount`, `pay_amount` AS `pay_amount`, `post_amount` AS `post_amount`, `post_insurance_amount` AS `post_insurance_amount`, `modify_amount` AS `modify_amount`, `modify_post_amount` AS `modify_post_amount`, `promotion_amount` AS `promotion_amount`, `promotion_shop_amount` AS `promotion_shop_amount`, `promotion_platform_amount` AS `promotion_platform_amount`, `shop_cost_amount` AS `shop_cost_amount`, `platform_cost_amount` AS `platform_cost_amount`, `promotion_talent_amount` AS `promotion_talent_amount`, `promotion_pay_amount` AS `promotion_pay_amount`, `encrypt_post_tel` AS `encrypt_post_tel`, `encrypt_post_receiver` AS `encrypt_post_receiver`, `post_addr` AS `post_addr`, `exp_ship_time` AS `exp_ship_time`, `ship_time` AS `ship_time`, `logistics_info` AS `logistics_info`, `sku_order_list` AS `sku_order_list`, `seller_remark_stars` AS `seller_remark_stars`, `order_phase_list` AS `order_phase_list`, `doudian_open_id` AS `doudian_open_id`, `serial_number_list` AS `serial_number_list`, `promotion_redpack_amount` AS `promotion_redpack_amount`, `promotion_redpack_platform_amount` AS `promotion_redpack_platform_amount`, `promotion_redpack_talent_amount` AS `promotion_redpack_talent_amount`, `appointment_ship_time` AS `appointment_ship_time`, `d_car_shop_biz_data` AS `d_car_shop_biz_data`, `shop_order_tag_ui` AS `shop_order_tag_ui`, `total_promotion_amount` AS `total_promotion_amount`, `post_origin_amount` AS `post_origin_amount`, `post_promotion_amount` AS `post_promotion_amount`, `user_tag_ui` AS `user_tag_ui`, `author_cost_amount` AS `author_cost_amount`, `only_platform_cost_amount` AS `only_platform_cost_amount`, `promise_info` AS `promise_info`, `mask_post_receiver` AS `mask_post_receiver`, `mask_post_tel` AS `mask_post_tel`, `mask_post_addr` AS `mask_post_addr`, `user_coordinate` AS `user_coordinate`, `earliest_receipt_time` AS `earliest_receipt_time`, `latest_receipt_time` AS `latest_receipt_time`, `early_arrival` AS `early_arrival`, `target_arrival_time` AS `target_arrival_time`, `packing_amount` AS `packing_amount`, `supermarket_order_serial_no` AS `supermarket_order_serial_no`, `tax_amount` AS `tax_amount`, `address_tag_ui` AS `address_tag_ui`, `mask_pay_tel` AS `mask_pay_tel`, `encrypt_pay_tel` AS `encrypt_pay_tel`, `greet_words` AS `greet_words`, `pay_tel` AS `pay_tel`, `post_receiver` AS `post_receiver`, `open_address_id` AS `open_address_id`, `post_tel` AS `post_tel`, `origin_data` AS `origin_data`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `$f94`, `$f95`, `$f96`
FROM (SELECT `accept_order_status`, `shop_id`, `shop_name`, `open_id`, `order_id`, `order_level`, `biz`, `biz_desc`, `order_type`, `order_type_desc`, `trade_type`, `trade_type_desc`, `order_status`, `order_status_desc`, `main_status`, `main_status_desc`, `pay_time`, `order_expire_time`, `finish_time`, `create_time`, `update_time`, `cancel_reason`, `buyer_words`, `seller_words`, `b_type`, `b_type_desc`, `sub_b_type`, `sub_b_type_desc`, `app_id`, `pay_type`, `channel_payment_no`, `order_amount`, `pay_amount`, `post_amount`, `post_insurance_amount`, `modify_amount`, `modify_post_amount`, `promotion_amount`, `promotion_shop_amount`, `promotion_platform_amount`, `shop_cost_amount`, `platform_cost_amount`, `promotion_talent_amount`, `promotion_pay_amount`, `encrypt_post_tel`, `encrypt_post_receiver`, `post_addr`, `exp_ship_time`, `ship_time`, `logistics_info`, `sku_order_list`, `seller_remark_stars`, `order_phase_list`, `doudian_open_id`, `serial_number_list`, `promotion_redpack_amount`, `promotion_redpack_platform_amount`, `promotion_redpack_talent_amount`, `appointment_ship_time`, `d_car_shop_biz_data`, `shop_order_tag_ui`, `total_promotion_amount`, `post_origin_amount`, `post_promotion_amount`, `user_tag_ui`, `author_cost_amount`, `only_platform_cost_amount`, `promise_info`, `mask_post_receiver`, `mask_post_tel`, `mask_post_addr`, `user_coordinate`, `earliest_receipt_time`, `latest_receipt_time`, `early_arrival`, `target_arrival_time`, `packing_amount`, `supermarket_order_serial_no`, `tax_amount`, `address_tag_ui`, `mask_pay_tel`, `encrypt_pay_tel`, `greet_words`, `pay_tel`, `post_receiver`, `open_address_id`, `post_tel`, `origin_data`, `yuce_cube_shop_id`, `yuce_tenant_id`, CASE WHEN `order_id` IS NOT NULL THEN `order_id` ELSE 'yuce@#$123456qwer' END AS `$f94`, CASE WHEN `yuce_cube_shop_id` IS NOT NULL THEN `yuce_cube_shop_id` ELSE 'yuce@#$123456qwer' END AS `$f95`, CASE WHEN `yuce_tenant_id` IS NOT NULL THEN `yuce_tenant_id` ELSE 'yuce@#$123456qwer' END AS `$f96`
FROM (SELECT `accept_order_status`, `shop_id`, `shop_name`, `open_id`, `order_id`, `order_level`, `biz`, `biz_desc`, `order_type`, `order_type_desc`, `trade_type`, `trade_type_desc`, `order_status`, `order_status_desc`, `main_status`, `main_status_desc`, `pay_time`, `order_expire_time`, `finish_time`, `create_time`, `update_time`, `cancel_reason`, `buyer_words`, `seller_words`, `b_type`, `b_type_desc`, `sub_b_type`, `sub_b_type_desc`, `app_id`, `pay_type`, `channel_payment_no`, `order_amount`, `pay_amount`, `post_amount`, `post_insurance_amount`, `modify_amount`, `modify_post_amount`, `promotion_amount`, `promotion_shop_amount`, `promotion_platform_amount`, `shop_cost_amount`, `platform_cost_amount`, `promotion_talent_amount`, `promotion_pay_amount`, `encrypt_post_tel`, `encrypt_post_receiver`, `post_addr`, `exp_ship_time`, `ship_time`, `logistics_info`, `sku_order_list`, `seller_remark_stars`, `order_phase_list`, `doudian_open_id`, `serial_number_list`, `promotion_redpack_amount`, `promotion_redpack_platform_amount`, `promotion_redpack_talent_amount`, `appointment_ship_time`, `d_car_shop_biz_data`, `shop_order_tag_ui`, `total_promotion_amount`, `post_origin_amount`, `post_promotion_amount`, `user_tag_ui`, `author_cost_amount`, `only_platform_cost_amount`, `promise_info`, `mask_post_receiver`, `mask_post_tel`, `mask_post_addr`, `user_coordinate`, `earliest_receipt_time`, `latest_receipt_time`, `early_arrival`, `target_arrival_time`, `packing_amount`, `supermarket_order_serial_no`, `tax_amount`, `address_tag_ui`, `mask_pay_tel`, `encrypt_pay_tel`, `greet_words`, `pay_tel`, `post_receiver`, `open_address_id`, `post_tel`, `origin_data`, `yuce_cube_shop_id`, `yuce_tenant_id`, `$93`, ROW_NUMBER() OVER (PARTITION BY `order_id`, `yuce_cube_shop_id`, `yuce_tenant_id` ORDER BY `$93` IS NULL DESC, `$93` DESC) AS `w0$o0`
FROM (SELECT `accept_order_status` AS `accept_order_status`, `shop_id` AS `shop_id`, `shop_name` AS `shop_name`, `open_id` AS `open_id`, `order_id` AS `order_id`, `order_level` AS `order_level`, `biz` AS `biz`, `biz_desc` AS `biz_desc`, `order_type` AS `order_type`, `order_type_desc` AS `order_type_desc`, `trade_type` AS `trade_type`, `trade_type_desc` AS `trade_type_desc`, `order_status` AS `order_status`, `order_status_desc` AS `order_status_desc`, `main_status` AS `main_status`, `main_status_desc` AS `main_status_desc`, `pay_time` AS `pay_time`, `order_expire_time` AS `order_expire_time`, `finish_time` AS `finish_time`, `create_time` AS `create_time`, `update_time` AS `update_time`, `cancel_reason` AS `cancel_reason`, `buyer_words` AS `buyer_words`, `seller_words` AS `seller_words`, `b_type` AS `b_type`, `b_type_desc` AS `b_type_desc`, `sub_b_type` AS `sub_b_type`, `sub_b_type_desc` AS `sub_b_type_desc`, `app_id` AS `app_id`, `pay_type` AS `pay_type`, `channel_payment_no` AS `channel_payment_no`, `order_amount` AS `order_amount`, `pay_amount` AS `pay_amount`, `post_amount` AS `post_amount`, `post_insurance_amount` AS `post_insurance_amount`, `modify_amount` AS `modify_amount`, `modify_post_amount` AS `modify_post_amount`, `promotion_amount` AS `promotion_amount`, `promotion_shop_amount` AS `promotion_shop_amount`, `promotion_platform_amount` AS `promotion_platform_amount`, `shop_cost_amount` AS `shop_cost_amount`, `platform_cost_amount` AS `platform_cost_amount`, `promotion_talent_amount` AS `promotion_talent_amount`, `promotion_pay_amount` AS `promotion_pay_amount`, `encrypt_post_tel` AS `encrypt_post_tel`, `encrypt_post_receiver` AS `encrypt_post_receiver`, `post_addr` AS `post_addr`, `exp_ship_time` AS `exp_ship_time`, `ship_time` AS `ship_time`, `logistics_info` AS `logistics_info`, `sku_order_list` AS `sku_order_list`, `seller_remark_stars` AS `seller_remark_stars`, `order_phase_list` AS `order_phase_list`, `doudian_open_id` AS `doudian_open_id`, `serial_number_list` AS `serial_number_list`, `promotion_redpack_amount` AS `promotion_redpack_amount`, `promotion_redpack_platform_amount` AS `promotion_redpack_platform_amount`, `promotion_redpack_talent_amount` AS `promotion_redpack_talent_amount`, `appointment_ship_time` AS `appointment_ship_time`, `d_car_shop_biz_data` AS `d_car_shop_biz_data`, `shop_order_tag_ui` AS `shop_order_tag_ui`, `total_promotion_amount` AS `total_promotion_amount`, `post_origin_amount` AS `post_origin_amount`, `post_promotion_amount` AS `post_promotion_amount`, `user_tag_ui` AS `user_tag_ui`, `author_cost_amount` AS `author_cost_amount`, `only_platform_cost_amount` AS `only_platform_cost_amount`, `promise_info` AS `promise_info`, `mask_post_receiver` AS `mask_post_receiver`, `mask_post_tel` AS `mask_post_tel`, `mask_post_addr` AS `mask_post_addr`, `user_coordinate` AS `user_coordinate`, `earliest_receipt_time` AS `earliest_receipt_time`, `latest_receipt_time` AS `latest_receipt_time`, `early_arrival` AS `early_arrival`, `target_arrival_time` AS `target_arrival_time`, `packing_amount` AS `packing_amount`, `supermarket_order_serial_no` AS `supermarket_order_serial_no`, `tax_amount` AS `tax_amount`, `address_tag_ui` AS `address_tag_ui`, `mask_pay_tel` AS `mask_pay_tel`, `encrypt_pay_tel` AS `encrypt_pay_tel`, `greet_words` AS `greet_words`, `pay_tel` AS `pay_tel`, `post_receiver` AS `post_receiver`, `open_address_id` AS `open_address_id`, `post_tel` AS `post_tel`, `origin_data` AS `origin_data`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `$93`
FROM (SELECT `t1`.`accept_order_status`, `t1`.`shop_id`, `t1`.`shop_name`, `t1`.`open_id`, `t1`.`order_id`, `t1`.`order_level`, `t1`.`biz`, `t1`.`biz_desc`, `t1`.`order_type`, `t1`.`order_type_desc`, `t1`.`trade_type`, `t1`.`trade_type_desc`, `t1`.`order_status`, `t1`.`order_status_desc`, `t1`.`main_status`, `t1`.`main_status_desc`, `t1`.`pay_time`, `t1`.`order_expire_time`, `t1`.`finish_time`, `t1`.`create_time`, `t1`.`update_time`, `t1`.`cancel_reason`, `t1`.`buyer_words`, `t1`.`seller_words`, `t1`.`b_type`, `t1`.`b_type_desc`, `t1`.`sub_b_type`, `t1`.`sub_b_type_desc`, `t1`.`app_id`, `t1`.`pay_type`, `t1`.`channel_payment_no`, `t1`.`order_amount`, `t1`.`pay_amount`, `t1`.`post_amount`, `t1`.`post_insurance_amount`, `t1`.`modify_amount`, `t1`.`modify_post_amount`, `t1`.`promotion_amount`, `t1`.`promotion_shop_amount`, `t1`.`promotion_platform_amount`, `t1`.`shop_cost_amount`, `t1`.`platform_cost_amount`, `t1`.`promotion_talent_amount`, `t1`.`promotion_pay_amount`, `t1`.`encrypt_post_tel`, `t1`.`encrypt_post_receiver`, `t1`.`post_addr`, `t1`.`exp_ship_time`, `t1`.`ship_time`, `t1`.`logistics_info`, `t1`.`sku_order_list`, `t1`.`seller_remark_stars`, `t1`.`order_phase_list`, `t1`.`doudian_open_id`, `t1`.`serial_number_list`, `t1`.`promotion_redpack_amount`, `t1`.`promotion_redpack_platform_amount`, `t1`.`promotion_redpack_talent_amount`, `t1`.`appointment_ship_time`, `t1`.`d_car_shop_biz_data`, `t1`.`shop_order_tag_ui`, `t1`.`total_promotion_amount`, `t1`.`post_origin_amount`, `t1`.`post_promotion_amount`, `t1`.`user_tag_ui`, `t1`.`author_cost_amount`, `t1`.`only_platform_cost_amount`, `t1`.`promise_info`, `t1`.`mask_post_receiver`, `t1`.`mask_post_tel`, `t1`.`mask_post_addr`, `t1`.`user_coordinate`, `t1`.`earliest_receipt_time`, `t1`.`latest_receipt_time`, `t1`.`early_arrival`, `t1`.`target_arrival_time`, `t1`.`packing_amount`, `t1`.`supermarket_order_serial_no`, `t1`.`tax_amount`, `t1`.`address_tag_ui`, `t1`.`mask_pay_tel`, `t1`.`encrypt_pay_tel`, `t1`.`greet_words`, `t1`.`pay_tel`, `t1`.`post_receiver`, `t1`.`open_address_id`, `t1`.`post_tel`, `t1`.`origin_data`, `t1`.`yuce_cube_shop_id`, `t1`.`yuce_tenant_id`, CASE WHEN CAST(`t1`.`update_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`t1`.`update_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`t1`.`update_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`t1`.`update_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`t1`.`update_time` AS DECIMAL(38, 8))) AS DATETIME) END AS `$93`
FROM `lake`.`saas_datalake`.`tmp_ods_api_dd_sale_order_list_info_du` t1) AS `t1`) AS `t1`) AS `t1`
WHERE `w0$o0` = 1) AS `t1`) AS `t1` FULL JOIN (SELECT `accept_order_status` AS `accept_order_status`, `shop_id` AS `shop_id`, `shop_name` AS `shop_name`, `open_id` AS `open_id`, `order_id` AS `order_id`, `order_level` AS `order_level`, `biz` AS `biz`, `biz_desc` AS `biz_desc`, `order_type` AS `order_type`, `order_type_desc` AS `order_type_desc`, `trade_type` AS `trade_type`, `trade_type_desc` AS `trade_type_desc`, `order_status` AS `order_status`, `order_status_desc` AS `order_status_desc`, `main_status` AS `main_status`, `main_status_desc` AS `main_status_desc`, `pay_time` AS `pay_time`, `order_expire_time` AS `order_expire_time`, `finish_time` AS `finish_time`, `create_time` AS `create_time`, `update_time` AS `update_time`, `cancel_reason` AS `cancel_reason`, `buyer_words` AS `buyer_words`, `seller_words` AS `seller_words`, `b_type` AS `b_type`, `b_type_desc` AS `b_type_desc`, `sub_b_type` AS `sub_b_type`, `sub_b_type_desc` AS `sub_b_type_desc`, `app_id` AS `app_id`, `pay_type` AS `pay_type`, `channel_payment_no` AS `channel_payment_no`, `order_amount` AS `order_amount`, `pay_amount` AS `pay_amount`, `post_amount` AS `post_amount`, `post_insurance_amount` AS `post_insurance_amount`, `modify_amount` AS `modify_amount`, `modify_post_amount` AS `modify_post_amount`, `promotion_amount` AS `promotion_amount`, `promotion_shop_amount` AS `promotion_shop_amount`, `promotion_platform_amount` AS `promotion_platform_amount`, `shop_cost_amount` AS `shop_cost_amount`, `platform_cost_amount` AS `platform_cost_amount`, `promotion_talent_amount` AS `promotion_talent_amount`, `promotion_pay_amount` AS `promotion_pay_amount`, `encrypt_post_tel` AS `encrypt_post_tel`, `encrypt_post_receiver` AS `encrypt_post_receiver`, `post_addr` AS `post_addr`, `exp_ship_time` AS `exp_ship_time`, `ship_time` AS `ship_time`, `logistics_info` AS `logistics_info`, `sku_order_list` AS `sku_order_list`, `seller_remark_stars` AS `seller_remark_stars`, `order_phase_list` AS `order_phase_list`, `doudian_open_id` AS `doudian_open_id`, `serial_number_list` AS `serial_number_list`, `promotion_redpack_amount` AS `promotion_redpack_amount`, `promotion_redpack_platform_amount` AS `promotion_redpack_platform_amount`, `promotion_redpack_talent_amount` AS `promotion_redpack_talent_amount`, `appointment_ship_time` AS `appointment_ship_time`, `d_car_shop_biz_data` AS `d_car_shop_biz_data`, `shop_order_tag_ui` AS `shop_order_tag_ui`, `total_promotion_amount` AS `total_promotion_amount`, `post_origin_amount` AS `post_origin_amount`, `post_promotion_amount` AS `post_promotion_amount`, `user_tag_ui` AS `user_tag_ui`, `author_cost_amount` AS `author_cost_amount`, `only_platform_cost_amount` AS `only_platform_cost_amount`, `promise_info` AS `promise_info`, `mask_post_receiver` AS `mask_post_receiver`, `mask_post_tel` AS `mask_post_tel`, `mask_post_addr` AS `mask_post_addr`, `user_coordinate` AS `user_coordinate`, `earliest_receipt_time` AS `earliest_receipt_time`, `latest_receipt_time` AS `latest_receipt_time`, `early_arrival` AS `early_arrival`, `target_arrival_time` AS `target_arrival_time`, `packing_amount` AS `packing_amount`, `supermarket_order_serial_no` AS `supermarket_order_serial_no`, `tax_amount` AS `tax_amount`, `address_tag_ui` AS `address_tag_ui`, `mask_pay_tel` AS `mask_pay_tel`, `encrypt_pay_tel` AS `encrypt_pay_tel`, `greet_words` AS `greet_words`, `pay_tel` AS `pay_tel`, `post_receiver` AS `post_receiver`, `open_address_id` AS `open_address_id`, `post_tel` AS `post_tel`, `origin_data` AS `origin_data`, `yuce_cube_shop_id` AS `yuce_cube_shop_id`, `yuce_tenant_id` AS `yuce_tenant_id`, `dt` AS `dt`, `$f91`, `$f92`, `$f93`
FROM (SELECT `t`.`accept_order_status`, `t`.`shop_id`, `t`.`shop_name`, `t`.`open_id`, `t`.`order_id`, `t`.`order_level`, `t`.`biz`, `t`.`biz_desc`, `t`.`order_type`, `t`.`order_type_desc`, `t`.`trade_type`, `t`.`trade_type_desc`, `t`.`order_status`, `t`.`order_status_desc`, `t`.`main_status`, `t`.`main_status_desc`, `t`.`pay_time`, `t`.`order_expire_time`, `t`.`finish_time`, `t`.`create_time`, `t`.`update_time`, `t`.`cancel_reason`, `t`.`buyer_words`, `t`.`seller_words`, `t`.`b_type`, `t`.`b_type_desc`, `t`.`sub_b_type`, `t`.`sub_b_type_desc`, `t`.`app_id`, `t`.`pay_type`, `t`.`channel_payment_no`, `t`.`order_amount`, `t`.`pay_amount`, `t`.`post_amount`, `t`.`post_insurance_amount`, `t`.`modify_amount`, `t`.`modify_post_amount`, `t`.`promotion_amount`, `t`.`promotion_shop_amount`, `t`.`promotion_platform_amount`, `t`.`shop_cost_amount`, `t`.`platform_cost_amount`, `t`.`promotion_talent_amount`, `t`.`promotion_pay_amount`, `t`.`encrypt_post_tel`, `t`.`encrypt_post_receiver`, `t`.`post_addr`, `t`.`exp_ship_time`, `t`.`ship_time`, `t`.`logistics_info`, `t`.`sku_order_list`, `t`.`seller_remark_stars`, `t`.`order_phase_list`, `t`.`doudian_open_id`, `t`.`serial_number_list`, `t`.`promotion_redpack_amount`, `t`.`promotion_redpack_platform_amount`, `t`.`promotion_redpack_talent_amount`, `t`.`appointment_ship_time`, `t`.`d_car_shop_biz_data`, `t`.`shop_order_tag_ui`, `t`.`total_promotion_amount`, `t`.`post_origin_amount`, `t`.`post_promotion_amount`, `t`.`user_tag_ui`, `t`.`author_cost_amount`, `t`.`only_platform_cost_amount`, `t`.`promise_info`, `t`.`mask_post_receiver`, `t`.`mask_post_tel`, `t`.`mask_post_addr`, `t`.`user_coordinate`, `t`.`earliest_receipt_time`, `t`.`latest_receipt_time`, `t`.`early_arrival`, `t`.`target_arrival_time`, `t`.`packing_amount`, `t`.`supermarket_order_serial_no`, `t`.`tax_amount`, `t`.`address_tag_ui`, `t`.`mask_pay_tel`, `t`.`encrypt_pay_tel`, `t`.`greet_words`, `t`.`pay_tel`, `t`.`post_receiver`, `t`.`open_address_id`, `t`.`post_tel`, `t`.`origin_data`, `t`.`yuce_cube_shop_id`, `t`.`yuce_tenant_id`, `t`.`dt`, CASE WHEN `t`.`order_id` IS NOT NULL THEN `t`.`order_id` ELSE 'yuce@#$123456qwer' END AS `$f91`, CASE WHEN `t`.`yuce_cube_shop_id` IS NOT NULL THEN `t`.`yuce_cube_shop_id` ELSE 'yuce@#$123456qwer' END AS `$f92`, CASE WHEN `t`.`yuce_tenant_id` IS NOT NULL THEN `t`.`yuce_tenant_id` ELSE 'yuce@#$123456qwer' END AS `$f93`
FROM ((SELECT `tmp_ods_api_dd_sale_order_list_info_f`.`accept_order_status`, `tmp_ods_api_dd_sale_order_list_info_f`.`shop_id`, `tmp_ods_api_dd_sale_order_list_info_f`.`shop_name`, `tmp_ods_api_dd_sale_order_list_info_f`.`open_id`, `tmp_ods_api_dd_sale_order_list_info_f`.`order_id`, `tmp_ods_api_dd_sale_order_list_info_f`.`order_level`, `tmp_ods_api_dd_sale_order_list_info_f`.`biz`, `tmp_ods_api_dd_sale_order_list_info_f`.`biz_desc`, `tmp_ods_api_dd_sale_order_list_info_f`.`order_type`, `tmp_ods_api_dd_sale_order_list_info_f`.`order_type_desc`, `tmp_ods_api_dd_sale_order_list_info_f`.`trade_type`, `tmp_ods_api_dd_sale_order_list_info_f`.`trade_type_desc`, `tmp_ods_api_dd_sale_order_list_info_f`.`order_status`, `tmp_ods_api_dd_sale_order_list_info_f`.`order_status_desc`, `tmp_ods_api_dd_sale_order_list_info_f`.`main_status`, `tmp_ods_api_dd_sale_order_list_info_f`.`main_status_desc`, `tmp_ods_api_dd_sale_order_list_info_f`.`pay_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`order_expire_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`finish_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`create_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`update_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`cancel_reason`, `tmp_ods_api_dd_sale_order_list_info_f`.`buyer_words`, `tmp_ods_api_dd_sale_order_list_info_f`.`seller_words`, `tmp_ods_api_dd_sale_order_list_info_f`.`b_type`, `tmp_ods_api_dd_sale_order_list_info_f`.`b_type_desc`, `tmp_ods_api_dd_sale_order_list_info_f`.`sub_b_type`, `tmp_ods_api_dd_sale_order_list_info_f`.`sub_b_type_desc`, `tmp_ods_api_dd_sale_order_list_info_f`.`app_id`, `tmp_ods_api_dd_sale_order_list_info_f`.`pay_type`, `tmp_ods_api_dd_sale_order_list_info_f`.`channel_payment_no`, `tmp_ods_api_dd_sale_order_list_info_f`.`order_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`pay_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`post_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`post_insurance_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`modify_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`modify_post_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`promotion_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`promotion_shop_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`promotion_platform_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`shop_cost_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`platform_cost_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`promotion_talent_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`promotion_pay_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`encrypt_post_tel`, `tmp_ods_api_dd_sale_order_list_info_f`.`encrypt_post_receiver`, `tmp_ods_api_dd_sale_order_list_info_f`.`post_addr`, `tmp_ods_api_dd_sale_order_list_info_f`.`exp_ship_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`ship_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`logistics_info`, `tmp_ods_api_dd_sale_order_list_info_f`.`sku_order_list`, `tmp_ods_api_dd_sale_order_list_info_f`.`seller_remark_stars`, `tmp_ods_api_dd_sale_order_list_info_f`.`order_phase_list`, `tmp_ods_api_dd_sale_order_list_info_f`.`doudian_open_id`, `tmp_ods_api_dd_sale_order_list_info_f`.`serial_number_list`, `tmp_ods_api_dd_sale_order_list_info_f`.`promotion_redpack_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`promotion_redpack_platform_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`promotion_redpack_talent_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`appointment_ship_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`d_car_shop_biz_data`, `tmp_ods_api_dd_sale_order_list_info_f`.`shop_order_tag_ui`, `tmp_ods_api_dd_sale_order_list_info_f`.`total_promotion_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`post_origin_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`post_promotion_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`user_tag_ui`, `tmp_ods_api_dd_sale_order_list_info_f`.`author_cost_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`only_platform_cost_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`promise_info`, `tmp_ods_api_dd_sale_order_list_info_f`.`mask_post_receiver`, `tmp_ods_api_dd_sale_order_list_info_f`.`mask_post_tel`, `tmp_ods_api_dd_sale_order_list_info_f`.`mask_post_addr`, `tmp_ods_api_dd_sale_order_list_info_f`.`user_coordinate`, `tmp_ods_api_dd_sale_order_list_info_f`.`earliest_receipt_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`latest_receipt_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`early_arrival`, `tmp_ods_api_dd_sale_order_list_info_f`.`target_arrival_time`, `tmp_ods_api_dd_sale_order_list_info_f`.`packing_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`supermarket_order_serial_no`, `tmp_ods_api_dd_sale_order_list_info_f`.`tax_amount`, `tmp_ods_api_dd_sale_order_list_info_f`.`address_tag_ui`, `tmp_ods_api_dd_sale_order_list_info_f`.`mask_pay_tel`, `tmp_ods_api_dd_sale_order_list_info_f`.`encrypt_pay_tel`, `tmp_ods_api_dd_sale_order_list_info_f`.`greet_words`, `tmp_ods_api_dd_sale_order_list_info_f`.`pay_tel`, `tmp_ods_api_dd_sale_order_list_info_f`.`post_receiver`, `tmp_ods_api_dd_sale_order_list_info_f`.`open_address_id`, `tmp_ods_api_dd_sale_order_list_info_f`.`post_tel`, `tmp_ods_api_dd_sale_order_list_info_f`.`origin_data`, `tmp_ods_api_dd_sale_order_list_info_f`.`yuce_cube_shop_id`, `tmp_ods_api_dd_sale_order_list_info_f`.`yuce_tenant_id`, `tmp_ods_api_dd_sale_order_list_info_f`.`dt`, `tmp_ods_api_dd_sale_order_list_info_du0`.`$f0`, `tmp_ods_api_dd_sale_order_list_info_du0`.`$f1`, `tmp_ods_api_dd_sale_order_list_info_f`.`dt` AS `dt0`
FROM (`lake`.`saas_datalake`.`tmp_ods_api_dd_sale_order_list_info_f` INNER JOIN (SELECT COUNT(*) AS `$f0`, COUNT(`EXPR$0`) AS `$f1`
FROM (SELECT `EXPR$0`
FROM (SELECT SUBSTRING(CAST(CASE WHEN CAST(`t1`.`pay_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`t1`.`pay_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`t1`.`pay_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`t1`.`pay_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`t1`.`pay_time` AS DECIMAL(38, 8))) AS DATETIME) END AS VARCHAR), 1, 10) AS `EXPR$0`
FROM `lake`.`saas_datalake`.`tmp_ods_api_dd_sale_order_list_info_du` t1) AS `tmp_ods_api_dd_sale_order_list_info_du0`
GROUP BY `EXPR$0`) AS `tmp_ods_api_dd_sale_order_list_info_du0`) AS `tmp_ods_api_dd_sale_order_list_info_du0` ON TRUE)) AS `t` LEFT JOIN (SELECT `EXPR$0`, MIN(`$f1`) AS `$f1`
FROM (SELECT `EXPR$0`, 1 AS `$f1`
FROM (SELECT SUBSTRING(CAST(CASE WHEN CAST(`tmp_ods_api_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) > 99999999999 THEN CAST(FROM_UNIXTIME(CAST(`tmp_ods_api_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) / 1000) AS DATETIME) WHEN CAST(`tmp_ods_api_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)) < 30000000 THEN str_to_date(CAST(`tmp_ods_api_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8)), '%Y%m%d') ELSE CAST(FROM_UNIXTIME(CAST(`tmp_ods_api_dd_sale_order_list_info_du`.`pay_time` AS DECIMAL(38, 8))) AS DATETIME) END AS VARCHAR), 1, 10) AS `EXPR$0`
FROM `lake`.`saas_datalake`.`tmp_ods_api_dd_sale_order_list_info_du`) AS `tmp_ods_api_dd_sale_order_list_info_du1`
GROUP BY `EXPR$0`) AS `tmp_ods_api_dd_sale_order_list_info_du1`
GROUP BY `EXPR$0`) AS `tmp_ods_api_dd_sale_order_list_info_du1` ON `t`.`dt0` = `tmp_ods_api_dd_sale_order_list_info_du1`.`EXPR$0`)
WHERE ((`tmp_ods_api_dd_sale_order_list_info_du1`.`$f1` IS NOT NULL AND NOT `t`.`$f0` = 0)) OR `t`.`dt` = '9999-12-31') AS `t2`) AS `t3` ON ((`tmp_ods_api_dd_sale_order_list_info_du`.`$f94` = `t3`.`$f91` AND `tmp_ods_api_dd_sale_order_list_info_du`.`$f95` = `t3`.`$f92`) AND `tmp_ods_api_dd_sale_order_list_info_du`.`$f96` = `t3`.`$f93`))) AS `t5`)
【背景】做过哪些操作？
执行计划上是 大表 full join 右表 row_number开窗去重 结果再写入到iceberg
由于分区比较多 写入速度比较慢, 整体的背压会比较高, full join 和 row_number开窗 的spill落盘时内存消耗非常高
【业务影响】
【是否存算分离】
【StarRocks版本】例如: 3.3.10
【集群规模】例如：3fe（3 follower+0observer）+3be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
- fe.log/beINFO/相应截图
- 慢查询：
- Profile信息，获取Profile，通过Profile分析查询瓶颈
- 并行度：show variables like ‘%parallel_fragment_exec_instance_num%’;
pipeline_dop=1 - pipeline是否开启：show variables like ‘%pipeline%’;
- be节点cpu和内存使用率截图
- 查询报错：
- query_dump，怎么获取query_dump文件
- be crash
- be.out
- coredump，如何获取coredump
- 外表查询报错
- be.out和fe.warn.log