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.
AWS 官方已更新 3 個月前