[This topic is migrated from our old forums. The original author name has been removed]
Has anyone successfully connected to Hive within DBVis? I have loaded all of the jars. Used the appropriate driver class. Constructed the JDBC url. I get connection refused...
No credentials are setup
Checked services are running
I'm at a loss.. ideas?
We got a question about Hive earlier. Please have a look and see if the answer helps you:
It seems like you have already found and installed the driver, so maybe not. Connection refused typically means a problem at the network level, such as specifying the wrong port or IP, firewalls, etc. so I suggest you double-check those areas. I have no experience with Hive, but make sure it binds to the same network interface IP as you use when you try to connect, as opposed to localhost.
over 10 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Successfully connected to Hive?
My personal experience with "connection refused" error and Hive is that given url is incorrect. Personally I prefer to setup a ssh tunneling from my own computer to server running Hive. Suppose this tunnel is set-up at port 10003 localhost then at Dbvisualizer you use following url (change default schema if needed): jdbc:hive://localhost:10003/default