主页

索引

模块索引

搜索页面

DB级,表级

创建数据库:

> CREATE DATABASE "NOAA_water_database"
// 创建一个有特定保留策略的数据库
> CREATE DATABASE "NOAA_water_database" WITH DURATION 3d REPLICATION 1 SHARD DURATION 1h NAME "liquid"

删除数据库:

DROP DATABASE <database_name>

用DROP从索引中删除series:

DROP SERIES FROM <measurement_name[,measurement_name]> WHERE <tag_key>='<tag_value>'
1. 从单个measurement删除所有series:
> DROP SERIES FROM "h2o_feet"
2. 从单个measurement删除指定tag的series:
> DROP SERIES FROM "h2o_feet" WHERE "location" = 'santa_monica'
3. 从数据库删除有指定tag的所有measurement中的所有数据:
> DROP SERIES WHERE "location" = 'santa_monica'

用DELETE删除series:

> DELETE FROM "h2o_feet"
> DELETE FROM "h2o_quality" WHERE "randtag" = '3'
> DELETE WHERE time < '2016-01-01'

删除measurement:

DROP MEASUREMENT <measurement_name>

删除shard:

DROP SHARD <shard_id_number>

schema的语法

SHOW DATABASES
SHOW RETENTION POLICIES
SHOW SERIES
SHOW MEASUREMENTS
SHOW TAG KEYS
SHOW TAG VALUES
SHOW FIELD KEYS
  1. 显示时间线:

    show series
    
    > SHOW SERIES ON NOAA_water_database
    
    > USE NOAA_water_database
    > SHOW SERIES
    $ curl -G "http://localhost:8086/query?db=NOAA_water_database&pretty=true" --data-urlencode "q=SHOW SERIES"
    
  2. 显示rp:

    > SHOW RETENTION POLICIES ON NOAA_water_database
    
    > USE NOAA_water_database
    > SHOW RETENTION POLICIES
    
    $ curl -G "http://localhost:8086/query?db=NOAA_water_database&pretty=true" --data-urlencode "q=SHOW RETENTION POLICIES"
    
  3. # 显示度量:

    show measurements
    
    > SHOW MEASUREMENTS ON NOAA_water_database
    
    > USE NOAA_water_database
    > SHOW MEASUREMENTS
    
    $ curl -G "http://localhost:8086/query?db=NOAA_water_database&pretty=true" --data-urlencode "q=SHOW MEASUREMENTS"
    
    // 运行有多个子句的SHOW MEASUREMENTS(1)
    > SHOW MEASUREMENTS ON DB WITH MEASUREMENT =~ /h2o.*/ LIMIT 2 OFFSET 1
    结果:
    name: measurements
    name
    ----
    h2o_pH
    h2o_quality
    
    // 运行有多个子句的SHOW MEASUREMENTS(2)
    > SHOW MEASUREMENTS ON NOAA_water_database WITH MEASUREMENT =~ /h2o.*/
        WHERE "randtag"  =~ /\d/
    结果:
    name: measurements
    name
    ----
    h2o_quality
    
  4. # 显示Tag的Key:

    show tag keys
    show tag keys from metrics
    
    > SHOW TAG KEYS ON "DB"
    
    > USE DB
    > SHOW TAG KEYS
    
    $ curl -G "http://localhost:8086/query?db=NOAA_water_database&pretty=true" --data-urlencode "q=SHOW TAG KEYS"
    
    // 运行带有多个子句的SHOW TAG KEY
    > SHOW TAG KEYS ON "DB" FROM "h2o_quality" LIMIT 1 OFFSET 1
    
    name: h2o_quality
    tagKey
    ------
    randtag
    
  5. SHOW TAG VALUES:

    > SHOW TAG VALUES ON "DB" WITH KEY = "randtag"
    
    > USE NOAA_water_database
    > SHOW TAG VALUES WITH KEY = "randtag"
    
    $ curl -G "http://localhost:8086/query?db=NOAA_water_database&pretty=true" --data-urlencode 'q=SHOW TAG VALUES WITH KEY = "randtag"'
    
    # 运行带有多个子句的SHOW TAG VALUES
    > SHOW TAG VALUES ON "NOAA_water_database" WITH KEY IN ("location","randtag")
    WHERE "randtag" =~ /./ LIMIT 3
    结果:
    name: h2o_quality
    key        value
    ---        -----
    location   coyote_creek
    location   santa_monica
    randtag       1
    
  6. 显示数据字段的Key:

    show field keys
    show field keys from metrics
    
    > SHOW FIELD KEYS ON "NOAA_water_database"
    
    > USE NOAA_water_database
    > SHOW FIELD KEYS
    
    $ curl -G "http://localhost:8086/query?db=NOAA_water_database&pretty=true" --data-urlencode 'q=SHOW FIELD KEYS'
    

主页

索引

模块索引

搜索页面