- 17454 Views
- 7 replies
- 0 kudos
Resolved! Tuning shuffle partitions
Is the best practice for tuning shuffle partitions to have the config "autoOptimizeShuffle.enabled" on? I see it is not switched on by default. Why is that?
- 17454 Views
- 7 replies
- 0 kudos
- 0 kudos
AQE applies to all queries that are:Non-streamingContain at least one exchange (usually when there’s a join, aggregate, or window), one sub-query, or both.Not all AQE-applied queries are necessarily re-optimized. The re-optimization might or might no...
- 0 kudos
- 1330 Views
- 0 replies
- 0 kudos
How to configure Spark to adjust the number of output partitions after a join or groupBy?
I know you can set "spark.sql.shuffle.partitions" and "spark.sql.adaptive.advisoryPartitionSizeInBytes". The former will not work with adaptive query execution, and the latter only works for the first shuffle for some reason, after which it just uses...
- 1330 Views
- 0 replies
- 0 kudos