impyla (0.14.0) ERROR - 'TSocket' object has no attribute 'isOpen'

Question

I am getting the following error while trying to create a connection to HiveServer

 Traceback (most recent call last):
  File "/Users/user_name/Desktop/ABCo/EEM/EntityManagement/lodurr/data_lake/hive_db.py", line 56, in wrapper
    auth_mechanism='PLAIN')
  File "/Users/user_name/.virtualenvs/entity1/lib/python3.6/site-packages/impala/dbapi.py", line 147, in connect
    auth_mechanism=auth_mechanism)
  File "/Users/user_name/.virtualenvs/entity1/lib/python3.6/site-packages/impala/hiveserver2.py", line 758, in connect
    transport.open()
  File "/Users/user_name/.virtualenvs/entity1/lib/python3.6/site-packages/thrift_sasl/__init__.py", line 67, in open
    if not self._trans.isOpen():

These are the packages that I have installed when I do pip list

six (1.11.0)
thriftpy (0.3.9)
thrift-sasl (0.3.0)
sasl (0.2.1)
impyla (0.14.0)

I am using a macOS High Sierra as my development environment

score 4 · Answer 1 · answered Jul 23 '18 at 12:52

4

I had the same issue and useed the following packages:

pip uninstall thrift-sasl
pip uninstall impyla
pip uninstall thrift

pip install thrift-sasl==0.2.1 
pip install thrift==0.9.3
pip install impyla==0.13.8

answered Jul 23 '18 at 12:52

Rene B.

6,557
7
46
72

1

this caused `thriftpy.transport.TTransportException: TTransportException(type=4, message='TSocket read 0 bytes')` for me. – user9074332 Oct 20 '19 at 02:33

score 3 · Answer 2 · answered Oct 05 '17 at 12:42

3

Not sure what the issue is but can you try with

thrift-sasl==0.2.1

answered Oct 05 '17 at 12:42

Umberto Boscolo

31
1

Please be a little more comprehensive here. – Sam Chats Oct 05 '17 at 12:52
1

The only way that i could get it to work was wing these specific versions of the libraries - thrift<=0.10.0 - thrift_sasl<=0.2.1 - sasl<=0.2.1 - impyla<=0.14.0 – ameyrupji Oct 05 '17 at 23:05

score 1 · Answer 3 · answered Apr 25 '20 at 00:33

1

This also got resolved by installing the latest versions of of Impyla (0.16.2) and thrift-sasl (0.4.2) using:

pip install --upgrade impyla
pip install --upgrade thrift-sasl

answered Apr 25 '20 at 00:33

ebeb

429
3
12

impyla (0.14.0) ERROR - 'TSocket' object has no attribute 'isOpen'

3 Answers3