GENERIC_INTERNAL_ERROR when select * from iceberg table

0

I am getting below error when running SELECT, INSERT, DELETE or any other statement on ICEBERG table

GENERIC_INTERNAL_ERROR: io.trino.plugin.hive.s3.TrinoS3FileSystem$UnrecoverableS3OperationException: com.amazonaws.services.s3.model.AmazonS3Exception: The specified key does not exist. (Service: Amazon S3; Status Code: 404; Error Code: NoSuchKey; Request ID: 01PHNZRRTYEF3169; S3 Extended Request ID: IvGkhgs9KJqlgmeL5hd9uhZiTYUfgI9JR7k7WgecOWnmN6LkusUVqUBoCbfmGl8KjdIKBSu4Q5U=; Proxy: null)

I have tried repairing the table using MSCK REPAIR TABLE <TABLE_NAME> but it says athena doesn't support this. When I try to OPTIMIZE table then also I get same GENERIC_INTERNAL_ERROR.

I checked S3 bucked related to this athena table and it has both metadata and data available.

Bharat
asked 7 months ago399 views
1 Answer
0

Hello.

The error states "The specified key does not exist.", but is the key specified in the query correct?
Also, are the permissions set to access that key?

profile picture
EXPERT
answered 7 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