[
https://issues.apache.org/jira/browse/KYLIN-1796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wang Cheng closed KYLIN-1796.
-----------------------------
Resolution: Fixed
> query return 0 results when join with sub sql with composite keys
> -----------------------------------------------------------------
>
> Key: KYLIN-1796
> URL: https://issues.apache.org/jira/browse/KYLIN-1796
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v1.5.2.1
> Reporter: Zhong,Jason
> Assignee: liyang
>
> from kylin sample cube 'kylin_sales_cube'
> after build successfully.
> if we want to query sql like this.
> "
> SELECT COUNT(*) FROM KYLIN_SALES as a INNER JOIN
> KYLIN_CATEGORY_GROUPINGS as b
> on a.LEAF_CATEG_ID = b.LEAF_CATEG_ID
> and a.LSTG_SITE_ID = b.SITE_ID
> group by b.META_CATEG_NAME
> "
> it works!!
> but if we query same sql like this
> "
> select count(*) as _count from kylin_sales as a
> inner join
> (select leaf_categ_id as _leaf_categ_id, site_id as _site_id,
> meta_categ_name as _meta_categ_name from kylin_category_groupings)
> as b
> on (a.leaf_categ_id = b._leaf_categ_id and a.lstg_site_id = b._site_id)
> group by b._meta_categ_name order by count(*) desc
> "
> it return 0 results.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
