FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

冷不防 2022-02-01 06:45 636阅读 0赞

1. 问题

hive> LOAD DATA LOCAL INPATH '/root/data/cities.csv' OVERWRITE INTO TABLE cities;  
Loading data to table default.cities  
Failed with exception Unable to move source file:/root/data/cities.csv to destination hdfs://localhost:9000/user/hive/warehouse/cities/cities.csv  
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

查看Hive Log：

\#vi /tmp/root/hive.log

\----------------------------------------  
Caused by: org.apache.hadoop.ipc.RemoteException(java.io.IOException): File /user/hive/warehouse/cities/cities.csv could only be replicated to 0 nodes instead of minReplication (=1).  There are 0 datanode(s) running and no node(s) are excluded in this operation.  
   at org.apache.hadoop.hdfs.server.blockmanagement.BlockManager.chooseTarget4NewBlock(BlockManager.java:1549)  
   at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getAdditionalBlock(FSNamesystem.java:3200)  
   at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.addBlock(NameNodeRpcServer.java:641)

2. 解决方法

2.1

hadoop namenode -format

2.2

/usr/local/hadoop/sbin/start-all.sh

检查：

hive> LOAD DATA LOCAL INPATH '/root/data/cities.csv' OVERWRITE INTO TABLE cities;  
Loading data to table default.cities  
Table default.cities stats: \[numFiles=1, numRows=0, totalSize=9940080, rawDataSize=0\]  
OK  
Time taken: 0.778 seconds

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关已解决：FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask

相关 HIVE Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask. Directory hdfs://m

相关 [Hadoop] Hive查询报错“Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask”

相关 hive创建表失败：FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaEx

相关（hive） Execution Error, return code -101 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask解决方案

相关 Hive 删除表报错： FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.

相关 hive 字符集问题报错 Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaExcept

相关 Hive 调度任务报错FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

相关 FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

相关解决： Failed to execute ... maven-deploy-plugin... Return code is: 401, ReasonPhrase: Unauthorized.