[大数据]Error: Could not open client transport with JDBC Uri: jdbc:hive2: |解决连接beenline连接HiveServer2报错

目录

一、错误现象

二、?解决方案

三、其他解决方式

背景：ranger 整合cdh后登陆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://hadoop105:10000/test -n test?

成功登陆

三、其他解决方式

在?hadoop?文件?core-site.xml?中配置信息如下，重启Hadoop，再次启动?hiveserver2?和?beeline?即可

把下面的root替换成自己的用户名

?? ?<property>
?? ??? ?<name>hadoop.proxyuser.root.hosts</name>
?? ??? ?<value>*</value>
?? ?</property>
?? ?<property>
?? ??? ?<name>hadoop.proxyuser.root.groups</name>
?? ??? ?<value>*</value>
?? ?</property>