Hi Sean, >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: *Name* *Type* *Size* *Replication* *Block Size* *Modification Time* *Permission* *Owner* *Group* *warehouse<http://h-node02:50075/browseDirectory.jsp?dir=%2Fuser%2Fhive%2Fwarehouse&namenodeInfoPort=50070&nnaddr=hdfs01:8020> * *dir* ** ** ** *2012-08-15 15:51* *rwxrwxr-x* *hdfs* *supergroup* Also I make sure that I run the hive CLI as 'hdfs' user. Hope this helps Thanks Himanish On Thu, Aug 16, 2012 at 1:50 AM, Sean Bigdatafun <sean.bigdata...@gmail.com>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: > user<http://cdh-slave2-16g.hwhadoop.com:50075/browseDirectory.jsp?dir=%2Fuser&namenodeInfoPort=50070> > dir 2012-08-14 16:51 rwxr-xr-xhdfs hadoop > Should I create a sub-directory under user with the following permission? > h<http://cdh-slave2-16g.hwhadoop.com:50075/browseDirectory.jsp?dir=%2Fuser&namenodeInfoPort=50070> > ive dir 2012-08-14 16:51 rwxr-xr-xhive hadoop > Thanks, > Sean > > > > -- Thanks & Regards Himanish
