[
https://issues.apache.org/jira/browse/KYLIN-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
pengfei.zhan updated KYLIN-5865:
--------------------------------
Attachment: 8813.2.png
> Supports OlapFilterJoinRule.FILTER_ON_JOIN
> ------------------------------------------
>
> Key: KYLIN-5865
> URL: https://issues.apache.org/jira/browse/KYLIN-5865
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 5.0.0
> Reporter: pengfei.zhan
> Assignee: pengfei.zhan
> Priority: Major
> Fix For: 5.0.0
>
> Attachments: 8813.1.png, 8813.2.png, 8813.3.png, 8813.4.png
>
>
> The following SQL hit index problem, casually add a filter condition will
> lead to repair failure, resulting in the query hit aggregation + detail, the
> expectation is to hit the aggregate index.
> !8813.1.png!
> Comparison of the original execution plans, with 1=1 on the left and without
> on the right.
> Optimized execution plan with 1=1 on the left and without on the right.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)