【业务影响】查询失败
【StarRocks版本】例如:2.2.2
【集群规模】例如:3fe(1 follower+2observer)+ 2be
【机器信息】
Fe 8c16g * 3
Be 16c64g * 2
【附件】
be.out 报错日志
select toh.orderOID as order_id,
max(case when toh.comment like ‘%快递单号%’ then toh.createTime else null end) as last_deliver_time,
max(case when toh.comment = ‘收票’ then toh.createTime else null end) as last_print_time,
array_join(array_distinct(array_agg(case when toh.orderHistoryType = ‘refund_order’ and toh.orderStatus = ‘Refunding’ then toh.comment else null end)), ', ') as refund_reason
from tm_order_history toh
where toh.comment like ‘%快递单号%’ or toh.comment = ‘收票’ or (toh.orderHistoryType = ‘refund_order’ and toh.orderStatus = ‘Refunding’)
group by 1
array_join 这个加上后一跑就挂,是不是else null空指针没处理好
