You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Zhichao Zhang (Jira)" <ji...@apache.org> on 2020/12/11 12:17:00 UTC
[jira] [Updated] (KYLIN-4840) When pushdown is enabled, execute sql
which includes subquery will be pushdowned
[ https://issues.apache.org/jira/browse/KYLIN-4840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhichao Zhang updated KYLIN-4840:
----------------------------------
Description:
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}
was:
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}
> 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: 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)