Michael, what version of the database and CLI are you using? Copy/paste the beginning of the session, e.g.
Connected to http://localhost:8086 version 1.0.0 InfluxDB shell version: v1.0.0 > On Sat, Oct 15, 2016 at 12:57 AM, <mic...@gmail.com> wrote: > Hello, I have an issue casting from float to int. > > usual query works: > > > SELECT "value" FROM "xyz" limit 2 > name: xyz > -------------------------- > time value > 1391212800000000000 19.1 > 1391212801000000000 18.8 > > > where this fails: > > > SELECT value::integer FROM "xyz" limit 2 > ERR: error parsing query: found :, expected FROM at line 1, char 13 > > > SELECT "value"::integer FROM "xyz" limit 2 > ERR: error parsing query: found :, expected FROM at line 1, char 15 > > > I am following this part of the documentation https://docs.influxdata.com/ > influxdb/v1.0/query_language/data_exploration/#data-types- > and-cast-operations-in-queries > > What I am missing here? > > regards, Michael > > > > -- > Remember to include the version number! > --- > You received this message because you are subscribed to the Google Groups > "InfluxData" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to influxdb+unsubscr...@googlegroups.com. > To post to this group, send email to influxdb@googlegroups.com. > 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/97464699-7b4d-45e1-97f1-8a481d6cd7e0%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 version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to influxdb+unsubscr...@googlegroups.com. To post to this group, send email to influxdb@googlegroups.com. 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/CALGqCvO1yi%2BgKT6oZ0L_X27UvRWeVuwMm8Xfq%2BFWmpDSa8fH8w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.