title: Sqoop import job error org.kitesdk.data.ValidationException for Oracle
body: <p>Sqoop import job for Oracle 11g fails with error</p>
  
  <blockquote>
    <p>ERROR sqoop.Sqoop: Got exception running Sqoop:
    org.kitesdk.data.ValidationException: Dataset name
    81fdfb8245ab4898a719d4dda39e23f9_C46010.HISTCONTACT is not
    alphanumeric (plus '_')</p>
  </blockquote>
  
  <p>here's the complete command:</p>
  
  <pre><code>$ sqoop job --create ingest_amsp_histcontact -- import --connect "jdbc:oracle:thin:@&lt;IP&gt;:&lt;PORT&gt;/&lt;SID&gt;" --username "c46010" -P --table C46010.HISTCONTACT --check-column ITEM_SEQ --target-dir /tmp/junk/amsp.histcontact -as-parquetfile -m 1 --incremental append
  
  $ sqoop job --exec ingest_amsp_histcontact
  </code></pre>
  
  <p>it's an incremental import with parquet format. Surprisingly, it works pretty well if I use another format like --as-textfile.</p>
  
  <p>This is similar issue with <a href="https://stackoverflow.com/questions/35276816/sqoop-job-fails-with-kitesdk-validation-error-for-oracle-import">Sqoop job fails with KiteSDK validation error for Oracle import</a></p>
  
  <p>But I've used ojdbc6 and switched to ojdbc7 doesn't work as well.</p>
  
  <p>Sqoop version: 1.4.7</p>
  
  <p>Oracle version: 11g</p>
  
  <p>Thanks,
  Yusata</p>