When playing with ClickHouse replicated tables it is quite probable that we end up getting errors like:
DB::Exception: Replica /clickhouse/my_cluster/tables/shard_01/bids/replicas/replica_01 already exists
Deleting this entry it's quite simple. Just connect to one of the ZooKeeper nodes in the cluster and execute:
./zkCli.sh deleteall /clickhouse/my_cluster/tables/shard_01/bids/replicas/replica_01
If we want to start all over we could even delete all the information regarding the cluster my_cluster:
./zkCli.sh deleteall /clickhouse/my_cluster
Top comments (0)