Sqoop Import Error due to permission


#1

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

Error:
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.



#2

@sumit8724

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.


#3

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


#4