BATCH DELETE FROM

BATCH DELETE FROM allows to delete records in large tables while minimizing the risk of lock invalidation and transaction rollback by weakening guarantees. Specifically, data deletion is performed as a series of transactions for each partition of the specified table separately, processing 10 000 rows per iteration. Each query processes up to 10 partitions concurrently.

This query, like the standard DELETE FROM, executes synchronously and returns a status. If an error occurs or the client disconnects, data deletion stops, and applied changes are not rolled back.

The semantics are inherited from the standard DELETE FROM with the following restrictions:

• Supported only for row-oriented tables.
• Supported only for queries with implicit transaction control (NoTx mode or EmptyTxControl in SDK).
• The use of subqueries and multiple statements in a single query is prohibited.
• The RETURNING clause is unavailable.

Example

BATCH DELETE FROM my_table
WHERE Key1 > 1 AND Key2 >= "One";