title: Load a CSV file in Hive with lines of different length
body: <p>How can I do to load a CSV file in Hive with each line having a different number of columns ?
  The problem is that each line have an undefined number of fields, otherwise I would have created a table with the maximum number of fields my CSV can have ...</p>
  
  <p>Fields 1 to 5 will always be there. However, fields 6 to Infinity may not always be there.
  A solution that might be acceptable would be to concatenate fields 6 to Infinity while importing the file in Hive.</p>
  
  <p>Is that even possible ?</p>
  
  <p>Here is a sample of my CSV file to make it clear :</p>
  
  <pre><code>data11;data12;data13;data14
  data21;data22;data23;data24;data25
  data31;data32;data33;data34;data35;data36
  data41;data42;data43
  </code></pre>