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