Shulou(Shulou.com)06/02 Report--

This article focuses on "how to use Knox proxy connection to open Kerberos certified Impala", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let the editor take you to learn "how to use Knox proxy connection to open Kerberos certified Impala"!

Install the ODBC driver

Go to the Cloudera website and log in

Under ODBC and JDBC Drivers (ODBC and JDBC drivers), select the ODBC driver for hive or Impala that is suitable for the system environment to download. Note that it is not JDBC.

Do not download Cloudera Impala ODBC driver v2.5.28, which is not compatible with tableau

Connect via Knox

Although when using Tableau Desktop, you can use the impala after connecting to the kerberos by installing the mit kerberos client. However, in some cases, it is not possible to connect to Impala in this way, such as

1. Users do not want to install kerberos client or use kerberos authentication

two。 The worksheet and data source need to be pushed to the Tableau Server. In this case, although you can configure the kerberos agent on the Tableau Server to connect to the impala after kerberos, the process is complicated.

The following describes a way to connect through the knox proxy, which is convenient to configure and does not need to install other software on the client side, only need to install knox, and knox is included in CDP.

Suppose we have already installed knox

Knox is authenticated by PAM. If you configure SSSD of LDAP or install FreeIPA, you don't need to do any additional configuration. You can log in directly and find the agent API of Impala after login. Make a note of the URL here, which will be used in the following configuration

Open the windows computer with Tableau Desktop installed, first confirm that the ODBC driver for Impala is installed, and open the ODBC data source manager (64-bit).

Select add

Select Impala

Click the picture below to fill in.

Hosts is the machine on which knox Gateway resides.

Port is 8443 by default for Knox

Random selection of database

UserName and PassWord are usernames and passwords for login to knox, that is, usernames and passwords for local PAM authentication.

Transport Mode Select HTTP

Click SSL Options, and check enable SSL to allow self-signature and host name mismatch.

Click HTTP Options,HTTP PATH to fill in the address gateway/cdp-proxy-api/impala/ obtained in knox

Click Test to confirm that the configuration is correct

Open Tableau Desktop, select another database (ODBC), and select the appropriate configured DSN

Click on the connection and you can see that the connection has been successful. Here, only Impala can be selected for the database, and the schema is the real database.

At this point, I believe you have a deeper understanding of "how to use Knox proxy connection to open Kerberos authentication Impala". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.