title: How to handle new line characters in hive?
body: <p>I am exporting table from Teradata to Hive.. The table in the teradata  Has a address field which has  New line characters(\n).. initially I am exporting the table to mount filesystem path from Teradata and then I am loading the table into hive...  Record counts are mismatching between teradata table and hive table, Since new line characters are presented in hive. </p>
  
  <p><strong>NOTE: I don't want to handle this through sqoop to bring the data</strong> I want to handle the new line characters while loading  Into hive from local path. </p>