influxdata / influxdata/influxdb
influxdb does not delete data from a series
- Dominant language
- Rust
- Stars
- 31.7k
- Forks
- 3.7k
- Avg merge
- 13h 37m
- Merged PRs (30d)
- 8
Description
I have tried these instructions to delete data from a series at a specific time, but it does not delete it.
when executing the instruction it does not give any error, it seems that it has been deleted.
But then you do the search again and the data is still in the database.
Can someone help me and tell me how to delete the data of a series on a specific date?
I have tried with the instruction:
drop series mean("value") AS "mean_value" FROM "HomeAssistant"."autogen"."kWh" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND "entity_id"='metering_total_absorbed' GROUP BY time(:interval:) FILL(previous)
delete from mean("value") AS "mean_value" FROM "HomeAssistant"."autogen"."kWh" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND "entity_id"='metering_total_absorbed' GROUP BY time(:interval:) FILL(previous)
thanks !!!


Thank you
Contributor guide
Research direction
No source files, tests, or implementation entry points are named. Start by reproducing the shown DROP SERIES and DELETE queries with the supplied measurement, tags, and time bounds, then determine whether the requested series deletion is supported; done means documenting or fixing the behavior so the targeted data is removed and the follow-up query confirms it.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 15/100