Allison Wang created SPARK-36063: ------------------------------------ Summary: Optimize OneRowRelation subqueries Key: SPARK-36063 URL: https://issues.apache.org/jira/browse/SPARK-36063 Project: Spark Issue Type: Sub-task Components: SQL Affects Versions: 3.2.0 Reporter: Allison Wang
Inline subqueries with OneRowRelation as leaf nodes instead of decorrelating and rewriting them as left outer joins. Scalar subquery: ``` SELECT (SELECT c1) FROM t1 -> SELECT c1 FROM t1 ``` Lateral subquery: ``` SELECT * FROM t1, LATERAL (SELECT c1, c2) -> SELECT c1, c2 , c1, c2 FROM t1 ``` -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org