[jira] [Commented] (KYLIN-2341) sum(case .. when ..) is not supported

["Shao Feng Shi (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-2341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17133120#comment-17133120 ] 

Shao Feng Shi commented on KYLIN-2341:
--------------------------------------

sum(expression) was supported in Kylin 2.4; the related Jira is https://issues.apache.org/jira/browse/KYLIN-3359

> sum(case .. when ..) is not supported
> -------------------------------------
>
>                 Key: KYLIN-2341
>                 URL: https://issues.apache.org/jira/browse/KYLIN-2341
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: liyang
>            Assignee:  Kaige Liu
>            Priority: Major
>             Fix For: v2.0.0
>
>         Attachments: KYLIN-2341.patch
>
>
> Query like below should either fail, or return correct result. Currently it returns incorrect result.
> {code}
> SELECT 
>     sum(case
>         when lstg_format_name like 'Other%'
>         then price
>         else 0
>     end) as gmv
>     
> FROM test_kylin_fact 
>     inner JOIN edw.test_cal_dt as test_cal_dt
>     ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt
>     inner JOIN test_category_groupings
>     ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = test_category_groupings.site_id
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)