[
https://issues.apache.org/jira/browse/KYLIN-4629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17155519#comment-17155519
]
chuxiao commented on KYLIN-4629:
--------------------------------
默认现在关了，要改默认值
> "sum case when" not support in kylin 3.1.0 not yet ?
> ----------------------------------------------------
>
> Key: KYLIN-4629
> URL: https://issues.apache.org/jira/browse/KYLIN-4629
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v3.1.0
> Environment: CDH 6.2.1
> Reporter: tylor
> Priority: Major
> Labels: features
>
> Using the latest version of 3.1.0, the following is still not supported. Why?
> 使用了3.1.0的最新版，依然不支持以下写法，为何？
> {code:java}
> select sum(case ACCOUNT_COUNTRY when 'CN' THEN 1 else 0 end) from
> kylin_account
> {code}
>
> _error info:_
> _No realization found for OLAPContext,
> CUBE_UNMATCHED_AGGREGATION[FunctionDesc [expression=SUM, parameter=CASE(=($3,
> 'CN'), 1, 0), returnType=null]],
> rel#2071:OLAPTableScan.OLAP.[](table=[DEFAULT, KYLIN_ACCOUNT],ctx=,fields=[0,
> 1, 2, 3, 4, 5]) while executing SQL: "select * from (select sum((case
> ACCOUNT_COUNTRY when 'CN' THEN 1 else 0 end)) from kylin_account) limit
> 50000"_
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
