connect kerberozied cluster from impyla in windows machine

[#1]

Hi, 

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

Thanks.

[#2]

Hi,

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.

[#3]

Hi, Eric.
1. I use IP address in Linux hosts(within or without CDH cluster hosts) is both OK.
2. I try FQDN "cdh-121", where the kerberos principal is "cdh-121@REALM". This works in Linux, fails in Windows.
I think the hostnames/IP/DNS both work. The trigger to this issue is still unknown.