You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "chuxiao (Jira)" <ji...@apache.org> on 2020/07/10 14:34:00 UTC

[jira] [Commented] (KYLIN-4629) "sum case when" not support in kylin 3.1.0 not yet ?

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