Reply
New Contributor
Posts: 2
Registered: ‎07-20-2017

Getting error while querying HIVE

Hi Friends,

 

I am getting below error:

 

> show tables;
FAILED: SemanticException MetaException(message:java.security.AccessControlException: Permission denied: user=user, access=READ, inode="/apps/hive/warehouse":hive:hadoop:drwxrwx---

 

Please share the solution asap.

 

Thanks,

Ravikumar

Posts: 614
Topics: 3
Kudos: 93
Solutions: 61
Registered: ‎08-16-2016

Re: Getting error while querying HIVE

Open up the Hive warehouse directory.  Run hdfs dfs -chmod -R 1776 /user/hive/warehouse, to make it readable by all, or hdfs dfs -chmod 1777 to open it for both read and write.

New Contributor
Posts: 2
Registered: ‎07-20-2017

Re: Getting error while querying HIVE

Still getting the permission error like below:

chmod: Permission denied: user=user,
access=EXECUTE, inode="/user/hive/warehouse"
hive:hdfs:drwx------

Thanks,
Ravikumar
Posts: 614
Topics: 3
Kudos: 93
Solutions: 61
Registered: ‎08-16-2016

Re: Getting error while querying HIVE

Umm you when from hive:hadoop:drwxrwx--- to hive:hdfs:drwx------. That is 770 to 700, which is more restrictive. Please review my previous post.
Announcements