title: How to remove semicolon in a string in HIVE SQL
body: <p>I am trying to remove ";" semi-colon from a string. 
  What command in HIVE SQL should I use. I know regexp_replace may work..but what to put ? 
  It appears that ; - the special character does not work but other special characters like , or : works.
  For example ,
  Data looks like</p>
  
  <pre><code>;;;;;0123445
  </code></pre>
  
  <p>I want the data to look like this</p>
  
  <pre><code>0123445
  </code></pre>
  
  <p>Any help on this will be appreciated. I have been struggling with this.</p>