2.4. (Optional) Microsoft 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. (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 is deployed and available in your environment, and that your database administrator creates the following databases and users. You will need the following information when you configure HDP:

  • For Hive, create a SQL database instance:

    1. Create a Hive database instance in SQL and record its name, such as hive_dbname.

    2. Create Hive user on SQL, add it 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, create a SQL database instance:

    1. Create an Oozie database instance and record its name, such as oozie_dbname.

    2. Create Oozie user on SQL, add it 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.

  • The following steps are required after installing SQL Server; refer to SQL Server documentation for more information:

    1. Ensure that TCP/IP is enabled under SQL Server Network Configuration. This might require restarting SQL Server.

    2. Add firewall exceptions for SQL Server and SQL Browser services.

    3. Before using SQL server for Hive or Oozie metastores, set up the Microsoft SQL Server JDBC Driver. For instructions, see (Optional) Install Microsoft SQL Server JDBC Driver.


loading table of contents...