Hive jdbc执行seelct 语句时报 return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
来源:互联网 发布:mac 命令查看运行程序 编辑:程序博客网 时间:2024/06/07 20:46
参考1
解决方法:
如:select distinct hdate from t_stage_access where hdate like '2014-07-%' and dt='2014-07-28'
hdate是partition。
不行
参考2
解决方式:用hive jdbc建表,用hive jdbc执行操作。
用hive shell建表,用hive jdbc执行操作可能会导致权限问题,引起以上两个错误。在删除原表,改用jdbc建表之后,异常解决了。
不行最终找了我们的DBA,hive报错:
没有设置下队列,不允许提交到default队列中
2017-06-20T17:05:26,685ERROR [HiveServer2-Background-Pool: Thread-180955]: exec.Task(SessionState.java:printError(1038)) - Job Submission failed with exception'java.io.IOException(Failed
to run job : Userhduser1701 cannot submit applications to queue root.default)'
java.io.IOException:Failed to run job : User hduser1701 cannot submit applications to queueroot.default
原来是代码里没有指定队列,默认访问默认队列,没有权限
//set queue
stmt.execute(mysql[0]);
res = stmt.executeQuery(mysql[1]);
Set mapreduce.job.queuename=queue_xxx_01;
阅读全文
0 0
- Hive jdbc执行seelct 语句时报 return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
- FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
- FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
- 关于return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask 错误
- return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
- Java 中执行Hive QL 语句时报return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask
- CDH5 中使用HIVE的问题总结 return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
- Hive报错:FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
- Hive code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask问题修复
- Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
- hive-05-Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
- FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
- FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
- 程序中执行hive sql出错[FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask]
- 一次hive reduce oom 处理:Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTas
- hive运行错误Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask
- hive Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException
- 跑hive有时成功有时失败!org.apache.hadoop.hive.ql.exec.mr.MapRedTask
- 每次输入都会附带着删除后一格内容
- 【Python+OpenCV】目标跟踪-实现基本的运动检测
- HBuilder开发App教程
- 移动端webview canvas bug
- golang简单实现一个基于TLS/SSL的 TCP服务器和客户端
- Hive jdbc执行seelct 语句时报 return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
- 传统构造函数存在的问题以及解决方法(原型)
- 【数据结构】C语言实现顺序表(动态顺序表)
- MockNet -- Android网络接口开发与测试神器
- COM总结
- Adblock:简单强大的广告过滤沙盒
- centos7 安装apache Benchmark
- 34. Search for a Range
- HttpClient使用详解