[jira] [Commented] (KYLIN-1855) Inner-join query partially matches inner-join model can return incorrect result

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

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

hongbin ma commented on KYLIN-1855:
-----------------------------------

I don't think it's good idea to reopen this JIRA, which became part of history as it went public with prior releases. Maybe it's better to open a  new JIRA and link to this, so that new comer can figure out when and what happened clearly

> Inner-join query partially matches inner-join model can return incorrect result
> -------------------------------------------------------------------------------
>
>                 Key: KYLIN-1855
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1855
>             Project: Kylin
>          Issue Type: Improvement
>            Reporter: Zhong Yanghong
>            Assignee: liyang
>             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)