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)
