exception org apache hadoop security AccessControlException Permission denied user test access WRITE inode user hive warehouse test

0 votes

I am getting this below error, when I tried to create one table in hive.

hive> create table test;
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.hadoop.security.AccessControlException Permission denied: user=test, access=WRITE, inode="/user/hive/warehouse/test":hadoop:hadoop:drwxrwx--t)
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:320)
Apr 17, 2020 in Big Data Hadoop by akhtar
• 38,230 points
2,192 views

1 answer to this question.

0 votes

Hi@akhtar,

According to your error, it shows you are running hive with test user. But you did not set permissions for this user. So set permissions for test user as given below. 

hadoop fs -setfacl -m user:test:rwx /user/hive/warehouse

Hope this will help you.

Thank you

answered Apr 17, 2020 by MD
• 95,360 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Hive: org.apache.hadoop.security.AccessControlException Permission denied: user

This error is generally thrown when the ...READ MORE

answered Aug 1, 2019 in Big Data Hadoop by Waniku
2,200 views
0 votes
1 answer

Sqoop import gives error: org.apache.hadoop.security.AccessControlException: Permission denied

Seems like you are not passing the ...READ MORE

answered Dec 17, 2018 in Big Data Hadoop by Omkar
• 69,190 points
1,318 views
0 votes
1 answer
0 votes
1 answer

Hadoop Hive: ClassNotFoundException: org.apache.hive.jdbc.HiveDriver

You have to use the right dependency <dependency> ...READ MORE

answered Dec 11, 2018 in Big Data Hadoop by Omkar
• 69,190 points
3,966 views
0 votes
1 answer

What is Metastore in Hive?

It stores metadata for Hive tables (like their schema ...READ MORE

answered Dec 20, 2018 in Big Data Hadoop by Frankie
• 9,830 points
2,177 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
9,088 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 11,380 points
1,636 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
82,808 views
0 votes
1 answer
+1 vote
1 answer

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

Hi@akhtar, This issue generally occurs when the memory ...READ MORE

answered Apr 17, 2020 in Big Data Hadoop by MD
• 95,360 points
21,368 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP