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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot