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$ClientNamenodeProtocolServerServer.call(RPC.java:969)
at org.apache.hadoop.ipc.Server$HandlerHandlerHandler.run(Server.java:2043)
jps命令查看hadoop,发现datanode挂了
之前因为反复进行过hadoop namenode -format 格式化,造成了datanode挂掉。
将hadoop/tmp目录删除,重新进行格式hadoop,再重新启动hive即可。