I Cannot carry out certain sqoop jobs

sqoop

#1

Hello to everyone. Much respect.

When I try to import data from table orders in retail_db, I get the following error:

Job job_1520592249193_31212 failed with state FAILED due to: Job setup failed : org.apache.hadoop.security.AccessControlException: Permission denied: user=josemanuelramirezleon, access=WRITE, inode="/user/cloudera/problem3/products_replica/input/products/_temporary/1":hdfs:hdfs:drwxr-xr-x

My sqoop job is:

sqoop import
–connect “jdbc:mysql://ms.itversity.com:3306/retail_db”
–username retail_user
–password itversity
–table products
–warehouse-dir
/user/cloudera/problem3/products_replica/input
–hive-import
–create-hive-table
–hive-database default
–hive-table products_replica
-m 1

If any caring soul could help me, I would be forever indebted,

Best resgards,

Jose Manuel Ramirez Leon


#2

you probably need to use HIVE directory location where your hive database is.

for example: /user/hive/warehouse/default.db


#3

I am sorry if I do not grasp your reasoning correctly. You mean that I should have specified /user/hive/warehouse/default.db as --hive database?

It still fails…


#4

You dont have permission tp write to /user/cloudera/.

you should write /user/[your_user_name]/cloudera/problem3/products_replica/input


#5

Thank you, that really helped :slight_smile: