Configuring the Impala-based Cloudera data sources using Kerberos
Procedure
-
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.
-
In the Create New Data Source dialog box, select Cloudera ODBC
Driver for Impala and then click Finish.
-
Use the options in the Cloudera ODBC Driver for Impala DSN Setup dialog
box to configure your DSN:
-
In the Data Source Name field, type a name for your DSN.
-
Optionally, in the Description field, type relevant details related to the
DSN.
-
In the Host field, type the IP address or hostname.
-
In the Port field, type the listening port for the Impala service.
Note: The default port number for the Impala service is 21050.
-
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:
- Realm: Type the Kerberos realm of the Impala server host in the Realm
field.
- In the Host FQDN field, type the fully qualified domain name of the Impala
host.
- 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.
Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.