influxdata / influxdata/influxdb

influxdb does not delete data from a series

Open
#23,077 0 comments 1 reaction 0 assignees View on GitHub
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 !!!

![image](https://user-images.githubusercontent.com/89639919/151430395-0fb2c035-6bdb-430d-a932-245a6994ace2.png)

![image](https://user-images.githubusercontent.com/89639919/151430317-6cf702d1-2f83-4644-a810-f538038fcbbf.png)

Thank you

Contributor guide

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.