Re: [influxdb] cast in query fails with parsing error

[Sean Beckett]

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,  wrote:

> Hello, I have an issue casting from float to int.
>
> usual query works:
>
> > SELECT "value" FROM "xyz" limit 2
> name: xyz
> --
> timevalue
> 13912128000 19.1
> 13912128010 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.

[influxdb] cast in query fails with parsing error

[micbuh]

Hello, I have an issue casting from float to int. 

usual query works:

> SELECT "value" FROM "xyz" limit 2
name: xyz
--
timevalue
13912128000 19.1
13912128010 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.