HIVE_PARTITION_SCHEMA_MISMATCH

Question

我从AWS雅典娜那里得到了这个错误：

HIVE_PARTITION_SCHEMA_MISMATCH: There is a mismatch between the table and partition schemas. The types are incompatible and cannot be coerced. The column 'id' in table 'db.app_events' is declared as type 'string', but partition 'xxxxx' declared column 'data.entity_price' as type 'double'.

与这些字段没有任何联系，但它会给出一个错误。是bug，还是我漏掉了什么？

Answer 1

架构将保留在分区级别，除非您从表中继承架构。看看这个：https://docs.aws.amazon.com/athena/latest/ug/updates-and-partitions.html

这里也讨论了：How to solve this HIVE_PARTITION_SCHEMA_MISMATCH?

Answer 2

ALTER TABLE tableName CHANGE columnName newColumnName类型级联；