This is an automated email from the ASF dual-hosted git repository. fhueske pushed a commit to branch fhueske-FLINK-39780-Make-TABLE-keyword-optional-in-LATERAL-context in repository https://gitbox.apache.org/repos/asf/flink.git
commit d20007f73cba99c918ed26ea6abd4fbbeed95e77 Author: Fabian Hueske <[email protected]> AuthorDate: Thu Aug 27 15:16:19 2026 +0200 [FLINK-39780][docs] Use implicit LATERAL form in the LATERAL SNAPSHOT join docs Convert the LATERAL SNAPSHOT join documentation (added upstream since this PR was opened) to the implicit table-function form, per the preference for the syntax without TABLE. Co-Authored-By: Claude Opus 4.8 (1M context) <[email protected]> --- docs/content.zh/docs/sql/reference/queries/joins.md | 17 ++++++++--------- docs/content/docs/sql/reference/queries/joins.md | 17 ++++++++--------- 2 files changed, 16 insertions(+), 18 deletions(-) diff --git a/docs/content.zh/docs/sql/reference/queries/joins.md b/docs/content.zh/docs/sql/reference/queries/joins.md index c69a8318367..2aad89d7588 100644 --- a/docs/content.zh/docs/sql/reference/queries/joins.md +++ b/docs/content.zh/docs/sql/reference/queries/joins.md @@ -323,7 +323,7 @@ For example, the following query enriches an append-only stream of `orders` (the SELECT o.order_id, o.currency, o.amount, r.rate FROM orders AS o -JOIN LATERAL TABLE(SNAPSHOT(input => TABLE currency_rates)) AS r +JOIN LATERAL SNAPSHOT(input => TABLE currency_rates) AS r ON o.currency = r.currency; order_id currency amount rate @@ -360,19 +360,18 @@ The load phase is what distinguishes a `LATERAL SNAPSHOT` join from the [process **Syntax** -The build side is wrapped in the `SNAPSHOT` table function inside a `LATERAL TABLE` clause. The outer (probe-side) table must be an append-only table. +The build side is wrapped in the `SNAPSHOT` table function, which is called with `LATERAL`. The outer (probe-side) table must be an append-only table. Both `INNER JOIN` and `LEFT [OUTER] JOIN` are supported. The join requires at least one conjunctive equality predicate; additional non-equi predicates are allowed in the `ON` clause. ```sql SELECT [column_list] FROM probe_table -[LEFT] JOIN LATERAL TABLE( - SNAPSHOT( - input => TABLE build_table, - [ load_completed_condition => <'compile_time' | 'user_time'>, ] - [ load_completed_time => <timestamp_ltz>, ] - [ load_completed_idle_timeout => <interval>, ] - [ state_ttl => <interval> ])) AS s +[LEFT] JOIN LATERAL SNAPSHOT( + input => TABLE build_table, + [ load_completed_condition => <'compile_time' | 'user_time'>, ] + [ load_completed_time => <timestamp_ltz>, ] + [ load_completed_idle_timeout => <interval>, ] + [ state_ttl => <interval> ]) AS s ON probe_table.col = s.col ``` diff --git a/docs/content/docs/sql/reference/queries/joins.md b/docs/content/docs/sql/reference/queries/joins.md index 74645e18976..c5a5123d96a 100644 --- a/docs/content/docs/sql/reference/queries/joins.md +++ b/docs/content/docs/sql/reference/queries/joins.md @@ -328,7 +328,7 @@ For example, the following query enriches an append-only stream of `orders` (the SELECT o.order_id, o.currency, o.amount, r.rate FROM orders AS o -JOIN LATERAL TABLE(SNAPSHOT(input => TABLE currency_rates)) AS r +JOIN LATERAL SNAPSHOT(input => TABLE currency_rates) AS r ON o.currency = r.currency; order_id currency amount rate @@ -369,19 +369,18 @@ By first loading the build side, a `LATERAL SNAPSHOT` join avoids this problem. **Syntax** -The build side is wrapped in the `SNAPSHOT` table function inside a `LATERAL TABLE` clause. The outer (probe-side) table must be an append-only table. +The build side is wrapped in the `SNAPSHOT` table function, which is called with `LATERAL`. The outer (probe-side) table must be an append-only table. Both `INNER JOIN` and `LEFT [OUTER] JOIN` are supported. The join requires at least one conjunctive equality predicate; additional non-equi predicates are allowed in the `ON` clause. ```sql SELECT [column_list] FROM probe_table -[LEFT] JOIN LATERAL TABLE( - SNAPSHOT( - input => TABLE build_table, - [ load_completed_condition => <'compile_time' | 'user_time'>, ] - [ load_completed_time => <timestamp_ltz>, ] - [ load_completed_idle_timeout => <interval>, ] - [ state_ttl => <interval> ])) AS s +[LEFT] JOIN LATERAL SNAPSHOT( + input => TABLE build_table, + [ load_completed_condition => <'compile_time' | 'user_time'>, ] + [ load_completed_time => <timestamp_ltz>, ] + [ load_completed_idle_timeout => <interval>, ] + [ state_ttl => <interval> ]) AS s ON probe_table.col = s.col ```
