Hadoop Hive无法将源移动到目标 [英] Hadoop Hive unable to move source to destination

问题描述

我试图在Hadoop 2.6.0上使用Hive 1.2.0。我创建了一个员工表。但是，当我运行以下查询时：

  hive>将数据本地inpath'/ home / abc / employeedetails'加载到表员工中; 
  

我得到以下错误：

 失败，异常无法将源文件：/ home / abc / employeedetails移至目标hdfs：// localhost：9000 / user / hive / warehouse / employee / employeedetails_copy_1 
 FAILED：执行错误，从org.apache.hadoop.hive.ql.exec.MoveTask返回代码1 
  

错误我在这里吗？有没有我需要设置的特定权限？感谢您！

解决方案

正如Rio所提到的，问题涉及缺乏将数据加载到配置单元表中的权限。我发现下面的命令解决了我的问题：

pre $ hadoop fs -chmod g + w / user / hive / warehouse


I am trying to use Hive 1.2.0 over Hadoop 2.6.0. I have created an employee table. However, when I run the following query:

hive> load data local inpath '/home/abc/employeedetails' into table employee;

I get the following error:

Failed with exception Unable to move source file:/home/abc/employeedetails to destination hdfs://localhost:9000/user/hive/warehouse/employee/employeedetails_copy_1
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

What wrong am I doing here? Are there any specific permissions that I need to set? Thanks in advance!

解决方案

As mentioned by Rio, the issue involved lack of permissions to load data into hive table. I figures out the following command solves my problems:

hadoop fs -chmod g+w /user/hive/warehouse

这篇关于Hadoop Hive无法将源移动到目标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！