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