[
https://issues.apache.org/jira/browse/SPARK-59627?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated SPARK-59627:
-----------------------------------
Labels: pull-request-available (was: )
> ASOF JOIN gives a generic syntax error for unsupported join types
> -----------------------------------------------------------------
>
> Key: SPARK-59627
> URL: https://issues.apache.org/jira/browse/SPARK-59627
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 5.0.0
> Reporter: Luka Zdravic
> Priority: Minor
> Labels: pull-request-available
>
> The ASOF JOIN grammar allows only INNER or LEFT [OUTER] before ASOF. Any
> other join type is rejected at parse time, but with a generic
> PARSE_SYNTAX_ERROR that does not tell the user which join type is not allowed.
>
> Repro (each fails with PARSE_SYNTAX_ERROR):
> SELECT * FROM l RIGHT ASOF JOIN r MATCH_CONDITION (l.ts >= r.ts);
> SELECT * FROM l FULL ASOF JOIN r MATCH_CONDITION (l.ts >= r.ts);
> SELECT * FROM l CROSS ASOF JOIN r MATCH_CONDITION (l.ts >= r.ts);
> Example message: "Syntax error at or near 'asof': extra input 'asof'".
>
> Expected: a clear error that names the incompatible join type, e.g.
> "The join types ASOF and RIGHT OUTER are incompatible."
> Umbrella: SPARK-59626
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
