Set up the backend Hive metastore database

CDP Public Cloud supports only PostgreSQL for the backend Hive metastore database, and generally, you do not need to manually perform the installation. In CDP Private Cloud Base you need to install, start, and configure a backend database.

In this procedure, you install a database on a different node/cluster from the HiveServer for sharing the Hive metastore (HMS) with Hive, Impala, Spark, and other componenets. Do not put HiveServer and the database on the same node. You can have one or more HMS instances in your cluster that can take over in the event of a problem.

Install a supported database.

MariaDB/MySQL
PostgreSQL
Oracle