Skip to main content
NazarK
NazarK
Bronze ⭐️⭐️⭐️
August 3, 2021
Question

Connecting Impala to DBeaver

Hi,

 

Can somebody please advise me on how to connect Cloudera impala to Dbeaver and query the impala tables via Dbeaver. 

 

I have tried some online resources, but that is not helping me much. 

 

Thank You!

 

 

2 replies

ask_bill_brooks
Platinum ⭐️
ask_bill_brooks
Platinum ⭐️
August 4, 2021

@NazarK ,

The more detail you provide in your post the better community members can assist with your question. You didn't indicate which online resources you tried which turned out not to be helpful, or what specific issues you encountered when you tried out the steps documented by those resources.

 

What "form factor" and/or version of Cloudera's data platforms and version of impala are you using? 

 

You might try connecting DBeaver to Impala via ODBC using the steps outlined here:

Connect DBeaver SQL Tool to Cloudera Hive/Impala with Kerberos

 

 

Translate
Bill Brooks, Community Moderator 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.
nareshbattula
nareshbattula
Silver ⭐️
August 4, 2021

Hi Nazar,

 

1) Please click on the Edit driver settings in the dbeaver, please fallow my below image and try.

2)And add the ImpalaJDBC drivers

What ever I was masked there, you can use impalaVIP if you have otherwise please Impala Daemon Host.

nareshbattula_0-1628061607518.png

3)In driver properties, please check this property and value

AllowSelfSignedCerts=1

4) Later try with username and password.

 

It will work.

 

Regards,

Naresh.B

 

Translate
Terms & ConditionsAccessibility statement