By default, Hive uses embedded Derby database for its metastore. However, you can choose to enable remote database (either MySQL or Oracle) for Hive metastore.
Use the following instructions to download the appropriate database connector for your cluster:
Ensure that you complete the instructions provided here.
Unzip and copy the downloaded JAR file the
/usr/lib/hive/lib/directory on your Hive host machine.Ensure that the JAR file has appropriate permissions.
