right semi join

PB-Data
New Contributor III

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.