influxdata / influxdata/influxdb

Deleting ISSUE : DELETE does not work well with the time clause

Open
#23,037 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.