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