How do I remove currency symbol from string and convert into int in hive? EXAMPLE (124$ INTO 124)

[#1]

How do I remove a currency symbol from a string and convert it into an int in Hive? For example, how do I change '124$' into 124?

[#2 · Accepted solution]

@Venkat

Use regexp_replace function in hive to replace $ with '' then cast to int.

Example:

select int(regexp_replace(string("124$"),'\\$',''));
+------+--+
| _c0  |
+------+--+
| 124  |
+------+--+

(or)

Starting from Hive-1.3 version use replace function.

select int(replace(string("124$"),'$',''));
+------+--+
| _c0  |
+------+--+
| 124  |
+------+--+