[GitHub] [incubator-doris] zbtzbtzbt edited a comment on issue #7008: [Enhance] use predicate if in bitmap_union_count() can not hit rollup.

[GitBox]

zbtzbtzbt edited a comment 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: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org