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-hcatalogFor SLES:
zypper install hive-hcatalogFor Ubuntu:
apt-get install hive-hcatalog
(Optional) Download and install the database connector .jar file for your Hive metastore database.
By default, Hive uses an embedded Derby database for its metastore. However, Derby is not recommended for production use. Use MySQL, Oracle, SQL Server, or Postgres for production use.
You will need to install the appropriate JDBC connector for your Hive metastore database. Hortonworks recommends using an embedded instance of the Hive Metastore with HiveServer2. An embedded metastore runs in the same process with HiveServer2 rather than as a separate daemon.
For example, if you previously installed MySQL, you would use the following steps to install the MySQL JDBC connector:
Execute the following command on the Hive metastore machine.
For RHEL/CENTOS/ORACLE LINUX:
yum install mysql-connector-java*For SLES:
zypper install mysql-connector-java*For UBUNTU/Debian:
apt-get install mysql-connector-java*
After the install, the MySQL connector .jar file is placed in the /usr/share/java/ directory. Copy the downloaded .jar file to the /usr/hdp/current/hive/lib/ directory on your Hive host machine.
Verify that the .jar file has appropriate permissions.
