Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-1471

LIMIT after having clause should not be pushed down to storage context

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • v1.4.0, v1.5.0
    • None
    • None

    Description

      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

      Attachments

        Activity

          People

            mahongbin Hongbin Ma
            mahongbin Hongbin Ma
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: