[core] Reduce small files while batch write append only table with a lot of partitions.

[core] Reduce small files while batch write append only table with a lot of partitions. #7807