[
https://issues.apache.org/jira/browse/KYLIN-2579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hongbin ma updated KYLIN-2579:
------------------------------
Summary: Improvement on subqueries: reorder subqueries joins with
RelOptRule (was: Improvement on subqueries: reroder subqueries joins with
RelOptRule)
> Improvement on subqueries: reorder subqueries joins with RelOptRule
> -------------------------------------------------------------------
>
> Key: KYLIN-2579
> URL: https://issues.apache.org/jira/browse/KYLIN-2579
> Project: Kylin
> Issue Type: Improvement
> Reporter: hongbin ma
> Assignee: hongbin ma
>
> Current support for subqueries has some limitations. for example, we require
> JOIN on tables precedes JOIN on all subqueries, the following query:
> {code:sql}
> select test_kylin_fact.lstg_format_name,sum(test_kylin_fact.price) as GMV
> , count(*) as TRANS_CNT
> from
> test_kylin_fact
> inner JOIN test_category_groupings
> ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND
> test_kylin_fact.lstg_site_id = test_category_groupings.site_id
> inner JOIN (select cal_dt,week_beg_dt from edw.test_cal_dt where
> week_beg_dt >= DATE '2010-02-10' ) xxx
> ON test_kylin_fact.cal_dt = xxx.cal_dt
>
>
> where test_category_groupings.meta_categ_name <> 'Baby'
> group by test_kylin_fact.lstg_format_name
> {code}
> works but
> {code:sql}
> select test_kylin_fact.lstg_format_name,sum(test_kylin_fact.price) as GMV
> , count(*) as TRANS_CNT
> from
> test_kylin_fact
> inner JOIN (select cal_dt,week_beg_dt from edw.test_cal_dt where
> week_beg_dt >= DATE '2010-02-10' ) xxx
> ON test_kylin_fact.cal_dt = xxx.cal_dt
>
> inner JOIN test_category_groupings
> ON test_kylin_fact.leaf_categ_id = test_category_groupings.leaf_categ_id AND
> test_kylin_fact.lstg_site_id = test_category_groupings.site_id
>
>
> where test_category_groupings.meta_categ_name <> 'Baby'
> group by test_kylin_fact.lstg_format_name
> {code}
> won't work. In this JIRA we'll reroder subqueries joins with RelOptRule
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
