Deletes the rows that match a predicate. When no predicate is provided, deletes all rows.
DELETE FROM table_identifier [AS alias] [WHERE predicate]
[database_name.] table_name: A table name, optionally qualified with a database name.
delta.`<path-to-table>`: The location of an existing Delta table.
Define a table alias.
Filter rows by predicate.
WHEREpredicate supports subqueries, including
NOT EXISTS, and scalar subqueries. The following types of subqueries are not supported:
- Nested subqueries, that is, an subquery inside another subquery
NOT INsubquery inside an
OR, for example,
a = 3 OR b NOT IN (SELECT c from t)
In most cases, you can rewrite
NOT INsubqueries using
NOT EXISTS. We recommend using
NOT EXISTSwhenever possible, as
NOT INsubqueries can be slow.