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.

    yum 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*

    2. After the yum 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. Ensure that the JAR file has appropriate permissions.


loading table of contents...