Posts: 23
Registered: ‎04-03-2017
Accepted Solution

Python Error 'TSaslClientTransport' object has no attribute 'trans' when openning cursor to Impala

Hi ,

using Ubuntu 14.0.4 and 16.0.4 unable to work with Impala via Python .


Installed :


pip install impyla

apt-get install libsasl2-dev python-dev libldap2-dev libssl-dev

pip install thrift_sasl
pip install sasl


thrift version install :

thrift (0.10.0)
thrift-sasl (0.2.1)

impyla (0.14.0)


The Example Code


from impala.dbapi import connect
conn = connect(host="", port="25003", user="user", password='pass', auth_mechanism='PLAIN')

print "Connected Successfully"

cur = conn.cursor()



stack error :


Traceback (most recent call last):
  File "/home/alon/PycharmProjects/test/", line 6, in <module>
    cur = conn.cursor()
  File "/usr/local/lib/python2.7/dist-packages/impala/", line 125, in cursor
    session = self.service.open_session(user, configuration)
  File "/usr/local/lib/python2.7/dist-packages/impala/", line 995, in open_session
    resp = self._rpc('OpenSession', req)
  File "/usr/local/lib/python2.7/dist-packages/impala/", line 923, in _rpc
    response = self._execute(func_name, request)
  File "/usr/local/lib/python2.7/dist-packages/impala/", line 940, in _execute
    return func(request)
  File "/usr/local/lib/python2.7/dist-packages/impala/_thrift_gen/TCLIService/", line 175, in OpenSession
    return self.recv_OpenSession()
  File "/usr/local/lib/python2.7/dist-packages/impala/_thrift_gen/TCLIService/", line 193, in recv_OpenSession
  File "/usr/local/lib/python2.7/dist-packages/impala/_thrift_gen/TCLIService/", line 1109, in read
    fastbinary.decode_binary(self, iprot.trans, (self.__class__, self.thrift_spec))
AttributeError: 'TSaslClientTransport' object has no attribute 'trans'


dont know what is going wrong here .







Posts: 23
Registered: ‎04-03-2017

Re: Python Error 'TSaslClientTransport' object has no attribute 'trans' when openning cursor to Impa

Solved the problem by reinstalling thrift and impyla with the following versions:


as root :


pip uninstall thrift

pip uninstall impyla

pip install thrift==0.9.3

pip install impyla==0.13.8





New Contributor
Posts: 2
Registered: ‎03-29-2017

Re: Python Error 'TSaslClientTransport' object has no attribute 'trans' when openning cursor to Impa

Was getting this issue in Airflow trying to use HiveServer2Hook:

    ImportError: cannot import name TFrozenDict


And figured it might be related to this pip warning:

    impyla 0.14.1 has requirement thrift<=0.9.3, but you'll have thrift 0.11.0 which is incompatible.


So I adjusted the thrift and impyla installs as indicated and now HiveServer2Hook works (and HiveOperator still works)--both of which are using kerberos beeline connections.


Thanks for posting the fix.



Our community is getting a little larger. And a lot better.

Learn More about the Cloudera and Hortonworks community merger planned for late July and early August.