Getting error while querying HIVE

[#1]

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

[#2]

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.

[#3]

Still getting the permission error like below:

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

Thanks,
Ravikumar

[#4]

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.