[ https://issues.apache.org/jira/browse/KYLIN-2341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15873684#comment-15873684 ]
Kaige Liu edited comment on KYLIN-2341 at 2/19/17 12:42 PM: ------------------------------------------------------------- [~liyang.g...@gmail.com] Would you please help review this patch? Thanks. was (Author: liukaige): [~liyang.g...@gmail.com]Would you please help review this patch? Thanks. > 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 > 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)