[KYLIN-3902] NoRealizationFoundException due to creating a wrong JoinDesc

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v3.0.0, v3.0.0-alpha
• Component/s: Query Engine
• Assignee: Zhong Yanghong
• Reporter: Zhong Yanghong
• Created: 21/Mar/19 17:03
• Updated: 16/Apr/19 02:25
• Resolved: 27/Mar/19 09:47

Description

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:

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

Issue Links

• links to: GitHub Pull Request #545