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*
