Hive: Convert String to Integer

Question

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.

Joe K · Accepted Answer · 2014-04-13T02:17:41.253

132

cast(str_column as int)

From: Language manual UDFs - type conversion functions

edited Apr 13 '14 at 02:17

answered Sep 10 '12 at 19:25

Joe K

18,204
2
36
58

Just curious, but will this return a unique int for every possible string, including non-ascii ones (e.g.: foreign words or phrases)? – Ward W Jun 11 '18 at 21:22
3

@wardw123 it will return `NULL` if string is non-numeric or too large/small to fit `int` data type – mangusta Oct 19 '18 at 04:43

score 7 · Answer 2 · answered Sep 18 '20 at 10:20

If the value is between –2147483648 and 2147483647, cast(string_filed as int) will work. else cast(string_filed as bigint) will work

    hive> select cast('2147483647' as int);
    OK
    2147483647
    
    hive> select cast('2147483648' as int);
    OK
    NULL
    
    hive> select cast('2147483648' as bigint);
    OK
    2147483648

score -2 · Answer 3 · answered Jun 12 '19 at 15:52

-2

It would return NULL but if taken as BIGINT would show the number

answered Jun 12 '19 at 15:52

ravi

15
3

1

Could you explain your answer please? – party-ring Jun 12 '19 at 16:15

Hive: Convert String to Integer

3 Answers3

Linked

Related