必填字段“sessionHandle”未设置！与python一起使用配置单元时

Question

我尝试过在python中使用hive的各种方法。在

一个是

How to Access Hive via Python?

也尝试了https://sites.google.com/site/tingyusz/home/blogs/hiveinpython

我要去哪里

  File "py_hive.py", line 8, in <module>
    database='default') as conn:
  File "/home/karimk/python/lib/python2.7/site-packages/pyhs2/__init__.py", line 7, in connect
    return Connection(*args, **kwargs)
  File "/home/karimk/python/lib/python2.7/site-packages/pyhs2/connections.py", line 52, in __init__
    cur.execute(query) 
  File "/home/karimk/python/lib/python2.7/site-packages/pyhs2/cursor.py", line 61, in execute
    res = self.client.ExecuteStatement(query)
  File "/home/karimk/python/lib/python2.7/site-packages/pyhs2/TCLIService/TCLIService.py", line 244, in ExecuteStatement
    return self.recv_ExecuteStatement()
  File "/home/karimk/python/lib/python2.7/site-packages/pyhs2/TCLIService/TCLIService.py", line 260, in recv_ExecuteStatement
    raise x
thrift.Thrift.TApplicationException: Required field 'sessionHandle' is unset! Struct:TExecuteStatementReq(sessionHandle:null, statement:USE default, confOverlay:{})

Python代码：

^{pr2}$

有什么线索吗？在

Answer 1

我正在使用一个类似的初始化代码来连接配置单元，它对我有用。在

但是，我可以看到它无法初始化连接。 字段sessionHandle是在打开与服务器的连接时在内部设置的。当对应的套接字连接无法打开时，未设置（或设置为无）。尝试在不指定数据库的情况下进行访问，并查看它是否有效。在