Beeswax for Hive
================
Beeswax is a UI for querying [Hive](http://wiki.apache.org/hadoop/Hive), a
data warehousing system built on top of Hadoop.
Navigate to different views in the beeswax UI by using the toolbar at the top of the application window.
Running Queries
---------------
The "Query" view lets you enter queries in Hive's Query Language,
[HQL](http://wiki.apache.org/hadoop/Hive/LanguageManual), which
is quite similar to SQL. Queries can be named and saved.
When you submit a query, a server ("the Beeswax Server") uses
Hive to run the queries. You can either wait for the query
to complete, or come back later to find the queries
in the "History" view.
Creating New Tables
-------------------
Though you can create tables by issuing the appropriate
HQL DDL query, it is easier to create a table using
the Table Creation Wizard. You will be asked to name
the table, specify storage parameters (essentially,
how columns and rows are formatted), and specify
the regular and partition columns.
Browsing Tables
---------------
Use the "Tables" tab to see the available tables, preview
their data, and examine their metadata. You can load
more data into the tables from here as well.
History
-------
The History tab presents queries that have been run
previously. Results for these queries are often
available for some time, and then are automatically
expired.
Saved Queries, My Queries
-------------------------
Queries can be saved, and then browsed using
these views. If a query is not yours to edit,
you may "clone" it to edit your own version.
Results View
------------
When viewing the results for a query,
notice the "Log" tab to see logs presented
by Hive. These will help you to debug
your query. The results view will also have
links to any MR jobs started by the query.
Hive Version
------------
Underneath the covers, Beeswax is using a very slightly
modified version of Hive 0.5.0.