Support Questions
Find answers, ask questions, and share your expertise

Regexp search match multiple values

Regexp search match multiple values

Expert Contributor

Hi,

I am trying to match multiple values in a string using hive regxp, looking for an optimal solution.

I want to match "first" and "1.11" from the below

 

column name is col: 

This string is the first string with two decimals 1.11 and 2.22 with a special char / and some more extra string.

 table name is t:

query I was using:

 select * from t where t.col regexp '(?=.*first)(?=.*1.11)'

 

Could you please help me.

Thank you

1 REPLY 1

Re: Regexp search match multiple values

Regex always gives me a go.  Knowing if you have a typo, or are completely missing what works and what doesn't is always a big pain.   Try working with something like this Regex Tester to get your regex string setup:

 

 

https://regex101.com