[ 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)