2.4. (Optional) MS SQL Server for Hive and Oozie Database Instances

By default, Hive and Oozie use an embedded Derby database for its metastore. However you can also use Microsoft SQL server.

	Note
	For details on installing and configuring Microsoft SQL Server, see TechNet instructions, such as SQL Server 2012

To use an external database for Hive and Oozie metastores, ensure that Microsoft SQL Server database is deployed and available in your environment and that your database administrator creates the following databases and users. You need the following details while configuring the HDP Installer:

For Hive, a SQL database instance:
1. Create Hive database instance in SQL, and record the name such as hive_dbname.
2. Create Hive user on SQL and add them to the sysadmin role within SQL, and record the name and password such as hive_dbuser/hive_dbpasswd.
3. Set the security policy for SQL to use both SQL and Windows authentication, the default setting is Windows authentication only.
For Oozie, a SQL database instance:
1. Create an Oozie database instance and record the name, such as oozie_dbname.
2. Create Oozie user on SQL and add them to the sysadmin role within SQL and record the user name and password, such as oozie_dbuser/oozie_dbpasswd.
3. Set the security policy for SQL to use both SQL and Windows authentication, the default setting is Windows authentication only.

	Important
	Before using SQL server for Hive or Oozie metastores, you must set up Microsoft SQL Server JDBC Driver after installing the components using the instructions provided here.

Legal notices