[ https://issues.apache.org/jira/browse/SPARK-11150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li updated SPARK-11150: ---------------------------- Description: Implements dynamic partition pruning by adding a dynamic-partition-pruning filter if there is a partitioned table and a filter on the dimension table. The filter is then planned using a heuristic approach: # As a broadcast relation if it is a broadcast hash join. The broadcast relation will then be transformed into a reused broadcast exchange by the {{ReuseExchange}} rule; or # As a subquery duplicate if the estimated benefit of partition table scan being saved is greater than the estimated cost of the extra scan of the duplicated subquery; otherwise # As a bypassed condition ({{true}}). Below shows a basic example of DPP. !image-2019-10-04-11-20-02-616.png|width=521,height=225! was: Implements dynamic partition pruning by adding a dynamic-partition-pruning filter if there is a partitioned table and a filter on the dimension table. The filter is then planned using a heuristic approach: # As a broadcast relation if it is a broadcast hash join. The broadcast relation will then be transformed into a reused broadcast exchange by the {{ReuseExchange}} rule; or # As a subquery duplicate if the estimated benefit of partition table scan being saved is greater than the estimated cost of the extra scan of the duplicated subquery; otherwise # As a bypassed condition ({{true}}). Below is an example to show how it takes an effect !image-2019-10-04-11-20-02-616.png|width=521,height=225! > Dynamic partition pruning > ------------------------- > > Key: SPARK-11150 > URL: https://issues.apache.org/jira/browse/SPARK-11150 > Project: Spark > Issue Type: New Feature > Components: SQL > Affects Versions: 1.5.1, 1.6.0, 2.0.0, 2.1.2, 2.2.1, 2.3.0 > Reporter: Younes > Assignee: Wei Xue > Priority: Major > Fix For: 3.0.0 > > Attachments: image-2019-10-04-11-20-02-616.png > > > Implements dynamic partition pruning by adding a dynamic-partition-pruning > filter if there is a partitioned table and a filter on the dimension table. > The filter is then planned using a heuristic approach: > # As a broadcast relation if it is a broadcast hash join. The broadcast > relation will then be transformed into a reused broadcast exchange by the > {{ReuseExchange}} rule; or > # As a subquery duplicate if the estimated benefit of partition table scan > being saved is greater than the estimated cost of the extra scan of the > duplicated subquery; otherwise > # As a bypassed condition ({{true}}). > Below shows a basic example of DPP. > !image-2019-10-04-11-20-02-616.png|width=521,height=225! -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org