Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Who agreed with this topic

Cloudera Hive and Impala ODBC connection failing Oracle Big Data Lite Virtual Machine

New Contributor

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

 

 

 

Who agreed with this topic