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)

Reply via email to