[jira] [Created] (KYLIN-5521) Query SQL association order change causes the model to fail to hit

["Yaguang Jia (Jira)" <ji...@apache.org>]

Yaguang Jia created KYLIN-5521:
----------------------------------

             Summary: 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
            Reporter: Yaguang Jia


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)