[
https://issues.apache.org/jira/browse/KYLIN-3902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16802372#comment-16802372
]
ASF GitHub Bot commented on KYLIN-3902:
---------------------------------------
shaofengshi commented on pull request #545: KYLIN-3902 fix JoinDesc in case of
same fact column with multiple loo…
URL: https://github.com/apache/kylin/pull/545
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> 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
> Priority: Major
> Fix For: v3.0.0
>
>
> 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)
