使用python、impala连接hive

from impala.dbapi import connect
from impala.util import as_pandas

conn = connect(host=‘10.10.14.18’,
port=10000,
auth_mechanism=‘LDAP’,
user=‘aaaa’,
password=‘bbbb’)
cursor = conn.cursor()
cursor.execute(“select * from graph.input_test_11_20”)
data = as_pandas(cursor)
print(data.head())

有可能出现
error: Microsoft Visual C++ 14.0 is required. Get it with “Microsoft Visual C++ Build Tools”:
需要下载对应的包
https://www.lfd.uci.edu/~gohlke/pythonlibs/#bitarray
搜索对应的依赖包
sasl‑0.2.1‑cp36‑cp36m‑win_amd64.whl

python中impyla包报’TSocket’ object has no attribute 'isOpen’错误
pip install thrift-sasl==0.2.1