HiveServer2 connection URL for remote mode

Question

Hi. What is the connection URL for remote HiveServer2? And what is the port I should use?

Answer 1

For a remote server, the URL format is 

jdbc:hive2://<host>:<port>/<db>. 

The default HiveServer2 port is 10000).

For an embedded server, the URL format is 

jdbc:hive2:// 

There is no need of mentioning any host or port.