Error while using Sqoop import


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( Permission denied: user=jitendrapp, access=WRITE, inode="

Please help.




provide us with the command your trying.


Hi Chandan,

This is the command i am using:

sqoop import --connect jdbc:mysql:// --username retail_user --password itversity --table order_items --target-dir



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://" --username retail_user --password itversity --table order_items --target-dir /user/jitendrapp/orderitems