@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 |
+------+--+
... View more
