DSXchange

Posted: **Mon Dec 04, 2017 2:19 am**

Hi All,

We are trying to use Hive Connector to connect to Hortonworks 2.5/2.6. The Connector fails with the error

main_program: Fatal Error: The connector failed to connect to the data source. The reported error is: java.sql.SQLException: [IBM][Hive JDBC Driver]Cannot establish connection to specified server, using either Hive1 or Hive2 protocol.

The URL provided looks fine.
Contents of the isjdbc.config file:
CLASSPATH=/opt/IBM/InformationServer/ASBNode/lib/java/IShive.jar
CLASS_NAMES=com.ibm.isf.jdbc.hive.HiveDriver

JDBCDriverLogin.conf:

JDBC_DRIVER_01{
com.ibm.security.auth.module.Krb5LoginModule required
credsType=both
principal="dsadm@principlename"
useKeytab="/home/dsadm/.dsadm.keytab";
};

Has anyone come across this error? Any other configuration that needs to be checked?

Posted: **Mon Dec 04, 2017 7:35 am**

Split this out to its own post. However, since this is your first post here, I had to guess at your version number. Please edit your post and update that if 11.x is not correct.

Posted: **Mon Dec 04, 2017 8:16 am**

Sure.
IIS version-11.5.0.1
Hive Driver Version-5.1
Hortonworks: 2.5/Hive2

Posted: **Wed Jun 13, 2018 1:37 am**

Did you manage to solve this problem ?

DSXchange

Hive Connector to Hortonworks error

Hive Connector to Hortonworks error