Title
a
Alejandro Decchi
05/11/2023, 8:36 PMLooks I have not space at clickhouse:
Cannot reserve 1.00 MiB, not enough spaces
Srikanth Chekuri
05/12/2023, 2:15 AMa
Alejandro Decchi
05/12/2023, 11:28 AMAhaa 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
Srikanth Chekuri
05/12/2023, 3:35 PMYes, there is some form of tag level TTL, but there is no way to do it from UI.
a
Alejandro Decchi
05/14/2023, 5:06 PMHow can I do it ? Without the UI ?
s
Srikanth Chekuri
05/15/2023, 4:49 AMthrough clickhouse command line
a
Alejandro Decchi
05/15/2023, 2:06 PMcan you share that command ?
s
Srikanth Chekuri
05/15/2023, 2:29 PMI know it exists but haven’t tried it ourselves.
v
Vishal Sharma
05/15/2023, 2:36 PMHere’s an example @Alejandro Decchi for the your case
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'