Converts a string literal to a number literal.
Syntax
string_to_number(string)
Usage
If the string can't be parsed as a number or contains a separator, such as a comma, the query fails.
Example
-- creates a field called "Number" that contains the number 12345
q = foreach q generate string_to_number("12345") as 'Number';