Reply
New Contributor
Posts: 1
Registered: ‎11-20-2015

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

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

 

 

 

New Contributor
Posts: 7
Registered: ‎07-17-2016

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

I am also getting the same error message at my end.

 

Did your issue got resolved ?

Highlighted
Champion
Posts: 544
Registered: ‎05-16-2016

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

Could you let me know the status of the  hive-metastore ? 

is the connector jar  file accessible to Hive ? 

Are you using the shared metastore for Hive and Impala ? 

 

Thanks

 

New Contributor
Posts: 1
Registered: ‎02-20-2017

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

Can you please help me on this issue even I'm also facing this issue.
New Contributor
Posts: 7
Registered: ‎07-17-2016

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

Sure..Let me know your available time slots.

New Contributor
Posts: 1
Registered: ‎06-26-2017

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

HI,

I am also getting same kind of error messgae not able cretae ODBC DSN.

 

SQLSTATE: HY000[Cloudera][ImpalaODBC] (100) Error from the Impala Thrift API: connect() failed: errno = 10060

 

 

Thanks

Sankar

Champion
Posts: 544
Registered: ‎05-16-2016

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

sure why not ? what error are you getting on the console or hive logs

Announcements