python中用presto连接hive

最新推荐文章于 2025-03-03 20:05:48 发布

XiangFei_Niu

最新推荐文章于 2025-03-03 20:05:48 发布

阅读量3k

点赞数

分类专栏： python

本文链接：https://blog.youkuaiyun.com/XiangFei_Niu/article/details/101366124

版权

python 专栏收录该内容

4 篇文章

订阅专栏

安装包

pip install presto-python-client

python测试文件

import prestodb
conn=prestodb.dbapi.connect(
    host='localhost',
    port=8443,
    user='username',
    catalog='hive',
    schema='default',
    http_scheme='https',
    auth=prestodb.auth.BasicAuthentication("username", "password"),
)
conn._http_session.verify = './presto.pem'  --身份认证
cur = conn.cursor()
cur.execute('SELECT * FROM system.runtime.nodes')
rows = cur.fetchall()
print rows

参考连接https://github.com/prestodb/presto-python-client