Question
Infosys Limited
IN
Last activity: 31 Jan 2017 17:37 EST
How to establish connection with Hive jdbc driver
Hi,
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 |
| Fail |
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
Cognizant Technology Solutions
IN
We are using Pega 7.2 and would like to connect to hive database.
What would be the necessary jar that needs to be placed in the application server to be able to connect?
Pegasystems Inc.
IN
Hello Samant,
Please go through below article
Thanks,
Arun
Pegasystems Inc.
US
See this article:
Did you restart tomcat after adding the jar to the lib directory? You could also consider importing the jar into the Customer codeset (or another codeset that you define).