JDBC to HiveServer2 connection in HTTPS mode with SSL enabled

Question

Hi. I am trying to connect to HiveServer2 using HTTPS mode and also SSL enabled. For HTTPS mode, I had used the below connection URL:

jdbc:hive2://<host>:<port>/<db>?hive.server2.transport.mode=http;hive.server2.thrift.http.path=<http_endpoint>

and for SSL I had used:

jdbc:hive2://<host>:<port>/<db>?hive.server2.transport.mode=http;hive.server2.thrift.http.path=<http_endpoint>

How to use both of this in a single connection URL?

Answer 1

To connect to HiveServer2 in HTTPS mode with SSL enabled, you have to use the below URL format:

jdbc:hive2://<host>:<port>/<db>;ssl=true;sslTrustStore=<trust_store_path>;trustStorePassword=<trust_store_password>?hive.server2.transport.mode=http;hive.server2.thrift.http.path=<http_endpoint>