I was working on a flow and had a typo for where my data was going which resulted in combining 2 temperature sets. I noticed it pretty quickly so I have around 30 minutes of data where I need to clean things up. Fortunately, the values are far apart so I can easily select them in the influx interface. I was hoping someone here might be able to help clear those. If not, I can ask on the influxdb community.
I have an outdoor weather station reporting temperatures in the 30-50°F range since I started the flow/database. I have a temp sensor that is indoors reporting ~68°F. There is a 30 minute period where these are combined. If I use the influx cli I can use a command like this to display the data:
> select * from "rtl_433/Acurite-5n1/A/temperature_F" where value > 60 limit 10 name: rtl_433/Acurite-5n1/A/temperature_F time value ---- ----- 1611345517862054888 69.98 1611345534624218033 69.98 1611345550936809045 70.16 1611345567639995886 69.98 1611345584503504227 69.98 1611345600706825760 69.98 1611345617452314045 69.98 1611345634224615565 69.98 1611345651093932895 69.98 1611345667253789482 69.98 >
If I try to use the delete command as I understand it, it doesn't work:
> delete from "rtl_433/Acurite-5n1/A/temperature_F" where value > 60 ERR: shard 7: fields not supported in WHERE clause during deletion >
Any help would be appreciated. This is something I can see easily happening so it would be good to know how to fix it.