Casting value data in influx query

#1

Hi,

Have situation where some measurement are in string format instead of integer, do I can’t execute function that uses integer.
Is there any option to cast it on the fly?

something like:
select max(integer(value)) from measurement.

Thanks
Dubravko

#2

The only cast operations available at this time are from float to int and int to float for field values. You can’t cast from a string to an int.