question Re: HDP 3.1 hive setup in Support Questions

HDP 3.1 hive setup

irfangk1 — Wed, 25 Sep 2019 07:10:45 GMT

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.

Re: HDP 3.1 hive setup

Shelton — Wed, 25 Sep 2019 18:41:13 GMT

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

Re: HDP 3.1 hive setup

irfangk1 — Mon, 30 Sep 2019 04:09:13 GMT

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.