Re: why advisoryPartitionSize <= maxShuffledHashJoinLocalMapThreshold

2023-08-15 Thread XiDuo You
CoalesceShufflePartitions will merge small partitions into bigger ones. Say, if you set maxShuffledHashJoinLocalMapThreshold to 32MB, but the advisoryPartitionSize is 64MB, then the final each reducer partition size will be close to 64MB. It breaks the maxShuffledHashJoinLocalMapThreshold. So we sh

why advisoryPartitionSize <= maxShuffledHashJoinLocalMapThreshold

2023-08-15 Thread ??????
dear community,         I want to set  maxShuffledHashJoinLocalMapThreshold to enable convert smj to hash join,but I found maxShuffledHashJoinLocalMapThreshold must be large than advisoryPartitionSize. I want to know what happend if maxShuffledHashJoinLocalMapThreshold < advisoryPartitionSize