Back

Explore Courses Blog Tutorials Interview Questions

How to delete / drop multiple tables in AWS athena?

0 votes
4 views
in AWS by (19.1k points)

I cannot run multiple DROP queries at same time. I am trying to drop few tables from Athena. Is there a way to do it? Can anyone help me in this?

1 Answer

0 votes
by (44.4k points)
edited by

The provision to run multiple queries simultaneously is not available in Athena yet. So you can try the following command once you decide the Database you want to drop but doing this will delete the tables under that database. Do not use this if you want to drop only particular tables. 

DROP DATABASE db_name CASCADE;

If you want to delete only a few tables, then run those queries one by one and get i 

Need help mastering the AWS Cloud platform? Consider Enrolling in AWS Certification Course!

Related questions

0 votes
1 answer
Drop multiple tables in one shot in mysql
asked Jul 30, 2019 in SQL by Tech4ever (20.3k points)

Want to get 50% Hike on your Salary?

Learn how we helped 50,000+ professionals like you !

0 votes
1 answer
How do I delete from multiple tables using INNER JOIN in SQL server
asked Jul 25, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
What Is AWS Athena?
asked Jan 6, 2021 in AWS by Amyra (12.9k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...