Athena Iceberg UPDATE writes Iceberg position delete files and newly
updated rows as data files in the same transaction. UPDATE can be
imagined as a combination of INSERT INTO and DELETE.
UPDATE operations are charged by the amount of data scanned. For
syntax, see UPDATE.
The following example updates the specified values in the table
iceberg_table.
UPDATE iceberg_table SET category='c2' WHERE category='c1'