Skip to content

Clickhouse Truncate Table

bash
TRUNCATE TABLE default.jaeger_span;

It will report error

bash
Reason:
1. Size (51.37 GB) is greater than max_[table/partition]_size_to_drop (50.00 GB)
2. File '/bitnami/clickhouse/data/flags/force_drop_table' intended to force DROP doesn't exist
How to fix this:
1. Either increase (or set to zero) max_[table/partition]_size_to_drop in server config
2. Either pass a bigger (or set to zero) max_[table/partition]_size_to_drop through query settings
3. Either create forcing file /bitnami/clickhouse/data/flags/force_drop_table and make sure that ClickHouse has write permission for it.
Example:
sudo touch '/bitnami/clickhouse/data/flags/force_drop_table' && sudo chmod 666 '/bitnami/clickhouse/data/flags/force_drop_table'. (TABLE_SIZE_EXCEEDS_MAX_DROP_SIZE_LIMIT)

go inside to the container

bash
touch '/bitnami/clickhouse/data/flags/force_drop_table' && chmod 666 '/bitnami/clickhouse/data/flags/force_drop_table'

do it again

bash
TRUNCATE TABLE default.jaeger_span;