[ https://issues.apache.org/jira/browse/KYLIN-2341?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liyang resolved KYLIN-2341. --------------------------- Resolution: Fixed Fix Version/s: v2.0.0 > 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 > 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 (v6.3.15#6346)