[
https://issues.apache.org/jira/browse/KYLIN-5764?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17832349#comment-17832349
]
pengfei.zhan commented on KYLIN-5764:
-------------------------------------
The following query cannot route to sum-expression to rewrite the queryPlan.
{code:sql}
select LO_CUSTKEY, count(distinct if(LO_CUSTKEY=74, LINEORDER.LO_SUPPLYCOST,0))
from ssb.LINEORDER where LO_CUSTKEY = 74
group by LO_CUSTKEY {code}
> Sum expression supports if condition
> ------------------------------------
>
> Key: KYLIN-5764
> URL: https://issues.apache.org/jira/browse/KYLIN-5764
> Project: Kylin
> Issue Type: Improvement
> Components: Query Engine
> Affects Versions: 5.0-beta
> Reporter: pengfei.zhan
> Assignee: pengfei.zhan
> Priority: Major
> Fix For: 5.0.0
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)