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

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. If the size of a table or partition exceeds 50 GB, the table or partition fails to be deleted.

Solution

Change the values of max_table_size_to_drop and max_partition_size_to_drop on Manager. The default value is 0, indicating that the size of tables and partitions is not limited.