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.
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.
Ambari requires a database to use as a metadata store and uses Postgres 8.x. This is the only database supported in this version.