I have upgraded influxdb from 1.8 to 2.6
I use a lot sensors, some of them produce incorrect values or are delivered falsely by mqtt.
Deleting those values have always been a very disturbing tasks with influxdb. I had hoped that this process might have been addressed, unfortunately not. However,
to delete those values I need to find out the timestamp because that is the only way to delete a _field value, insane but true.
I can use two different query methods to find out the timestamp of a datapoint
- Flux via DataExplorer
Values for _time have nothing to do with the real values, raw data is even more confusing. Shows values that aren’t even recorded. Some sort of intepolation it seems.
sonoff.0.Strom-Gas.Gas_Verbrauch gestern m_ value 3.93 2023-01-10T17:30:51.000Z 2023-01-13T17:30:51.823Z 2023-01-12T23:05:28.778Z
- influx v1 shell
Select query brings up this result:
2023-01-12T22:59:57.676Z ┃system.adapter.sonoff.0 ┃ 3.9300000000
so in this example it is 23:05:28 vs 22:59:57
The latter is the correct value.
I don’t understand the DataExplorer concept. See attachment
How do get my real values?
What is going on here?
And if there is a normal way of doing this (delete a single datapoint) please tell me