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

ASF GitHub Bot updated SPARK-57993:
-----------------------------------
    Labels: pull-request-available  (was: )

> Support advisory partition size in rebalance hint
> -------------------------------------------------
>
>                 Key: SPARK-57993
>                 URL: https://issues.apache.org/jira/browse/SPARK-57993
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 5.0.0
>            Reporter: Zhen Wang
>            Priority: Major
>              Labels: pull-request-available
>
> Spark SQL users often insert a *REBALANCE* hint before writing query results 
> to control small files and produce output partitions with a reasonable target 
> size.
> Today, the target size used by rebalance is controlled by the session-level 
> *spark.sql.adaptive.advisoryPartitionSizeInBytes* configuration. This is too 
> broad for write-side file size control: increasing the advisory partition 
> size for the final write stage can also affect earlier AQE stages, including 
> shuffle coalescing and read/computation parallelism before the final output 
> stage.
> This proposes adding a *REBALANCE_BY_SIZE* hint that works like *REBALANCE* 
> and accepts an optional advisory partition size in bytes as the first 
> parameter, followed by optional partition columns. Users can insert this hint 
> before writing and set the target partition size only for the rebalance 
> shuffle, so the final output file size can be controlled without changing the 
> advisory size used by preceding stages.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

Reply via email to