Clickhouse: Delete TTL setting

Created on 22 Oct 2020  路  2Comments  路  Source: ClickHouse/ClickHouse

I read doc here - https://clickhouse.tech/docs/ru/sql-reference/statements/alter/ttl/
and here - https://clickhouse.tech/docs/ru/engines/table-engines/mergetree-family/mergetree/#table_engine-mergetree-ttl

But I didn't find any information about how I can remove the TTL setting from the table.
For example, this could be useful in migration, in the case of a rollback.

question question-answered
Source
picture igortyulkin

Most helpful comment

You can set TTL to the future + 10 years for example.

ALTER TABLE example_table MODIFY TTL d + INTERVAL 10 years;

Starting from CH 20.11 ALTER TABLE REMOVE TTL

picture den-crane on 22 Oct 2020
👍2

All 2 comments

You can set TTL to the future + 10 years for example.

ALTER TABLE example_table MODIFY TTL d + INTERVAL 10 years;

Starting from CH 20.11 ALTER TABLE REMOVE TTL

den-crane picture den-crane on 22 Oct 2020
👍2

Grateful! but YEAR, not YEARS

igortyulkin picture igortyulkin on 26 Oct 2020
Was this page helpful?
0 / 5 - 0 ratings

Related issues

vixa2012 picture vixa2012  路  3Comments
fizerkhan picture fizerkhan  路  3Comments
lttPo picture lttPo  路  3Comments
opavader picture opavader  路  3Comments
jangorecki picture jangorecki  路  3Comments