...

This page describes the different clients supported by Hive. The command line client currently only supports an embedded server. The JDBC and thrift-java clients support both embedded and standalone servers. Clients in other languages only support standalone servers. For details about the standalone server see HiveServer Hive Server.

Command line

Operates in embedded mode only, i.e., it needs to have access to the hive libraries. For more details see GettingStarted Getting Started.

JDBC

For embedded mode, uri is just "jdbc:hive://". For standalone server, uri is "jdbc:hive://host:port/dbname" where host and port are determined by where the hive server is run. For example, "jdbc:hive://localhost:10000/default". Currently, the only dbname supported is "default".

...

Operates only on a standalone server. See HiveODBC Hive ODBC.

Thrift C++ Client

Operates only on a standalone server. In the works.