#influxdb

hi

I can select data fine, but appear not to be able to delete it

> delete from temperatures where node='hottub' and sensor='temp' and time > now() - 7d and value < 1;

ERR: error parsing query: DELETE FROM is currently not supported. Use DROP SERIES or DROP MEASUREMENT instead

how can I remove the data matching that criteria?

(dodgy sensor readings)

ichilton, for loop

influx -execute 'show measurements' | grep badmeasurments > out

for i in `cat out`;do echo "influx -username \"root\" -password \"oassword\" -database \"telegraf\" -execute 'drop measurement \"$i\" ' " >> out2;done

then just sh -x out2

and have fun

i haven't tried dropping by regex