Skip to main content
Panther Knowledge Base

Why do I see a table and partition mismatch error in my self-hosted Panther account?


When trying to use the Data Explorer in my self-hosted Panther instance, the following error occurs: 

HIVE_PARTITION_SCHEMA_MISMATCH: There is a mismatch between the table and partition schemas. The types are incompatible and cannot be coerced.


To resolve this issue:

  • Try splitting your query time range into 2 queries based on when you updated your Panther instance:
  • Query ('2023-10-27 00:00:01Z' - before upgrade timestamp)
  • Query (after upgrade timestamp -'2023-11-03 23:59:59')


This issue occurs when a self-hosted instance is recently upgraded and users try to query within that time range.


  • Was this article helpful?