title: Hive remove multiple space between the string
body: <p>In Hive how can I replace multiple spaces between a strings ?</p>
  
  <p><code>select regexp_replace('foot    ball','  ',' ')</code></p>
  
  <p>Expected output is a string with only one space between them</p>
  
  <p><code>foot ball</code> </p>
  
  <p>Any help is appreciated</p>