Apache Impala connection

Last updated: Aug 14, 2025

To access your data in Apache Impala, create a connection asset for it.

Apache Impala provides high-performance, low-latency SQL queries on data that is stored in popular Apache Hadoop file formats.

Supported versions

Apache Impala 4.0.

Create a connection to Apache Impala

To create the connection asset, you need these connection details:

Database (optional): If you do not enter a database name, you must enter the catalog name, schema name, and the table name in the properties for SQL queries.
Hostname or IP address
Port number
Username and password
SSL certificate (if required by the database server)

Authentication method

Select the security mechanism to use to authenticate the user:

Username and password or Kerberos credentials
Available Kerberos selections depend on whether you select Personal or Shared credentials.
LDAP
Use an LDAP security mechanism for external authentication.

Note:
SPSS Modeler supports only the Username and password authentication method.

For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.