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

When pushdown is enabled, execute sql which includes subquery will be pushdowned

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • v4.0.0-alpha, v3.1.1
    • v3.1.4, v4.0.2
    • Query Engine
    • None

    Description

      When pushdown is enabled, execute sql which includes subquery will be pushdowned.

        

      For example:

      SELECT t1.week_beg_dt, t1.sum_price, t1.lstg_site_id
      FROM (
       select KYLIN_CAL_DT.week_beg_dt, sum(price) as sum_price, lstg_site_id
       from KYLIN_SALES
       inner JOIN KYLIN_CAL_DT as KYLIN_CAL_DT
       ON KYLIN_SALES.PART_DT = KYLIN_CAL_DT.cal_dt
       inner JOIN kylin_category_groupings
       ON KYLIN_SALES.leaf_categ_id = kylin_category_groupings.leaf_categ_id AND KYLIN_SALES.lstg_site_id = kylin_category_groupings.site_id
       group by KYLIN_CAL_DT.week_beg_dt, lstg_site_id
      ) t1
      inner JOIN KYLIN_CAL_DT as KYLIN_CAL_DT
      on t1.week_beg_dt = KYLIN_CAL_DT.week_beg_dt

       

       

      Attachments

        Activity

          People

            zzcclp Zhichao Zhang
            zzcclp Zhichao Zhang
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: