Ranger错误:Unable to connect to Hive Thrift Server instance..
来源:互联网 发布:女装知茵品牌 编辑:程序博客网 时间:2024/05/18 12:42
org.apache.ranger.plugin.client.HadoopException: Unable to connect to Hive Thrift Server instance..
Unable to connect to Hive Thrift Server instance..
Could not open client transport for any of the Server URI's in ZooKeeper: Could not establish connection to jdbc:hive2://c2bde55:10000/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default}).
Could not establish connection to jdbc:hive2://c2bde55:10000/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default}).
Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default}).
解决办法:
使用hdp2.6.1出现,原因是hive相关jar包不匹配问题
1)备份目录:
# cd /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/
# cp -r hive hive.bak
2)清空,重新拷贝hive jar包和它的依赖包
rm -rf /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive/*
cp -r /usr/hdp/2.6.1.0-129/hive/lib/hive-common*.jar /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive
cp -r /usr/hdp/2.6.1.0-129/hive/lib/hive-jdbc*.jar /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive
cp -r /usr/hdp/2.6.1.0-129/hive/lib/hive-exec*.jar /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive
cp -r /usr/hdp/2.6.1.0-129/hive/lib/hive-metastore*.jar /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive
cp -r /usr/hdp/2.6.1.0-129/hive/lib/hive-service*.jar /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive
cp -r /usr/hdp/2.6.1.0-129/hive/lib/libfb303*.jar /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive
cp -r /usr/hdp/2.6.1.0-129/hive/lib/libthrift*.jar /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive
chmod -R a+x /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive
cp ../hive.bak/ranger-hive-plugin-0.7.0.2.6.1.0-129.jar /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive/
3) 改变拥有者
chown -R ranger:ranger /usr/hdp/2.6.1.0-129/ranger-admin/ews/webapp/WEB-INF/classes/ranger-plugins/hive
4)重启ranger服务,然后测试连接。
注明:此方法通过Ranger授权无效,不建议使用,因为Ranger插件默认使用的是hive2,所以需Ambari中hive组件开启HiveServer2 Interactive
同时修改Ranger中hive服务的jdbc.url *值为:
jdbc:hive2:/ip:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2- Ranger错误:Unable to connect to Hive Thrift Server instance..
- unable to connect to converter enterprise server
- ORA-12549 Unable To Connect To ASM Instance问题
- Unable to connect to specified host. 错误
- 查找网站搬迁错误Unable to connect to your database server using the provided settings
- Unable to connect to database server:specified database is invalid 错误修复方法
- Qt连接Sql server错误ConnectionOpen (Connect()). QODBC3: Unable to connect"
- hive删除表错误:FAILED: SemanticException Unable to fetch table user_info. For direct MetaStore DB connect
- 【Oracle错误】unable to connect 08004 ora12154
- Unable to connect to CUPS server localhost:631 - C
- 解决Error: Unable to connect to BackupPC server
- C028: "Unable to Connect to the Siebel Gateway Name Server
- Unable to connect to the remote server 问题
- nova-compute出错: unable to connect to AMQP server.
- PHP Warning: mssql_connect() Unable to connect to server
- zookeeper Unable to connect to zookeeper server within timeout: 5000
- ZkTimeoutException: Unable to connect to zookeeper server within timeout: 10000
- Unable to connect to zookeeper server within timeout: 5000
- Linux帮助命令
- Java 操作Solr搭建高性能搜索引擎
- Android网络问题
- 利用原生 jquery 制作移动端滑动时间插件
- 常用图像数据集大全
- Ranger错误:Unable to connect to Hive Thrift Server instance..
- mysql增改查的sql语句学习笔记
- [问题记录] spring-boot 打印启动时间
- 第八周项目一
- 你是如何调用 wait()方法的?使用 if 块还是循环?为什么?
- Linux内核模块
- nodejs下载及helloworld!
- VB.NET-VS2010 通过代码关闭计算机的方法
- cmd maven常用打包命令