Regex not giving same results as other regex engines

mattschutz — Fri, 16 Sep 2022 13:28:06 GMT

I'm executing the following query in Hive. Many of my field values in my actual table look like:

ASDF (1)

abc 123 xyz (10)

etc. etc. I just want to replace any digits in parentheses at the end of a string with "x".

select 'SP0724_FA (1)' as str, regexp_replace(trim('SP0724_FA (1)'), ' [(]\d+[)]$', 'x') as str_2

The online testing app at regex101.com matches this. However, Hive returns the same value for str and str_2. I would expect to see "SP0724_FAx" as the str_2 value. Please note the space at the beginning of the regex pattern.

Any ideas?

Thank you!

Re: Regex not giving same results as other regex engines

mattschutz — Thu, 19 Jul 2018 12:54:13 GMT

Turned out to be pretty simple. Hadoop (or at least Hive) prefers two backslashes like \\d rather than \d. I ended up using this, which also requires one to four digits.

[(]\\d{1,4}[)]$

question Re: Regex not giving same results as other regex engines in Archives of Support Questions (Read Only)

Regex not giving same results as other regex engines

Re: Regex not giving same results as other regex engines