升级至4.0.4后物化视图查询失败，报错Insert a plan into targetGroup but differ in logicalproperties

背景：
doris从2.1.9升级至4.0.4后有一个查询报错

报错信息

ERROR 1105 (HY000): errCode = 2, detailMessage = Insert a plan into targetGroup but differ in logicalproperties

尝试EXPLAIN报同样错误

sql语句

select
        object_id,
        level_one_tag_name ,
        level_two_tag_name ,
        show_name as semantic_name,
        platform,
        IFNULL(sum(all_comment_cnt), 0) as total_volume,
        IFNULL(all_mix_field, 0) as US,
        IFNULL(all_mix_field, 0) as TC,
        IFNULL(sum(comment_cnt)/ sum(all_comment_cnt), 0) as kpi1,
        IFNULL(sum(comment_cnt)/ max(all_mix_field), 0) as kpi2
from
        ges.super_voc_v_comment_ai_tag_4_level_tc
where
        object_id = 'b8e1737e2d6a2c6f7876c620134413a4'
        and platform = 'GES'
group by
        object_id,
        level_one_tag_name,
        level_two_tag_name,
        show_name,
        platform,
        all_mix_field;

直接执行
select * from ges.super_voc_v_comment_ai_tag_4_level_tc能正常查询。

表结构如下