CODEWITHSUNDEEP
amazon-web-servicesprestoamazon-athena
Dev Woman
Dev Woman

Reputation: 88

Cannot drop aws athena table across database

I had created my test database, named: test, there was a table named: test_table

I executed the command from default database: DROP TABLE IF EXISTS test.test_table and got the error message:

FAILED: Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.DDLTask. 
NoSuchObjectException(message:Table test_table not found. (Service: AmazonDataCatalog; Status Code: 400; Error Code: EntityNotFoundException; Request ID: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx))

any suggestion?

Upvotes: 1

Views: 1603

Answers (1)

Dawn T Cherian
Dawn T Cherian

Reputation: 5406

Just follow the below steps and see whether you can delete it from the console:

  1. From the amazon athena console, select catalog manager from the top bar
  2. Select test database from the databases listed on the left hand side.
  3. Select test_table listed in the tables section
  4. Click on the drop option shown above the tables section

Upvotes: 1

Related Questions