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 1.1. Supported HDP Databases
| Operating System | Component | Database | Database | Database | Database | Other |
|---|---|---|---|---|---|---|
| PostgreSQL 8.x | PostgreSQL 9.x | MySQL 5.x | Oracle 11gr2 | |||
| RHEL/Centos/Oracle Linux 5.x RHEL/CentOS/Oracle Linux 6.x SLES 11 Ubuntu 12 | 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference 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 Installing HDP Manually or Ambari Reference Guide | SQLite (default) | |
| Ambari | Default. For more information, refer to the "Preparing to Install an HDP Cluster->Meet Minimum System Requirements->Database Requirements" section in the Ambari Reference Guide | Supported. For more information, refer to the "Using Non-Default Databases -Ambari->Using Ambari with PostgreSQL" section in the Ambari Reference Guide | Supported. For more information, refer to the "Using Non-Default Databases -Ambari->Using Ambari with MySQL" section in the Ambari Reference Guide | Supported. For more information, refer to the "Using Non-Default Databases -Ambari->Using Ambari with Oracle" section in the Ambari Reference Guide |