Skip to content

Athena Table Creation Metadata

0

AlreadyExistsException from Athena when creating a table but I deleted the table from S3. Why does it think it still exists? Is there metadata somewhere that I can also delete?

asked 3 years ago548 views
1 Answer
0
Accepted Answer

You can use the commands below to validate your current databases and tables inside each database.

SHOW DATABASES;

# Using "default" database as example
SHOW TABLES IN default;

If you need to drop the table you can use the command below:

DROP TABLE `my-athena-database-01.my-athena-table`
AWS
answered 3 years ago
EXPERT
reviewed 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.