How do I drop native Delta tables from Athena catalog?

Onboarded native Delta table using

CREATE EXTERNAL TABLE [table_name]
LOCATION '[s3_location]'
TBLPROPERTIES (
'table_type'='DELTA'
);

Works great when I query it. However, when I run

drop table [table_name]

I get the following error:

"Routed statement type 'DROP_TABLE' to DeltaLakeDDLEngine, expected to route to DATACATALOG_DDL_ENGINE"

トピック

タグ

言語

English

質問済み 1年前1388ビュー

2回答

Deleting from the Glue UI or using Glue API works

回答済み 1年前

エキスパート

レビュー済み 1年前

Fabrizio@AWS エキスパート
1年前
see the documentation to review the DDL support: https://docs.aws.amazon.com/athena/latest/ug/delta-lake-tables.html
big-data-user-1234
1年前
@fabrizio this answer is okay as a manual workaround, but I have workloads that rely on the athena API only. There is no feasible way for me to change the underlying code so your workaround is no good for my use case.

Is there any way to raise this issue with the AWS team? The specific ask is "support dropping delta tables from athena via SQL command". Thanks

Is it possible to re-open the issue? The workaround using the glue ui to drop the table doesn't solve the issue. From the documentation create and drop table should work directly from athena (https://docs.aws.amazon.com/athena/latest/ug/delta-lake-tables.html): Enter image description here

回答済み 4ヶ月前

関連するコンテンツ