Athena Iceberg DELETE writes Iceberg position delete files to a table.
This is known as a merge-on-read delete. In contrast to a
copy-on-write delete, a merge-on-read delete is more
efficient because it does not rewrite file data. When Athena reads Iceberg data, it
merges the Iceberg position delete files with data files to produce the latest view
of a table. To remove these position delete files, you can run the REWRITE
DATA compaction action. DELETE operations are charged by the
amount of data scanned. For syntax, see DELETE.
The following example deletes rows from iceberg_table that have
c3 as the value for category.
DELETE FROM iceberg_table WHERE category='c3'