Hi All, I have installed Hive 0.7 and its up and running. But I am getting permission denied error while creating a table.
But I have rwxrwxr-x to warehouse directory. My HADOOP_HOME is setup to cluster and on hive-site.xml I have these setting <property> <name>hive.metastore.local</name> <value>true</value> <description>controls whether to connect to remove metastore server or open a new metastore server in Hive Client JVM</description> </property> Error Message: FAILED: Error in metadata: MetaException(message:Gotexception: org.apache.hadoop.security.AccessControlException org.apache.hadoop.securityAccessControlException: Permission denied: user=sgehlot, access=WRITE, inode="warehouse":hdfs2:user:rwxrwxr-x) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Can anyone please tell me what is possible reason of this error. Thanks, Sonia