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달 전411회 조회
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달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠