Help Center/ MapReduce Service/ Troubleshooting/ Using ClickHouse/ Failed to Delete a ClickHouse Table or Partition
Updated on 2025-12-01 GMT+08:00
View PDF

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