You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shendandan (JIRA)" <ji...@apache.org> on 2017/08/14 01:42:00 UTC

[jira] [Created] (KYLIN-2787) SUM(CASE WHEN...) does not supported

Shendandan created KYLIN-2787:
---------------------------------

             Summary: SUM(CASE WHEN...) does not supported
                 Key: KYLIN-2787
                 URL: https://issues.apache.org/jira/browse/KYLIN-2787
             Project: Kylin
          Issue Type: Bug
          Components: REST Service
    Affects Versions: v1.6.0
         Environment: jdk1.7.0_80, hbase-0.98.6-cdh5.3.9, apache-kylin-1.6.0-bin,
            Reporter: Shendandan
            Assignee: Zhong,Jason
             Fix For: v1.6.0


Use a calculated field in tableau, but it can not work. There is an error in kylin.log:

 {{[Kylin][ODBC 1.0(w) Driver]The REST query request failed, the error message is: Error while executing SQL "SELECT SUM((CASE WHEN (( EXTRACT(YEAR FROM a.column1) = 2017) AND ( EXTRACT(MONTH FROM a.column1) = 6)) THEN a.column2 ELSE 0 END)) AS "sum_Calculation_FIIAIBABGCIFEFEJ_ok" FROM table a LEFT JOIN table b ON (a. column3= b.column1) LEFT JOIN table c ON (a. column4= c.column1) LEFT JOIN table d ON (a.column5 = d.column1) LEFT JOIN table e ON (a.column6 = e.column1) ": Can't find any realization. Please confirm with providers. SQL digest: fact table
a ,group by [],filter on [],with aggregates[FunctionDesc [expression=SUM, parameter=null, returnType=null]].}}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)