Skip to main content
Question

Hadoop Data Connection Configuration with Kerberos Support

  • August 8, 2019
  • 2 replies
  • 151 views
M

I am trying to configure a Hadoop data connection in FME Desktop 2018.1. I have installed the JDBC driver supplied by iut IT team so I no longer get a driver error bit I now get the error below.

 

We use Kerberos security but it's not clear to me if this is supported in FME Desktop for this connection type. Is it?

 

I use the same connection parameters as used in Oracle SQLDeveloper, which works there.

The error seems very generic but any help is appreciated.

Error Log:

java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://ourServer.com:10000: Peer indicated failure: Unsupported mechanism type PLAIN

at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:222)

at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)

at COM.safe.fme.jdbc.JdbcCommon.openConnection(JdbcCommon.java:467)

at COM.safe.fme.jdbc.JdbcReader.openHelper(JdbcReader.java:187)

at COM.safe.fme.jdbc.JdbcReader.open(JdbcReader.java:157)

Caused by: org.apache.hive.org.apache.thrift.transport.TTransportException: Peer indicated failure: Unsupported mechanism type PLAIN

at org.apache.hive.org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:199)

at org.apache.hive.org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:307)

at org.apache.hive.org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37)

at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:240)

at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:195)

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

richardatsafe
Safer
Forum|alt.badge.img+10
  • richardatsafeSafer
  • Safer
  • 217 replies
  • August 12, 2019

Hi @mikeherel,

 

At this time we only support Kerberos authentication through the HDFS Connector, which will work through either FME Desktop or FME Server. The Hive Reader and the JDBC Reader do not have this functionality yet.

 

Thanks,

Richard

M
  • msokolocto
  • 1 reply
  • October 29, 2019

Is there a timetable for implementing this? Right now, I have no ability to read from our Cloudera HDFS either using the Hive or JDBC reader

 

java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://<instance>:10000/<database>: Peer indicated failure: Unsupported mechanism type PLAIN

Community Stats

32,068
Posts
121,757
Replies
39,692
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.