sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raymond Xie <xie3208...@gmail.com>
Subject where is the default sqoop hive import destination directory? is it controllable?
Date Thu, 22 Mar 2018 20:37:33 GMT
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*

Mime
View raw message