Created on
08-03-2021
08:32 AM
- last edited on
08-03-2021
02:11 PM
by
ask_bill_brooks
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!
Created on 08-03-2021 05:28 PM - edited 08-03-2021 05:34 PM
@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
Created 08-04-2021 12:28 AM
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