I would like to use impyla with PyCharm in Windows machine. I act as the following:
1. kinit using MIT kerberos for Windows. confirm that it is the proper principal.
2. set %JAVA_HOME%\jre\bin\security\krb5.ini with proper realm and kdc.
3. pip install impyla
4. start PyCharm python console.
5. run the following script:
from impala.dbapi import connect from impala.util import as_pandas # Impala conn = connect(host='192.168.53.121', port=21050, auth_mechanism='GSSAPI')
However, it throw the exception:
TTransportException: Could not start SASL: None of the mechanisms listed meet all required properties
I see that you are using IP address 192.168.53.121 for the impala daemon host, can you pleaes use the FQDN for the impala host? The one that matches host defined with the kerberos principal, like impala/<full-domain>@REALM.
Hope that can help. I have tested and it works by using the domain, but IP address will fail.