Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

connect kerberozied cluster from impyla in windows machine

connect kerberozied cluster from impyla in windows machine

Rising Star

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 REPLIES 2

Re: connect kerberozied cluster from impyla in windows machine

Guru

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.

Highlighted

Re: connect kerberozied cluster from impyla in windows machine

Rising Star
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.
Don't have an account?
Coming from Hortonworks? Activate your account here