You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "Anton Borisov (Jira)" <ji...@apache.org> on 2025/12/31 16:57:00 UTC

[jira] [Created] (FLINK-38854) Enrich upsert keys across equivalence relations in MultiJoin

Anton Borisov created FLINK-38854:
-------------------------------------

             Summary: Enrich upsert keys across equivalence relations in MultiJoin
                 Key: FLINK-38854
                 URL: https://issues.apache.org/jira/browse/FLINK-38854
             Project: Flink
          Issue Type: Improvement
          Components: Table SQL / Planner
    Affects Versions: 2.2.0
            Reporter: Anton Borisov


*Description*
In FLINK-38753, upsert keys are enriched for *binary joins* by propagating them across equi-join key equivalences (via {{{}JoinInfo{}}}), using a bounded fixpoint to cover cross-combinations of multiple equi predicates.

This logic currently does not apply when joins are represented as a {{{}MultiJoin{}}}.

For {{{}MultiJoin{}}}, equivalence relations may span more than two inputs, and upsert keys inferred from one input can be equivalent to columns originating from other inputs. Since these substitutions are not derived today, the planner may conservatively infer missing upsert keys and introduce unnecessary {{{}upsertMaterialize{}}}.

*Expected Behavior*

For {{{}MultiJoin{}}}, the planner should:
 * consider all equi-join key equivalence classes across inputs

 * enrich inferred upsert keys by propagating them across these equivalences

 * respect join null-generation semantics (outer joins)

 * use a bounded fixpoint/worklist approach, similar to FLINK-38753

This is a planner metadata improvement only.
h3. *Related*
 * FLINK-38753 — Enrich upsert keys by equivalence expressions for binary joins



--
This message was sent by Atlassian Jira
(v8.20.10#820010)