v.23.9Improvement

RESTORE TABLE ON CLUSTER Requires Matching UUIDs for Replicated Tables

Official CH changelog text
RESTORE TABLE ON CLUSTER must create replicated tables with a matching UUID on hosts. Otherwise the macro {uuid} in ZooKeeper path can't work correctly after RESTORE. This PR implements that. #53765 (Vitaly Baranov).
RESTORE TABLE ON CLUSTER now ensures that replicated tables are restored with matching UUIDs across all hosts in the cluster.

Why it matters

This feature resolves issues with the macro {uuid} used in ZooKeeper paths after a RESTORE operation. Ensuring consistent UUIDs across replicated tables prevents replication and coordination problems within the cluster.

How to use it

When using RESTORE TABLE ON CLUSTER, replicated tables will automatically be restored with synchronized UUIDs on all cluster hosts, maintaining the integrity of ZooKeeper path macros without additional user intervention.

Related resources

PreviousNext