sql查询条件不同导致结果出错

[U_1696757345648_2421]

【详述】常用sql语句,查询条件的一个值不同,导致了报错
【背景】查询
【业务影响】查询无正确结果返回
【StarRocks版本】2.5.7版
【集群规模】例如：3fe（1 leader + 2 follower）+3be（fe与be分开部署）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/128G/千兆网
【表模型】明细模型
【附件】

[U_1696757345648_2421]

查询语句是 SELECT ALI_T_1_.c_kind_cnm AS T_AED_2_, ALI_T_1_.c_kind_cnm AS
T_AFA_3_ FROM app.app_fin_procedures_fee_detail AS ALI_T_1_
WHERE (case
when ALI_T_1_.c_kind_cnm in (‘机动车辆保险’) then ‘车险’
when ALI_T_1_.c_kind_cnm in (‘农业保险’,‘种植险’,‘养殖险’) then ‘农业保险’
when ALI_T_1_.c_kind_cnm in (‘健康险’,‘意外险’,‘人身险’) then ‘人身险’
when ALI_T_1_.c_kind_cnm not in (‘健康险’,‘意外险’,‘人身险’,‘农业保险’,‘种植险’,‘养殖险’) then ‘财产险’
end )= ‘车险’ AND ALI_T_1_.c_dptcnm_2nd IN (‘广东省分公司’) GROUP BY ALI_T_1_.c_kind_cnm LIMIT 0, 30000
建表语句是
CREATE TABLE app.app_fin_procedures_fee_detail (
c_dptcnm_2nd varchar(65533) NULL COMMENT “二级机构名称”,
c_dptcnm_3rd varchar(65533) NULL COMMENT “三级机构名称”,
c_dptcnm_4th varchar(65533) NULL COMMENT “四级机构名称”,
c_dptcnm_5th varchar(65533) NULL COMMENT “五级机构名称”,
c_ply_no varchar(65533) NULL COMMENT “保单号”,
c_app_no varchar(65533) NULL COMMENT “申请单号”,
c_edr_no varchar(65533) NULL COMMENT “批单号”,
t_ply_crt_tm datetime NULL COMMENT “保单生成时间”,
t_sign_tm datetime NULL COMMENT “签单日期”,
t_edr_bgn_tm datetime NULL COMMENT “批改生效起期”,
c_kind_cnm varchar(65533) NULL COMMENT “产品大类名称”,
c_prod_cnm varchar(65533) NULL COMMENT “产品名称”,
c_agt_cnm varchar(65533) NULL COMMENT “代理机构名称(代理人/经纪人名称)”,
c_brk_sls_cnm varchar(65533) NULL COMMENT “代理业务员”,
c_salegrp_cnm varchar(65533) NULL COMMENT “销售团队”,
c_sls_cnm varchar(65533) NULL COMMENT “业务员名称”,
t_insrnc_bgn_tm datetime NULL COMMENT “保险起期”,
t_insrnc_end_tm datetime NULL COMMENT “保险止期”,
c_insured_cnm varchar(65533) NULL COMMENT “被保人名称”,
n_after_tax_prem_fee double NULL COMMENT “签单保费含税 e.n_after_tax_prem (税后保费),e.n_tax_fee(税费)”,
n_after_tax_prem double NULL COMMENT “签单保费不含税”,
n_edr_prem double NULL COMMENT “批单增减保费”,
c_bsns_type_cnm varchar(65533) NULL COMMENT “一级渠道”,
c_single_cnm varchar(65533) NULL COMMENT “出单员/录单人”,
c_app_cnm varchar(65533) NULL COMMENT “投保人”,
n_bef_prm double NULL COMMENT “折前保费”,
n_amt_rmb double NULL COMMENT “保险金额”,
c_edr_typ varchar(65533) NULL COMMENT “批改类型”,
n_edr_prj_no double NULL COMMENT “批改序号”,
c_orig_flg varchar(65533) NULL COMMENT “转续保标识”,
n_irr_ratio double NULL COMMENT “总折扣率”,
c_grp_id varchar(65533) NULL COMMENT “渠道标识码”,
c_grp_cnm varchar(65533) NULL COMMENT “渠道标识码名称”,
n_comm_fee double NULL COMMENT “手续费金额”,
n_cmm_prop double NULL COMMENT “手续费比例”,
n_comm_vat double NULL COMMENT “手续费(税费)”,
n_comm_sum double NULL COMMENT “手续费含税金额”,
n_sls_base_perf double NULL COMMENT “浮动绩效工资”,
n_sls_base_prop double NULL COMMENT “浮动绩效比例”,
n_sls_base_vat double NULL COMMENT “浮动绩效工资(税费)”,
n_sls_base_sum double NULL COMMENT “浮动绩效工资含税”,
n_maint_fee_var double NULL COMMENT “管理费用”,
n_maint_prop double NULL COMMENT “管理费用比例”,
n_maint_var double NULL COMMENT “管理费用(税费)”,
n_maint_sum double NULL COMMENT “管理费用含税”,
n_a_fee double NULL COMMENT “A费用”,
n_a_prop double NULL COMMENT “A费用比例”,
n_a_vat double NULL COMMENT “A费用(税费)”,
n_a_sum double NULL COMMENT “A费用含税”,
c_plate_no varchar(65533) NULL COMMENT “车牌号[车险]”,
c_is_new_vhl varchar(65533) NULL COMMENT “是否新车[车险]”,
c_ecdemic_mrk varchar(65533) NULL COMMENT “是否外地车[车险]”,
c_is_change_nme varchar(65533) NULL COMMENT “是否过户车[车险]”,
c_vhl_mod varchar(65533) NULL COMMENT “品牌车型[车险]”,
c_usage_cde varchar(65533) NULL COMMENT “使用性质[车险]”,
c_car_typ varchar(65533) NULL COMMENT “车辆种类[车险]”,
c_vhl_typ varchar(65533) NULL COMMENT “机动车种类[车险]”,
c_clm_coefficient_front varchar(65533) NULL COMMENT “无赔款优待及上年赔款记录[车险]【综改前】”,
c_clm_coefficient_after varchar(65533) NULL COMMENT “无赔款优待及上年赔款记录[车险]【综改后】”,
c_ndisc_rsn_cnm varchar(65533) NULL COMMENT “不浮动原因 [车险]”,
n_catdamage_prem double NULL COMMENT “车损保费[车险]”,
n_the_three_prem double NULL COMMENT “三者保费[车险]”,
c_ply_type01 varchar(65533) NULL COMMENT “是否单保交强险”,
c_owner_nme varchar(65533) NULL COMMENT “车主[车险]”,
t_debut_tm datetime NULL COMMENT “初登日期[车险]”,
c_vhl_used_year varchar(65533) NULL COMMENT “车龄[车险]”,
c_new_purchase_stage varchar(65533) NULL COMMENT “新车购置价[车险]”,
n_seat_num double NULL COMMENT “座位数[车险]”,
c_self_cha_coef varchar(65533) NULL COMMENT “自主渠道系数[车险]”,
c_self_undr_coef varchar(65533) NULL COMMENT “自主核保系数[车险]”,
n_robbery_prm double NULL COMMENT “盗抢险保费[车险]”,
c_ply_type05 varchar(65533) NULL COMMENT “是否单商业险[车险]”,
c_frm_no varchar(65533) NULL COMMENT “车架号[车险]”,
c_eng_no varchar(65533) NULL COMMENT “发动机号[车险]”,
n_std_tonage double NULL COMMENT “核定载质量[车险]”,
n_driver_amt double NULL COMMENT “司机险别的保额[车险]”,
n_passenger_amt double NULL COMMENT “乘客险别的保额[车险]”,
c_cus_flag varchar(65533) NULL COMMENT “客户标志[车险]”,
c_group_cnm varchar(65533) NULL COMMENT “集团名称[车险]”,
n_the_three_amt double NULL COMMENT “第三者保额[车险]”,
c_prm_state varchar(65533) NULL COMMENT “保费会计状态[待取数]”,
c_energy_typ varchar(65533) NULL COMMENT “车辆能源类型[车险]”,
c_undr_cnm varchar(65533) NULL COMMENT “核保人名称”,
n_displacement double NULL COMMENT “排气量[车险]”,
c_repair_cde varchar(65533) NULL COMMENT “车辆送修码[车险]”,
t_transfer_date datetime NULL COMMENT “转移登记（过户）日期”,
c_brand_id varchar(65533) NULL COMMENT “车辆品牌”,
n_ctpsunlightscore double NULL COMMENT “交强险光博分”,
n_comsunlightscore double NULL COMMENT “商业险光博分”,
n_sunlightscore double NULL COMMENT “整单光博分”,
vhl_damage_grade_prediction varchar(65533) NULL COMMENT “车损分档”,
the_three_are_forecast varchar(65533) NULL COMMENT “三者评分分档”,
total_tranche varchar(65533) NULL COMMENT “三者+车损分档”,
compulsory_insurance_sub_file varchar(65533) NULL COMMENT “交强险分档”,
c_brand_nme varchar(65533) NULL COMMENT “品牌车系”,
n_entire_fit_disc double NULL COMMENT “精算折扣”,
n_pricing_adjust_value double NULL COMMENT “自主定价系数”,
c_claim_adjust_level varchar(65533) NULL COMMENT “无赔优待系数级别”,
c_ago_clm_rec double NULL COMMENT “无赔优待系数等级系数”,
t_paid_tm_caiwu datetime NULL COMMENT “复合日期”,
c_dpt_cde varchar(65533) NULL COMMENT “机构代码”,
c_dpt_cnm varchar(65533) NULL COMMENT “机构名称”,
t_ply_bgn_tm datetime NULL COMMENT “批单生效日期”,
c_prem_cur varchar(65533) NULL COMMENT “币种(保费)”,
n_prem_rmb double NULL COMMENT “总保费”,
n_real_paid_prem double NULL COMMENT “实收保费”,
n_receivable_prem double NULL COMMENT “应收保费”,
n_b_fee double NULL COMMENT “B费用”,
n_b_prop double NULL COMMENT “B费用比例”,
n_b_vat double NULL COMMENT “B费用(税费)”,
n_b_fee_sum double NULL COMMENT “B费用含税”,
n_c_fee double NULL COMMENT “C费用”,
n_c_prop double NULL COMMENT “C费用比例”,
n_c_vat double NULL COMMENT “C费用(税费)”,
n_c_fee_sum double NULL COMMENT “C费用含税”,
t_real_paid_tm datetime NULL COMMENT “实收日期”,
c_cha_type_cnm varchar(65533) NULL COMMENT “二级渠道”,
c_cha_subtype_cnm varchar(65533) NULL COMMENT “三级渠道”,
c_ecdemic_mrk_typ varchar(65533) NULL COMMENT “过户车类别”,
c_if_unload varchar(65533) NULL COMMENT “是否自卸”,
n_resv_num_1 double NULL COMMENT “业务份额”,
c_ci_typ varchar(65533) NULL COMMENT “共保录单方式”,
c_sys_source varchar(65533) NULL COMMENT “出单来源”,
vehicle_score varchar(65533) NULL COMMENT “单车UBI(车损+三者)”,
c_t_total_tranche varchar(65533) NULL COMMENT “团车三者+车损分档”,
c_is_nvhl varchar(65533) NULL COMMENT “是否非车,车”,
n_ctpsunlightscore_gl double NULL COMMENT “交强险光博评分_关联”,
c_unfix_spc varchar(65533) NULL COMMENT “特别约定”,
n_ply_fee_rate double NULL COMMENT “共保出单费比例”,
c_constr_item varchar(65533) NULL COMMENT “险种特殊字段显示”,
n_nvhl_coef double NULL COMMENT “非车系数”
,c_remark STRING COMMENT ‘保单备注’,
c_pkg_no STRING COMMENT ‘统保代码’,
c_cal_radix STRING COMMENT ‘出单费计算基数’,
n_ply_fee DOUBLE COMMENT ‘出单费’,
n_ply_fee_tax DOUBLE COMMENT ‘出单费税额’,
n_ply_fee_exc_vat DOUBLE COMMENT ‘不含税出单费’
)
DUPLICATE KEY(c_dptcnm_2nd,c_dptcnm_3rd)
COMMENT ‘手续费清单’
DISTRIBUTED BY HASH( c_dptcnm_5th,c_ply_no)
PROPERTIES(
“replication_num” = “2”
);

[U_1696757345648_2421]

{“statement”:“SELECT ALI_T_1_.c_kind_cnm AS T_AED_2_, ALI_T_1_.c_kind_cnm AS\nT_AFA_3_ FROM app.app_fin_procedures_fee_detail AS ALI_T_1_ \nWHERE (CASE\nWHEN ALI_T_1_.c_kind_cnm IN (‘机动车辆保险’) THEN ‘车险’\nWHEN ALI_T_1_.c_kind_cnm IN (‘农业保险’,‘种植险’,‘养殖险’) THEN ‘农业保险’\nWHEN ALI_T_1_.c_kind_cnm IN (‘健康险’,‘意外险’,‘人身险’) THEN ‘人身险’ \nWHEN ALI_T_1_.c_kind_cnm NOT IN (‘健康险’,‘意外险’,‘人身险’,‘农业保险’,‘种植险’,‘养殖险’) THEN ‘财产险’\nEND )= ‘车险’ AND ALI_T_1_.c_dptcnm_2nd IN (‘广东省分公司’) GROUP BY ALI_T_1_.c_kind_cnm”,“table_meta”:{“app.app_fin_procedures_fee_detail”:“CREATE TABLE app_fin_procedures_fee_detail (\n c_dptcnm_2nd varchar(65533) NULL COMMENT “二级机构名称”,\n c_dptcnm_3rd varchar(65533) NULL COMMENT “三级机构名称”,\n c_dptcnm_4th varchar(65533) NULL COMMENT “四级机构名称”,\n c_dptcnm_5th varchar(65533) NULL COMMENT “五级机构名称”,\n c_ply_no varchar(65533) NULL COMMENT “保单号”,\n c_app_no varchar(65533) NULL COMMENT “申请单号”,\n c_edr_no varchar(65533) NULL COMMENT “批单号”,\n t_ply_crt_tm datetime NULL COMMENT “保单生成时间”,\n t_sign_tm datetime NULL COMMENT “签单日期”,\n t_edr_bgn_tm datetime NULL COMMENT “批改生效起期”,\n c_kind_cnm varchar(65533) NULL COMMENT “产品大类名称”,\n c_prod_cnm varchar(65533) NULL COMMENT “产品名称”,\n c_agt_cnm varchar(65533) NULL COMMENT “代理机构名称(代理人/经纪人名称)”,\n c_brk_sls_cnm varchar(65533) NULL COMMENT “代理业务员”,\n c_salegrp_cnm varchar(65533) NULL COMMENT “销售团队”,\n c_sls_cnm varchar(65533) NULL COMMENT “业务员名称”,\n t_insrnc_bgn_tm datetime NULL COMMENT “保险起期”,\n t_insrnc_end_tm datetime NULL COMMENT “保险止期”,\n c_insured_cnm varchar(65533) NULL COMMENT “被保人名称”,\n n_after_tax_prem_fee double NULL COMMENT “签单保费含税 e.n_after_tax_prem (税后保费),e.n_tax_fee(税费)”,\n n_after_tax_prem double NULL COMMENT “签单保费不含税”,\n n_edr_prem double NULL COMMENT “批单增减保费”,\n c_bsns_type_cnm varchar(65533) NULL COMMENT “一级渠道”,\n c_single_cnm varchar(65533) NULL COMMENT “出单员/录单人”,\n c_app_cnm varchar(65533) NULL COMMENT “投保人”,\n n_bef_prm double NULL COMMENT “折前保费”,\n n_amt_rmb double NULL COMMENT “保险金额”,\n c_edr_typ varchar(65533) NULL COMMENT “批改类型”,\n n_edr_prj_no double NULL COMMENT “批改序号”,\n c_orig_flg varchar(65533) NULL COMMENT “转续保标识”,\n n_irr_ratio double NULL COMMENT “总折扣率”,\n c_grp_id varchar(65533) NULL COMMENT “渠道标识码”,\n c_grp_cnm varchar(65533) NULL COMMENT “渠道标识码名称”,\n n_comm_fee double NULL COMMENT “手续费金额”,\n n_cmm_prop double NULL COMMENT “手续费比例”,\n n_comm_vat double NULL COMMENT “手续费(税费)”,\n n_comm_sum double NULL COMMENT “手续费含税金额”,\n n_sls_base_perf double NULL COMMENT “浮动绩效工资”,\n n_sls_base_prop double NULL COMMENT “浮动绩效比例”,\n n_sls_base_vat double NULL COMMENT “浮动绩效工资(税费)”,\n n_sls_base_sum double NULL COMMENT “浮动绩效工资含税”,\n n_maint_fee_var double NULL COMMENT “管理费用”,\n n_maint_prop double NULL COMMENT “管理费用比例”,\n n_maint_var double NULL COMMENT “管理费用(税费)”,\n n_maint_sum double NULL COMMENT “管理费用含税”,\n n_a_fee double NULL COMMENT “A费用”,\n n_a_prop double NULL COMMENT “A费用比例”,\n n_a_vat double NULL COMMENT “A费用(税费)”,\n n_a_sum double NULL COMMENT “A费用含税”,\n c_plate_no varchar(65533) NULL COMMENT “车牌号[车险]”,\n c_is_new_vhl varchar(65533) NULL COMMENT “是否新车[车险]”,\n c_ecdemic_mrk varchar(65533) NULL COMMENT “是否外地车[车险]”,\n c_is_change_nme varchar(65533) NULL COMMENT “是否过户车[车险]”,\n c_vhl_mod varchar(65533) NULL COMMENT “品牌车型[车险]”,\n c_usage_cde varchar(65533) NULL COMMENT “使用性质[车险]”,\n c_car_typ varchar(65533) NULL COMMENT “车辆种类[车险]”,\n c_vhl_typ varchar(65533) NULL COMMENT “机动车种类[车险]”,\n c_clm_coefficient_front varchar(65533) NULL COMMENT “无赔款优待及上年赔款记录[车险]【综改前】”,\n c_clm_coefficient_after varchar(65533) NULL COMMENT “无赔款优待及上年赔款记录[车险]【综改后】”,\n c_ndisc_rsn_cnm varchar(65533) NULL COMMENT “不浮动原因 [车险]”,\n n_catdamage_prem double NULL COMMENT “车损保费[车险]”,\n n_the_three_prem double NULL COMMENT “三者保费[车险]”,\n c_ply_type01 varchar(65533) NULL COMMENT “是否单保交强险”,\n c_owner_nme varchar(65533) NULL COMMENT “车主[车险]”,\n t_debut_tm datetime NULL COMMENT “初登日期[车险]”,\n c_vhl_used_year varchar(65533) NULL COMMENT “车龄[车险]”,\n c_new_purchase_stage varchar(65533) NULL COMMENT “新车购置价[车险]”,\n n_seat_num double NULL COMMENT “座位数[车险]”,\n c_self_cha_coef varchar(65533) NULL COMMENT “自主渠道系数[车险]”,\n c_self_undr_coef varchar(65533) NULL COMMENT “自主核保系数[车险]”,\n n_robbery_prm double NULL COMMENT “盗抢险保费[车险]”,\n c_ply_type05 varchar(65533) NULL COMMENT “是否单商业险[车险]”,\n c_frm_no varchar(65533) NULL COMMENT “车架号[车险]”,\n c_eng_no varchar(65533) NULL COMMENT “发动机号[车险]”,\n n_std_tonage double NULL COMMENT “核定载质量[车险]”,\n n_driver_amt double NULL COMMENT “司机险别的保额[车险]”,\n n_passenger_amt double NULL COMMENT “乘客险别的保额[车险]”,\n c_cus_flag varchar(65533) NULL COMMENT “客户标志[车险]”,\n c_group_cnm varchar(65533) NULL COMMENT “集团名称[车险]”,\n n_the_three_amt double NULL COMMENT “第三者保额[车险]”,\n c_prm_state varchar(65533) NULL COMMENT “保费会计状态[待取数]”,\n c_energy_typ varchar(65533) NULL COMMENT “车辆能源类型[车险]”,\n c_undr_cnm varchar(65533) NULL COMMENT “核保人名称”,\n n_displacement double NULL COMMENT “排气量[车险]”,\n c_repair_cde varchar(65533) NULL COMMENT “车辆送修码[车险]”,\n t_transfer_date datetime NULL COMMENT “转移登记（过户）日期”,\n c_brand_id varchar(65533) NULL COMMENT “车辆品牌”,\n n_ctpsunlightscore double NULL COMMENT “交强险光博分”,\n n_comsunlightscore double NULL COMMENT “商业险光博分”,\n n_sunlightscore double NULL COMMENT “整单光博分”,\n vhl_damage_grade_prediction varchar(65533) NULL COMMENT “车损分档”,\n the_three_are_forecast varchar(65533) NULL COMMENT “三者评分分档”,\n total_tranche varchar(65533) NULL COMMENT “三者+车损分档”,\n compulsory_insurance_sub_file varchar(65533) NULL COMMENT “交强险分档”,\n c_brand_nme varchar(65533) NULL COMMENT “品牌车系”,\n n_entire_fit_disc double NULL COMMENT “精算折扣”,\n n_pricing_adjust_value double NULL COMMENT “自主定价系数”,\n c_claim_adjust_level varchar(65533) NULL COMMENT “无赔优待系数级别”,\n c_ago_clm_rec double NULL COMMENT “无赔优待系数等级系数”,\n t_paid_tm_caiwu datetime NULL COMMENT “复合日期”,\n c_dpt_cde varchar(65533) NULL COMMENT “机构代码”,\n c_dpt_cnm varchar(65533) NULL COMMENT “机构名称”,\n t_ply_bgn_tm datetime NULL COMMENT “批单生效日期”,\n c_prem_cur varchar(65533) NULL COMMENT “币种(保费)”,\n n_prem_rmb double NULL COMMENT “总保费”,\n n_real_paid_prem double NULL COMMENT “实收保费”,\n n_receivable_prem double NULL COMMENT “应收保费”,\n n_b_fee double NULL COMMENT “B费用”,\n n_b_prop double NULL COMMENT “B费用比例”,\n n_b_vat double NULL COMMENT “B费用(税费)”,\n n_b_fee_sum double NULL COMMENT “B费用含税”,\n n_c_fee double NULL COMMENT “C费用”,\n n_c_prop double NULL COMMENT “C费用比例”,\n n_c_vat double NULL COMMENT “C费用(税费)”,\n n_c_fee_sum double NULL COMMENT “C费用含税”,\n t_real_paid_tm datetime NULL COMMENT “实收日期”,\n c_cha_type_cnm varchar(65533) NULL COMMENT “二级渠道”,\n c_cha_subtype_cnm varchar(65533) NULL COMMENT “三级渠道”,\n c_ecdemic_mrk_typ varchar(65533) NULL COMMENT “过户车类别”,\n c_if_unload varchar(65533) NULL COMMENT “是否自卸”,\n n_resv_num_1 double NULL COMMENT “业务份额”,\n c_ci_typ varchar(65533) NULL COMMENT “共保录单方式”,\n c_sys_source varchar(65533) NULL COMMENT “出单来源”,\n vehicle_score varchar(65533) NULL COMMENT “单车UBI(车损+三者)”,\n c_t_total_tranche varchar(65533) NULL COMMENT “团车三者+车损分档”,\n c_is_nvhl varchar(65533) NULL COMMENT “是否非车,车”,\n n_ctpsunlightscore_gl double NULL COMMENT “交强险光博评分_关联”,\n c_unfix_spc varchar(65533) NULL COMMENT “特别约定”,\n n_ply_fee_rate double NULL COMMENT “共保出单费比例”,\n c_constr_item varchar(65533) NULL COMMENT “险种特殊字段显示”,\n n_nvhl_coef double NULL COMMENT “非车系数”,\n c_remark varchar(65533) NULL COMMENT “保单备注”,\n c_pkg_no varchar(65533) NULL COMMENT “统保代码”,\n c_cal_radix varchar(65533) NULL COMMENT “出单费计算基数”,\n n_ply_fee double NULL COMMENT “出单费”,\n n_ply_fee_tax double NULL COMMENT “出单费税额”,\n n_ply_fee_exc_vat double NULL COMMENT “不含税出单费”\n) ENGINE=OLAP \nDUPLICATE KEY(c_dptcnm_2nd, c_dptcnm_3rd)\nCOMMENT “手续费清单”\nDISTRIBUTED BY HASH(c_dptcnm_5th, c_ply_no)\nPROPERTIES (\n"replication_num” = “2”,\n"in_memory" = “false”,\n"storage_format" = “DEFAULT”,\n"enable_persistent_index" = “false”,\n"compression" = “LZ4”\n);"},“table_row_count”:{“app.app_fin_procedures_fee_detail”:{“app_fin_procedures_fee_detail”:25057236}},“session_variables”:"{“enable_show_all_variables”:false,“cbo_cte_reuse”:true,“full_sort_max_buffered_bytes”:16777216,“character_set_connection”:“utf8”,“cbo_use_correlated_join_estimate”:true,“enable_insert_strict”:true,“enable_connector_adaptive_io_tasks”:true,“tx_isolation”:“REPEATABLE-READ”,“wait_timeout”:86400,“cbo_cte_reuse_rate”:1.2,“enable_query_tablet_affinity”:false,“transmission_encode_level”:7,“character_set_results”:“utf8”,“transaction_isolation”:“REPEATABLE-READ”,“enable_global_runtime_filter”:true,“load_transmission_compression_type”:“NO_COMPRESSION”,“cbo_enable_low_cardinality_optimize”:true,“enable_resource_group_v2”:true,“scan_use_query_mem_ratio”:0.3,“new_planner_optimize_timeout”:3000,“enable_realtime_mv”:false,“enable_adaptive_sink_dop”:true,“force_schedule_local”:false,“hudi_mor_force_jni_reader”:false,“full_sort_late_materialization”:false,“enable_profile”:false,“cbo_enable_greedy_join_reorder”:true,“load_mem_limit”:0,“sql_safe_updates”:0,“runtime_filter_early_return_selectivity”:0.05,“enable_local_shuffle_agg”:true,“rpc_http_min_size”:2147482624,“cbo_debug_alive_backend_number”:0,“global_runtime_filter_probe_min_size”:102400,“nested_mv_rewrite_max_level”:3,“query_delivery_timeout”:300,“net_write_timeout”:60,“cbo_prune_shuffle_column_rate”:0.1,“collation_database”:“utf8_general_ci”,“hash_join_push_down_right_table”:true,“new_planner_agg_stage”:0,“use_compute_nodes”:-1,“collation_connection”:“utf8_general_ci”,“resource_group”:"",“broadcast_row_limit”:15000000,“enable_populate_block_cache”:true,“profile_limit_fold”:true,“exec_mem_limit”:2147483648,“enable_sort_aggregate”:false,“cbo_max_reorder_node_use_dp”:10,“query_cache_force_populate”:false,“runtime_filter_on_exchange_node”:false,“disable_join_reorder”:false,“enable_rule_based_materialized_view_rewrite”:true,“enable_hive_column_stats”:true,“enable_groupby_use_output_alias”:false,“connector_scan_use_query_mem_ratio”:0.3,“net_buffer_length”:16384,“forward_to_leader”:false,“count_distinct_column_buckets”:1024,“full_sort_max_buffered_rows”:1024000,“query_cache_agg_cardinality_limit”:5000000,“query_timeout”:300,“connector_io_tasks_slow_io_latency_ms”:50,“enable_pipeline_query_statistic”:true,“cbo_max_reorder_node”:50,“cboPushDownAggregateMode_v1”:-1,“window_partition_mode”:1,“enable_deliver_batch_fragments”:true,“enable_tablet_internal_parallel_v2”:true,“enable_distinct_column_bucketization”:false,“interpolate_passthrough”:true,“runtime_filter_scan_wait_time”:20,“SQL_AUTO_IS_NULL”:false,“event_scheduler”:“OFF”,“prefer_compute_node”:false,“enable_strict_type”:false,“broadcast_right_table_scale_factor”:10,“group_concat_max_len”:65535,“disable_streaming_preaggregations”:false,“parse_tokens_limit”:3500000,“chunk_size”:4096,“runtime_join_filter_push_down_limit”:1024000,“global_runtime_filter_probe_min_selectivity”:0.5,“query_mem_limit”:0,“enable_filter_unused_columns_in_scan_stage”:true,“enable_scan_block_cache”:false,“enable_materialized_view_single_table_view_delta_rewrite”:false,“div_precision_increment”:4,“auto_increment_increment”:1,“sql_mode_v2”:32,“character_set_client”:“utf8”,“autocommit”:true,“hdfs_backend_selector_scan_range_shuffle”:false,“enable_column_expr_predicate”:true,“pipeline_profile_level”:1,“parallel_fragment_exec_instance_num”:4,“max_scan_key_num”:-1,“cbo_cte_max_limit”:10,“net_read_timeout”:60,“streaming_preaggregation_mode”:“auto”,“storage_engine”:“olap”,“hive_partition_stats_sample_size”:3000,“enable_optimizer_trace_log”:false,“enable_mv_planner”:false,“cbo_enable_dp_join_reorder”:true,“tx_visible_wait_timeout”:10,“enable_materialized_view_view_delta_rewrite”:true,“cbo_max_reorder_node_use_exhaustive”:4,“enable_sql_digest”:false,“profile_timeout”:2,“cbo_push_down_aggregate”:“global”,“pipeline_dop”:10,“enable_query_dump”:false,“single_node_exec_plan”:false,“join_implementation_mode_v2”:“auto”,“global_runtime_filter_build_max_size”:67108864,“sql_select_limit”:9223372036854775807,“enable_materialized_view_rewrite”:true,“statistic_collect_parallel”:1,“query_cache_hot_partition_num”:3,“enable_prune_complex_types”:true,“query_cache_type”:0,“disable_colocate_join”:false,“max_parallel_scan_instance_num”:-1,“query_cache_entry_max_rows”:409600,“max_pushdown_conditions_per_column”:-1,“connector_io_tasks_per_scan_operator”:16,“enable_materialized_view_union_rewrite”:true,“sql_quote_show_create”:true,“enable_exchange_pass_through”:true,“query_cache_entry_max_bytes”:4194304,“innodb_read_only”:true,“enable_exchange_perf”:false,“enable_predicate_reorder”:false,“workgroup_id”:0,“enable_query_cache”:false,“enable_rewrite_groupingsets_to_union_all”:false,“transmission_compression_type”:“NO_COMPRESSION”,“interactive_timeout”:3600,“max_allowed_packet”:33554432,“collation_server”:“utf8_general_ci”,“time_zone”:“Asia/Shanghai”,“enable_multicolumn_global_runtime_filter”:false,“character_set_server”:“utf8”,“tablet_internal_parallel_mode”:“auto”,“enable_pipeline”:true,“cbo_use_nth_exec_plan”:0,“io_tasks_per_scan_operator”:4,“parallel_exchange_instance_num”:-1,“enable_shared_scan”:false,“enable_query_debug_trace”:false,“allow_default_partition”:false}",“column_statistics”:{“app.app_fin_procedures_fee_detail”:{“c_kind_cnm”:"[-Infinity, Infinity, 0.0, 4.292843871526772, 15.0] ESTIMATE",“c_dptcnm_2nd”:"[-Infinity, Infinity, 0.0, 5.079042476991477, 6.0] ESTIMATE"}},“be_number”:3,“be_core_stat”:{“numOfHardwareCoresPerBe”:"{“635002”:48,“621101”:48,“607806”:48}",“cachedAvgNumOfHardwareCores”:-1},“exception”:[],“version”:“2.5.7”,“commit_version”:“8dc1b68”}