You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "liyang (JIRA)" <ji...@apache.org> on 2017/04/03 23:24:41 UTC
[jira] [Commented] (KYLIN-2341) sum(case .. when ..) is not
supported
[ https://issues.apache.org/jira/browse/KYLIN-2341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15954322#comment-15954322 ]
liyang commented on KYLIN-2341:
-------------------------------
Thanks Kaige. The patch is merged and followed by an edit commit.
In general, Kylin cannot do sum(case .. when ..) yet. So a clear error is preferred now.
The particular test query could work, at cost of scanning the finest cuboid. Though over and over, I didn't let it still. Such query will be super slow in production, and I'd rather it fail quickly.
> 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)