用户工具


查询所有表

  • list series

查看表内容

  • select * from “table” where 1=1 group by time(10m)

    删除表行

  • delete from “table”

    删除表

  • drop series “table”

    创建Fanout continuos query (sql没有group by语句)

  • select * from “table”b where tablea时,会自动判断值是否大于10,如果大于10则也同时插入tableb不存在会自动创建。tablea中旧的值不受影响

    创建Downsampling continuos query (sql有group by语句,且只能group by time() )

  • 与Fanout continuos query不同,Downsampling continuos query对旧值和新插入的值都有影响

    查看continuos query

  • list continuous queries

    删除continuos query

  • drop continuous query <id> (这个动作不会删除continuous query创建的表)
  • drop series “table”