There is no trivial way to do what you require. The best current way is to query the data and store the JSON returns. Then write some code to manipulate the data into line protocol and alter the tag(s) into fields.
The challenge is that there is no way to directly return line protocol from a query, so the JSON to line protocol transition is the most complex part of the operation. On Wed, Jul 13, 2016 at 7:55 AM, <[email protected]> wrote: > I'm in a situation where my influxdb is un-usable, due to high > cardinality. (Takes about 70GB of ram, show series doesn't even return) > > I've re-created a new schema design to fix this; but I'd like to export > all my existing data, manipulate it to change a column from field to tag, > and re-import into the new schema. > > Is there some recommended way to do this with a 0.12.x version? > > It seems /export end-point was only for a one-time data migration. > Backup & Restore seems to be without manipulation of data the way I need. > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/37559335-64b6-46d0-9a4d-d5312ed067d2%40googlegroups.com > . > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvP8EwqNdhm7wRFLjK16uZZYJvhYRkQQ0Sv2Ot_N%3DEr6aQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
