I published a new blog post on the tecRacer AWS Blog: https://www.tecracer.com/blog/2022/01/solving-hive-partition-schema-mismatch-errors-in-athena.html