[ https://issues.apache.org/jira/browse/SPARK-43308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jia Fan updated SPARK-43308: ---------------------------- Parent: SPARK-35553 Issue Type: Sub-task (was: Improvement) > 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: Sub-task > Components: SQL > Affects Versions: 3.5.0 > Reporter: Jia Fan > Priority: Major > > 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