Failed to Delete a ClickHouse Table or Partition

Symptom

If the size of a data table exceeds the value of max_table_size_to_drop, the table fails to be deleted and the alter table database.table drop partition ('2021-12-15', '20211225-0000') operation fails. Error message "Table or Partition in database.table was not dropped" is displayed.

Cause Analysis

In ClickHouse, the default values of max_table_size_to_drop and max_partition_size_to_drop are 50 G. A table or partition larger than 50 GB cannot be deleted.

Solution

Change the values of max_table_size_to_drop and max_partition_size_to_drop on Manager. The value 0 indicates that the sizes of tables and partitions are not limited.

Parent topic: Using ClickHouse

Previous topic: Frequent ClickHouse Connection Failures Due to Incorrect Passwords

Next topic: Slow Data Replication of ClickHouse Table Replicas and a Large Number of Fetch Requests in the Queue