Support Questions
Find answers, ask questions, and share your expertise

Getting error while querying HIVE

Explorer

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

Explorer
Still getting the permission error like below:

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

Thanks,
Ravikumar

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.