I am using influxDB 1.x.
There is nothing wrong with moving the existing DB.
You need to change the “measurement” name,
Is there any way?
I am using influxDB 1.x.
There is nothing wrong with moving the existing DB.
You need to change the “measurement” name,
Is there any way?
SELECT * INTO DestMeasurementCopy from SrcMeasurement GROUP BY *
DROP MEASUREMENT SrcMeasurement
Does this method work well?
Hello @Bryan,
Yes it depends on how much data you’re querying and writing to the other measurement.
If you have a ton of data i’ve seen people create a bash script with curl commands to execute that query while changing the timestamps to break the writing down into smaller chunks.
Drop measurement works great.
But hopefully you don’t have a ton of data and it works smoothly
@Bryan
But for what its worth InfluxDB 1.x wasn’t designed for updates. So that’s why sometimes people have to do a little extra work.