Deleting Apache Iceberg Tables
The DELETE command deletes rows from a table.
DELETE FROM <table_path>.<table_name> [AS alias]
[ WHERE where_conditions ]
Parameters
<table_path>
String
The path in which the table is located.
<table_name>
String
The name of the table with data that you want to delete.
WHERE where_conditions
String
(Optional) The filter for specifying which rows of the table to delete.
note:
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)
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.