Zhong,Jason created KYLIN-1796:
----------------------------------
Summary: 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)
