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

Alteryx Knowledge Base

Definitive answers from Designer experts.

Configuring Impala connection to use Windows Kerberos

Alteryx
Alteryx

Starting in 10.1, Alteryx added 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 email support@alteryx.com and one of us will reach out to you.

 

Fadi Bassil,

Client Services, UK. 

Comments
Meteoroid

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