[jira] [Comment Edited] (KYLIN-1855) Should exclude those joins in whose related lookup tables no dimensions are used in cube

["liyang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-1855?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15635590#comment-15635590 ] 

liyang edited comment on KYLIN-1855 at 11/4/16 7:58 AM:
--------------------------------------------------------

I'm proposing to revert to the original behavior, that all the joins in model always participates in flat table creation. Make things simple.

[~yaho], what do you think?


was (Author: liyang.gmt8@gmail.com):
I'm proposing to revert to the original behavior, that all the joins in model always participates in flat table creation.

[~yaho], what do you think?

> 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
>             Fix For: v1.5.4
>
>         Attachments: exclude_unused_joins.patch
>
>
> 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)