Athena S3 Query failing on SlowDown Error
0
Hi there,
I am attempting to follow this tutorial: https://commoncrawl.org/2018/03/index-to-warc-files-and-urls-in-columnar-format/
However when I run the Athena query against the S3 content, I receive the following SlowDown error:
Error opening Hive split s3://commoncrawl/cc-index/table/cc-main/warc/crawl=CC-MAIN-2018-05/subset=warc/part-00223-248eba37-08f7-4a53-a4b4-d990640e4be4.c000.gz.parquet (offset=0, length=67108864): com.amazonaws.services.s3.model.AmazonS3Exception: Please reduce your request rate. (Service: Amazon S3; Status Code: 503; Error Code: SlowDown; Request ID: QQ7HDYXF8HS44HRR; S3 Extended Request ID: yp+/JdDECD+pTbEIv3CrIcgVMgO8RZZgGN+u7Zf6v0gtACf/C3x7ANUDUq2I03gFcnhdBzlNnOs=; Proxy: null), S3 Extended Request ID: yp+/JdDECD+pTbEIv3CrIcgVMgO8RZZgGN+u7Zf6v0gtACf/C3x7ANUDUq2I03gFcnhdBzlNnOs=
This query ran against the "ccindex" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 3bd4d647-091b-42c0-b60e-f689e7aa0f49
Should the Athena Query Editor automatically handle such errors, and implement exponential backoffs so that I can successfully run the query?
asked 3 months ago24 views
1 Answers
0
See the answers to this question: https://repost.aws/questions/QU2JCqkDnLStC-HowHqYN6xA/athena-query-error
answered 3 months ago
Relevant questions
Athena -- Query exhausted resources at this scale factor
asked 3 years agoAthena S3 Query failing on SlowDown Error
asked 3 months agoErrorCode: INTERNAL_ERROR_SERVICE
asked 8 days agoAthena permission error running a query
asked 3 months agoSagemake couldn't access S3 vis athena query
asked 2 months agoHow to query .json.gz files from Amazon Athena?
Accepted Answerasked 3 years agoGENERIC_USER_ERROR for Athena + Dynamodb
asked 25 days agoI cannot use current_date + interval in Athena boto3 query in Lambda
Accepted Answerasked 3 months agoMSCK REPAIR TABLE returns FAILED org.apache.hadoop.hive.ql.exec.DDLTask. nu
asked 5 years agoWhat permissions configurations are required on an S3 bucket for Athena to be able to Preview View on an object?
asked 2 months ago
which query are you running?