Reply
Highlighted
New Contributor
Posts: 1
Registered: ‎03-06-2018

Sqoop export subset of columns

[ Edited ]

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

New Contributor
Posts: 1
Registered: ‎04-27-2018

Re: Sqoop export subset of columns

Hi Krish,

 

Did you get any resolution for your problem. I have the similar situation to select specific columns from HIVE table.

 

Thank you,

Ranjith

Champion
Posts: 731
Registered: ‎05-16-2016

Re: Sqoop export subset of columns

you can try using the 


--columns cust_id, name, address, date, history, occupation

--columns parameter 

if i understand correctly your requirment 

Announcements