Yuming Wang created SPARK-32628:
-----------------------------------

             Summary: Use bloom filter to improve dynamicPartitionPruning
                 Key: SPARK-32628
                 URL: https://issues.apache.org/jira/browse/SPARK-32628
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.1.0
            Reporter: Yuming Wang


It will throw exception when 
{{spark.sql.optimizer.dynamicPartitionPruning.reuseBroadcastOnly}} is disabled:
{code:sql}
select catalog_sales.* from  catalog_sales join catalog_returns  where 
cr_order_number = cs_sold_date_sk and cr_returned_time_sk < 40000;
{code}
{noformat}
20/08/16 06:44:42 ERROR TaskSetManager: Total size of serialized results of 494 
tasks (1225.3 MiB) is bigger than spark.driver.maxResultSize (1024.0 MiB)
{noformat}

We can improve it with minimum, maximum and bloom filter to reduce serialized 
results.



--
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

Reply via email to