1.4.2. Create Database Users for the Hive Metastore and/or the Oozie Metastore

Use one of the following options to create database users:

  • Option I: Allow HDP to create database users

    1. Ensure that you have root privileges to the database instance.

    2. Ensure that you deploy either a MySQL or an Oracle client on the master install machine.

    3. On the master install machine, edit the master-install-machine/gsInstaller/gsInstaller.properties file and provide values for the following properties:

      Table 1.1. Properties to create database users
      Property Name Notes
      dbsysuser Database system user credentials for Oracle instance. Required if value of dbflavor property is set to oracle.
      dbsyspasswd
      hive_dbuser Database user credentials for Hive Metastore. Required if installing Hive.
      hive_dbpasswd
      oozie_dbname Database name for Oozie Metastore. Required if installing Oozie and if oozie_use_external_db property is set to yes. See Reference - Configuration Properties (oozie_use_external_db).
      oozie_dbuser Database user credentials for Oozie Metastore. Required if installing Oozie and if oozie_use_external_db property is set to yes.
      oozie_dbpasswd
    4. On the master install machine, execute the setupDatabaseUsers auxiliary script file.

      sh master-install-machine/gsInstaller/setupDataBaseUsers.sh

  • Option II: Manually create database users

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

      • For Hive:

        1. hive_dbname

        2. hive_dbuser

        3. hive_dbpasswd

      • For Oozie:

        1. oozie_dbname

        2. oozie_dbuser

        3. oozie_dbpasswd

    2. On the master install machine, edit the master-install-machine/gsInstaller/gsInstaller.properties file and provide values for the Hive and/or Oozie users (as listed in the table above).


loading table of contents...