[
https://issues.apache.org/jira/browse/KYLIN-1471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hongbin ma resolved KYLIN-1471.
-------------------------------
Resolution: Fixed
Fix Version/s: v2.0
v2.1
> LIMIT after having clause should not be pushed down to storage context
> ----------------------------------------------------------------------
>
> Key: KYLIN-1471
> URL: https://issues.apache.org/jira/browse/KYLIN-1471
> Project: Kylin
> Issue Type: Bug
> Reporter: hongbin ma
> Assignee: hongbin ma
> Fix For: v2.1, v2.0
>
>
> for example:
> SELECT *
> FROM (
> select test_kylin_fact.lstg_format_name,
> test_cal_dt.week_beg_dt,sum(test_kylin_fact.price) as GMV
> , count(*) as TRANS_CNT
> 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
> where test_cal_dt.week_beg_dt between DATE '2013-05-01' and DATE
> '2013-08-01'
> group by test_kylin_fact.lstg_format_name, test_cal_dt.week_beg_dt
> having sum(price)>500
> ) "TableauSQL"
> LIMIT 1
> the limit here should not be pushed to storage context
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
