[jira] [Commented] (KYLIN-1796) query return 0 results when join with sub sql with composite keys

["hongbin ma (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-1796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15391084#comment-15391084 ] 

hongbin ma commented on KYLIN-1796:
-----------------------------------

hi [~wormholer] does this issue relate with your recent fix on query engine?

> 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)