Question

Hadoop Data Connection Configuration with Kerberos Support

  • 8 August 2019
  • 2 replies
  • 39 views

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)


2 replies

Badge +10

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

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

Reply