View a markdown version of this page

Troubleshoot JSON queries - Amazon Athena

Troubleshoot JSON queries

For help on troubleshooting issues with JSON-related queries, see JSON related errors or consult the following resources:

I get errors when I try to read JSON data in Amazon Athena
How do I resolve "HIVE_CURSOR_ERROR: Row is not a valid JSON object - JSONException: Duplicate key" when reading files from AWS Config in Athena?
The SELECT COUNT query in Amazon Athena returns only one record even though the input JSON file has multiple records
How can I see the Amazon S3 source file for a row in an Athena table?

See also Considerations and limitations for SQL queries in Amazon Athena.

Document Conventions

Get the length and size of JSON arrays

Use ML with Athena