Shaofeng SHI created KYLIN-849:
----------------------------------
Summary: Couldn't query metrics on lookup table PK
Key: KYLIN-849
URL: https://issues.apache.org/jira/browse/KYLIN-849
Project: Kylin
Issue Type: Bug
Components: Query Engine
Affects Versions: v0.7.1
Reporter: Shaofeng SHI
Assignee: Shaofeng SHI
Fix For: v0.7.2
When running such a SQL, kylin will throw error:
{code}
SELECT
min(test_cal_dt.cal_dt) as mmin
,max(test_cal_dt.cal_dt) as mmax
FROM test_kylin_fact
inner JOIN edw.test_cal_dt as test_cal_dt
ON test_kylin_fact.cal_dt = test_cal_dt.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
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)