Hive remove multiple space between the string

Asked Jun 11 '18 at 13:32

Active Jun 11 '18 at 13:36

Viewed 1,967 times

In Hive how can I replace multiple spaces between a strings ?

select regexp_replace('foot ball',' ',' ')

Expected output is a string with only one space between them

foot ball

Any help is appreciated

edited Jun 11 '18 at 13:36

OneCricketeer

asked Jun 11 '18 at 13:32

Shijo

1

You should use a regex that captures multiple spaces? https://stackoverflow.com/q/2932392/2308683 – OneCricketeer Jun 11 '18 at 13:34
Thanks @cricket_007, select regexp_replace('foot ball',' +',' ') did the trick for me – Shijo Jun 11 '18 at 13:42

0 Answers0