how to permanently merge two measurements in InfluxDB

0
votes

Have a set of temperature sensors in my house and I've just upgraded them, to new devices.

They record exactly the same way into my InfluxDB (ie temperature and humidity every 15 mins), but the device names are different in the InfluxDB.

I'm keen not to lose years of history, so I'd like to rename all my historical records from TempSensor to the new name which is ESP_TempSensor (and thus merge the records) - there's no overlap as I literally swapped the devices and data format is identical.

I've googled and I know InfluxDB doesn't seem very capable at joins and other simple things, but in this case I'm happy to manually and permanently merge the datasets.

Any pointers/help much appreciated!

1
influxdb

1 Answers

0
votes

You can use the INTO clause:

SELECT * INTO ESP_TempSensor FROM TempSensor GROUP BY *

Make sure you include the GROUP BY * otherwise influx will convert all tags into field keys.