[
https://issues.apache.org/jira/browse/SPARK-20175?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15950624#comment-15950624
]
Apache Spark commented on SPARK-20175:
--------------------------------------
User 'viirya' has created a pull request for this issue:
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
>
> 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]
