1、安装相关库(Python3为例)
pip3 install clickhouse-driver[lz4]
pip如果遇到权限错误,并且百度未解决,查看下相应的版本,我的是3.7和3.8都装了 所以必须用pip3.8指定版本
2、使用方法
- 导入包
from clickhouse_driver import Client
- 配置连接
client = Client(host='***', database='***', user='***', password='')
# 无需配置端口
如果执行sql的时候,长时间未返回结果,也未报错可能是配置有问题
- 执行sql
sql = client.execute("select uid,groupArray(bookid) from *** where topic = '***' group by uid limit 1,1 ")
- 返回值类型转换及提取
print(sql, type(sql)) ===》[(890, (123456, 123457, 123458))] <class 'list'>
print(sql[0][1], type(sql[0][1])) ===》 (123456, 123457, 123458) <class 'tuple'>
uId = str(sql[0][0])
bookid = str(sql[0][1][0])
print("uId:", uId, "bookid:", bookid)
===> uId:890, bookid:123456