influxdata / influxdata/influxdb

Deletion from database not possible

Open
#22,062 0 comments 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

using influx with Openhab3.1. Trying to delete some entries where the values were wrong but facing an issue. Any ideas?

```
select * from Aussen_Boden_Feuchte where value <0.30

> name: Aussen_Boden_Feuchte
> time item value
> ---- ---- -----
> 1628079367121000000 Aussen_Boden_Feuchte 0.26
> 1628079367124000000 Aussen_Boden_Feuchte 0.26
> 1628079367344000000 Aussen_Boden_Feuchte 0.26
> 1628079420453000000 Aussen_Boden_Feuchte 0.26
> 1628079427319000000 Aussen_Boden_Feuchte 0.26
> 1628079480454000000 Aussen_Boden_Feuchte 0.26
> 1628079487313000000 Aussen_Boden_Feuchte 0.27
```

```
delete from Aussen_Boden_Feuchte where value < 0.30
ERR: shard 2: fields not supported in WHERE clause during deletion
```

Contributor guide

Open the contributing guide

Research direction

No source file or test is identified. Start by reproducing the SELECT and DELETE statements from the report and tracing the reported field-predicate error. Before work is considered done, establish whether this deletion is intended to be supported and define the expected behavior or documentation for the result.

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
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.