I have a 2000 column table in Hive and need to export this data to 4 different tables in Oracle each having 500 columns.

I don't see query or columns as parameters for sqoop export in the documentation. Can you please let me know if there is any way to export subset of columns from Hive to Oracle.

Thanks

Krish