用sqoop将数据从oracle导出至hive表,报错Permission denied: user=root, access=WRITE, inode="/u
ambari安装的hadoop、hive、sqoop ,用sqoop将数据从oracle导出至hive表,报错Permission denied: user=root, access=WRITE, inode="/user":hdfs:hdfs:drwxr-xr-x!
操作系统rhel6.3 64位,在root下用ambari安装的hadoop、hive、sqoop
各版本如下:
hadoop 2.2.0.2.0.6.0-101
hive 0.12.0.2.0.6.1-101
sqoop 1.4.4.2.0.6.1-101
-------------
sqoop import --hive-import --connect jdbc:oracle:thin:@192.168.88.233:1521:ITSPDB2 --username ITSP --password itsp --verbose --m 1 --table HADOOP_TEST
在root下用sqoop将数据从oracle导出至hive表,报错如下:
14/02/19 09:27:31 INFO client.RMProxy: Connecting to ResourceManager at Slave1.Hadoop/192.168.88.233:8050
14/02/19 09:27:32 ERROR security.UserGroupInformation: PriviledgedActionException as:root (auth:SIMPLE) cause:org.apache.hadoop.security.AccessControlException: Permission denied: user=root, access=WRITE, inode="/user":hdfs:hdfs:drwxr-xr-x
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:234)
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:214)
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:158)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:5202)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:5184)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkAncestorAccess(FSNamesystem.java:5158)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirsInternal(FSNamesystem.java:3405)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirsInt(FSNamesystem.java:3375)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.mkdirs(FSNamesystem.java:3349)
at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.mkdirs(NameNodeRpcServer.java:724)
at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.mkdirs(ClientNamenodeProtocolServerSideTranslatorPB.java:502)
at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java:59598)
at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:585)
at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:928)
at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2053)
at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2049)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:396)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1491)
at org.apache.hadoop.ipc.Server$Handler.run(Server.java:2047)
注:各/home/hadoop/hdfs目录的权限为777, /home/hadoop/hdfs/data 目录权限为750, 各目录属主为root
求解决方案!