Eva Ramya Priya Konedana (EVAKONEDANA)
Infosys Limited

Infosys Limited
EVAKONEDANA Member since 2012 2 posts
Infosys Limited
Posted: March 21, 2016
Last activity: January 31, 2017
Posted: 21 Mar 2016 7:29 EDT
Last activity: 31 Jan 2017 17:37 EST

How to establish connection with Hive jdbc driver


We need to connect to Big Data system using a Hive jdbc driver.

We have configured the driver on the Pega server, added the jar file (hive-jdbc-1.1.0.jar) into the lib directory on Tomcat.

We then created a Data-Admin-DB-Name rule and are attempting to connect. However, we get the following error

Status Value:   Problem encountered when getting a database connection: code: 0 SQLState: 08001 Message: No suitable driver found for jdbc:hive2://XX.XX.XXX.XX:10000?default 

Below is the snap shot of the DB Name rule to connect to Hive jdbc driver.

We also tried to look up the Java class, org.apache.hadoop.hive.jdbc.HiveDriver,  in SMA but that derived a Class not found error.

Please suggest how can we establish connection to the Hive jdbc driver.

We are working with Pega 7.1.7

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.