[ 
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)

Reply via email to