aws query engine don't support all hudi promotion type

athena and spectrum have limitation in promotion type support. Then hudi has better to rollback the commit when the sync operation failed. OTW the table would be in a corrupted state for the query engine.

|          | int->bigint | int->float | float->double | int->string | 
|----------|-------------|------------|---------------|-------------|
| spark    | yes         | yes        | yes           | yes         |
| athena   | yes         | yes        | yes           | no          |
| spectrum | yes         | no         | yes           | no          |

## JIRA info

- Link: https://issues.apache.org/jira/browse/HUDI-8292
- Type: Improvement
- Fix version(s):
- 1.1.0