What permissions configurations are required on an S3 bucket for Athena to be able to Preview View on an object?


Hello, I've been able to create tables and various views in Athena console after running a Glue crawler against an S3 bucket as a datasource.

When running a Preview View from Athena on a view generated from the Glue crawler, I am getting an error with some reference to a Hive split on a CSV file in our S3 bucket similar to the following:

Error opening Hive split s3://bucket_name/Folder1/folder/File.csv (offset=33554432, length=33554432) using org.apache.hadoop.mapred.TextInputFormat: Permission denied on S3 path: s3://bucket_name/Folder1/folder/File.csv This query ran against the "athena_database_name" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: e9d6e300-c82d-40d0-b9a0-879e97f72db6

It is similar to the issue outlined in : https://stackoverflow.com/questions/68859517/amazon-athena-error-opening-hive-split-s3-path-and-access-denied

I do not think that this is a permission related to my IAM user but I am unsure what the Hive split is related to. Is this service related? If anyone has a solution for this, please let me know.

Thank you in advance.

  • M
asked 2 years ago1506 views
1 Answer

Although not exactly similar to the error you are getting, maybe compare your IAM permissions with this checklist https://aws.amazon.com/premiumsupport/knowledge-center/access-denied-athena/

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions