03-27-2014 07:55 AM
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-home '/user/hive/warehouse/hboc.db' \
03-29-2014 09:53 AM
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: