07-29-2015 05:12 AM
I am trying to connect to cdh5 hosted on Amazon ec2 private cloud using Tableau for desktop, but getting the following list of errors: Unable to connect to the ODBC Data Source. Check that the necessary drivers are installed and that the connection properties are valid. [Cloudera][HiveODBC] (22) Error from server: Could not resolve host for client socket. Unable to connect to the server "ip of private cloud". Check that the server is running and that you have access privileges to the requested database.
Access to database on cloud is granted ...
ODBC drivers for impala and hive too are installed
08-20-2015 01:02 PM
It could be a network or firewall issue. Can you ping or ssh to the servers? Do you have to be on a VPN to connec to them?