You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@sqoop.apache.org by Raymond Xie <xi...@gmail.com> on 2018/03/22 20:37:33 UTC

where is the default sqoop hive import destination directory? is it controllable?

I need to do a sqoop import all tables from an existing mysql database to
hive, the first table is categories.

The command is as below:

sqoop import-all-tables -m 1 \
--connect=jdbc:mysql://ms.itversity.com/retail_db \
--username=retail_user \
--password=itversity \
--hive-import \
--hive-overwrite \
--create-hive-table \
--compress \
--compression-codec org.apache.hadoop.io.compress.SnappyCodec \
--outdir java_output0322

It failed for the following reason:

Output directory hdfs://nn01.itversity.com:8020/user/paslechoix/categories
already exists

I am wondering how can I import them into
/apps/hive/warehouse/paslechoix.db/

paslechoix is the hive database name.


*------------------------------------------------*
*Sincerely yours,*


*Raymond*