Question4Replies600Views×Close popoverEva Ramya Priya Konedana (EVAKONEDANA) Infosys Limited Infosys Limited IN View Profile EVAKONEDANA Member since 2012 2 posts Infosys Limited Posted: March 21, 2016Last activity: January 31, 2017Posted: 21 Mar 2016 7:29 EDTLast activity: 31 Jan 2017 17:37 EST Closed How to establish connection with Hive jdbc driverHi,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 errorStatus 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 Data Integration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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. Posted: 4 years agoPosted: 24 Mar 2016 16:38 EDT×Close popoverKumar (VipinKumar38163630) View ProfileVipinKumar38163630 replied to EVAKONEDANASee this - https://pdn.pega.com/support-articles/unable-connect-hadoop-database-cluster-0 Posted: 3 years agoPosted: 31 Jan 2017 17:10 EST×Close popoverSagar Samant Sinhar (SAMANTSS) Cognizant Technology Solutions Architect Cognizant Technology Solutions IN View ProfileSAMANTSS Cognizant Technology Solutions replied to VipinKumar38163630We 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? Posted: 3 years agoPosted: 31 Jan 2017 17:37 EST×Close popoverArun Kumar Mahanty (Arun_Mahanty) PEGA Principal Technical Solutions Engineer Pegasystems Inc. IN View ProfileArun_Mahanty PEGA replied to SAMANTSSHello Samant, Please go through below article https://pdn.pega.com/jar-file-dependencies-hbase-and-hdfs-data-sets Thanks, Arun Posted: 4 years agoPosted: 24 Mar 2016 16:41 EDT×Close popoverCeleste Dufresne (CelesteDufresne_GCS) PEGA Principal Software Solutions Engineer Pegasystems Inc. US View ProfileCelesteDufresne_GCS PEGA replied to EVAKONEDANASee this article:https://pdn.pega.com/troubleshooting-no-suitable-driver-found%E2%80%A6-error-when-testing-connectivity-external-databaseDid 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).