TLDR Alejandro needed help with data management in Clickhouse. Srikanth and vishal-signoz provided links and examples for implementing tag level TTL and data deletion.
Looks I have not space at clickhouse:
```Cannot reserve 1.00 MiB, not enough space```
how can i drop my data from clickhouse since x days?
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 ?
Yes, there is some form of tag level TTL, but there is no way to do it from UI.
How can I do it ? Without the UI ?
through clickhouse command line
can you share that command ?
I know it exists but haven’t tried it ourselves.
Here’s an example Alejandro for the your case
```CREATE TABLE events
ENGINE = MergeTree
ORDER BY (event, time)
TTL time + INTERVAL 1 MONTH DELETE WHERE event != 'error',
time + INTERVAL 6 MONTH DELETE WHERE event = 'error'```
Indexed 1061 threads
Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI