- Newest
- Most votes
- Most comments
Hello,
Generally above error occurs when partition schema is not compatible with table schema. I understand in error its showing two different columns but that means that you need to check both the columns at partition level mentioned in error and tabel level to verify the schema. If you find discrepancy then you need to update your partition schema and make sure its compatible with table schema.
It seems like you are using crawler to load the partition. If your file format is csv,josn or text file format then you can use crawler with "Update all new and existing partitions with metadata from the table" to overcome this issue.
https://repost.aws/knowledge-center/athena-hive-partition-schema-mismatch
If your file format is structured like paruqet,orc then you need to check the file again for mentioned partition and verify the schema. If it contains incompatible schema then you need to generate that file again with consistent schema to avoid this issue as incas of parquet it reference the metadat from file footer itself.
Relevant content
- asked 2 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 2 years ago