[
https://issues.apache.org/jira/browse/KYLIN-2580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hongbin ma resolved KYLIN-2580.
-------------------------------
Resolution: Fixed
Fix Version/s: v2.1.0
> Improvement on subqueries: allow grouping by columns from subquery
> ------------------------------------------------------------------
>
> Key: KYLIN-2580
> URL: https://issues.apache.org/jira/browse/KYLIN-2580
> Project: Kylin
> Issue Type: Improvement
> Reporter: hongbin ma
> Assignee: hongbin ma
> Fix For: v2.1.0
>
>
> {code:sql}
> select test_kylin_fact.lstg_format_name, xxx.week_beg_dt ,
> 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, xxx.week_beg_dt
> {code}
> will fail due to groupby xxx.week_beg_dt, because week_beg_dt does not
> necessarily appear in the cube
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
