title: How to use autoincrement-IDs in Sqoop export
body: <p>I have a tab-separated textfile in HDFS, and want to export this into a MySQL table.</p>
  
  <p>Since the rows in the textfile do not have numerical ids, how do I export into a table with an ID automatically set during the SQL INSERT (autoincrement)?</p>
  
  <p>If I try to export (id being the last defined attribute in the table), I get </p>
  
  <pre><code>java.util.NoSuchElementException
    at java.util.AbstractList$Itr.next(AbstractList.java:350)
    at entity.__loadFromFields(entity.java:996)
  </code></pre>
  
  <p>If I take the autogenerated class and modify it to exclude the id-attribute, I get </p>
  
  <pre><code>java.io.IOException: java.sql.SQLException: No value specified for parameter 27
  </code></pre>
  
  <p>where parameter 27 is 'id'.</p>
  
  <p>Version is Sqoop 1.3.0-cdh3u3</p>