question Re: Connecting Impala to DBeaver in Support Questions

Connecting Impala to DBeaver

NazarK — Tue, 03 Aug 2021 21:11:10 GMT

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!

Re: Connecting Impala to DBeaver

ask_bill_brooks — Wed, 04 Aug 2021 00:34:09 GMT

@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

Re: Connecting Impala to DBeaver

nareshbattula — Wed, 04 Aug 2021 07:28:34 GMT

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.

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