[ 
https://issues.apache.org/jira/browse/SPARK-28155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16877975#comment-16877975
 ] 

Xiao Li commented on SPARK-28155:
---------------------------------

[https://github.com/apache/spark/pull/24956]

> Improve SQL optimizer's predicate pushdown performance for cascading joins
> --------------------------------------------------------------------------
>
>                 Key: SPARK-28155
>                 URL: https://issues.apache.org/jira/browse/SPARK-28155
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Yesheng Ma
>            Assignee: Yesheng Ma
>            Priority: Major
>
> The current catalyst optimizer's predicate pushdown is divided into two 
> separate rules: PushDownPredicate and PushThroughJoin. This is not efficient 
> for optimizing cascading joins such as TPC-DS q64, where a whole default 
> batch is re-executed just due to this. We need a more efficient approach to 
> pushdown predicate as much as possible in a single pass.



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

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to