Deleting Apache Iceberg Tables
The DELETE command deletes rows from a table.
DELETE FROM <table_path>.<table_name> [AS alias] [ WHERE where_conditions ]
The path in which the table is located.
The name of the table with data that you want to delete.
(Optional) The filter for specifying which rows of the table to delete.
Join conditions are not supported in WHERE clauses. If you need to use a join condition, use a correlated subquery instead.
delete from orders using returns where orders.order_id = returns.order_id;
delete from orders where exists(select 1 from returns where order_id = orders.order_id)