kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shao Feng Shi (Jira)" <j...@apache.org>
Subject [jira] [Closed] (KYLIN-2787) SUM(CASE WHEN...) does not supported
Date Mon, 02 Mar 2020 15:05:00 GMT

     [ https://issues.apache.org/jira/browse/KYLIN-2787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Shao Feng Shi closed KYLIN-2787.
--------------------------------
    Resolution: Fixed

> 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: Jason Zhong
>            Priority: Major
>
> 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
(v8.3.4#803005)

Mime
View raw message