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
demandé il y a 8 mois432 vues
1 réponse
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
répondu il y a 8 mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions