Athena Iceberg delete failing
I am trying to perform a fairly simple delete via Athena on a table defined with the tabletype of Iceberg.
delete from emaildelivery where uniqueid in (select b.uniqueid from deletestaging b)
The following error message is returned.
GENERIC_INTERNAL_ERROR: Invalid descendant for DeleteNode or UpdateNode: com.facebook.presto.sql.planner.plan.JoinNode
Performing the query with values directly in the query is successful.
delete from emaildelivery where uniqueid in ('6e41279b-a22d-4bad-ad8d-448625ae9d88','2831e5a1-8a5c-424f-8d07-198a57f6a04a')
The same query as a select works successfully.
select uniqueid from emaildelivery where uniqueid in (select b.uniqueid from deletestaging b);
Any assistance with resolving the issue with the delete query is greatly appreciated.
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 any update on this? I am currently stumbling on the same problem while testing Iceberg, and this is a key feature for our PoC.
INVALID_INPUT in Athena Queryasked 5 months ago
Athena query failing while using UNNEST(x) AS yasked a month ago
Unable to query dynamodb table in Athena using DynamoDB ConnectorAccepted Answer
Help in creating the most simple Athena UDFasked 4 months ago
How to query DynamoDB nested elements from AthenaAccepted Answer
"DDL execution timed out" when trying to DROP Iceberg table after the S3 folder has already been deletedasked 2 months ago
Odd Athena Query Performance Issueasked 2 months ago
Athena views can't include Athena table partitionsasked 5 days ago
Athena Iceberg delete failingasked a month ago
I cannot use current_date + interval in Athena boto3 query in LambdaAccepted Answerasked 4 months ago