[jira] [Created] (KYLIN-1471) LIMIT after having clause should not be pushed down to storage context

["hongbin ma (JIRA)" <ji...@apache.org>]

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)