Hi Sean: I have similar issue with the data, I stored integers as string accidentally. Can you give me some suggestions on how to export and re-write the data? I couldn't find any documentation regarding import/export from influxdb doc. Also I have 44G of data, which sounds impossible for me to finish it in any time soon. What's the best approach? Thanks!
On Friday, April 8, 2016 at 8:55:37 PM UTC-4, Sean Beckett wrote: > There is no CAST function, nor is there a way to alter the type of a field > after write. > > > There are open feature requests for both, but until one or both is written I > think you will need to export and re-write the data with the proper type. > > > On Tue, Apr 5, 2016 at 3:28 AM, <[email protected]> wrote: > Hi Sean, > > > > I have an influxDB database where a field is stored as strings. Now I am in a > bit of a predicament as I need to do some aggregation and math functions on > this field. > > > > Are there any InfluxDB functions I could use to do this on the string field? > I am currently on InfluxDB 9. I can upgrade to a newer version, if that does > the job. > > > > Thanks, > > Paul John > > > > On Thursday, June 11, 2015 at 1:21:12 PM UTC+5:30, Yukinori SUDA wrote: > > > Hi Sean, > > > > > > > > > thanks for your quick response. > > > > > > > > > I filed the issue. > > > https://github.com/influxdb/influxdb/issues/2911/ > > > > > > > > > > > > I'm looking forward to implementing this function. > > > > > > > > > Thanks, > > > > > > > > > suda > > > > > > > > > > > > > > > 2015-06-11 15:59 GMT+09:00 Sean Beckett <[email protected]>: > > > > > > There are no issues filed requesting that feature so it is not currently > > planned. > > > > > > > > > If you would like to have this feature, please open a feature request issue > > on GitHub: https://github.com/influxdb/influxdb/issues/new > > > > > > > > > > > > > > > On Wed, Jun 10, 2015 at 11:37 PM, Suda Yukinori <[email protected]> wrote: > > > > > > > > > Hello, > > > > > > > > > Many DBs basically support cast() function. > > > So we can get the sum of string field by using cast(field AS int) > > > > > > > > > In the latest version, InfluxDB does not seem to support cast() function > > > and the sum of string field is empty. > > > > > > > > > Does InfluxDB have a plan to support cast() function in the future release? > > > > > > > > > Thanks > > > > > > > > > suda > > > > > > > > > > > > > > > > > > > > > -- > > > > > > 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 http://groups.google.com/group/influxdb. > > > > > > To view this discussion on the web visit > > https://groups.google.com/d/msgid/influxdb/768a2c57-52d9-45dc-bd82-4e5043a23039%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 http://groups.google.com/group/influxdb. > > > > > > To view this discussion on the web visit > > https://groups.google.com/d/msgid/influxdb/CALGqCvOekD-BgTwZfJfcxw6NGLL2%3D6U1b0k%3Dt63ubELnaEDXVA%40mail.gmail.com. > > > > > > > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > -- > > 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/1db177ed-4d1c-4439-8adb-160e4ea53b6e%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/e0918c48-3e20-4be9-8b39-ce5e2b9ba5ad%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
