right semi join
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 01:49 AM
Hi All,
I am having issue running a simple right semi join in my community databricks edition.
select * from Y right semi join X on Y.y = X.a;
Error : [PARSE_SYNTAX_ERROR] Syntax error at or near 'semi': extra input 'semi'.
Not sure what is the issue with the syntax. The left semi works fine.
Help appreciated.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 02:11 AM
Hi @PB-Data ,
Spark doesn't support right semi and right anti joins. Take a look on below documentation entry to find out all allowed kinds of join:
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-17-2024 07:27 AM
Thanks @szymon_dybczak 👍
