Reference Guide
Also available as:
PDF

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

Table 5.1. Supported HDP Databases

Operating SystemComponentDatabaseDatabaseDatabaseDatabaseOther
64-bit versions PostgreSQL 8.xPostgreSQL 9.xMySQL 5.xOracle 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 / 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 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. 
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 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)
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 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)
RangerDefault. 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.