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?

moshe
質問済み 5ヶ月前412ビュー
1回答
3
承認された回答

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
サポートエンジニア
回答済み 5ヶ月前
profile picture
エキスパート
レビュー済み 5ヶ月前
profile picture
エキスパート
レビュー済み 5ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ