Sqoop Import Error due to permission


Support Team,

I am trying to run a simple Sqoop import and getting some error.
Below is the detail.

Sqoop import script

sqoop import \
--connect jdbc:mysql://ms.itversity.com:3306/hr_db \
--username hr_user \
--password itversity \
--table employees \
--warehouse-dir /home/sumit8724/sqoop_import/hr_db

I looked in to the log and I think the specific area where I see the error is below. Please let me know if you want me to send the entire log. Looks like some permission issue

Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=sumit8724, access=WRITE, inode="/home/sumit8724/sqoop_import/hr_db/employees/_temporary/1":hdfs:hdfs:drwxrwxr-x

Retail_db has permission 777 , not sure what exactly the issue is.
drwxrwxrwx 2 sumit8724 students 4096 May 4 00:09 retail_db

Please help.

Sign up for our state of the art Big Data cluster for hands on practice as developer. Cluster have Hadoop, Spark, Hive, Sqoop, Kafka and more.



you should mention in the above command like below at the last line:
–warehouse-dir /user/sumit8724

/home/sumit8724 is your local.
/user/sumit8724 is your hdfs directory.


Path is incorrect, it should be /user/sumit8724/sqoop_import/hr_db