[HUDI-8467][DNM] Auto commit enable deprecate (dis allowing auto commit in data table too)

[nsivabalan]

Change Logs

Describe context and summary for this change. Highlight if any code was copied.

Impact

Describe any public API or user-facing feature change or any performance impact.

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

If medium or high, explain what verification was done to mitigate the risks.

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:

• ac60a2396bba75f82d5ce6f699da6d3376dcd136 Azure: FAILURE

Bot commands

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

[danny0405]

I do see some usages for Flink auto commit:

• for delete operation in FlinkDeleteHelper , the logic does not work at all before and we can just replace it with commit;
• for drop partition operation in FlinkDeletePartitionCommitActionExecutor , Flink explicitly enabled the auto-commit in HoodieCatalogUtil.createWriteClient.