Rename values on influxdb

#1

Hi,
I am new to Influx and I have a question.

I have a table with the following measurements:
time sensor temperatur


1552683815994000000 28-02131d9887aa 24.625
554143704283000000 28-00000a290397 25.562
1554143705563000000 28-02131d8fddaa 15.187
1554143706763000000 28-0114330246ab 20.312

One of the sensor is brocken, and the new one has another ID. I can’t change the ID itself.
I would like to update now the ID of the old sensor in Influxdb to the new ID, to have all measurements allocated to one ID.

Something like Update"28-00000a290397 to 28-00000456789", timestamp and temperature should not change.

Any ideas?

Thank you!

#2

@RoofAquaponics_DeLux What version of InfluxDB are you using?

#3

InfluxDB shell version: 1.7.4 is installed.