发布于 2 年前 作者 helloworld_001 5742 次浏览 来自 问答

从官网中看到对于ttl的介绍,但是找不到如何使用。不知道怎么建表时指定表、字段为过期删除,试了几种都报语法错误。求助社区。 Can be specified only for MergeTree-family tables. An expression for setting storage time for values. It must depends on Date or DateTime column and has one Date or DateTime column as a result. Example: TTL date + INTERVAL 1 DAY

You are not allowed to set TTL for key columns. For more details, see TTL for columns and tables

1 回复