By using AWS re:Post, you agree to the Terms of Use

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

0

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
1 Answer
0

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 6 months 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