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?

질문됨 5달 전629회 조회
1개 답변
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
전문가
답변함 5달 전
profile picture
전문가
검토됨 5달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인