[ https://issues.apache.org/jira/browse/SPARK-12845?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maciej Bryński updated SPARK-12845: ----------------------------------- Description: 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. was: 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 which have no sense {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. > During join Spark should pushdown predicates 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