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

chiranjeevivenk — Thu, 17 Jan 2019 05:02:23 GMT

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

Shu_ashu — Thu, 17 Jan 2019 06:49:47 GMT

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  |
+------+--+