v.18.14Improvement

Truncate Table Query Execution on Replicas

Official CH changelog text
A TRUNCATE TABLE query can be executed on any replica (the query is passed to the leader replica). Kirill Shvakov
Execute the TRUNCATE TABLE query on any replica in a replicated table setup, with the query automatically forwarded to the leader replica.

Why it matters

This feature simplifies the management of replicated tables by allowing users to perform TRUNCATE TABLE operations from any replica instead of only from the leader. It enhances usability and flexibility when clearing data from replicated tables.

How to use it

Simply run the TRUNCATE TABLE query on any replica of a replicated table. The query will be internally forwarded to the leader replica to perform the truncation.

Related resources

PreviousNext