Hey all, just wondering I see in the clickhouse da...
# support
m
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
> 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
what is the TTL set to?
s
1 month
m
yes the retention period. how would I delete a metric from all tables it is present in currently?