Hey all, just wondering I see in the clickhouse database that in for example the same metric, fingerprint, timestamp is stored in time_series_v2, time_series_v3, time_series_v4 etc. It looks very similar each time. Let's say after a week I don't want this specific data anymore, is there an easy command to wipe it? Specific use case without changing the retention period.
s
Srikanth Chekuri
03/07/2024, 1:36 AM
> Let's say after a week I don't want this specific data anymore, is there an easy command to wipe it? Specific use case without changing the retention period.
The v4 tables have TTL and get deleted automatically.
m
Mike Collins
03/07/2024, 8:13 AM
what is the TTL set to?
s
Srikanth Chekuri
03/07/2024, 8:46 AM
1 month
m
Mike Collins
03/07/2024, 9:14 AM
yes the retention period. how would I delete a metric from all tables it is present in currently?
SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.