[jira] [Updated] (SPARK-27741) Transitivity on predicate pushdown

["U Shaw (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SPARK-27741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

U Shaw updated SPARK-27741:
---------------------------
    Fix Version/s: 2.4.0

> Transitivity on predicate pushdown 
> -----------------------------------
>
>                 Key: SPARK-27741
>                 URL: https://issues.apache.org/jira/browse/SPARK-27741
>             Project: Spark
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 2.1.1
>            Reporter: U Shaw
>            Priority: Major
>             Fix For: 2.4.0
>
>
> When using inner join, where conditions can be passed to join on, and when using outer join, even if the conditions are the same, only the predicate is pushed down to left or right.
> As follows:
> select * from t1 left join t2 on t1.id=t2.id where t1.id=1
> --> select * from t1 left join on t1.id=t2.id and t2.id=1 where t1.id=1
> Is Catalyst can support transitivity on predicate pushdown ?



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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