| 创建 | CREATE RETENTION POLICY "rp_30d" ON "mydb" DURATION 30d REPLICATION 1 |
|---|---|
| 默认 | CREATE RETENTION POLICY "rp_7d" ON "mydb" DURATION 7d REPLICATION 1 DEFAULT |
| 查看/删除 | SHOW RETENTION POLICIES ON "mydb"；DROP RETENTION POLICY "rp_30d" ON "mydb" |
示例
示例
CREATE DATABASE "metrics" WITH DURATION 7d REPLICATION 1;
CREATE RETENTION POLICY "rp_90d" ON "metrics" DURATION 90d REPLICATION 1;
SHOW RETENTION POLICIES ON "metrics";
-- 写入时显式指定 RP
-- INSERT INTO "metrics"."rp_90d"."cpu" ...查询跨 RP 需要写全路径 库.RP.measurement；DEFAULT 变更会影响未指定 RP 的写入与查询。