CnosDB 数据库管理

摘要

数据库管理

• CREATE DATABASE
• DROP DATABASE
• DROP SERIES
• DELETE
• DROP MEASUREMENT
• DROP SHARD

保留策略管理

• CREATE RETENTION POLICY
• ALTER RETENTION POLICY
• DROP RETENTION POLICY

数据库管理

CREATE DATABASE

语法

CREATE DATABASE <database_name> [WITH [DURATION <duration>] [REPLICATION <n>] [SHARD DURATION <duration>] [NAME <rp-name>]]

DROP DATABASE

语法

DROP DATABASE <database_name>

DROP SERIES

语法

DROP SERIES FROM <measurement_name[,measurement_name]> WHERE <tag_key>='<tag_value>'

DELETE

语法

DELETE FROM <measurement_name> WHERE [<tag_key>='<tag_value>'] | [<time interval>]

DROP MEASUREMENT

语法

DROP MEASUREMENT <measurement_name>

DROP SHARD

语法

DROP SHARD <shard_id_number>

保留策略管理

CREATE RETENTION POLICY

语法

CREATE RETENTION POLICY <rp_name> ON <database_name> DURATION <duration> REPLICATION <n> [SHARD DURATION <duration>] [DEFAULT]

ALTER RETENTION POLICY

语法

ALTER RETENTION POLICY <rp_name> ON <database_name> DURATION <duration> REPLICATION <n> SHARD DURATION <duration> DEFAULT

DROP RETENTION POLICY

语法

DROP RETENTION POLICY <rp_name> ON <database_name>