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

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

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

tylor created KYLIN-4629:
----------------------------

             Summary: "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


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)