This page contains certification information on supported databases for Hortonworks Data Platform (HDP).
The following table identifies the supported databases for HDP.
Operating System | Component | Database | ||||
PostgreSQL 8.x | PostgreSQL 9.x | MySQL 5.x | Oracle 11gr2 | Other | ||
RHEL/Centos/Oracle Linux 5.x RHEL/CentOS/Oracle Linux 6.x SLES 11 |
Hive / HCatalog | Supported. For instructions on configuring this database for Hive metastore, see Instructions for Manual Install. | Supported. For instructions on configuring this database for Hive metastore, either see Instructions for Manual Install or see Using Hive with PostgreSQL. | Default. For instructions on configuring this database for Hive metastore, either see Instructions for Manual Install or see Using Hive with MySQL. | Default. For instructions on configuring this database for Hive metastore, either see Instructions for Manual Install or see Using Hive with Oracle. | |
Oozie | Supported. For instructions on configuring this database for Oozie metastore, see Instructions for Manual Install. | Supported. For instructions on configuring this database for Oozie metastore, either see Instructions for Manual Install or see Using Oozie with PostgreSQL. | Supported. For instructions on configuring this database for Oozie metastore, either see Instructions for Manual Install or see Using Oozie with MySQL. | Supported. For instructions on configuring this database for Oozie metastore, either see Instructions for Manual Install or see Using Oozie with Oracle. | Derby (default). | |
Hue | Supported. For instructions on configuring this database for Hue, see Instructions for Manual Install. | Supported. For instructions on configuring this database for Hue, see Instructions for Manual Install . | Supported. For instructions on configuring this database for Hue, see Instructions for Manual Install. | Supported. For instructions on configuring this database for Hue, see Instructions for Manual Install. | SQLite (default) | |
Ambari | Default. For more information, see, see Getting Started - Database Requirements. | Supported. For insturctions on configuirng this database for Ambari, see Using Ambari with PostgreSQL. | Supported. For instructions on configuring this database for Ambari metastore, see Using Ambari with MySQL. | Supported. For instructions on configuring this database for Ambari, see Using Ambari with Oracle. |