[HUDI-4071] Enable schema reconciliation by default

[codope]

What is the purpose of the pull request

Segregating all the config flips in #5643 . This one enables reconcile schema by default.

Brief change log

(for example:)

• Modify AnnotationLocation checkstyle rule in checkstyle.xml

Verify this pull request

(Please pick either of the following options)

This pull request is a trivial rework / code cleanup without any test coverage.

(or)

This pull request is already covered by existing tests, such as (please describe tests).

(or)

This change added tests and can be verified as follows:

(example:)

• Added integration tests for end-to-end.
• Added HoodieClientWriteTest to verify the change.
• Manually verified the change by running a job locally.

Committer checklist

• [ ] Has a corresponding JIRA in PR title & commit

• [ ] Commit message is descriptive of the change

• [ ] CI is green

• [ ] Necessary doc changes done or have another open PR

• [ ] For large changes, please consider breaking it into sub-tasks under an umbrella JIRA.

[xushiyan]

some spark sql test failed. is it actually safe to enable this? not sure if this config could be unintended in some cases.

[yihua]

@alexeykudinkin could you also review this PR?

[hudi-bot]

CI report:

• 1dfb9ffa267bce2c73bdc10e285a3ab2d3e15939 Azure: FAILURE

Bot commands

@hudi-bot supports the following commands:

• @hudi-bot run azure re-run the last Azure build

[codope]

Closing it as we first need to audit the full schema evolution scenarios.