STARROCKS 版本： 2.2.0 查询视图union all 视图的sum结果 be节点不存活了 ，两条sql单独查询很快出结果 数据条数为1000条左右 sql语句：(select
null as stat_dt
,null as area_name
,null as provincename_b
,null as dbct_nm
,null as dbct_cd
,null as pre_site_nm
,null as pre_scan_site
,null as car_lic_id
,sum(onway_cnt_tot) as onway_cnt_tot
,round(sum(onway_wgt_tot),2) as onway_wgt_tot
,sum(prov_inv_cnt) as prov_inv_cnt
,round(sum(prov_inv_wgt),2) as prov_inv_wgt
,null as frgt_unit_id
,null as arv_plan_tm
from ads.v_on_way_frgt_dir
where 1=1 and stat_dt=‘2022-07-28’
group by 1,2,3,4,5,6,7,8,13,14 )
union all
(select
a.stat_dt
,b3.area_name
,b4.provincename_b
,b1.mc dbct_nm
,a.dbct_cd
,b2.mc pre_site_nm
,a.pre_scan_site
,a.car_lic_id
,a.onway_cnt_tot
,round(a.onway_wgt_tot,2) as onway_wgt_tot
,a.prov_inv_cnt
,round(a.prov_inv_wgt,2) as prov_inv_wgt
,a.frgt_unit_id
,a.arv_plan_tm
from ads.v_on_way_frgt_dir a
left join dim.gs b1 on a.dbct_cd = b1.bm
left join dim.gs b2 on a.pre_scan_site = b2.bm
left join dim.bigarea b3 on b3.area_id = b1.bigarea
left join dim.province_business b4 on b4.provinceid_b = b1.parent_pro_site
where 1=1 and stat_dt=‘2022-07-28’
)
发一下explain和explain costs 看看
1赞
be.out 也提供一下看看
我复现一下，不确定是不是已经修过的问题，你可以先升到2.2.3试试
我们已经升级到了2.3.0
2.3.0 也有这个问题吗
如果你们能提供一个最小复现case，我们可能会复现的快一些
是的 升级之后还是会有这个问题
caused by a wrong view.
solution:
drop view and create view