pyhive-long running query timeout-[errno 110]连接超时

m528fe3b  于 2021-06-27  发布在  Hive
关注(0)|答案(0)|浏览(403)

我在跑步 Hive queriesPython 使用 PyHive . 其中一个查询大约需要12-15分钟才能完成。我可以看到它在
Hadoop ResourceManager UI ,但是我看到下面的超时错误 Python .
error:traceback (最后一次调用):文件“/home/mrjadav/python/thunderbolt.py”,第704行,在main()文件“/home/mrjadav/python/thunderbolt.py”,第662行,在main getcololatency()文件“/home/mrjadav/python/thunderbolt.py”,第582行,在getcololatency dataset=savehqlresulttoxls(querystring=querystring,caption='colo latency breakdown',configuration=g\u hive\u config\u heavy)file“/home/mrjadav/python/thunderbolt.py”,第636行,在savehqlresulttoxls dataset=cursor.fetchall()file“/home/y/lib/python2.7/site packages/pyhive/common.py”中,第136行,在fetchall返回列表(iter(self.fetchone,none))file“/home/y/lib/python2.7/site packages/pyhive/common.py”,第105行,在fetchone self.\u fetch \u while中(lambda:not self.\u data and self.\u state!=self.\u state\u finished)file“/home/y/lib/python2.7/site packages/pyhive/common.py”,第45行,在self.\u fetch\u while self.\u fetch\u more()file“/home/y/lib/python2.7/site packages/pyhive/hive.py”中,第386行,在\u fetch\u more response=self.\u connection.client.fetchresults(req)file“/home/y/lib/python2.7/site packages/tcliservice/tcliservice,在fetchresults return self.recv\u fetchresults()file“/home/y/lib/python2.7/site packages/tcliservice/tcliservice.py”第726行中,在recv\u fetchresults(fname,mtype,rseqid)=iprot.readmessagebegin()file“/home/y/lib/python2.7/site packages/thrift/protocol/tbinaryprotocol.py”第134行中,在readmessagebegin sz=self.readi32()文件“/home/y/lib/python2.7/site packages/thrift/protocol/tbinaryprotocol.py”的第217行,在readi32 buff=self.trans.readall(4)文件“/home/y/lib/python2.7/site packages/thrift/transport/tttransport.py”的第60行,在readall chunk=self.read(sz-have)file“/home/y/lib/python2.7/site packages/thrift\u sasl/init.py”的第166行,在read self.\u read\u frame()file“/home/y/lib/python2.7/site packages/thrift\u sasl/init.py”的第170行,在\u read\u frame header=self.\u trans.readall(4)file“/home/y/lib/python2.7/site packages/thrift/transport/tttransport.py”的第60行,在readall chunk=self.read(sz-have)file“/home/y/lib/python2.7/site packages/thrift/transport/tsocket.py”的第117行,read buff=self.handle.recv(sz)error:[errno 110]连接超时

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题