Hive Connector to Hortonworks error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
AnnDSX
Participant
Posts: 4
Joined: Mon Dec 04, 2017 2:12 am

Hive Connector to Hortonworks error

Post by AnnDSX »

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?
Last edited by AnnDSX on Mon Dec 04, 2017 8:18 am, edited 1 time in total.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:!:

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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
AnnDSX
Participant
Posts: 4
Joined: Mon Dec 04, 2017 2:12 am

Post by AnnDSX »

Sure.
IIS version-11.5.0.1
Hive Driver Version-5.1
Hortonworks: 2.5/Hive2
skathaitrooney
Participant
Posts: 103
Joined: Tue Jan 06, 2015 4:30 am

Post by skathaitrooney »

Did you manage to solve this problem ?
Post Reply