[
https://issues.apache.org/jira/browse/KYLIN-899?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14635207#comment-14635207
]
Julian Hyde commented on KYLIN-899:
-----------------------------------
Calcite already has this feature:
{code}select sum(col) filter (where col>1024) as newcol from testtabale;{code}
See https://issues.apache.org/jira/browse/CALCITE-704.
> add "if" support in sum
> -----------------------
>
> Key: KYLIN-899
> URL: https://issues.apache.org/jira/browse/KYLIN-899
> Project: Kylin
> Issue Type: Improvement
> Reporter: liangmeng
>
> add "if" support in sum,such as :
> select sum(if(col>1024,col,0)) as newcol from testtabale;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
