1. Install the Hive and HCatalog RPMs

  1. On all client/gateway nodes (on which Hive programs will be executed), Hive Metastore Server, and HiveServer2 machine, install the Hive RPMs.

    • For RHEL/CentOS/Oracle Linux:

      yum install hive hcatalog
    • For SLES:

      zypper install hive hcatalog
    • For Ubuntu:

      apt-get install hive hcatalog
  2. Optional - Download and add the database connector JAR.

    By default, Hive uses embedded Derby database for its metastore. However, you can optionally choose to enable remote database (MySQL) for Hive metastore.

    1. Execute the following command on the Hive metastore machine.

      yum install mysql-connector-java*

      [For SLES]
      zypper install mysql-connector-java*
      [For UBUNTU]
      apt-get install mysql-connector-java*
    2. After the install, the mysql jar is placed in '/usr/share/java/'. Copy the downloaded JAR file to the /usr/lib/hive/lib/ directory on your Hive host machine.

    3. Verify that the JAR file has appropriate permissions.

loading table of contents...