En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

Error while trying to delete ICEBERG table

0

Hi, I created ICEBERG table by using CTAS command. By mistake I deleted the Parquet files and afterwards tried to drop the table. Now once I'm trying to delete the table I'm getting the following error.

DDL execution timed out.
This query ran against the "default" database, unless qualified by the query. Please post the error message on our forum  or contact customer support

How I can recover it?

Sujets
AnalytiqueBase de données
Balises
Amazon AthenaBase de données
Langue
English
moshe
demandé il y a 5 mois412 vues
1 réponse
3
Réponse acceptée

Hello,

This seems to be a known issue as the underlying metadata of iceberg deletion makes timeout from Athena. You can alternatively try to,

  1. delete data/metadata from S3 location if any still exist by manually goto your iceberg location and delete the entire folder.

  2. Navigate into Glue --> Tables --> Select the table(iceberg) --> Delete. This will delete the iceberg table gracefully.

AWS
INGÉNIEUR EN ASSISTANCE TECHNIQUE
Yokesh NK
répondu il y a 5 mois
profile picture
EXPERT
MaxCloud
vérifié il y a 5 mois
profile picture
EXPERT
Antonio_Lagrotteria
vérifié il y a 5 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

Contenus pertinents