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

Issue

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.

Resolution

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')

Cause

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