Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HDP 3.1 hive setup

Solved Go to solution
Highlighted

HDP 3.1 hive setup

Contributor

 if there is postgresql install then also can i install MySQL

2. If i want to add Service Nifi & Spark in existing ambari server then which i have to go first.

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: HDP 3.1 hive setup

Mentor

@irfangk1 

You can definitely use Mysql database alongside postresql any other database for the different HDP components that need back end databases see the screenshots for ranger and ambari DB options but that adds only adds extra administrative complexity to you cluster management like backup and scripts usability

Database scripts.PNG

 

Database2 scripts.PNG

 

HTH

Happy hadooping

Re: HDP 3.1 hive setup

Contributor

Hi Shelton, 

Facing the issue in Hive..

2019-09-27 15:41:46,351 - Retrying after 10 seconds. Reason: Execution of '/usr/jdk64/jdk1.8.0_112/bin/java -cp /usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/hdp/current/hive-server2/lib/postgresql-42.2.8.jar org.apache.ambari.server.DBConnectionVerification 'jdbc:postgresql://inairsr542007v3.ntil.com:5432/hive' hive [PROTECTED] org.postgresql.Driver' returned 1. ERROR: Unable to connect to the DB. Please check DB connection properties.
org.postgresql.util.PSQLException: Connection to inairsr542007v3.ntil.com:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

2 REPLIES 2

Re: HDP 3.1 hive setup

Mentor

@irfangk1 

You can definitely use Mysql database alongside postresql any other database for the different HDP components that need back end databases see the screenshots for ranger and ambari DB options but that adds only adds extra administrative complexity to you cluster management like backup and scripts usability

Database scripts.PNG

 

Database2 scripts.PNG

 

HTH

Happy hadooping

Re: HDP 3.1 hive setup

Contributor

Hi Shelton, 

Facing the issue in Hive..

2019-09-27 15:41:46,351 - Retrying after 10 seconds. Reason: Execution of '/usr/jdk64/jdk1.8.0_112/bin/java -cp /usr/lib/ambari-agent/DBConnectionVerification.jar:/usr/hdp/current/hive-server2/lib/postgresql-42.2.8.jar org.apache.ambari.server.DBConnectionVerification 'jdbc:postgresql://inairsr542007v3.ntil.com:5432/hive' hive [PROTECTED] org.postgresql.Driver' returned 1. ERROR: Unable to connect to the DB. Please check DB connection properties.
org.postgresql.util.PSQLException: Connection to inairsr542007v3.ntil.com:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Don't have an account?
Coming from Hortonworks? Activate your account here