【已记录】doris在执行这段sql时,be轮流宕机,不知为啥,请大佬们看看

Viewed 87

doris版本:1.2.4-1

sql语句:
截图:bb471a6b91dd75c0bfa11cc7ff60e4f.png

select
b1.created_time
,b1.road
,ROUND(AVG(b1.estimate_km),4) as '平均运距'
,ROUND(AVG(b1.rate), 4) as ton_km_price
from(
select
b.created time
,concat(p.end_plate_province, p.end_plate_city) as road
,p.estimate_km
,if(b.valu_mode='1',Round(b.price / p.estimate_km, 4), Round(b.price /b.truck_loading_weight/ p.estimate_km, 4)) as rate
FROM dataease.bu_delivery b
LEFT JOIN dataease.bu_publish p on b.publish_id = p.publish_id
WHERE
(concat(p.end_plate_province, p.end_plate_city) like '%郑州%'
OR concat(p.end_plate_province, p.end_plate_city) like '%武汉%'
OR concat(p.end_plate_province, p.end_plate_city) like '%泰安%'
OR concat(p.end_plate_province, p.end_plate_city) like '%渭南%'
OR concat(p.end_plate_province, p.end_plate_city) like '%西安%')
and b.val_status ='90'
and b.created_time >='2023-01-01' 
and b.created_time < '2025-01-01'
order by b.created_time 
limit 100)b1
group by
b1.created_time
,b1.road
order by
b1.created_time

注释:
end_plate_province : 目的地省
end_plate_city :目的地市

be.out异常栈信息:
911b12b232975ff9a41e78fac72dfd3.png

是否复现:可复现

1 Answers

哈喽,您好,这个是已知问题,目前正在修复中,比较难解决,预计得在 2.1上fix,您这个稳定复现的case方便私我下吗?