- 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