Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

ODBC via Kerberos doesn't work permanently

avatar
New Contributor

We are trying to connect from several windows severs to a hadoop cluster. Authentication is via Kerberos. On one terminal server we are using the MIT Kerberos ticket manager (a bunch of users), on others not (only one technical user). From time to time connections fail, mostly with the information that the server is not reachable and we shall check if we have permissions to access the database. Sometimes changing one value in the registry and return to old value helps, Sometimes not. Not even a restart. On some server we have scheduled as task recurring every 15 minutes. e.g 5 times it works, 3 times not and then it works again. For secure we have set MaxPacketSize to 1 in order to force using tcp.

In the logs we see mostly this information: java.lang.RuntimeException: [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala: [08S01] : ImpalaThriftAPICallFailed 

There is no loadbalancer is use, we are connecting directly to the nodes. Two nodes are configured as KDC (Linux Kerberos).

 

Every part (Hadoopteam - Kerberosteam) says all is working fine.

 

 

 

4 REPLIES 4

avatar
Expert Contributor

Hi @SchmidtS 

 

Please try increasing session/ query timeout.

avatar
Community Manager

@SchmidtS, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community:

avatar
New Contributor
No, it's still in discussion with the other teams

avatar
Master Collaborator

@SchmidtS 

If In case you are not currently using the latest version of the Impala ODBC driver, please update the driver to the latest version (2.6.16 currently). Please note that 2.6.16 supports CDH6 so there should not be any incompatibility.
You can download the latest version of Impala ODBC driver in the below link:

https://www.cloudera.com/downloads/connectors/impala/odbc/2-6-16.html