Reply
Explorer
Posts: 15
Registered: ‎11-20-2013
Accepted Solution

sqoop and --hive-import how to define destination folder for hive/warehouse

is it possible to specify the hive-table destionation when using sqoop with the -hive-import switch.

 

the script below is creating the tables at the root of /user/hive/warehouse.  I'd like them in a single directory that I specify.

 

using --hive-home was a guess but it is not working.  Thanks

 

sqoop import-all-tables \
--connect jdbc:oracle:thin:@//schema.domain.org:1521/schema \
--username=user -P \
--warehouse-dir '/user/choa/dev/HBOC' \
--fields-terminated-by '|' \
--hive-import \
--hive-home '/user/hive/warehouse/hboc.db' \
-m 1

Highlighted
Cloudera Employee
Posts: 20
Registered: ‎07-08-2013

Re: sqoop and --hive-import how to define destination folder for hive/warehouse

Hi sir,

the concept you are describing is known in Hive as external table and Sqoop currently do not supports that. It's covered by SQOOP-816:

 

https://issues.apache.org/jira/browse/SQOOP-816

 

Jarcec

Announcements