[
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)
v4.1.0
> 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.3, v4.1.0
>
>
> 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)
