Cloudera Impala

Type of Support: Read & Write; In-Database
Validated On: Impala 2.6.0; Simba Impala Driver 1.2.11.1016
Connection Type: ODBC (32- and 64-bit)
Driver Details:

The ODBC driver can be downloaded here. Certified with CDH 5.8.

In-Database processing requires 64-bit database drivers.

Alteryx tools used to connect

Additional Details

If you are using Windows Kerberos authentication (via SSPI), you must select the "Use Only SSPI - Enable for this DSN" option within the Simba Impala ODBC driver Advanced Options.

If you have issues with reading or writing Unicode® characters, access the Simba Impala ODBC driver. Under Advanced Options, select the “Use SQL Unicode Types” option.

Write Support

The Impala ODBC driver supports both the Impala write capability and HDFS connection options via one of the following two methods:

  • For a standard workflow use the Output Data Tool. Select the Hadoop connection option, and then select HDFS Avro or HDFS CSV for the File Format.
  • For an In-Database workflow use the Connect In-DB Tool or the Data Stream In Tool. Establish a Read connection. On the Write tab select HDFS Avro or HDFS (CSV) for the Driver.

Limitations