- Newest
- Most votes
- Most comments
Is there any update on this? I am currently stumbling on the same problem while testing Iceberg, and this is a key feature for our PoC.
Hello, Thank you for brining on to the notice, Currently, this is a known issue only for DELETE and UPDATE. Athena Service team is actively working on it.
Is there additional information related to when there will be a resolution to this issue?
I had the same issue. The workaround which I found works for me is to use merge into .. with delete statement when there is a match. E.g. first create a table with the record ids that need to be deleted (emailtodelete). Then use it to delete the data from the original table.
MERGE INTO emaildelivery t USING emailtodelete s ON (t. uniqueid = s. uniqueid) WHEN MATCHED THEN DELETE
Relevant content
- asked a year ago
- asked 3 months ago
- asked 9 months ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated a year ago