Sqoop Incremental Import Error using Date Column
<p>I'm trying to incrementally import using sqoop . It is working for the column id but when I'm trying to do the same thing in date column it is showing an error , the date column in mysql is in varchar format .</p>

<p>code :</p>

<pre><code>sqoop import --connect jdbc:mysql://$hostName/$dbName --username $userName --password $pass --query "select * , 'username' as user_name, 'date' as created_date from $tableName WHERE $cloumnName between ${values[0]} and ${values[1]} AND \$CONDITIONS"  --target-dir outputPath --append --m mapperNo --split-by splitByValue --check-column cloumnName --incremental $imode
</code></pre>

<p>Error : </p>

<blockquote>
  <p>16/12/20 01:18:46 ERROR tool.ImportTool: Error during import: Character column (date_field) can not be used to determine which rows to incrementally import.</p>
</blockquote>