Python Impyla - Unsupported mechanism type PLAIN'

[rbhatia6]

I have the following 2 lines of code. I am using Anaconda on MacOS:

from impala.dbapi import connect
imp_conn = connect(host='hostname.corp.XXX.net', port=10000, user='XXX', password='XXX', auth_mechanism='PLAIN')

However, I get the following error. Is it possible for you to help out?

File "//anaconda/lib/python3.5/site-packages/impala/dbapi.py", line 147, in connect
auth_mechanism=auth_mechanism)
File "//anaconda/lib/python3.5/site-packages/impala/hiveserver2.py", line 644, in connect
transport.open()
File "//anaconda/lib/python3.5/site-packages/thrift_sasl/init.py", line 83, in open
message=("Bad status: %d (%s)" % (status, payload)))
thriftpy.transport.TTransportException: TTransportException(type=1, message="Bad status: 3 (b'Unsupported mechanism type PLAIN')")

[wesm]

I am not sure -- there have been a number of issues regarding Hive connectivity with impyla. Users have reported getting PyHive to work, but I unfortunately am not in a position to test and diagnose these issues myself.

[gittify]

It worked for me ..I am using the following connection string to connect to hive
conn = connect(host='localhost', port=10000, database='default',auth_mechanism='PLAIN', user='xxx', kerberos_service_name='hive')