cdh6.3.2升级hive至3.x后登陆HiveServer2连接失败.doc
需积分: 2 105 浏览量
2024-03-01
10:33:51
上传
评论
收藏 183KB DOC 举报
cdh6.3.2升级hive至3.x后登陆HiveServer2连
接失败
一、错误现象
后台日志
Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop105:10000: Failed to
open new session: java.lang.IllegalArgumentException: Cannot modify
hive.query.redaction.rules at runtime. It
is not in list of params that are allowed to be modified at runtime (state=08S01,code=0)
HiveServer2日志
[HiveServer2-Handler-Pool: Thread-55]: Error opening session:
org.apache.hive.service.cli.HiveSQLException: Failed to open new session:
java.lang.IllegalArgumentException: Cannot modify hive.query.redaction.rules at runtime. It is
not in list of params that are allowed to be modified at runtime
at org.apache.hive.service.cli.session.SessionManager.createSession(SessionManager.java:420)
~[hive-service-2.1.1-cdh6.3.2.jar:2.1.1-cdh6.3.2]
二、 解决方案
修改/opt/cloudera/parcels/CDH/lib/hive/conf/目录下的hive环境变量文件hive-env.sh，注释
export HIVE_OPTS配置（集群所有机器都要修改）
vim /opt/cloudera/parcels/CDH/lib/hive/conf/hive-env.sh
不需要重启
beeline -u jdbc:hive2://master02:10000
资源评论
