"TSocket read 0 bytes" error while running SQL query in a docker container

[rkhilnani9]

We are running a long-ish SQL query in pyhive from inside a python 3.6 container. The query freezes up after 10-15 mins and the error mentioned above is thrown. We are using the following versions :

thrift==0.13.0 sasl==0.2.1 thrift-sasl==0.4.2 PyHive==0.6.3

Any leads/solutions?

Additionally, when we try to query a different dedicated queue using configuration = {'mapred.job.queue.name' : queue_name} inside connect(), we also get the following error sometimes:

thrift.transport.TTransport.TTransportException: unexpected exception

Thanks!

[cool-joker]

@rkhilnani9 hello，Is the problem solved?

[lucharo]

Hello, I keep getting this too when polling a cursor from a single Connection object. My first thought it that maybe the current/previous operation needs to be closed using cursor.close() or cursor.cancel() before trying to run execute another query but I haven't seen this mentioned anywhere

[cool-joker]

@lucharo tank u,but I found this error when I was querying the data and I tried many versions. When I tested it, I try 'select * from table limit 100' that the results could appear, but the error was reported when 'select * from table'. I still haven't solved the problem