How do I resolve the "HIVE_CANNOT_OPEN_SPLIT: Error opening Hive split s3://awsdoc-example-bucket/: Slow Down (Service: Amazon S3; Status Code: 503; Error Code: 503 Slow Down;" error in Athena?

Last updated: 2020-07-14

My Amazon Athena query fails with an error like this:

"HIVE_CANNOT_OPEN_SPLIT: Error opening Hive split s3://awsdoc-example-bucket/date=2020-05-29/ingest_date=2020-04-25/part-00000.snappy.parquet (offset=0, length=18614): Slow Down (Service: Amazon S3; Status Code: 503; Error Code: 503 Slow Down;"

Short description

This error usually happens when you query an Amazon Simple Storage Service (Amazon S3) bucket prefix that has a large number of objects. You can send 3,500 PUT/COPY/POST/DELETE and 5,500 GET/HEAD requests per second per prefix in an S3 bucket. There are no limits to the number of prefixes that you can have in your bucket.

Resolution

Use one of the following methods to prevent request throttling:


Did this article help?


Do you need billing or technical support?