title: Multi-line insert in Hive
body: <p>I am trying to insert into Hive table through files. But it so happens that the the last column in text file has data which spills across different lines.</p>
  
  <p>Example data:</p>
  
  <pre><code>col1|col2|col3|this line is spilling into different line
                 as is this, this is spilling this is spilling this is sp
                 iliing and so is this
  col1|col2|col3|this can be inserted without problem
  </code></pre>
  
  <p>So the spilled data is considered as a new row instead to wrapping into the last column. I tried using lines terminated by option, but cannot get this to work.</p>