sql - 可以从 influxdb 中删除数据吗？

Question

如何从 influxdb 中删除数据？

文档显示它应该简单如下:

delete from foo where time < now() -1h

出于某种原因，influxdb 拒绝我的删除语句，并表示“删除查询不能包含不引用时间的 where 子句”

select * from bootstrap where duration > 1000 and time > 14041409940s and time < now()

我想删除这 5 个持续时间 > 1000 秒的条目

这应该是一个有效的sql语句，但它失败了

这些删除语句都不起作用

delete from bootstrap where duration > 3000000"

delete from bootstrap where duration > 300000"

delete from bootstrap where time = 1404140994043"

delete from bootstrap where duration > 300000 and time > 1404141054508 "

delete from bootstrap where duration > 300000 and time > 1404141054508s "

delete from bootstrap where time > 1404141054508s and duration > 300000 "

delete from bootstrap where duration > 30000 and time > 1s"

文档引用

https://docs.influxdata.com/influxdb/v2.0/query-data/influxql/

更新

其他查询

delete from bootstrap where time > 1404141416824 and duration > 3000;
delete sequence_number from bootstrap where time > 1s and duration > 1000;

也许这是一个错误？

https://github.com/influxdb/influxdb/issues/975
https://github.com/influxdb/influxdb/issues/84

Answer 1

看来您可以在 influxdb 0.9 中执行此操作。例如，这是我刚刚成功的查询:

DROP SERIES FROM temperature WHERE machine='zagbar'

(根据 @MuratCorlu 的慷慨评论，我将重新发布我之前的评论作为答案......)