[jira] [Created] (FLINK-39779) FLIP-579: LATERAL SNAPSHOT Join

["Fabian Hueske (Jira)" <ji...@apache.org>]

Fabian Hueske created FLINK-39779:
-------------------------------------

             Summary: FLIP-579: LATERAL SNAPSHOT Join
                 Key: FLINK-39779
                 URL: https://issues.apache.org/jira/browse/FLINK-39779
             Project: Flink
          Issue Type: New Feature
          Components: Table SQL / API, Table SQL / Planner, Table SQL / Runtime
            Reporter: Fabian Hueske


Add new LATERAL SNAPSHOT Join to support processing-time temporal table joins.

This feature consists of the following tasks
 * make TABLE keyword optional in LATERAL contexts
 * add built-in SNAPSHOT function definition to specify temporal table joins in SQL with a built-in (temporal) table function.
 * add implementation of new join operator for processing-time temporal table joins with improved semantics
 ** initialization phase to prevent early joining
 ** immediate joining after initialization (no dependency on build-side WMs)
 ** atomic application of update changes (U- and U+)
 * add optimization rules to translate LATERAL call of SNAPSHOT function into new join operator and prevent usage of SNAPSHOT outside of LATERAL context
 * end-to-end tests to ensure correctness of join



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