[Hive-user] How to setup Hive JDBC client to connect remote Hiveserver

On Sun, Apr 3, 2016 at 9:43 PM, brajmohan saxena wrote:

Hi,

Could you please tell me how to connect a simple JDBC program to remote
Hiveserver2 with default Derby database.

I have Hiveserver2 running on remote machine and i am trying to run simple
JDBC program from client machine (
DriverManager.getConnection("jdbc:hive2://192.168.1.103:10000/default",
"", ""); )

but getting the following error.

Error: Could not open client transport with JDBC Uri: jdbc:hive2://
192.168.1.103:10001: java.net.ConnectException: Connection refused
(state=08S01,code=0)

Do I need to change hive-site.xml file at server side.

Thanks in advance

Regards

Braj