[jira] [Created] (KYLIN-4840) When pushdown is enabled, execute sql which includes subquery will be pushdowned

["Zhichao Zhang (Jira)" <ji...@apache.org>]

Zhichao  Zhang created KYLIN-4840:
-------------------------------------

             Summary: When pushdown is enabled, execute sql which includes subquery will be pushdowned
                 Key: KYLIN-4840
                 URL: https://issues.apache.org/jira/browse/KYLIN-4840
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v3.1.1, v4.0.0-alpha
            Reporter: Zhichao  Zhang
            Assignee: Zhichao  Zhang
             Fix For: v4.0.0-beta, v3.1.2


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

 

 

For example:
{code:java}
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{code}
 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)