Database Reference
In-Depth Information
vice help
to get a list of available service names; some of the most useful ones are de-
scribed in the following list:
cli
The command-line interface to Hive (the shell). This is the default service.
hiveserver2
Runs Hive as a server exposing a Thrift service, enabling access from a range of clients
written in different languages. HiveServer 2 improves on the original HiveServer by
supporting authentication and multiuser concurrency. Applications using the Thrift,
JDBC, and ODBC connectors need to run a Hive server to communicate with Hive. Set
the
hive.server2.thrift.port
configuration property to specify the port the
server will listen on (defaults to 10000).
beeline
A command-line interface to Hive that works in embedded mode (like the regular
CLI), or by connecting to a HiveServer 2 process using JDBC.
hwi
The Hive Web Interface. A simple web interface that can be used as an alternative to
the CLI without having to install any client software. See also
Hue
for a more fully
featured Hadoop web interface that includes applications for running Hive queries and
browsing the Hive metastore.
jar
The Hive equivalent of
hadoop jar
, a convenient way to run Java applications that
includes both Hadoop and Hive classes on the classpath.
metastore
By default, the metastore is run in the same process as the Hive service. Using this ser-
vice, it is possible to run the metastore as a standalone (remote) process. Set the
METASTORE_PORT
environment variable (or use the
-p
command-line option) to
specify the port the server will listen on (defaults to 9083).
Hive clients
If you run Hive as a server (
hive --service hiveserver2
), there are a number of
different mechanisms for connecting to it from applications (the relationship between
Hive clients and Hive services is illustrated in
Figure 17-1
):
