DocsHortonworks Data Platform Win 1.1.0 (GA)

 

 2.4. Database Requirements

  • By default, Hive and Oozie use an embedded Derby database for its metastore.

    To use an external database for Hive and Oozie metastores, Microsoft SQL Server database must be deployed and available in your environment.

    [Important]Important

    Before using SQL server for Hive metastore, set up Microsoft SQL Server JDBC Driver using the instructions provided here.

  • Ensure that your database administrator creates the following databases and users.

    Note down the database name and user account credentials. You need these details while configuring the HDP Installer.

    • For Hive:

      1. hive_dbname

        [Note]Note

        Create Hive database in SQL.

      2. hive_dbuser

        [Note]Note

        Create Hive users on SQL and add them to the sysadmin role within SQL.

      3. hive_dbpasswd

    • For Oozie:

      1. oozie_dbname

        [Note]Note

        Create Oozie database in SQL.

      2. oozie_dbuser

        [Note]Note

        Create Oozie users on SQL and add them to the sysadmin role within SQL.

      3. oozie_dbpasswd

      [Important]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.)

Legal notices