hive仓库远程链接:Peer indicated failure: Unsupported mechanism type PLAIN (state=08S01,code=0)
来源:互联网 发布:java soa 框架 编辑:程序博客网 时间:2024/05/24 06:32
beeline connect to hiveserver2 kerberos
目的:利用beeline进行远程操作hive仓库
遇到问题:
利用beeline进行访问hive仓库报错
Peer indicated failure: Unsupported mechanism type PLAIN (state=08S01,code=0)
错误原因:
beeline链接语句问题,因为使用kerbrized 认证,所以需要查看hive-site.xml中的配置,进行改写相关操作
<!-- hive server2 -->
<property>
<name>hive.server2.thrift.port</name>
<value>10001</value>
</property>
<property>
<name>hive.server2.authentication</name>
<value>KERBEROS</value>
</property>
<property>
<name>hive.server2.authentication.kerberos.principal</name>
<value>hive/<HiveServer2Host></value><!--例如此处填写:my_hive/test@HADOOP.TEST.COM 则相对应的beeline语句的principal=my_hive/test@HADOOP.TEST.COM -->
</property>
<property>
<name>hive.server2.authentication.kerberos.keytab</name>
<value>/home/user/user.keytab</value>
</property>
最终beeline链接语句:!connect jdbc:hive2://localhost:10001/default;principal=my_hive/test@HADOOP.TEST.COM mysql_user mysql_passwd
- hive仓库远程链接:Peer indicated failure: Unsupported mechanism type PLAIN (state=08S01,code=0)
- beeline连接hive server遭遇MapRedTask (state=08S01,code=1)错误
- hive启动beeline连接报错: User: xxx is not allowed to impersonate anonymous (state=08S01,code=0)
- SQL Error: 0, SQLState: 08S01 和Communications link failure
- Bug收集:{ status code: 200, headers { "Content-Length" = 14; "Content-Type" = "text/plain;char
- RESTful调用报错status code=415 Unsupported Media Type
- Hive错误:Error: FUNCTION 'NUCLEUS_ASCII' already exists. (state=X0Y68,code=30000)
- git -- 链接远程仓库
- Status Code:415 Unsupported Media Type
- Content type 'text/plain;charset=UTF-8' not supported
- Kafka Security Mechanism (SASL/PLAIN)
- git 更改远程仓库链接
- AMQP close-reason, initiated by Peer, code=406
- Mysql 远程链接 Communications link failure
- Magento SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_pack
- [iOS]Error Domain=NSURLErrorDomain Code=-1002 "unsupported URL"
- 发邮件抛异常。no object DCH for MIME type text/plain; charset=UTF-8
- request中获取post的json对象数据content-type=“text/plain”
- 如何把MATLAB编译成C++模块
- httpost请求间隔两秒
- 数据统计sql语句
- Codeforces Round #378 (Div. 2)D. Kostya the Sculptor
- Android使用iText生成pdf文件并读取pdf内容
- hive仓库远程链接:Peer indicated failure: Unsupported mechanism type PLAIN (state=08S01,code=0)
- Python多进程编程
- shinyapps安装部署
- Mysql指定字符集创建数据库
- OBS源码阅读笔记--32位的无法检测摄像头问题
- 文字倒影
- map用法大全
- Jetty实战之 嵌入式Jetty运行Servlet
- C# 数据库操作