regex - regexp_extract not working -


i have string created rsa key 1234 intelligent expense id 54678||||||"

and need extract 54678 in hive ql. using

select description,regexp_extract(description,'id\s(\d*)\|') cctkey smartmatching limit 10 

i tested regex , looks fine. hive not return output me. showing null. can help

you need escape \s, \d , \|. should be

id\\s(\\d*)\\| 

Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -