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, ensure that Microsoft SQL Server database is deployed and available in your environment.

    [Important]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:

      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.)


loading table of contents...