Skip to main content
  • EN

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)

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


Community Stats

30,159
Posts
114,480
Replies
37,805
Members
Terms & ConditionsCookie settings
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.