Looks I have not space at clickhouse: ```Cannot re...
# general
a
Looks I have not space at clickhouse:
Copy code
Cannot reserve 1.00 MiB, not enough space
how can i drop my data from clickhouse since x days?
a
Ahaa ok. I thought I have an option via SigNoz UI to clean data from determined date
On the other hand, is a way to say for example application with tag service name helloworld keep traces from last 15 days ?
s
Yes, there is some form of tag level TTL, but there is no way to do it from UI.
a
How can I do it ? Without the UI ?
s
through clickhouse command line
a
can you share that command ?
s
I know it exists but haven’t tried it ourselves.
v
Here’s an example @Alejandro Decchi for the your case
Copy code
CREATE TABLE events
(
    `event` String,
    `time` DateTime,
    `value` UInt64
)
ENGINE = MergeTree
ORDER BY (event, time)
TTL time + INTERVAL 1 MONTH DELETE WHERE event != 'error',
    time + INTERVAL 6 MONTH DELETE WHERE event = 'error'