Zhong Yanghong created KYLIN-3902: ------------------------------------- Summary: NoRealizationFoundException due to creating a wrong JoinDesc Key: KYLIN-3902 URL: https://issues.apache.org/jira/browse/KYLIN-3902 Project: Kylin Issue Type: Bug Components: Query Engine Reporter: Zhong Yanghong Assignee: Zhong Yanghong
When joining with a lookup table, a column from fact table is used more than once, the JoinDesc will not be correctly generated in *OLAPJoinRel*, causing NoRealizationFoundException. Multimap should be used instead of Map. Sample Join: {code} select LSTG_FORMAT_NAME, count(*) 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 AND TEST_KYLIN_FACT.CAL_DT = TEST_CAL_DT.WEEK_BEG_DT group by LSTG_FORMAT_NAME {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)