string_to_number

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';