Converting wrong values in a measurement in InfluxDB 1.8.10

InfluxDB 1 InfluxQL
1

Hi,
i’m using InfluxDB 1.x on linux since many years as persistence of my OpenHAB installation and also for visulazing historical values in grafana.

Accidentaly something happend for a ping latency measurement.
so i have values in there like 12 or 0,012 which both represents 12ms.

So i would now like to convert(divide by 1000) all values larger as 4. Any idea how i could realize that?

2 
SELECT 0.001 * value INTO google_latency2 FROM google_latency WHERE value >4 GROUP BY *
name: result
time written
---- -------
0    1219956
> SELECT *  INTO google_latency2 FROM google_latency WHERE value <=4 GROUP BY *
name: result
time written
---- -------
0    46501

DROP SERIES FROM google_latency

SELECT * INTO google_latency from google_latency2 GROUP BY *

DROP SERIES FROM google_latency2
3

fixed it by

  1. copying the 0,0xx values as they are to a new measurement ending with 2
  2. copying the values larger then 4 to same measurement but divided by 1000
  3. dropped old measurement
  4. copied consolidated new data to the measurement with the original name
    5 dropped the temp measurement ending with 2