`
root@545ee5b8ad52:/# influx
Connected to http://localhost:8086 version 1.8.0
InfluxDB shell version: 1.8.0
use opentsdb
Using database opentsdb
delete from "netdata.cpu.cpu2.system" where time < '2022-01-02T11:40:00Z'
`
It should delete data before 11:40 at second January but it delete the whole data of the day . How should I say that I want to delete data before specific time of day?
holzi-x
commented
1 year ago
Tested on v1.8.0
Description: DELETE does not work well with the time clause.
Tested it with past, future and finite duration clauses in the following repro case.
In the docs it is implied that it works.
` root@545ee5b8ad52:/# influx Connected to http://localhost:8086 version 1.8.0 InfluxDB shell version: 1.8.0
It should delete data before 11:40 at second January but it delete the whole data of the day . How should I say that I want to delete data before specific time of day?