right semi join

[PB-Data]

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.

[szymon_dybczak]

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:

https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-syntax-qry-select-joi...

[PB-Data]

Thanks @szymon_dybczak 👍