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

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

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: v1.4.0, v1.5.0
    • Component/s: None
    • Labels:
      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

            • Assignee:
              mahongbin Hongbin Ma
              Reporter:
              mahongbin Hongbin Ma

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment