[jira] [Created] (SPARK-12845) During join Spark should pushdown predicates to both tables

["Maciej Bryński (JIRA)" <ji...@apache.org>]

Maciej Bryński created SPARK-12845:
--------------------------------------

             Summary: 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 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.



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

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