Failed to Re-create a Replicated Table After It Is Deleted from ClickHouse

Symptom

When a ClickHouse replicated table is deleted and then recreated, the error message "Existing table metadata in ZooKeeper" is displayed.

Cause Analysis

• Deleting a replicated table in ClickHouse does not immediately remove the metadata in ZooKeeper.
• There is residual metadata in ZooKeeper.

Solution

1. Wait for about 8 minutes until ZooKeeper deletes the metadata of the replicated table, and try again.
2. Run the drop table table_name SYNC or drop table table_name no delay statement to correct the service operation.