I have installed Hive service on top Hadoop eco-system then trying to create a database but I got below error and find out a solution as well.
Permission Denied Error in Hive:
FAILED: Execution Error, return code1 from org.apache.hadoop.hive.ql.exec.DDLTask hive> set hive.auto.convert.join.nonconditional task = false: hive> create database myhive: FAILED: Error in metadata: MetaException(message:Got exception: org.apache.hadoop.security.AccessControlException Permission denied user = hadoop access = WRITE, inode*/user*: hdfs : supergroup : drwxr-rx-r at org.apache.hadoop.hdfs.server.namenode.FSPErmissionChecker.check(FSPermissionChecker.java:224) at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:149) at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:149) at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:4891) at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.mkdirs(NameNodeRpcServer.java:669) at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.mkdirs at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java.453) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask hive>
Above error belongs to Permission issue in Hive component:
Resolution:
To resolve the permission issue to the user Hadoop in HDFS. Can you please follow step for the solutions is just change permission to the user using chmod commands:
Step 1: Login to as hduser then execute the below commands one by one. Step 2: sudo - u hdfs hadoop fs -mkdir /user/hive/warehouse Step 3: sudo -u hdfs hadoop fs -chmod g+w /tmp Step 4: sudo -u hdfs hadoop fs -chmod g+w /user/hive/warehouse Step 5: sudo - u hdfs hadoop fs -chown -R /user/hive/warehouse Step 6: sudo chmod 777 /var/lib/hive/metastore Step 7: cd /var/lib/hive/metastore/metastore_db/ Step 8 :sudo rm *.lck
Summary: I have tried above resolutions then working fine now for above error in Hive.