KeKe Zhu created SPARK-52186:
--------------------------------

             Summary: An Optimization for EXISTS Subquery
                 Key: SPARK-52186
                 URL: https://issues.apache.org/jira/browse/SPARK-52186
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.5.5, 3.5.4, 4.0.0
            Reporter: KeKe Zhu


Since EXISTS only returns True or False, it doesn't matter what is SELECTED. 
Therefore, an optimization rule can be added to check whether the EXISTS clause 
contains Project 1, If not, add a Project 1 on the EXISTS. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to