[ 
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)

Reply via email to