jdbc连接hive的问题

来源：互联网发布：js 格式化数字前补零编辑：程序博客网时间：2024/04/18 18:32

利用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_driver:org.apache.hive.jdbc.HiveDriver

hive_url:jdbc:hive2://cloud000:10000/default

get connection sessucess

获取hive连接成功！

Heart beat

执行insert成功！

或者在con = DriverManager.getConnection(url, user, password);中的user传进可以操作hive的用户名即可

阅读全文

0 0