community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Configuring Impala connection to use Windows Kerberos

Alteryx
Alteryx
Created on

 

Alteryx has the ability to connect with MIT Kerberos based Impala implementations. With this feature, came the need to tell the Simba Impala driver that you are using Windows Kerberos and not MIT's version. The typical sign that you need to enable this option is this error: 

 

[Simba][ImpalaODBC] (100) Error from the Impala Thrift API: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure.  Minor code may provide more information.

 

SSPI.png 

 

Make sure you have the latest Simba Impala driver for the next steps. To enable the Windows Kerberos in the driver:

  • Open the ODBC Administrator

 ODBC Admin.png

 

  • Select the User or System Impala DSN that you have configured and press Configure

 DSN.png

 

  • Once in the Simba Impala ODBC Driver DSN Setup window, press on Advanced Options

DSN_Setup.png 

 

  • Under Advanced Options, check the Enable for this DSN for the Use Only SSPI

    Advanced_Options.png

 

  • Press OK on all the windows, start Alteryx and test your connection.

 

If you still can’t get the connection to work, please don't hesitate to reach out to Support by opening a ticket in the Case Portal

Comments
Meteor

Hi

Got the below error for HIVE using SIMBA HIVE ODBC driver. I have enabled the SSPI and ODBC test has succeeded but Designer failed. Any config need to be further tuned. 

KerbError.PNG