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

[Anton Vinogradov (Jira)]

Stanislav Lukyanov created IGNITE-13975:
-------------------------------------------

             Summary: 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


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)