hongbin ma created KYLIN-1471:
---------------------------------
Summary: 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
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)
