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

["Xiaoxiang Yu (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/KYLIN-4840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Xiaoxiang Yu updated KYLIN-4840:
--------------------------------
    Fix Version/s:     (was: v4.0.0-beta)
                   v4.0.0-GA

> 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: v4.0.0-alpha, v3.1.1
>            Reporter: Zhichao  Zhang
>            Assignee: Zhichao  Zhang
>            Priority: Minor
>             Fix For: v3.1.2, v4.0.0-GA
>
>
> 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)