[HUDI-8521] Use commit time merge in preCombine for OverwriteWithLatestAvroPayload

[linliu-code]

Change Logs

Currently HoodieMergedLogRecordScanner could use HoodiePreCombineAvroRecordMerger to merge log records, which treats all the records from the same batch, and does not respect the order of records across different batches. Such that commit time merging logic is broken.

Therefore, we use the configured merger instead.

Impact

Fix the bug for commit time merging.

Risk level (write none, low medium or high below)

Medium.

Documentation Update

Describe any necessary documentation update if there is any new feature, config, or user-facing change. If not, put "none".

• The config description must be updated if new configs are added or the default value of the configs are changed
• Any new feature or user-facing change requires updating the Hudi website. Please create a Jira ticket, attach the ticket number here and follow the instruction to make changes to the website.

Contributor's checklist

• [ ] Read through contributor's guide
• [ ] Change Logs and Impact were stated clearly
• [ ] Adequate tests were added if applicable
• [ ] CI passed

[hudi-bot]

CI report:

• e2dab8e55299754349e13fd7a5ae432f6d663be8 Azure: FAILURE

Bot commands

@hudi-bot supports the following commands: - `@hudi-bot run azure` re-run the last Azure build