Hive - Count number of occurrences of character

Question

I am trying to count number of occurrences of pipe symbol in Hive - (6)

select length(regexp_replace('220138|251965797?AIRFR?150350161961|||||','^(?:[^|]*\\|)(\\|)','')) from smartmatching limit 10

This is what I am trying and I am not getting it right.

Answer 1

This will work

SELECT LENGTH(regexp_replace('220138|251965797?AIRFR?150350161961|||||','[^|]',''))