Installing Hive

For instructions on setting up the MEP repository, see Step 10: Install Ecosystem Components Manually

You can install Hive on a node in the MapR cluster or on a MapR client node. Installation of HiveServer2 on a client node is not supported by MapR. If you wish to install HS2 on a client node, note that one or more required JAR files may not be installed during the installation of mapr-client. Copy the following JAR file from a resource manager node to the MapR client node:

/opt/mapr/hadoop/hadoop-<X.X.X>/share/hadoop/yarn/hadoop-yarn-server-resourcemanager-<X.X.X>-mapr-<YYYY>.jar

Here:

X.X.X	Refers to the version (for example, hadoop-2.7.0)
YYYY	Refers to the release tag of ecosystem component (for example, 1602)

Note: Copying the JAR file may allow you to work with Hive in non-secure mode.

See the Hive Release Notes for a list of fixes and new features.

Hive is distributed as the following packages:

Package	Description
`mapr-hive`	The core Hive package.
`mapr-hiveserver2`	The Hive package that enables HiveServer2 to be managed by the warden, allowing you to start and stop HiveServer2 using maprcli or the MapR Control System. The `mapr-hive` package is a dependency and will be installed if you install `mapr-hiveserver2`. At installation time, Hiveserver2 is started automatically.
`mapr-hivemetastore`	The Hive package that enables the Hive Metastore to be managed by the warden, allowing you to start and stop Hive Metastore using maprcli or the MapR Control System. The `mapr-hive` package is a dependency and will be installed if you install `mapr-hivemetastore`. At installation time, the Hive Metastore is started automatically.
`mapr-hivewebhcat`	The Hive package that enables WebHCat to be managed by the warden, allowing you to start and stop WebHCat using maprcli or the MapR Control System. The `mapr-hive` package is a dependency and will be installed if you install `mapr-hivewebhcat.` At installation time, the WebHCat is started automatically.

Make sure the environment variable JAVA_HOME is set correctly. For example:

# export JAVA_HOME=/usr/lib/jvm/java-7-sun

You can set these system variables by using the shell command line or by updating files such as /etc/profile or ~/.bash_profile. See the Linux documentation for more details about setting system environment variables.

Note: The MapR cluster must be up and running before installing Hive.

On Ubuntu, while configuring the new version of Hive, you could have an issue caused by an incomplete removal of previously installed Hive packages. To avoid this issue, use the purge command for complete removal of all previously installed Hive packages.

Execute the following commands as root or using sudo.

On each planned Hive node, install Hive packages.

To install Hive:

On CentOS / RedHat	`yum install mapr-hive`
On SUSE	`zypper install mapr-hive`
On Ubuntu	`apt-get install mapr-hive`

To install Hive and HiveServer2:

On CentOS / RedHat	`yum install mapr-hive mapr-hiveserver2`
On SUSE	`zypper install mapr-hive mapr-hiveserver2`
On Ubuntu	`apt-get install mapr-hive mapr-hiveserver2`

To install Hive, HiveServer2, and HiveMetastore:

On CentOS / RedHat	`yum install mapr-hive mapr-hiveserver2 mapr-hivemetastore`
On SUSE	`zypper install mapr-hive mapr-hiveserver2 mapr-hivemetastore`
On Ubuntu	`apt-get install mapr-hive mapr-hiveserver2 mapr-hivemetastore`

To install Hive, HiveServer2, HiveMetastore and WebHCat:

On CentOS / RedHat

yum install mapr-hive mapr-hiveserver2 mapr-hivemetastore mapr-hivewebhcat

On SUSE

zypper install mapr-hive mapr-hiveserver2 mapr-hivemetastore mapr-hivewebhcat

On Ubuntu

apt-get install mapr-hive mapr-hiveserver2 mapr-hivemetastore mapr-hivewebhcat

Note: Starting from MEP-5.0.2 and MEP-6.0.1+, you can use Apache Derby as the underlying database (only for test purposes). To configure Hive on Derby DB, install all Hive packages (mapr-hive, mapr-hiveserver2 mapr-hivemetastore, and mapr-hivewebhcat), and run the configure.sh command, as described in Step 3 later in this procedure.

CAUTION: Do not use datanucleus.schema.autoCreateAll for populating underlying databases. For more details, see prohibited usage of datanucleus.schema.autoCreateAll property .

Configure the database for Hive Metastore.
See Configuring Database for Hive Metastore for more information.
Run configure.sh with the -R option.
```
/opt/mapr/server/configure.sh -R
```

After Hive is installed, the executable is located at: /opt/mapr/hive/hive-<version>/bin/hive.

See Hive User Impersonation for the steps to configure user impersonation for Hive and the MapR cluster.

To configure Hive on Tez, see Configuring Hive and Tez.