How to delete / drop multiple tables in AWS athena?

Question

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?

Answer 1

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!