1. 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 1.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 or Ambari Reference GuideSupported. 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 GuideSupported. 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 GuideSupported. 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 
 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 or Ambari Reference GuideSupported. 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 GuideSupported. 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 GuideSupported. 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 GuideDerby (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 or Ambari Reference GuideSupported. 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 GuideSupported. 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 GuideSupported. 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 GuideSQLite (default)
 AmbariDefault. For more information, refer to the "Preparing to Install an HDP Cluster->Meet Minimum System Requirements->Database Requirements" section in the Ambari Reference GuideSupported. For more information, refer to the "Using Non-Default Databases -Ambari->Using Ambari with PostgreSQL" section in the Ambari Reference GuideSupported. For more information, refer to the "Using Non-Default Databases -Ambari->Using Ambari with MySQL" section in the Ambari Reference GuideSupported. For more information, refer to the "Using Non-Default Databases -Ambari->Using Ambari with Oracle" section in the Ambari Reference Guide