Configuring the Impala-based Cloudera data sources using Kerberos

Procedure

  1. In the ODBC Data Source Administrator, click the Drivers tab and verify that the Cloudera ODBC Driver for Impala appears in the list of ODBC drivers that are installed on your system.
  2. In the Create New Data Source dialog box, select Cloudera ODBC Driver for Impala and then click Finish.
  3. Use the options in the Cloudera ODBC Driver for Impala DSN Setup dialog box to configure your DSN:
    1. In the Data Source Name field, type a name for your DSN.
    2. Optionally, in the Description field, type relevant details related to the DSN.
    3. In the Host field, type the IP address or hostname.
    4. In the Port field, type the listening port for the Impala service. Note: The default port number for the Impala service is 21050.
    5. In the Database field, type the name of the database schema to use.

What to do next

In the Authentication area, configure authentication as Kerberos:
  1. Realm: Type the Kerberos realm of the Impala server host in the Realm field.
  2. In the Host FQDN field, type the fully qualified domain name of the Impala host.
  3. In the Service Name field, type the service name of the Impala server. For example, if the principle for the Impala server is impala/fully.qualified.domain.name@yourrealm.com, then the value in the service name field is impala. If you are unsure of the correct service name to use for your particular Hadoop deployment, contact your Hadoop administrator
Note: Test the connection to make sure Connection is working fine with Kerberos enabled.