[
https://issues.apache.org/jira/browse/SPARK-20175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wenchen Fan resolved SPARK-20175.
---------------------------------
Resolution: Fixed
Fix Version/s: 2.2.0
Issue resolved by pull request 17491
[https://github.com/apache/spark/pull/17491]
> Exists should not be evaluated in Join operator and can be converted to
> ScalarSubquery if no correlated reference
> -----------------------------------------------------------------------------------------------------------------
>
> Key: SPARK-20175
> URL: https://issues.apache.org/jira/browse/SPARK-20175
> Project: Spark
> Issue Type: Improvement
> Components: SQL
> Affects Versions: 2.1.0
> Reporter: Liang-Chi Hsieh
> Fix For: 2.2.0
>
>
> Similar to ListQuery, Exists should not be evaluated in Join operator too.
> Otherwise, a query like following will fail:
> sql("select * from l, r where l.a = r.c + 1 AND (exists (select * from r) OR
> l.a = r.c)")
> For the Exists subquery without correlated reference, this patch converts it
> to scalar subquery with a count Aggregate operator.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
