Support Questions

Find answers, ask questions, and share your expertise

Connecting Impala to DBeaver

avatar
New Contributor

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 2

avatar

@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

 

 

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.

avatar

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