28787
DISCUSSIONS
102103
MEMBERS
3161
ARTICLES
Created 11-21-2015 12:08 AM
Hi everyone,
We are trying to connect the Cloudera ODBC driver for both Hive and Impala with Oracle Big Data Lite VM (which has the CDH 5 stack within it along with oracle's products ) but its failing. The VM is hosted in a Linux server and we are installing the ODBC drivers in a windows machine which will act as a client machine. We can access the CDH stack from this windows client machine via HUE and everything (Hive, Mapreduce, Imapla queries etc) works fine. We are configuring and managing manually and not through Cloudera Manager. However when we are trying to test the ODBC driver connection, we get the following errors :-
For Hive ODBC :-
Driver Version: V2.5.12.1005
Running connectivity tests...
Attempting connection
Failed to establish connection
SQLSTATE: HY000[Cloudera][HiveODBC] (34) Error from Hive: connect() failed: errno = 10061.
TESTS COMPLETED WITH ERROR.
For Impala ODBC : -
Driver Version: V2.5.23.1024
Running connectivity tests...
Attempting connection
Failed to establish connection
SQLSTATE: HY000[Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: connect() failed: errno = 10061
TESTS COMPLETED WITH ERROR.
So far we have done the following Trouble shooting :-
1) Checked and confirmed that port 10000 and port 21050 are running.
2) Added IP address of the server to etc/hosts of the client machine so that there are no resolving issues
3) Followed the cloudera guideline for starting and stopping Hive-server2 via beeline commands
Any help is highly appreciated !
Thanks,
Souvik