[ 
https://issues.apache.org/jira/browse/SPARK-12845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15108158#comment-15108158
 ] 

Xiao Li edited comment on SPARK-12845 at 1/20/16 7:27 AM:
----------------------------------------------------------

It supports Inner, Right-outer, Left-outer and Left-semi Join. 

Unfortunately, this idea is not applicable to Full-outer Join. 


was (Author: smilegator):
It supports both Inner and Outer Join

> During join Spark should pushdown predicates on joining column to both tables
> -----------------------------------------------------------------------------
>
>                 Key: SPARK-12845
>                 URL: https://issues.apache.org/jira/browse/SPARK-12845
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.6.0
>            Reporter: Maciej BryƄski
>
> I have following issue.
> I'm connecting two tables with where condition
> {code}
> select * from t1 join t2 in t1.id1 = t2.id2 where t1.id = 1234
> {code}
> In this code predicate is only push down to t1.
> To have predicates on both table I should run following query:
> {code}
> select * from t1 join t2 in t1.id1 = t2.id2 where t1.id = 1234 and t2.id2 = 
> 1234
> {code}
> Spark should present same behaviour for both queries.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to