Menu
I need to replace the square brackets around a key:value pair similar to the following. Any help is much appreciated!
data in 'properties' looks like this:
name: property1
value: [12345667:97764458]
**code**
SELECT p.name, regexp_replace(p.value,'[','') AS value
FROM properties p
Solved: Revised code
SELECT p.name, regexp_replace(p.value,'\\[|\\]','') AS value
FROM properties p;
207
Regexp_replace function in Hive. We need to define the pattern of the string like java regular expression in the Regexp_replace function.If the given string pattern match with the input string, it will replace all the occurrence of string to new string that given as a string replacement value in the function.
Hive provides few functions to handle the string replacement. Using string replace functions , we can replace some characters or the string with another character or string in Hive table values. Lets see the following string functions in detail. regexp_replace ; translate ; Regexp_replace function in Hive
A bracket expression [\ [\] which matches either a \ character or a [ character or a \ character (since \ is not an escape character in Oracle's regular expression syntax but is treated as a character literal). Followed by a ] character. So your regular expression would match a sub-string that was either \] or [].
Regexp_replace function replaces the string that matches a regular expression pattern with another string. Regexp_extract function extracts a portion of the string that matches a regular expression pattern with another string. RLIKE function to evaluate the LIKE operation using regular expression pattern.
You always need to double your backslashes in Hive regexes. That's because a single backslash is used as an escape character in Hive strings so it would get stripped off before the regex parser can see it. A double backslash becomes a single backslash, which is what you need.
To see how backslashes get stripped just run a select using your regex as a string literal:
select '\\[' from t limit 1;
OK
\[
Here is you regex [\[\]]+ this will match one or more [ and ] in a string.
28
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
