1. Install the Hive and HCatalog RPMs

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

    • For RHEL/CentOS:

      yum install hive hcatalog
    • For SLES:

      zypper install hive hcatalog

  2. Optional: Download and add the database connector JAR.

    • For MySQL:

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

        • RHEL/CentOS:

          yum install mysql-connector-java
        • For SLES:

          zypper install mysql-connector-java
      2. Unzip and copy the downloaded JAR file the /usr/lib/hive/lib/ directory on your Hive host machine.

      3. Ensure that the JAR file has appropriate permissions.

    • For Oracle: Note that these instructions are for OJDBC driver for Oracle 11g.

      1. On the Hive metastore host machine, download the Oracle JDBC (OJDBC) driver from here.

      2. Copy the JAR file to $HIVE_HOME/lib/.

        $HIVE_HOME is by default configured to usr/lib/hive.

      3. Ensure that the JAR file has appropriate permissions.

    • For PostgreSQL:

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

        • RHEL/CentOS:

          yum install postgresql-jdbc
        • For SLES:

          zypper install postgresql-jdbc
      2. Execute the following command on the Hive metastore machine:

        ln -sf /usr/share/java/postgresql-jdbc.jar $HIVE_HOME/lib/.

        where $HIVE_HOME is by default configured to usr/lib/hive.

      3. Ensure that the JAR file has appropriate permissions.


loading table of contents...