[
https://issues.apache.org/jira/browse/FLINK-39780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fabian Hueske updated FLINK-39780:
----------------------------------
Description:
Make `TABLE` keyword optional in `LATERAL` context:
{code:java}
SELECT *
FROM
t,
CROSS JOIN LATERAL SNAPSHOT(TABLE s)
ON t.a = s.a;{code}
instead of
{code:java}
SELECT *
FROM
t,
CROSS JOIN TABLE(LATERAL SNAPSHOT(TABLE s))
ON t.a = s.a; {code}
The TABLE keyword is already optional in Flink SQL without the LATERAL context.
So this change improves the consistency of Flink's SQL dialect.
This improvement is part of
[FLIP-579|https://cwiki.apache.org/confluence/spaces/FLINK/pages/421958523/FLIP-579+LATERAL+SNAPSHOT+Join]
was:
Make `TABLE` keyword optional in `LATERAL` context:
{code:java}
SELECT *
FROM
t,
CROSS JOIN LATERAL SNAPSHOT(TABLE s)
ON t.a = s.a;{code}
instead of
{code:java}
SELECT *
FROM
t,
CROSS JOIN TABLE(LATERAL SNAPSHOT(TABLE s))
ON t.a = s.a; {code}
The TABLE keyword is already optional in Flink SQL without the LATERAL context.
So this change improves the consistency of Flink's SQL dialect.
{{}}
> Make TABLE keyword optional in LATERAL context
> ----------------------------------------------
>
> Key: FLINK-39780
> URL: https://issues.apache.org/jira/browse/FLINK-39780
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Reporter: Fabian Hueske
> Assignee: Fabian Hueske
> Priority: Major
> Labels: pull-request-available
>
> Make `TABLE` keyword optional in `LATERAL` context:
> {code:java}
> SELECT *
> FROM
> t,
> CROSS JOIN LATERAL SNAPSHOT(TABLE s)
> ON t.a = s.a;{code}
> instead of
> {code:java}
> SELECT *
> FROM
> t,
> CROSS JOIN TABLE(LATERAL SNAPSHOT(TABLE s))
> ON t.a = s.a; {code}
> The TABLE keyword is already optional in Flink SQL without the LATERAL
> context.
> So this change improves the consistency of Flink's SQL dialect.
>
> This improvement is part of
> [FLIP-579|https://cwiki.apache.org/confluence/spaces/FLINK/pages/421958523/FLIP-579+LATERAL+SNAPSHOT+Join]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
