title: Replace specific junk characters from column in hive
body: <p>I've an issue where one of the column loaded in a hive table contains junk character (<code>"~</code>) in a column suffixed with actual value (<code>ABC</code>). So the actual value that's visible for this column is (<code>ABC"~</code>).</p>
  
  <p>This column can have either ABC (or any such string) or NULL. The table is huge and Update is not an option here.</p>
  
  <p>I've thought of a solution of creating a temp table with this column containing either the string (<code>ABC</code>) or NULL, thereby want to remove this junk character (<code>"~</code>) completely while copying the data from original table to this temp table.</p>
  
  <p>Any help on how I can remove this junk? I tried using regexp function, but no success. Any suggestions?</p>