ascii()
chr()
ends_with()
index_of()
len()
lower()
ltrim()
mv_to_string()
number_to_string
replace()
rtrim()
starts_with()
string_to_number
substr()
trim()
upper()
Windowing Functions
coalesce
Previous Versions
Converts a string literal to a number literal.
string_to_number(string)
If the string can’t be parsed as a number or contains a separator, such as a comma, the query fails.
1-- creates a field called "Number" that contains the number 12345
2
3q = foreach q generate string_to_number("12345") as 'Number';