Configure LindormTSDB TTL & Cold Boundary via ALTER DATABASE - Lindorm

Modifies the attributes of an existing LindormTSDB database.

ALTER DATABASE applies only to LindormTSDB and is supported by all LindormTSDB versions.

Syntax

ALTER DATABASE database_identifier [ WITH attribute_statement ]

attribute_statement  ::= '(' attribute_definition (',' attribute_definition)* ')'
attribute_definition ::= attr_identifier '=' attr_val

Use the WITH clause to specify one or more attributes to change. For example: WITH (ttl=60, cold_boundary=30).

Parameters

attribute_definition

For the full list of modifiable attributes, default values, and valid value ranges, see the attribute_definition parameter in CREATE DATABASE.

Limitations

Database name cannot be changed

ALTER DATABASE uses the database name to identify the target database.

Only attributes can be modified

ALTER DATABASE changes attribute values only.

Examples

Change the TTL (time to live) of database DB1 to 40 days:

ALTER DATABASE DB1 WITH (ttl=40);

What's next

CREATE DATABASE — view all available attributes, default values, and valid value ranges