I think the exception thrown must be due to one of the following reasons:
* Incorrect “IP address or Hostname & Port” you are trying to connect to.
* Firewall which is blocking the connection.
* IP address of the server must be down.
* LAN or Network connection error.
I recommend you to check on the above four possible reasons and then try connecting to Hive DB server from VDP Admin tool. If you are still not able to connect, then check if you are able to connect to Hive DB server using third party data visualizer tools like Spark SQL. If you are connected successfully, then you should be connected from VDP admin tool as well.
You can take a look at the following tutorial about how to connect to Hive Data Sources https://community.denodo.com/tutorials/browse/bigdata/1hive
Hope this helps!!