Aws Athena unknown error

Question

Facing the below issue while using Athena to load the Partitioned details.

```
HIVE_UNKNOWN_ERROR: serDe should not be accessed from a null StorageFormat
This query ran against the "mydb" database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query Id: 25a2a209-4826-4861-909e-059fe954e12b
```

Answer

If you had used Glue Crawler to create your table in Athena, most likely its unable to classify the data and you can verify it by [querying](https://docs.aws.amazon.com/cli/latest/reference/glue/get-table.html) table's InputFormat, OutputFormat and SerializationLibrary parameters.

Below are few suggestions to similar questions within this forum

https://repost.aws/questions/QUALQTowQHTyC35vQnh10gRQ/hive-unknown-error-ser-de-should-not-be-accessed-from-a-null-storage-format

https://repost.aws/questions/QUGcW-6V8wSmGleOu0XL0CqA/athena-ser-de-should-not-be-accessed-from-a-null-storage-format

https://aws.amazon.com/premiumsupport/knowledge-center/athena-unable-to-create-input-format/

Aws Athena unknown error

Conteúdo relevante