You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "Jia Fan (Jira)" <ji...@apache.org> on 2023/04/27 12:45:00 UTC

[jira] [Updated] (SPARK-43308) Improve scalar subquery logic plan when result are literal

     [ 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org