This message was deleted.

# general

Slackbot

05/11/2023, 8:36 PM

This message was deleted.

Srikanth Chekuri

05/12/2023, 2:15 AM

See https://clickhouse.com/docs/en/sql-reference/statements/alter/delete

Alejandro Decchi

05/12/2023, 11:28 AM

Ahaa ok. I thought I have an option via SigNoz UI to clean data from determined date

Alejandro Decchi

05/12/2023, 11:29 AM

On the other hand, is a way to say for example application with tag service name helloworld keep traces from last 15 days ?

Srikanth Chekuri

05/12/2023, 3:35 PM

Yes, there is some form of tag level TTL, but there is no way to do it from UI.

Alejandro Decchi

05/14/2023, 5:06 PM

How can I do it ? Without the UI ?

Srikanth Chekuri

05/15/2023, 4:49 AM

through clickhouse command line

Alejandro Decchi

05/15/2023, 2:06 PM

can you share that command ?

Srikanth Chekuri

05/15/2023, 2:29 PM

I know it exists but haven’t tried it ourselves.

Vishal Sharma

05/15/2023, 2:36 PM

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'

Vishal Sharma

05/15/2023, 2:36 PM

Refer: https://clickhouse.com/blog/using-ttl-to-manage-data-lifecycles-in-clickhouse

Vishal Sharma

05/15/2023, 2:37 PM

Follow this: https://stackoverflow.com/questions/72037815/clickhouse-ttl-settings-with-where-condition

246 Views

Open in Slack

Previous Next

SigNoz Community

SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.