Python链接impala数据库

xujingpilot

于 2025-03-17 14:09:21 发布

阅读量211

点赞数 1

CC 4.0 BY-SA版权

文章标签： python linux 开发语言

本文链接：https://blog.csdn.net/xujingpilot/article/details/146313697

先准备相关包

pip install impyla   -i https://mirrors.tuna.tsinghua.edu.cn/pypi/web/simple
pip install pure-sasl -i https://mirrors.tuna.tsinghua.edu.cn/pypi/web/simple
pip install thrift_sasl -i https://mirrors.tuna.tsinghua.edu.cn/pypi/web/simple

然后运行

import pandas as pd
from impala.dbapi import connect

conn = connect(host=***, port=***, user=***, password=****, database=***)
###***换成自己的环境
cur=conn.cursor()
cur.execute("""
-------sql语句

            """)
# 将结果放入dataframe
dfzzz = pd.DataFrame(cur.fetchall()).fillna(0)