I have followed the steps on the Installing and configuring the Hortonworks ODBC driver on Windows 7 guide, but using Windows 10.
After setting the parameters to the values specified in the PDF, I try to test the configuration and I get the following error:
FAILED! [Hortonworks][Hardy] (34) Error from server: connect() failed: errno = 10060.
I don´t know the reason why I am getting this message, could it be an effect of the company proxy?
To connect ensure that:
- The correct drivers are installed. - The appropriate port is selected. - The correct Hive Server (HiveServer or HiveServer2) is selected. - Restart the Hortonworks Hadoop Hive server. - Add exceptions to firewall and anti-virus software for communication to Hive server.
I think it will be a problem with the proxy, because the parameters are well-setted, and Hive is up and working. If this is not the cause, maybe the version of the sandbox can be the reason (I have the latest one).
whats does your host entry file look like on the host machine? This is not the sandbox. It is where you installed virtualbox/vmware
If you are using *nix system or Mac OS X it is simply
You might need Bridge or internal network or NAT to work.
Just tried out the hive odbc problem on my LAN laptop running windows 10.
No firewall between my laptop and the hadoop cluster and the entries of all the cluster nodes in my local windows host file and it was succesful