title: handling newline character in hive
body: <p>I have created a table in hive as  </p>
  
  <pre><code>Create table(id int, Description String)  
  </code></pre>
  
  <p>My data looks something as follows :</p>
  
  <pre> 
  1|This will return corrupt data since there is a ',' in the first string.
       some text
       Change the data  
  2|There is prob in reading data 
      sometext
  </pre>
  
  <p>After the data is loaded into hive since the default line terminator is \n, the description column cannot be read by hive, Hence it displays a NULL value. Can anyone suggest how to handle newline before loading into hive.</p>