Is it possible to delete a record with Athena?

Question

I would like to delete all records related to a client. My datalake is composed of parquet files. Is it possible to delete data with a query on Athena

DELETE
FROM myTable
WHERE client_id=73513

Answer 1

I know there has been more than a year, but I decided to share it here because this comes out on top when you search for Athena delete. ACID level transactions are now supported for Athena using Iceberg https://aws.amazon.com/about-aws/whats-new/2021/11/amazon-athena-acid-apache-iceberg/

Answer 2

Its not possible with Athena. DELETE FROM is not supported DDL statement.