Giving error on refreshing the dataset from Athena

Question & Answer
, , , , , ,
1

I have created a QuickSight dashboard with source as Athena. Initially the data refresh was working fine but now it is giving error as follows :

Error type:

SQL_EXCEPTION Learn More

This is a general SQL error. This can be caused by query timeouts, resource constraints, unexpected DDL alterations before or during a query, and other database errors. Check your database settings and your query, and try again.

Error details:

HIVE_PARTITION_SCHEMA_MISMATCH: There is a mismatch between the table and partition schemas. The types are incompatible and cannot be coerced. The column ‘browsersisinstalled’ in table ‘quicksight_db.cleaned_glue_data’ is declared as type ‘boolean’, but partition ‘year=2024/month=10/day=10’ declared column ‘browsername’ as type ‘string’.

2

FYI :

Both the columns -
browsersisinstalled should be boolean
browsername should be string.

3

Hi @kolishashank2712, welcome to the QuickSight Community!

I believe this is of the same issue as in the following post.
*Please note the following is a third party forum outside AWS and I’m providing it for reference purpose only

You might want to check the schema of both table and partition, and drop and recreate the partition so it matches table’s schema.

4

Hi @kolishashank2712,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

5

Hi @kolishashank2712,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!