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]