[HUDI-8178] Fix CI failures for partition-stats enablement

[linliu-code]

Change Logs

Enable partition stats index by default, and fix test failures caused.

Root causes include:

1. Test setup.
2. UTF8 to String casting.
3. Date to LocalDate casting.
4. .partition.metadata is missing within partition-stats folder.
5. Different types of partition stats due to schema evolution.

Impact

Partition stats is available genreally.

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

High.

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:

• 7e413900f4f70c34bb8e33d42f3e0ba973e716b2 Azure: FAILURE

Bot commands

@hudi-bot supports the following commands:

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

[nsivabalan]

We fixed both Date and LocalDate with col stats and partition stats.

https://github.com/apache/hudi/blob/1f43b231763a978bef8d340a654e9f6287241ec9/hudi-common/src/main/java/org/apache/hudi/avro/HoodieAvroUtils.java#L152C55-L152C86