[
https://issues.apache.org/jira/browse/KYLIN-2787?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16134302#comment-16134302
]
liyang commented on KYLIN-2787:
-------------------------------
This is a known issue.
> 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
>
> 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)
