hive插入数据失败FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values File

向数据库插入数据失败,报错
hive插入数据失败FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values File

hive> insert into table a1 values(1,‘zzz’);
FAILED: SemanticException [Error 10293]: Unable to create temp file for insert values File /tmp/hive/root/8af3f6fb-7116- could only be replicated to 0 nodes instead of minReplication (=1). There are 0 datanode(s) running and no node(s) are
at org.apache.hadoop.hdfs.server.blockmanagement.BlockManager.chooseTarget4NewBlock(BlockManager.java:1550)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getNewBlockTargets(FSNamesystem.java:3110)
at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getAdditionalBlock(FSNamesystem.java:3034)
at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.addBlock(NameNodeRpcServer.java:723)
at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.addBlock(ClientNamenodeProtoco
at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol2.callBlockingMethoatorg.apache.hadoop.ipc.ProtobufRpcEngine2.callBlockingMetho at org.apache.hadoop.ipc.ProtobufRpcEngineServerProtoBufRpcInvoker.call(ProtobufRpcEngine.java:616)atorg.apache.hadoop.ipc.RPCProtoBufRpcInvoker.call(ProtobufRpcEngine.java:616) at org.apache.hadoop.ipc.RPCServer.call(RPC.java:969)
at org.apache.hadoop.ipc.Server$Handler1.run(Server.java:2049)atorg.apache.hadoop.ipc.Server1.run(Server.java:2049) at org.apache.hadoop.ipc.ServerHandler1.run(Server.java:2045)atjava.security.AccessController.doPrivileged(NativeMethod)atjavax.security.auth.Subject.doAs(Subject.java:422)atorg.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)atorg.apache.hadoop.ipc.Server1.run(Server.java:2045) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at org.apache.hadoop.ipc.ServerHandler.run(Server.java:2043)

jps命令查看hadoop,发现datanode挂了
之前因为反复进行过hadoop namenode -format 格式化,造成了datanode挂掉。

将hadoop/tmp目录删除,重新进行格式hadoop,再重新启动hive即可。