Athena Dynamodb ClassCastException

The error message suggests that the issue is related to a type conversion error when casting a java.lang.String to a java.math.BigDecimal. This can happen when the data types in the DynamoDB table do not match the data types specified in the Athena schema.

To resolve this issue, you may need to update the Athena schema to reflect the correct data types. You can use the CAST or TRY_CAST function in Athena to cast the data to the correct data type.

For example, if you have a column named my_column in your Athena schema that is supposed to be a DECIMAL data type, you could use the following query to cast the data to the correct type:

vbnet Copy code SELECT TRY_CAST(my_column as DECIMAL) FROM my_table; If you have already tried using TRY_CAST and are still experiencing issues, it's possible that there are other data type mismatches in your schema that are causing the issue. You may need to review the schema and data types in your DynamoDB table to ensure that they are consistent with the data types specified in the Athena schema.