[ https://issues.apache.org/jira/browse/KYLIN-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhong Yanghong updated KYLIN-3005: ---------------------------------- Description: Suppose there are two tables, FA & FL. In a model, there are two joins: FA inner join FL(alias FL1, without snapshot), FA inner join FL(alias FL2, with snapshot). The join conditions are the same, FA.colA = FL.colL. In this case, when the returns from {{getTable()}} of both FL1.colL & FL2.colL are FL which is regarded as fact table. This finally results in the return from {{getAllDictColumnsOnFact()}} in {{CubeManager}} include the fact table's foreign key, FA.colA. was: Suppose there are two tables, FA & FL. In a model, there are two joins: FA inner join FL(alias FL1, without snapshot), FA inner join FL(alias FL2, with snapshot). The join conditions are the same, FA.colA = FL.colL. In this case, when the returns from getTable() of both FL1.colL & FL2.colL are FL which is regarded as fact table. This finally results in the return from > getAllDictColumnsOnFact in CubeManager may include fact table's foreign key > --------------------------------------------------------------------------- > > Key: KYLIN-3005 > URL: https://issues.apache.org/jira/browse/KYLIN-3005 > Project: Kylin > Issue Type: Improvement > Reporter: Zhong Yanghong > Assignee: Zhong Yanghong > > Suppose there are two tables, FA & FL. In a model, there are two joins: FA > inner join FL(alias FL1, without snapshot), FA inner join FL(alias FL2, with > snapshot). The join conditions are the same, FA.colA = FL.colL. > In this case, when the returns from {{getTable()}} of both FL1.colL & > FL2.colL are FL which is regarded as fact table. This finally results in the > return from {{getAllDictColumnsOnFact()}} in {{CubeManager}} include the fact > table's foreign key, FA.colA. -- This message was sent by Atlassian JIRA (v6.4.14#64029)