How to decide bucket number

[chenwyi2]

Query engine

Flink

Question

There is a formula to get the number of buckets? If buckets number is small when i set write.distribution-mode=hash, and QPS is relatively high, then the data can be back pressure, but if buckets number is large, samll file can be a problem which can slow down our query, so we can get a formula to calculate buckets number reasonably？

[github-actions]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[github-actions]

This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'