Installing the Hive-HCatalog Package
![[Note]](../common/images/admon/note.png) | Note |
|---|---|
It is recommended that you set the soft and hard limits for number of processes that the Hive user can consume in your server
For non-secured clusters: <hive user ID> soft nproc 128 <hive user ID> hard nproc 1024 For secured clusters: <hive user ID> soft nproc 128 <hive user ID> hard nproc 32768 |
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.
![[Important]](../common/images/admon/important.png)
Important If you are using MySQL, you must use
mysql-connector-java-5.1.35.zipor later JDBC driver.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-client/lib/directory on your Hive host machine.Verify that the .jar file has at least the minimum set of permissions required.