Hive and HCatalog require a database to use as a metadata store and by default uses embedded Derby database. MySQL 5.x, Oracle 11gr2, or PostgreSQL 8.x are supported. You may provide access to an existing database, or you can use Ambari installer to deploy MySQL instance for your environment. For more information, see Supported Database Matrix for Hortonworks Data Platform.
Oozie requires a database to use as a metadata store and by default uses embedded Derby database.
MySQL 5.x, Oracle 11gr2, or PostgreSQL 8.x are also supported. For more information, see Supported Database Matrix for Hortonworks Data Platform.
Ambari requires a database to store information about cluster topology and configuration.
The default database is Postgres 8.x and Oracle 11gr2 is also supported. For more information, see Supported Database Matrix for Hortonworks Data Platform.