[ https://issues.apache.org/jira/browse/KYLIN-5521?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yaguang Jia updated KYLIN-5521: ------------------------------- Fix Version/s: 5.0-beta > 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: JoinsGraph 改造 Dev Design.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)