Yuming Wang created SPARK-27877: ----------------------------------- Summary: Implement SQL-standard LATERAL subqueries Key: SPARK-27877 URL: https://issues.apache.org/jira/browse/SPARK-27877 Project: Spark Issue Type: Sub-task Components: SQL Affects Versions: 3.0.0 Reporter: Yuming Wang
Subqueries appearing in {{FROM}} can be preceded by the key word {{LATERAL}}. This allows them to reference columns provided by preceding {{FROM}} items. A trivial example of {{LATERAL}} is: {code:sql} SELECT * FROM foo, LATERAL (SELECT * FROM bar WHERE bar.id = foo.bar_id) ss; {code} More details: [https://www.postgresql.org/docs/9.3/queries-table-expressions.html#QUERIES-LATERAL] [https://github.com/postgres/postgres/commit/5ebaaa49445eb1ba7b299bbea3a477d4e4c0430] -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org