question How to use regexp_replace in hive to remove special character ^ in Archives of Support Questions (Read Only)

How to use regexp_replace in hive to remove special character ^

achandra — Thu, 28 Jun 2018 00:51:29 GMT

I have an expression like

HA^G^FER$$JY

I would like to replace the all ^ with $.

How do I do it. I tried all methods but this isn't working.

Most common error I get is :

java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

Re: How to use regexp_replace in hive to remove special character ^

Shu_ashu — Thu, 28 Jun 2018 04:40:18 GMT

@Abhilash Chandrasekharan

Try with the below syntax

hive> select regexp_replace('HA^G^FER$JY',"\\^","\\$");
+---------------+--+
|      _c0      |
+---------------+--+
| HA$G$FER$JY  |
+---------------+--+

As ^,$ are reserved keys for Regex so use two back slashes in regexp_replace function.