By default, Hive and Oozie use an embedded Derby database for its metastore.
To use an external database for Hive and Oozie metastores, ensure that Microsoft SQL Server database is deployed and available in your environment.
Important Before using SQL server for Hive metastore, ensure that you set up Microsoft SQL Server JDBC Driver using the instructions provided here.
Ensure that your database administrator creates the following databases and users.
It is recommended that you note down the database name and user account credentials. You will need these details while configuring the HDP Installer.
For Hive:
hive_dbname
Note Create Hive database in SQL.
hive_dbuser
Note Create Hive users on SQL and add them to the
sysadmin
role within SQL.hive_dbpasswd
For Oozie:
oozie_dbname
Note Create Oozie database in SQL.
oozie_dbuser
Note Create Oozie users on SQL and add them to the
sysadmin
role within SQL.oozie_dbpasswd
Important Ensure that you set the security policy of Microsoft SQL server to use both SQL and Windows authentication. (By default, the security policy uses Windows authentication.)