You construct a JDBC URL to connect Hive to a BI tool.
In CDP Private Cloud Base, if HiveServer runs within
the Hive client (embedded mode), not as a separate process, the URL in the connection
string does not need a host or port number to make the JDBC connection. If HiveServer does
not run within your Hive client, the URL must include a host and port number because
HiveServer runs as a separate process on the host and port you specify. The JDBC client and
HiveServer interact using remote procedure calls using the Thrift protocol. If HiveServer
is configured in remote mode, the JDBC client and HiveServer can use either HTTP or
TCP-based transport to exchange RPC messages.
-
Create a minimal JDBC connection string for connecting Hive to a BI tool.
- Embedded mode: Create the JDBC connection string for connecting to Hive in
embedded mode.
- Remote mode: Create a JDBC connection string for making an unauthenticated
connection to the Hive default database on the localhost port 10000.
Embedded mode: "jdbc:hive://"
Remote mode: "jdbc:hive://myserver:10000/default", "",
"");
-
Modify the connection string to change the transport mode from TCP (the default) to
HTTP using the
transportMode and
httpPath session configuration
variables.
jdbc:hive2://myserver:10000/default;transportMode=http;httpPath=myendpoint.com;
You need to specify
httpPath when using the HTTP transport mode.
<http_endpoint> has a corresponding HTTP endpoint configured in
hive-site.xml.
-
Add parameters to the connection string for Kerberos authentication.
jdbc:hive2://myserver:10000/default;principal=prin.dom.com@APRINCIPAL.DOM.COM
