Successfully connected to Hive?

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... Checked firewalls No credentials are setup Checked services are running I'm at a loss.. ideas?

Hi Adam, We got a question about Hive earlier. Please have a look and see if the answer helps you: http://www.dbvis.com/forum/thread.jspa?messageID=15654㴦 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. Best Regards, Hans

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