Connection to HIVE on Cloudera
Hi,
We are trying to connect to HIVE that is on Cloudera Enterprise CDH and we are having troubles.
1.) Are there instructions how connect PEGA with HIVE DB and get simple query result back?
1.) Is there integration component available from PEGA (existing or planned)?
1.) Is it possible to use HIVE JDBC driver ?
2.) How to install JDBC driver in PEGA (steps to configure it)?
Thanks a lot in advance, and appreciate your help.
***Edited by Moderator Marissa to update Platform Capability tags****
Pegasystems Inc.
IN
1)Are there instructions how connect PEGA with HIVE DB and get simple query result back?
Please go through below article
https://community.pega.com/support/support-articles/unable-connect-hadoop-database-cluster
2)Is there integration component available from PEGA (existing or planned)?
If you are speaking about how to integrate a external hive database in pega , yes you can do it through external database mapping .
Designer StudioàData ModelàClasses & PropertiesàDatabase Class MappingsàNew External Database Class Mapping
3) Is it possible to use HIVE JDBC driver ?
You can try placing the driver in lib folder of application server and bounce the server
Check the feasibility from the article in point 1.
4) How to install JDBC driver in PEGA (steps to configure it)?
Refer point 3.
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
Please find the below article which might be helpful.
https://collaborate.pega.com/question/hadoophive-integration-pega
https://collaborate.pega.com/question/how-establish-connection-hive-jdbc-driver