[SUPPORT] Athena does not support s3a partition scheme anymore leading to missing data

[parisni]

Describe the problem you faced

Few days ago we had suddently 0 data in all our hudi partitionned tables when querying from athena. Spark and redshift spectrum were not affected by the issue.

We found out that new athena version silently drop hudi data when the partition location has a s3a scheme. Recreating the table with partition s3 scheme fixed the issue

This affect any version of hudi, when the basepath is specified with s3a scheme