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

todwith1d — Fri, 16 Sep 2022 08:56:05 GMT

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

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

jarcec — Sat, 29 Mar 2014 16:53:42 GMT

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

question sqoop and --hive-import how to define destination folder for hive/warehouse in Archives of Support Questions (Read Only)

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

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