[jira] [Assigned] (IGNITE-13975) Validate that tables beind joined have the same partition distribution

["Maksim Timonin (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-13975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Maksim Timonin reassigned IGNITE-13975:
---------------------------------------

    Assignee: Maksim Timonin

> Validate that tables beind joined have the same partition distribution
> ----------------------------------------------------------------------
>
>                 Key: IGNITE-13975
>                 URL: https://issues.apache.org/jira/browse/IGNITE-13975
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Stanislav Lukyanov
>            Assignee: Maksim Timonin
>            Priority: Major
>
> To be able to join two PARTITIONED tables one needs to perform the JOIN on an affinity key, and also to make sure that the tables have the same partition distribution - otherwise, the result will be incorrect.
> Validation of whether the affinity key is being used for JOIN is to be done in https://issues.apache.org/jira/browse/IGNITE-13019.
> The goal of this ticket is to add validation of the partition distribution.
> Whenever a JOIN of PARTITIONED tables is being done, the SQL engine needs to ensure that
>  * The tables use the same affinity function
>  * The tables have the same number of partitions
>  * The tables have the same node filters
> Same is for when REPLICATED tables are used and `treatReplicatedAsPartitioned=true` (see https://issues.apache.org/jira/browse/IGNITE-8732).



--
This message was sent by Atlassian Jira
(v8.3.4#803005)