 <p>There are 2 options:</p> <ol> <li><p>As of now, sqoop export is very limited (thinking because this is not much intended functionality but other way around), it gives only option to specify the <code>--export-dir</code> which is the table's warehouse directory. And it loads all columns. So you may need to load into a staging table &amp; load it into the original base table with relevant column mapping.</p></li> <li><p>You can export the data from Hive using:</p> <pre><code>INSERT OVERWRITE DIRECTORY '/user/hive_exp/orders' select column1, column2 from hivetable; </code></pre> <p>Then use the Oracle's native import tool. This gives more flexibility.</p></li> </ol> <p>Please update if you have a better solution.</p>