Influxdb: [feature request] RENAME MEASUREMENT
From https://github.com/influxdb/influxdb/issues/828#issuecomment-83224779
e.g. RENAME MEASUREMENT foo TO bar
Would need to update all CQs for the new measurement name.
beckettsean
All 68 comments
+1
joltup
on 13 Nov 2015
+1
raulk
on 9 Jan 2016
+1
zapient
on 11 Jan 2016
+1
max3163
on 19 Jan 2016
+1
mgf909
on 27 Jan 2016
+1
ptlls
on 5 Feb 2016
+1
bicoco
on 5 Feb 2016
+1
renankof
on 19 Feb 2016
+1
sagetrey
on 5 Mar 2016
+1
CamJN
on 7 Mar 2016
+1
Iseji
on 13 Apr 2016
+1
gvohra
on 15 Apr 2016
+1
jasase
on 11 May 2016
+1
julienvienne
on 26 May 2016
+1
adampl
on 7 Jun 2016
+1
ghost
on 23 Jun 2016
+1
miguelcnf
on 6 Jul 2016
+1
zarrigoni
on 8 Jul 2016
+100
bopeng87
on 8 Jul 2016
+1
AlexGrs
on 25 Jul 2016
+1
jarlwolfganger
on 31 Jul 2016
+1
fredvd
on 12 Aug 2016
+1
sachinrase
on 16 Sep 2016
How is it going?
KawaiDesu
on 21 Sep 2016
+1
petermo13
on 4 Nov 2016
+1
haripriyavanchinathan
on 9 Nov 2016
Is there any workaround so far? Like exporting use sed to rename and import again or something?
dersimn
on 2 Dec 2016
+1
wei-hai
on 15 Dec 2016
Update: do not use this workaround - it converts tags into fields! See other comments for better ideas.
A workaround is:
SELECT * INTO new_name FROM old_name
DROP MEASUREMENT old_name
Although I had problems dropping the old name due to "in use" errors. Still, +1.
See http://docs.influxdata.com/influxdb/v0.12/query_language/data_exploration/#relocate-data
hraftery
on 22 Dec 2016
+1
gmegan
on 11 Jan 2017
+1
ot3
on 12 Jan 2017
+1
topinet
on 1 Mar 2017
+1
MrMontesa
on 13 Apr 2017
Comment on the mentioned workaround:
SELECT * INTO new_name FROM old_name
This converts all tags to fields, causing overwrites at points with identical timestamps, see http://docs.influxdata.com/influxdb/v1.2/troubleshooting/frequently-asked-questions/#why-are-my-into-queries-missing-data.
So one should use SELECT * INTO new_name FROM old_name GROUP BY *.
lrytz
on 26 May 2017
+1
akuma
on 27 May 2017
- 1
5k3105
on 9 Jun 2017
SELECT * INTO new_name FROM old_name GROUP BY *
DROP MEASUREMENT old_name
Yes, it works
but there is unacceptable for a big data and bulk rename - so long time.
Still, +1.
mguryanov
on 27 Jun 2017
+1
vatechie
on 5 Dec 2017
+1
anderskvist
on 4 Feb 2018
+1
xristosrou
on 16 Feb 2018
+1
hyteoo
on 19 Feb 2018
+1
jcmartins
on 23 Feb 2018
+1
qiyugfh
on 2 Apr 2018
+1
BOFH90
on 26 Apr 2018
+1
kmoppel
on 30 Apr 2018
+1
arpitmsharma
on 7 Jun 2018
+1
nkolchakov
on 14 Jun 2018
+1
RRomaNN
on 26 Jun 2018
+1
bhuism
on 2 Jul 2018
+1
memetb
on 7 Jul 2018
+1
ishikhman
on 10 Jul 2018
+1
ninjadude333
on 18 Jul 2018
+1
Ramalama2
on 17 Sep 2018
+1
salzix
on 18 Sep 2018
I appreciate this feature too. Because downsampled measurements are renamed and it's impossible to use already created Grafana dashboards. You need to create new ones with modified measurement names in SELECT.
waldauf
on 6 Dec 2018
+1
Schm1tz1
on 6 Jan 2019
+1
osaether
on 9 Jan 2019
+1
Raymundo1
on 10 Jan 2019
+1
sada-okamura
on 23 Apr 2019
+1
gregors
on 14 Jun 2019
If you're going to reply with ":+1:", please stop. Github already has this feature. Choose a comment above you agree with, and :+1: that one instead.
Or add something that hasn't been mentioned before, e.g. that SELECT INTO doesn't display any progress indicator, so estimating how long a "rename" would take is a shot in the dark.
UPDATE: do NOT run the workaround! It ended up corrupting my database.
dandv
on 15 Jul 2019
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
![stale[bot] picture](https://avatars3.githubusercontent.com/in/1724?v=4&s=40)
stale[bot]
on 13 Oct 2019
+100 need it right now though :)
carsten-lund
on 13 Oct 2019
Is this a planned feature, or do we have to go with the SELECT * INTO ... solution?
Ricaz
on 28 Oct 2019
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
stale[bot]
on 26 Jan 2020
Unstale.
mitar
on 26 Jan 2020
Another update on running the workaround: this time SELECT * INTO ... FROM ... did something that apparently converted tags to fields.
Again, be very careful when running the workaround. It's not a solid solution.
dandv
on 12 Feb 2020
Hello,
Altering metadata is a major limitation of InfluxDB. Since InfluxQL does not support alter query types for measurements, tags or fields, I decided to implement a tool as a workaround.
The tool supports a RenameMeasurement rule to rename a measurement and update the fields index. It is an offline tool, so the node must be taken down first (the exact same way you would run influx_inspect buildtsi).
Please check it and let me know if it helps.
https://github.com/Abc-Arbitrage/infix
Any feedback is also welcome.
oktal
on 12 May 2020
Related issues
Witee
路
3Comments
acarapetis
路
3Comments
dtouzeau
路
3Comments
MayukhSobo
路
3Comments
Raniz85
路
3Comments
Most helpful comment
Yes, it works
but there is unacceptable for a big data and bulk rename - so long time.
Still, +1.