其实我的意思并不是在query界面可以支持if in
sum，而是在cube的配置过程中，定义度量汇聚的时候，可以更加的灵活，例如我要根据某一列的大小定义两个不同的统计指标，如果用sql来写，大概就是
select sum(if(cola>1000,cola,0)) as cola_>1000, sum(if(cola<1000,cola,0)) as
cola_<1000 from ********;
目前kylin的cube定义只能做sum，但不能定义sum里面的条件，而filter又是针对整个sql语句的，无法做到更灵活的配置；
From: Julian Hyde (JIRA)
Date: 2015-07-21 22:52
To: dev
Subject: [jira] [Commented] (KYLIN-899) add "if" support in sum
[
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)
