How to use outer apply in Spark sql

Question

I am new to spark sql. I am in a situation to convert existing sql query to spark sql. My existing sql query contains outer apply function which needs to work in spark sql. What is the alternative for Outer apply in Spark sql?

Any help much appreciated.

Thanks in advance.

Any help much appreciated.

Thanks in advance.

user_3946641 · Answer

You can do a OUTER APPLY with LEFT JOIN LATERAL ( query ).

Here a link to the official documentation including examples at the bottom: JOIN (Databricks SQL)

user_2015904 · Answer

OUTER APPLY is just a LEFT OUTER JOIN

How to use outer apply in Spark sql

2 Answers