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”