Dbeaver Impala



See good deals, great deals and more on Used Chevrolet Impala. Search from 5774 Used Chevrolet Impala cars for sale, including a 1995 Chevrolet Impala SS, a 1996 Chevrolet Impala SS, and a 2018 Chevrolet Impala Premier w/ 2LZ.

ImpalaWith Cloudera, you can use the Hue web interface to run your SQL queries but sometimes you may find it easier and more convenient to use a SQL editor tool. One of the free SQL editor tool available is DBeaver but it is a bit tricky to setup the connection to Impala using JDBC if your Cloudera cluster is fully secured with TLS and Kerberos. Here is the steps that may help to to get it to connect successfully.
  • Impala SQL provides a high degree of compatibility with the Hive Query Language, and is a subset of SQL-92. The Simba ODBC and JDBC drivers are fully aware of the capabilities of Impala and can take any standard ODBC, JDBC, and SQL queries and ensure full compatibility with Impala.
  • DBeaver is free universal SQL client/database tool for developers and database administrators. It can work with any database server which has JDBC or ODBC driver. It supports pluggable extensions.

1. Download the JDBC drivers

The very first step is of course to download the latest Cloudera JDBC drivers from their website. Extract the downloaded zip file and you will see two other zip files containing the JDBC JAR files - ImpalaJDBC4.jar and ImpalaJDBC41.jar.
For this blog, I am using version 2.6.4 and ImpalaJDBC41.jar driver.

2. TLS Certificate Truststore

If you cluster has TLS enabled, you will need to have the root and intermediate CA certificates in Java keystore format as your truststore.

3. Create a New Connection in DBeaver

Start DBeaver on your laptop and create a new connection:


Navigate to Hadoop and select Cloudera Impala:

Enter the following information as shown in the following screenshot:
  • Host - hostname of the Impala daemon (coordinator), or the load balancer if there is one. The hostname has to be fully qualified (FQDN) for Kerberos to work.
  • Database/Schema - the name of the Impala database to connect to.

Dbeaver Impalas

Next, click on 'Edit Driver Settings'. If this is the first time you are configuring the Impala driver, then you need to add the JDBC driver Jar file to Libraries.

Dbeaver Impala Kerberos

We also need to configure the JDBC connection string to include the Kerberos and TLS properties. Click on 'Connection Properties' and add the properties as shown in the screenshot below:
  • AuthMech - the authentication mechanism to use. Value of 1 indicates Kerberos.
  • KrbHostFQDN - the hostname in FQDN that you are connecting to. This should be the FQDN of the load balancer if you are connecting via the load balancer.
  • KrbRealm - Kerberos realm of the Cloudera cluster.
  • KrbServiceName - the Kerberos service name. In this case it is impala.
  • SSL - 1 if the Cloudera cluster has SSL/TLS enabled.
  • SSLTrustStore - the path to the truststore in Java Keystore format that contains the root CA and any intermediate CA certificates (if any).
  • SSLTrustStorePwd - the truststore password.
If you have gotten the properties right, click on the 'Test Connection' and you should see that DBeaver is connected successfully. Remember that you need to kinit first to get a valid Kerberos ticket.

4. Troubleshooting

If for any reason you are having issues connecting with the JDBC driver, you can add the following properties to enable logging in the driver:

Dbeaver Impala For Sale

  • LogLevel - set the value to 6.
  • LogPath - the path to the directory where the driver will write the logs to.

Dbeaver Impala Ss

A new log files will be created for each connection attempt with the filename Impala_connection_XX.log, where XX is an incrementing number.




Comments are closed.