python连接hive报错：TypeError: can‘t concat str to bytes

目录

一、完整报错

二、解决

三、 其他报错

一、完整报错

Traceback (most recent call last):
  File "D:/Gitlab/my_world/hive2csv.py", line 18, in <module>
    conn = hive.Connection(host=host, port=port, username=username, password=password, database=database, auth=auth)
  File "D:\Anaconda3\lib\site-packages\pyhive\hive.py", line 269, in __init__
    self._transport.open()
  File "D:\Anaconda3\lib\site-packages\thrift_sasl\__init__.py", line 82, in open
    self._send_message(self.START, chosen_mech)
  File "D:\Anaconda3\lib\site-packages\thrift_sasl\__init__.py", line 103, in _send_message
    self._trans.write(header + body)
TypeError: can't concat str to bytes

二、解决

        2.1、进入D:\Anaconda3\lib\site-packages\thrift_sasl\__init__.py文件

        2.2、添加如下代码到第101行之前

if (type(body) is str):
    body = body.encode()

        然后就可以运行了。

三、 其他报错

        报错：AttributeError: 'TSaslClientTransport' object has no attribute 'readAll'

        解决：pip install thrift_sasl==0.3.0

其他报错可以参考文章：python连接hive