Hive: Convert String to Integer

string hive user-defined-functions hiveql
Srinivas picture Srinivas · Sep 10, 2012 · Viewed 197.7k times · Source

I am looking for a Built-in UDF to convert values of a string column to integer in my hive table for sorting using SELECT and ORDER BY. I searched in the Language Manual, but no use. Any other suggestions also welcome.

Answer

Joe K picture Joe K · Sep 10, 2012

cast(str_column as int)

From: Language manual UDFs - type conversion functions

Related questions

Hive cast string to date dd-MM-yyyy

How can I cast a string in the format 'dd-MM-yyyy' to a date type also in the format 'dd-MM-yyyy' in Hive? Something along the lines of: CAST('12-03-2010' as date 'dd-mm-yyyy')

Read More
How can I convert array to string in hive sql?

I want to convert an array to string in hive. I want to collect_set array values to convert to string without [[""]]. select actor, collect_set(date) as grpdate from actor_table group by actor; so that [["2016-07-01", "2016-07…

Read More
Hiveql - RIGHT() LEFT() Function

Is there a function in Hiveql that is equivalent to Right() or Left() fuction form TSQL? For example, RIGHT(col1,10) to get the first 10 characters from col1. thank you

Read More