[jira] [Commented] (KYLIN-5521) JoinsGraph optimization: Query SQL association order change causes the model to fail to hit

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

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

ASF GitHub Bot commented on KYLIN-5521:
---------------------------------------

hit-lacus merged PR #2116:
URL: https://github.com/apache/kylin/pull/2116




> JoinsGraph optimization: Query SQL association order change causes the model to fail to hit
> -------------------------------------------------------------------------------------------
>
>                 Key: KYLIN-5521
>                 URL: https://issues.apache.org/jira/browse/KYLIN-5521
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 5.0-alpha
>            Reporter: Yaguang Jia
>            Assignee: Yaguang Jia
>            Priority: Major
>             Fix For: 5.0-beta
>
>         Attachments: (Chinese)KYLIN-5521 JoinsGraph optimization_ Query SQL association order change causes the model to fail to hit.pdf, (English)KYLIN-5521 JoinsGraph optimization_ Query SQL association order change causes the model to fail to hit.pdf
>
>
> In the log, the following two query statements, only the order of the association of the first 2 tables is changed (the actual logical relationship has not changed), resulting in the query statement can not be hit by the same index. When there are only 2 tables after from, the order of the replacement table association can hit the same index.
>  
> 日志中，以下两条查询语句，只是前面2张表的关联先后顺序换了一下（实际逻辑关系并未改变），导致查询语句不能被同一个索引击中。而当from后面只有2张表时，替换表关联的先后顺序是可以击中同一个索引的。
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)