Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
Docs Required, Release Notes Required
Description
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).
Attachments
Issue Links
- is related to
-
IGNITE-8732 SQL: REPLICATED cache cannot be left-joined to PARTITIONED
- Resolved
-
IGNITE-13019 Unexpected JOIN result when querying a single-node cluster
- Resolved