Beeswax, the Hive UI


1. Introduction

Beeswax is an application that lives within Cloudera Desktop and helps you use Hive to query your data.

2. Installation

2.1. Via packages

First you must have configured your package manager with the appropriate repository; you’ve already done this, if you installed Cloudera Desktop using packages. Then, run:

# yum install beeswax

or

# apt-get install beeswax

2.2. Via tarball

Download the tarball.

To install Beeswax, you need to use Desktop build system to install the Beeswax package. Specifically:

## Untar the package
# tar -xf beeswax-basic-0.1.0.tar.gz
## Install it
# export ROOT=/usr/share/cloudera-desktop
# cd beeswax-basic-0.1.0
# make -f $ROOT/desktop/app.mk env-install
## Add necessary tables to the DB
# /usr/share/cloudera-desktop/env/bin/desktop syncdb
## Restart Desktop
## If not using the init scripts, bounce the "supervisor" process.
# /etc/init.d/cloudera-desktop restart

3. Hive Configuration

Beeswax, the Hive interface in Cloudera Desktop, includes Hive 0.5. You do not need an existing Hive installation.

Your Hive data is stored in HDFS, normally under under /user/hive/warehouse (or any path you specify as hive.metastore.warehouse.dir in your hive-site.xml). Please ensure that this location exists, and is writable by the users whom you expect to be creating tables. /tmp (on the local file system) should be world-writable, as Hive makes extensive use of it.

4. Configuration

4.1. No Existing Hive Installation

Please first familiarize yourself with the configuration options in hive-site.xml (see http://wiki.apache.org/hadoop/Hive/AdminManual/Configuration). Having a hive-site.xml is optional but often useful, particularly on setting up a metastore. You may store the hive-site.xml in /etc/cloudera-desktop/conf, or instruct Beeswax to locate it using the hive_conf_dir configuration variable. See /etc/cloudera-desktop/conf/cloudera-desktop-beeswax.ini.

4.2. Existing Hive Installation

In /etc/cloudera-desktop/conf/cloudera-desktop-beeswax.ini, modify hive_conf_dir to point to the directory containing hive-site.xml.