This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 03-22-201602:38 PM - edited on 04-22-201901:53 PM by SydneyF
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.
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
Select the User or System Impala DSN that you have configured and press Configure
Once in the Simba Impala ODBC Driver DSN Setup window, press on Advanced Options
Under Advanced Options, check the Enable for this DSN for the Use Only SSPI
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.