Python连接数据库——首次连接impala并获取数据

先安装一波这个

pip install six
pip install bit_array
pip install thriftpy  
pip install thrift_sasl
pip install impyla

然后输入

from impala.dbapi import connect
import pandas as pd
conn = connect(host='query.nobank.com',port=2000)#21000,query.noobank.com
cur = conn.cursor()

尝试取数

sql = """
select user_id
from idw.fact_borrows
limit 10
"""
#执行sql
cur.execute(sql)
cur.close
result = cur.fetchall()
df = pd.DataFrame(data = result)
df.to_excel('路径'，index=True)

好了就这么简单~

**喜欢可以关注【小猪课堂】公众号了解更多编程小技巧**