To use external database for Hive or Oozie metastore, have a MySQL, Oracle, or PostgreSQL database deployed and available. By default, Hive and Oozie use Derby database for its metastore. To use an external database for Hive and Oozie metastore, ensure that a MySQL database is deployed and available.
Ensure that your database administrator creates the following databases and users.
• For Hive, ensure that your database administrator creates hive_dbname, hive_dbuser, and hive_dbpasswd.
• For Oozie, ensure that your database administrator creates oozie_dbname, oozie_dbuser, and oozie_dbpasswd.
Instructions to configure an Oracle database:
Run following SQL script against your Hive schema: /usr/lib/hive/scripts/metastore/upgrade/oracle/hive-schema-0.12.0.oracle.sql
You hardly see below scripts inside this folder:
derby mssql mysql oracle postgres
eg, /usr/hdp/2.2.0.0-2041/hive/scripts/metastore/upgrade/oracle/hive-schema-0.13.0.oracle.sql
