I have run into similar problems. Thanks for the suggestions. One concern... Isn't hdfs a highly privileged user within the Hadoop cluster? So do we really want it to be standard practice for all Hive users to su to hdfs?
Nuance R&D Data Team
From: Himanish Kushary [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2012 9:30 AM
To: [EMAIL PROTECTED]
Subject: Re: Hive directory permissions
>From the Hive language manual - "Moreover, we strongly advise users to create the HDFS directories /tmp and /user/hive/warehouse
(aka hive.metastore.warehouse.dir) and set them chmod g+w before tables are created in Hive"
My warehouse directory has the following permissions:
Also I make sure that I run the hive CLI as 'hdfs' user.
Hope this helps
On Thu, Aug 16, 2012 at 1:50 AM, Sean Bigdatafun <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
I ran the following command trying to setup my hive directory, but got the following error.
root@cdh-client:/# hadoop fs -mkdir /user/hive/warehouse
mkdir: org.apache.hadoop.security.AccessControlException: Permission denied: user=root, access=WRITE, inode="/user":hdfs:hadoop:drwxr-xr-x
Can someone tell me what is the "correct" ownership for hive directories? My "/user" directory is with the following ownership:
Should I create a sub-directory under user with the following permission?
Thanks & Regards