Created 08-14-2017 10:06 AM
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?
Created 08-14-2017 10:23 AM
Created 08-14-2017 10:29 AM
That link contains an incorrect URI, which has changed, and it isn't able to me to fix that error.
Created 08-14-2017 11:15 AM
Created 08-14-2017 11:35 AM
I'm getting the same error. I have followed the steps for W8 (because of the similarity between 8 and 10), but it still keeps failing.
Created 08-14-2017 12:05 PM
Do you have select privilege on the tables,this is related to the permission issue.
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.
Created 08-14-2017 12:49 PM
Created 08-14-2017 12:54 PM
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).
Created 08-14-2017 01:07 PM
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.
Created 08-16-2017 07:05 AM
I'm using Virtual Box, and I installed it in the default path established when installing. I don't know what do I have to look for in the host file
Created 08-16-2017 07:20 AM
Created on 08-16-2017 07:27 AM - edited 08-17-2019 08:06 PM
I'm not completely sure If you asked me for this. I hope so.
Created 08-16-2017 09:49 AM
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