Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Unable to use beenline under security cluster

avatar
Super Collaborator

In the sandbox, I enable the kerborse and want to login beeline using command

!connect jdbc:hive2://localhost:10000

But got the error

Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: Peer indicated failure: Unsupported mechanism type PLAIN (state=08S01,code=0)

And here's the log in hiveserver2.log

2016-03-15 07:52:31,067 ERROR [HiveServer2-Handler-Pool: Thread-45]: server.TThreadPoolServer (TThreadPoolServer.java:run(296)) - Error occurred during processing of message.
java.lang.RuntimeException: org.apache.thrift.transport.TTransportException: Unsupported mechanism type PLAIN
        at org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:219)
        at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingTransportFactory$1.run(HadoopThriftAuthBridge.java:739)
        at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingTransportFactory$1.run(HadoopThriftAuthBridge.java:736)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:356)
        at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1637)
        at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingTransportFactory.getTransport(HadoopThriftAuthBridge.java:736)
1 ACCEPTED SOLUTION

avatar

If you have enabled kerberos your connection string should look as follows:

!connect jdbc:hive2://<hiveserver host>:<port>/default;principal=hive/_HOST@<REALM>

View solution in original post

2 REPLIES 2

avatar

If you have enabled kerberos your connection string should look as follows:

!connect jdbc:hive2://<hiveserver host>:<port>/default;principal=hive/_HOST@<REALM>

avatar
Super Collaborator

Thanks, it works.