How do I drop native Delta tables from Athena catalog?

Question

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"

rePost-User-5062491 · Answer

Deleting from the Glue UI or using Glue API works

Oleg · Answer

We are facing a similar issue when dropping a Delta Lake table in Athena

DROP TABLE not supported for Delta Lake
This query ran against the ‘111’ database, unless qualified by the query. Please post the error message on our forum  or contact customer support  with Query ID: 111

We are seeking assistance in understanding the peculiarities of managing Delta Lake tables via Athena. Any insights or guidance would be greatly appreciated.

Jawad · Answer

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](/media/postImages/original/IM4Wyu2hqUTzilmHyHAirJEw)

Jawad

answered 3 years ago

How do I drop native Delta tables from Athena catalog?

Add your answer

Relevant content