[ https://issues.apache.org/jira/browse/SPARK-12845?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15107600#comment-15107600 ]
Xiao Li commented on SPARK-12845: --------------------------------- I think the following PR resolves your issue: https://github.com/apache/spark/pull/10490 Right? > 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