zbtzbtzbt commented on issue #7008:
URL:
https://github.com/apache/incubator-doris/issues/7008#issuecomment-968689508
还有另一个问题也反馈一下，sum(case when)这种写法
当存在隐式转换时，也可能不会命中rollup，比如从int转化为bigint就命中不了了
猜测转换的原因是怕数据溢出吧
```
explain
select dt,
sum(arrived_waybill_cnt) as arrived_waybill_cnt
, sum(case when delivery_type_second_level_code=2 then
arrived_waybill_cnt end) as arrived_waybill_cnt_jiameng
from bi_peisong.app_rider_model_ctl_sa_view_day
where dt > 20211022 and dt<= 20211109
and delivery_type_second_level_code in (2,4)
group by dt
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
