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)
