在尝试使用jdbc连接Hive时遇到错误：Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask。问题源于权限不足，用户匿名无法执行写操作。解决方案是使用hdfs命令修改目录权限或在连接时使用有权限的Hive用户名。执行权限修复和正确设置用户后，Hive JDBC连接及插入操作成功。"
81101356,7687174,Qt教程：创建管理员注册界面,"['Qt开发', 'GUI设计', '数据库交互', '编程概念', '对话框']
利用hive jdbc连接hive出现如下问题：
org.apache.hive.jdbc.HiveDriverorg.apache.hive.jdbc.HiveDriverhive_driver:
org.apache.hive.jdbc.HiveDriverhive_url:jdbc:hive2://10.174.242.28:10000/defaultget
connection sessucess获取hive连接成功！
java.sql.SQLException: Error whileprocessing statement: FAILED: Execution Error, return code 1 fromorg.apache.hadoop.hive.ql.exec.mr.MapRedTask
I tried to use the sql execute in hive andit works well. Then I saw the log in/var/log/hive/hadoop-cmf-hive-HIVESERVER2-cloud000.log.out then I found thereason of this error. The following error:
Job Submission failed with exception'org.apache.hadoop.security.AccessControlException(Permission denied:user=anonymous, access=WRITE,inode="/user":hdfs:supergroup:drwxr-xr-x
Solution
sudo -u hdfs hadoop fs -chmod -R 777 /
This solved the error!
hive_dri
最低0.47元/天 解锁文章
4532
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
