db:hive:uri

is the corresponding HTTP endpoint. Default value is cliservice or /. See conf hive.server2.thrift.http.path

transportMode : Hive - Transport Mode. Default port for HTTP transport mode is 10001. See conf hive.server2.thrift.http.port

Embedded

In the embedded mode, the client runs an embedded Hive (similar to Hive CLI)

jdbc:hive2:///;initFile=<file> (no host or port).

If the Hadoop cluster uses SSL or TLS authentication, you must add ssl=true to the JDBC connectionURI.

jdbc:hive2://<hostname>:<port>/<db>;ssl=true

Example

Azure

Zookeeper Quorum

Zookeeper Quorum

jdbc:hive2://zk0-hi-clu.3qy32mhqlj1ubaea5iyw5joamf.ax.internal.cloudapp.net:2181,zk1-hi-clu.3qy32mhqlj1ubaea5iyw5joamf.ax.internal.cloudapp.net:2181,zk6-hi-clu.3qy32mhqlj1ubaea5iyw5joamf.ax.internal.cloudapp.net:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2

Headnode

Headnode (Example Azure with default database)

jdbc:hive2://headnode:10001/default/;transportMode=http;httpPath=/hive2

Support

Invalid status 72 (state=08S01,code=0)

beeline> !connect jdbc:hive2://localhost:10001/default; user pwd
Connecting to jdbc:hive2://localhost:10001/default;
18/05/28 10:38:09 [main]: WARN jdbc.HiveConnection: Failed to connect to localhost:10001
Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10001/default;: Invalid status 72 (state=08S01,code=0)

Error 72 is a bad url issueTry to add the transport mode, it 's mandatory if you are in http transport mode

jdbc:hive2://headnode:10001/default/;transportMode=http;httpPath=/hive2

Documentation / Reference