Sqoop import failing due to permission denied

sqoop

#1

Hi,

I’m running the below command to import a table from mysql to HDFS and its failing with permission denied message. I tried to provide the write access to all my folders but that didn’t help. can you please let me know what the issue here?

Command:

sqoop import --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity --table
order_items --warehouse-dir /home/nandhuu_s/sqoop_import/retail_db

error:

Permission denied: user=nandhuu_s, access=WRITE, i
node="/home/nandhuu_s/sqoop_import/retail_db/order_items/_temporary/1":hdfs:hdfs:drwxr-xr-x


#2

You have to give HDFS path as:

/user/nandhuu_s/sqoop_import/retail_db


#3

Thank you, it worked.


#4