[
https://issues.apache.org/jira/browse/KYLIN-1855?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15367105#comment-15367105
]
Shaofeng SHI commented on KYLIN-1855:
-------------------------------------
Hi Yanghong, Just to confirm whether I get it:
Assume I have a model which has 1 fact and 4 lookup tables; Now I create a cube
by using that model, but in the cube I only use 2 lookup tables; Now when I
query it, if the SQL only has 2 lookup tables, will Kylin report the "no
realization found" error?
> Should exclude those joins in whose related lookup tables no dimensions are
> used in cube
> ----------------------------------------------------------------------------------------
>
> Key: KYLIN-1855
> URL: https://issues.apache.org/jira/browse/KYLIN-1855
> Project: Kylin
> Issue Type: Improvement
> Reporter: Zhong Yanghong
> Assignee: Zhong Yanghong
>
> A cube is based on a model in which a star schema is defined. In some cases,
> the cube utilizes only a few lookup tables rather than all. In this case,
> when creating the sql for the flat table, those lookup tables should not be
> included. Otherwise, it will confuse users when query. If users do query
> according to the definition of the flat table, error of no realization will
> occur due to lack of the related join.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
