Chapter 5. Supported Database Matrix for the Hortonworks Data Platform
This section contains certification information on supported databases for the Hortonworks Data Platform (HDP).
![[Important]](../common/images/admon/important.png) | Important |
|---|---|
It is required that you optimize relational databases that are used with each component for high availability by using the best practices for the database you choose to use. |
The following table identifies the supported databases for HDP.
Table 5.1. Supported HDP Databases
| Operating System | Component | Database | Database | Database | Database | Other |
|---|---|---|---|---|---|---|
| 64-bit versions | PostgreSQL 8.x | PostgreSQL 9.x | MySQL 5.x | Oracle 11g R2, 12c | ||
| RHEL/CentOS/Oracle Linux 6.x, RHEL/CentOS/Oracle Linux 7.x, SLES 11 SP3/SP4, Debian 6 and Ubuntu 12.04 (HDP 2.3 first maintenance release only) | Hive / HCatalog | Supported. For instructions on how to configure this database for the Hive metastore, refer to the "Installing Hive->Configuring Hive for an External Database->Using Hive with PostgreSQL" section in Non-Ambari Cluster Installation Guide. | Supported. For instructions on how to configure this database for the Hive metastore, refer to the "Installing Hive->Configuring Hive for an External Database->Using Hive with PostgreSQL" section in Non-Ambari Cluster Installation Guide. | Supported. For instructions on how to configure this database for the Hive metastore, refer to the "Installing Hive->Configuring Hive for an External Database->Using Hive with MySQL" section in Non-Ambari Cluster Installation Guide. | Supported. For instructions on how to configure this database for the Hive metastore, refer to the "Installing Hive->Configuring Hive for an External Database->Using Hive with Oracle" section in Non-Ambari Cluster Installation Guide. | |
| Oozie | Supported. For instructions on how to configure this database for the Oozie, refer to the "Installing Oozie->Configuring Oozie for an External Database->Using Oozie with PostgreSQL" section in Non-Ambari Cluster Installation Guide. | Supported. For instructions on how to configure this database for Oozie, refer to the "Installing Hive->Configuring Oozie for an External Database->Using Oozie with PostgreSQL" section in Non-Ambari Cluster Installation Guide. | Supported. For instructions on how to configure this database for Oozie, refer to the "Installing Oozie->Configuring Oozie for an External Database->Using Oozie with MySQL" section in Non-Ambari Cluster Installation Guide. | Supported. For instructions on how to configure this database for Oozie, refer to the "Installing Oozie->Configuring Oozie for an External Database->Using Oozie with Oracle" section in Non-Ambari Cluster Installation Guide. | Derby (default) | |
| Hue | Supported. For instructions on how to configure this database for Hue, refer to the "Installing Hue->Configuring Hue for an External Database->Using Hue with PostgreSQL" section in Non-Ambari Cluster Installation Guide. | Supported. For instructions on how to configure this database for the Hue, refer to the "Installing Hue->Configuring Hue for an External Database->Using Hue with PostgreSQL" section in Non-Ambari Cluster Installation Guide. | Supported. For instructions on how to configure this database for the Hue metastore, refer to the "Installing Hue->Configuring Hue for an External Database->Using Hue with MySQL" section in Non-Ambari Cluster Installation Guide. | Supported. For instructions on how to configure this database for the Hue metastore, refer to the "Installing Hue->Configuring Hue for an External Database->Using Hue with Oracle" section in Non-Ambari Cluster Installation Guide. | SQLite (default) | |
| Ranger | Default. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Non-Ambari Cluster Installation Guide, or see Installing Ranger Over Ambari. | Supported. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Non-Ambari Cluster Installation Guide, or see Installing Ranger Over Ambari. | Supported. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Non-Ambari Cluster Installation Guide, or see Installing Ranger Over Ambari. | Supported. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Non-Ambari Cluster Installation Guide, or see Installing Ranger Over Ambari. |