topic Re: right semi join in Data Engineering

right semi join

PB-Data — Wed, 17 Jul 2024 08:49:45 GMT

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 — Wed, 17 Jul 2024 09:11:22 GMT

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:

PB-Data — Wed, 17 Jul 2024 14:27:02 GMT