How to connect to HiveServer2 in HTTPS mode

Question

I have set up a HiveServer2 and I am trying to access it using JDBC clients. I want to make the connection using HTTPS mode, what is the connection URL for this?

Answer 1

The connection URL to connect to HiveServer2 from a JDBC client in HTTPS mode is as follows:

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