[ https://issues.apache.org/jira/browse/IGNITE-21311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17826059#comment-17826059 ]
Iurii Gerzhedovich commented on IGNITE-21311: --------------------------------------------- [~mzhuravkov] Thanks for the contribution! > Sql. Partition pruning. Introduce pruning for correlated scans > -------------------------------------------------------------- > > Key: IGNITE-21311 > URL: https://issues.apache.org/jira/browse/IGNITE-21311 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Konstantin Orlov > Assignee: Maksim Zhuravkov > Priority: Major > Labels: ignite-3 > Time Spent: 50m > Remaining Estimate: 0h > > Apart of static pruning made on preparation step, we may also introduce > dynamic pruning for correlated scans. > In case of correlated join, a predicate on the right shoulder should be > evaluated based on the context provided from the left shoulder. This context > is not known until runtime, those partitions are not trimmed on preparation > step. However, this very case doesn't differ match from the static pruning: > the only difference here is a time when pruning should be applied. > In order to support dynamic pruning, we should save pruning meta during > planning phase in a scan node. Later, in runtime, we should evaluate pruning > function in order to derive partitions satisfying the predicate. Those > partitions should be used to do a lookup into a table. -- This message was sent by Atlassian Jira (v8.20.10#820010)