Is it Possible Delete Table (or Rows from Table) Using Amazon Athena?

0

I am using Athena together with SQL Alchemy ORM. I just created a table (for testing some machine learning model integration) and pushed some data to it using SQL Alchemy ORM. But unfortunately, I can neither delete the table, nor the rows inside it. I tried both of these commands on the Athena query editor.

DELETE FROM tensorflow_clustering;
DROP TABLE tensorflow_clustering;

Both failing. This is the error message for dropping table, for example.

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Insufficient Lake Formation permission(s): Required Drop on tensorflow_clustering (Service: AmazonDataCatalog; Status Code: 400; Error Code: AccessDeniedException; Request ID: 8d2b9a82-6e50-4fdd-9b7e-09804f6445bc; Proxy: null))

Is it possible to drop tables and rows in athena at all?

gefragt vor 5 Monaten628 Aufrufe
1 Antwort
0

Hi,

Could you check if your user has Lake Formation permissions to delete rows or drop tables? I recommend you take a look at the following links, they may be helpful to you.

profile picture
EXPERTE
beantwortet vor 5 Monaten
profile picture
EXPERTE
überprüft vor 5 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen