Permission denied?


#1

Can anyone help the following script:

sqoop import
–connect jdbc:mysql://ms.itversity.com:3306/retail_db
–username retail_user
–password itversity
–table orders
–target-dir /paslechoix/sqoop_import/retail_db
–append

I am getting this error:
Job setup failed : org.apache.hadoop.security.AccessControlException: Permission denied: user=paslechoix, access=WRITE, inode="/paslechoix/sqoop_import/retail_db/_temporary/1":hdfs:hdfs:drwxrwxr-x

Thanks.


#2

you can use the target directory as /user/paslechoix/retail_db/order_def

Here is the command:

sqoop import --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity --table order_items --target-dir /user/paslechoix/retail_db/order_def --compress --compression-codec org.apache.hadoop.io.compress.DefaultCodec --append