liyang created KYLIN-2341:
-----------------------------
Summary: sum(case .. when ..) problem
Key: KYLIN-2341
URL: https://issues.apache.org/jira/browse/KYLIN-2341
Project: Kylin
Issue Type: Bug
Reporter: liyang
Assignee: liyang
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.4#6332)
