Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Getting error while querying HIVE

Getting error while querying HIVE

New Contributor

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

3 REPLIES 3

Re: Getting error while querying HIVE

Champion

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.

Re: Getting error while querying HIVE

New Contributor
Still getting the permission error like below:

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

Thanks,
Ravikumar
Highlighted

Re: Getting error while querying HIVE

Champion
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.