Sqoop export of a hive table partitioned on an int column
<p>I have a Hive table partitioned on an 'int' column.</p>

<p>I want to export the Hive table to MySql using Sqoop export tool.</p>

<pre><code>sqoop export --connect jdbc:mysql://XXXX:3306/temp --username root --password root --table emp --hcatalog-database temp --hcatalog-table emp
</code></pre>

<p>I tried the above sqoop command but it failed with below exception.</p>

<pre><code>ERROR tool.ExportTool: Encountered IOException running export job: java.io.IOException: 
The table provided temp.emp uses unsupported  partitioning key type  for column mth_id : int.  
Only string fields are allowed in partition columns in HCatalog
</code></pre>

<p>I understand that the partition on int column is not supported.
<br>But would like to check whether this issue is fixed in any of the latest releases with an extra config/option.</p>

<p>As a workaround, I can create another table without a partition before exporting.<br>But I would like to check whether there is a better way to achieve this?</p>

<p>Thanks in advance.</p>