influxdata / influxdata/influxdb
Deleting ISSUE : DELETE does not work well with the time clause
- Dominant language
- Rust
- Stars
- 31.7k
- Forks
- 3.7k
- Avg merge
- 13h 37m
- Merged PRs (30d)
- 8
Description
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](https://docs.influxdata.com/influxdb/v1.8/query_language/manage-database/#delete-series-with-delete) it is implied that it works.
`
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?
Contributor guide
Research direction
Start by reproducing the DELETE query in the InfluxDB shell against past, future, and finite time clauses, then compare the result with the linked DELETE documentation. Done means a predicate such as time < '2022-01-02T11:40:00Z' removes only points before that timestamp rather than the whole day, or the documentation clearly explains the supported behavior.
Written by the indexing model from the issue text.
Assessment
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100