Replace first occurrence of . in hive

Question

I want to find the first dot (.) in the string of a column and replace it with text.

Tried Regexp_replace, but couldn't find

Answer 1

hive> select regexp_replace ('Hello ... World ...','^(.*?)\\.','$1{text}'); 

Hello {text}.. World ...