[ 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