title: How to remove ^A and \N from file using hive
body: <p>I get the data from a staging table.I am selecting all columns data from staging table and inserting into a base table.After inserting to base table file looks like below.</p>
  
  <p><code>val1^Aval2^Aval3^A\N^Aval4^A\N</code> 
  But i need data to be like this.</p>
  
  <pre><code>val1 val2 val3   val4  
  </code></pre>
  
  <p>^A must be removed from file and \N should be replaced by blankspace.
  I want to achieve this in hive any help is appreciate.</p>