Top "Lateral-join" questions

What is the difference between LATERAL and a subquery in PostgreSQL?

Since Postgres came out with the ability to do LATERAL joins, I've been reading up on it, since I currently …

sql postgresql subquery lateral-join
How to read a nested collection in Spark

I have a parquet table with one of the columns being , array<struct<col1,col2,..colN>> …

apache-spark apache-spark-sql nested parquet lateral-join
MySQL - How to unpivot columns to rows?

I'm probably not seeing things very clear at this moment, but I have a table in MySQL which looks like …

mysql sql union unpivot lateral-join
What is the equivalent Syntax for Outer Apply in PostgreSQL

Im trying to find a SQL query on the equivalent usage of OUTER APPLY from MSSQL to PostgreSQL but it …

sql-server postgresql lateral-join
Hive lateral view explode with 2 table joins

Checking to see if this is possible in Hive: Select a.col1,b.col1 from tableA a join tableB b …

hive lateral-join