Error while using Sqoop import


#1

Hi Team,

I have created folders as below manually:

/user/jitendra/sqoop_import/retail_db inside /home/jitendrapp

But i am getting error as below while using sqoop import:

org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=jitendrapp, access=WRITE, inode="
/home/jitendrapp/user/sqoop_import/retail_db/_temporary/1":hdfs:hdfs:drwxr-xr-x

Please help.

Thanks


#2

@jitendrapp

provide us with the command your trying.


#3

Hi Chandan,

This is the command i am using:

sqoop import --connect jdbc:mysql://ms.itversity.com/retail_db --username retail_user --password itversity --table order_items --target-dir
/home/jitendrapp/user/sqoop_import/retail_db


#4

@jitendrapp

It is an incorrect path. you should mention HDFS path while importing data from MySQL database to Hadoop HDFS.
Try below command it is working fine:

sqoop import --connect "jdbc:mysql://ms.itversity.com:3306/retail_db" --username retail_user --password itversity --table order_items --target-dir /user/jitendrapp/orderitems


#5