Jia Fan created SPARK-43308: ------------------------------- Summary: Improve scalar subquery logic plan when result are literal Key: SPARK-43308 URL: https://issues.apache.org/jira/browse/SPARK-43308 Project: Spark Issue Type: Improvement Components: SQL Affects Versions: 3.5.0 Reporter: Jia Fan
When use scalar subquery, sometimes we can get result before physical plan execute. Like `select a, (select (count(1)) is null from r where a = c group by c) from l where a < 4`. The result alway be false. So we can skip unnecessary aggregate. -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org