[
https://issues.apache.org/jira/browse/IGNITE-21262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-21262:
--------------------------------------
Description:
Currently, predicate doesn't pushed down under LogicalCorrelate node. As a
result, complex queries with multiple joins, such q2, q4, q21, q22 from TPC-H
suite, executed as a humongous cross join of several tables with post
filtration afterwards.
This could simply be addressed by introducing {{CoreRules.FILTER_CORRELATE}} to
rule set.
was:
Currently, predicate doesn't pushed down under LogicalCorrelate node. As a
result, complex queries with multiple joins, such q2, q4, q21, q22 from TPC-H
suite, executed as a humongous cross join of several tables with post
filtration afterwards.
This could simply be addressed by introducing {{CoreRules.FILTER_CORRELATE}} to
rule set.
> Sql. Push down predicate under correlate
> ----------------------------------------
>
> Key: IGNITE-21262
> URL: https://issues.apache.org/jira/browse/IGNITE-21262
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Konstantin Orlov
> Assignee: Konstantin Orlov
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0.0-beta2
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Currently, predicate doesn't pushed down under LogicalCorrelate node. As a
> result, complex queries with multiple joins, such q2, q4, q21, q22 from TPC-H
> suite, executed as a humongous cross join of several tables with post
> filtration afterwards.
> This could simply be addressed by introducing {{CoreRules.FILTER_CORRELATE}}
> to rule set.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
