...

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

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. The Hive ODBC client provides a set of C-compatible library functions to interact with Hive Server in a pattern similar to those dictated by the ODBC specification. See Hive ODBC Driver.

Thrift C++ Client

Operates only on a standalone server. In the works.