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
已提问 7 个月前431 查看次数
1 回答
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
专家
已回答 7 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则

相关内容