New hive 0.11.3 charm, also enables hive-server2 .

Hive 0.11.3 is a data warehouse infrastructure built on top of Hadoop that
provides tools to enable easy data summarization, adhoc querying and
analysis of large datasets data stored in Hadoop files. It provides a
mechanism to put structure on this data and it also provides a simple
query language called Hive QL which is based on SQL and which enables
users familiar with SQL to query this data. At the same time, this
language also allows traditional map/reduce programmers to be able to
plug in their custom mappers and reducers to do more sophisticated
analysis which may not be supported by the built-in capabilities of
the language.

Hive provides:

- HiveQL - An SQL dialect language for querying data in a RDBMS fashion
- UDF/UDAF/UDTF (User Defined [Aggregate/Table] Functions) - Allows user to
  create custom Map/Reduce based functions for regular use
- Ability to do joins (inner/outer/semi) between tables
- Support (limited) for sub-queries
- Support for table 'Views'
- Ability to partition data into Hive partitions or buckets to enable faster
  querying
- Hive Web Interface - A web interface to Hive
- Hive Server2 - Supports multi-suer querying using Thrift, JDBC and ODBC clients
- Hive Metastore - Ability to run a separate Metadata storage process
-* Hive cli - A Hive commandline that supports HiveQL