Skip to main content
GoldDigger
Gold ⭐️
March 30, 2023
Solved

Error while Setting up ODBC

I am getting following error message while trying to set up ODBC. 

I am using SSL connection to connect.

 

[Cloudera] [ImpalaODBC] (100) Error from the Impala Thrift API: authorize: cannot authorize peer

GoldDigger
Gold ⭐️
April 3, 2023

Thanks I was able to resolve the issue. It needed another tick in enable SSL.

4 replies

VidyaSargur
Community Manager
Community Manager
March 30, 2023

@GoldDigger Welcome to our community! To help you get the best possible answer, I have tagged in our Impala experts @ChethanYM, @Chella @ShankerSharma who may be able to assist you further.

Please feel free to provide any additional information or details about your query, and we hope that you will find a satisfactory solution to your question.

Translate
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.
ChethanYM
Gold ⭐️
Gold ⭐️
March 31, 2023

Hi,

 

What is the authentication mechanism given in driver?

Can you change the Authentication in driver to Kerberos and provide the user kerberos credentials user and give a try?

 

Regards,

Chethan YM

Translate
GoldDigger
Gold ⭐️
March 31, 2023

@ChethanYM  I am using Authentication mechanism as User Name and Password. As per company policy that's only valid mechanism to be use.

Translate
GoldDigger
GoldDiggerAuthorAnswer
Gold ⭐️
April 3, 2023

Thanks I was able to resolve the issue. It needed another tick in enable SSL.

Translate