Python要实现使用clickhouse_driver操作clickhouse数据库，首先需要安装clickhouse_driver模块：pip install clickhouse_driver PIP安装的时候有时会遇到WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<pip._vendor.urllib3.connection.HTTPSConnection object at 0x7fd06b379a90>: Failed to establish a new connection: [Errno -3] Temporary failure in name resolution')': /simple/clickhouse-driver/。如果不是在DOCKER容器中一般可以通过指定PIP源的方法解决，如果是在docker容器中一般要修改docker中的DNS地址，参考：http://www.04007.cn/article/1034.html本文地址:http://www.04007.cn/article/1059.html,未经许可,不得转载.
from clickhouse_driver import Client
#可以再加个连接超时时间send_receive_timeout=send_receive_timeout
client = Client(host=host, port=port, user=user, password=password,database=database)
result = client.execute("select * from 数据库.表 limit 10")
print(result)
本文地址:http://www.04007.cn/article/1059.html,未经许可,不得转载. 连接的时候可能碰到报错：File "/usr/local/lib/python3.8/site-packages/clickhouse_driver/connection.py", line 437, in receive_hello raise errors.UnexpectedPacketFromServerError(message)
clickhouse_driver.errors.UnexpectedPacketFromServerError: Code: 102. Unexpected packet from server None:None (expected Hello or Exception, got Unknown packet)
这是因为端口使用错误导致，clickhouse有两个端口，8123和9000。分别用于接收 http协议和tcp协议请求，管理后台登录用的8123(jdbc连接)，而程序连接clickhouse(driver连接)则需要使用9000端口。如果在程序中使用8123端口连接就会报错：
clickhouse_driver.errors.UnexpectedPacketFromServerError: Code: 102. Unexpected packet from server None:None (expected Hello or Exception, got Unknown packet)本文地址:http://www.04007.cn/article/1059.html,未经许可,不得转载.
本文地址:http://www.04007.cn/article/1059.html 未经许可,不得转载. 手机访问本页请扫描右下方二维码.
|
|
手机扫码直接打开本页面 |
