[HUDI-8292]: avoid commit promotion type not supported by aws tools

[parisni]

Change Logs

• rollback when metastore syncfails
• change schemaDifference updateColumn structure to store previous/next type
• glue sync to fail when unsupported schema evolution

#11599 fixes #11701

Impact

none

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

none

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:

• f56729bb1d7fd305d2d76b8c08d9377c8bb56b43 Azure: SUCCESS

Bot commands

@hudi-bot supports the following commands:

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

[yihua]

@parisni is this ready for review again?

[yihua]

Could you also file a JIRA?

[parisni]

Its ready for revews. Let me add the jira ticket

[parisni]

@yihua updated with a jira ticket. BTW I did not yet test this patch to confirm it works as expected.