HDP 3.1 hive setup

[#1]

 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 solution]

@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

HTH

Happy hadooping

[#3 · Accepted solution]

@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

HTH

Happy hadooping

[#4 · Accepted solution]

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.