influxdata / influxdata/influxdb
Deletion from database not possible
- 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
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