无法使用impyla连接到hiveserver2

but5z9lq  于 2021-06-26  发布在  Hive
关注(0)|答案(0)|浏览(241)

有人能帮我在Windows10上解决下面的问题吗?
下面是我的python代码:

from impala.dbapi import connect
from contextlib import closing

if __name__ == '__main__':

    with closing(connect(host='host_name_with_hiveserver2',
                 port=10000,
                 database='databasename',
                 user='username',
                 password='password',
                 auth_mechanism='PLAIN')) as conn:
        cursor = conn.cursor()

已安装python软件包的列表:
位数组==0.8.1
异丙基==0.14.0
sasl==0.2.1
六==1.10.0
节俭==0.9.3
节俭sasl==0.2.1
版本:
操作系统版本:microsoft windows 10(64位)
dbms版本:1.2.1.2.3.6.0-3796 apache hive
回溯:

Traceback (most recent call last):
  File "D:/vinokur/projects/python/hive_connect/main.py", line 11, in <module>
    auth_mechanism='PLAIN')) as conn:
  File "D:\vinokur\projects\python\virtual_envs\pip_impyla\lib\site-packages\impala\dbapi.py", line 147, in connect
    auth_mechanism=auth_mechanism)
  File "D:\vinokur\projects\python\virtual_envs\pip_impyla\lib\site-packages\impala\hiveserver2.py", line 758, in connect
    transport.open()
  File "D:\vinokur\projects\python\virtual_envs\pip_impyla\lib\site-packages\thrift_sasl\__init__.py", line 72, in open
    message=("Could not start SASL: %s" % self.sasl.getError()))
thrift.transport.TTransport.TTransportException: Could not start SASL: Error in sasl_client_start (-4) SASL(-4): no mechanism available: Unable to find a callback: 2

我能够在linux ubuntu16.04上成功运行此代码,遵循python无法连接hiveserver2的指令。
提前谢谢!

暂无答案!

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

相关问题