[jira] [Commented] (SPARK-20175) Exists should not be evaluated in Join operator and can be converted to ScalarSubquery if no correlated reference

["Apache Spark (JIRA)" <ji...@apache.org>]

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