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]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 supported databases for HDP.

 

Table 5.1. Supported HDP Databases

Operating SystemComponentDatabaseDatabaseDatabaseDatabaseOther
  PostgreSQL 8.xPostgreSQL 9.xMySQL 5.xOracle 11gr2 
RHEL/Centos/Oracle Linux 5.x, RHEL/CentOS/Oracle Linux 6.x, SLES 11, Ubuntu 12Hive / HCatalogSupported. 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.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.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.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. 
OozieSupported. 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.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.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.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.Derby (default)
HueSupported. 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.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.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.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.SQLite (default)
RangerDefault. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Installing HDP Manually.Supported. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Installing HDP Manually.Supported. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Installing HDP Manually.Supported. For instructions on how to configure this database for Ranger, see "Installing Ranger" in Installing HDP Manually.