Java 中执行Hive QL 语句时报return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
来源:互联网 发布:淘宝怎么发链接给别人 编辑:程序博客网 时间:2024/06/05 06:01
错误描述:
java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:296)
at org.apache.hive.jdbc.HiveStatement.executeUpdate(HiveStatement.java:406)
at yzwork.HiveJdbcClient.main(HiveJdbcClient.java:59)
执行SQL时,最后一个任务是MoveTask,它的作用是将运行SQL生成的Mapeduce任务结果文件放到SQL中指定的存储查询结果的路径中,具体方法就是重命名.所以就涉及到权限问题了。
以下是建立连接的语句,
//默认端口1000 默认的用户名和密码
Connection conn = DriverManager.getConnection(url,user,password);
需要在设置user,password为你自己hdfs文件系统的Owner。
查看Owner方式可以在启动hfs(配置了HADOOP_HOME环境变量后命令start-dfs.sh)服务后访问
localhost:50070,然后选择Utilities。如图:
然后Owner即为所需。
阅读全文
1 0
- Java 中执行Hive QL 语句时报return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
- 程序中执行hive sql出错[FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask]
- Hive jdbc执行seelct 语句时报 return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
- 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.MoveTask.
- Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeExcept
- hive Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException
- hive中删除表的错误Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException
- Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
- FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(me
- hive-05-Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
- FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.Runtim
- CDH5 中使用HIVE的问题总结 return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
- hive安装过程中的一个问题 return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
- Hive连接Mysql---FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
- Hive创建表格报【Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException】引发的血案
- hive创建表失败:FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
- 关于使用hive删除表时出现的return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException
- 第三章 求1!+1/2!+1/3!+1/4!+....的前20项和
- Win10和Ubuntu17.10双系统安装以及liunx系统初始配置
- java.lang.NoClassDefFoundError: org/apache/commons/fileupload/FileItemFactory
- SpringMVC+cxf 发布WebService 服务
- 1032. 挖掘机技术哪家强(20)--Python
- Java 中执行Hive QL 语句时报return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
- OpenResty的现状趋势使用学习方法
- Gradle sync failed: Cause: com.android.build.gradle.api.BaseVariant.getOutputs()Ljava/util/List
- NumPy随机数函数
- 字符串,JSONObject , JSONArray三者之间互转
- 关于容器时间同步
- Java 各种工程对象的区分
- windowsserver 2008+IIS7发布web访问返回534错误
- 加固和混淆