Installation and Setup Instructions - Professional NoSQL - page 337

4.

Create hive.metastore.warehouse.dir directory (default value: / user/hive/warehouse )
on HDFS:

$HADOOP_HOME/bin/hadoop fs -mkdir /user/hive/warehouse

5. Give write permission on HDFS /user/hive/warehouse directory to the group:

$HADOOP_HOME/bin/hadoop fs -chmod g+w /user/hive/warehouse

Overlaying Hadoop Confi guration
Hive confi guration lays on top of the Hadoop confi guration. The default Hive confi guration is
included in the conf/hive-default.xml fi le in the Hive distribution. You can override the default
Hive confi guration by redefi ning confi guration variables and their values in conf/hive-site.xml .
You can also change the Hive confi guration directory by pointing the HIVE_CONF_DIR variable to
the new confi guration directly. In addition to redefi ning variables in conf/hive-site.xml , you can
also redefi ne the confi guration variables using any of the following:

Hive Command Line Interface (CLI) SET command — For example, hive > SET mapred
.job.tracker=hostName.organizationName.com:50030 ; sets the MapReduce cluster to
the one specifi ed.
hiveconf confi guration variable and value pair — Pass the hiveconfig variable and value
pair to the hive executable.
For example, bin/hive -mapred.job.tracker=hostName.organizationName.com:50030
sets the MapReduce cluster exactly the same way as the earlier SET command does. Multiple
hiveconf variable and value pairs can be passed to the hive executable. Sometimes passing
a number of confi guration parameters can be a little diffi cult to maintain. In such cases,
concatenate all confi guration variable and value pairs and set it as the value of the
HIVE_OPTS environment variable.
To verify the Hive installation and setup, run $HIVE_HOME/bin/hive .

➤

➤

INSTALLING AND SETTING UP HYPERTABLE

The easiest way to install Hypertable is to use the binary downloads. Hypertable binaries are
compliant with all systems built with glibc 2.4+. If your system is built with a version of glibc older
than 2.4, compile and package Hypertable manually using the instructions at http://code.google
.com/p/hypertable/wiki/HowToPackage .

Hypertable offers binaries for both 64-bit and 32-bit platforms. Packages are available in
.rpm , .deb , and .dmg formats. A binary distribution is also available in .tar.bz2 format. To
try to be package-agnostic, I usually choose the .tar.bz2 format.

Follow these steps to install the Hypertable 64-bit .tar.bz2 platform:

1.

Download the latest release distribution from www.hypertable.com/download/ . The latest
release distribution version is 0.9.5.0.pre5.