Sqoop hive import exception


#1

Hi , when i try to run the following sqoop command
sqoop import
–connect jdbc:mysql://nn01.itversity.com:3306/retail_db
–username retail_dba
–password itversity
–table customers
–hive-import
–hive-database hariharan_hive
–hive-table hivecustomers
–hive-overwrite

I’m getting exception as
" Failed with exception Destination directory hdfs://nn01.itversity.com:8020/apps/hive/warehouse/hariharan_hive.db/hivecustomers has not be cleaned up. "

but there is no path exist ,that is specified in the exception


#2

You can try using ms.itversity.com in place of nn01.itversity.com

Before trying make sure to delete the hdfs directory n also drop the hive table.

Create the table by using below code

create table Customers(customer_id int,customer_fname string,customer_lname string,customer_email string,customer_password string,customer_street string,customer_city string,customer_state string,customer_zipcode string);

Use below sqoop import command

sqoop import \
  --connect jdbc:mysql://ms.itversity.com:3306/retail_db \
  --username retail_user \
  --password itversity \
  --table customers \
  --hive-import \
  --hive-database databasename \
  --hive-table Customers \
  --hive-overwrite