安装驱动
pip install clickhouse-driver
本地环境
python Python 3.8.8
clickhouse-driver 0.2.8
clickhouse server 20.3
https://github.com/mymarilyn/clickhouse-driver
https://clickhouse-driver.readthedocs.io/en/latest/installation.html
from clickhouse_driver import Clientck = Client(user=clickhouse_config['user'], password=clickhouse_config['password'],host=clickhouse_config['host'], port=clickhouse_config['port'], database=clickhouse_config['database']
)sql = "SELECT id,author,publisher,title,summary FROM bigdata.dw_dim_metadata_book_cip_all WHERE `title` = '互联网' limit 1"
res = ck.execute(sql) # list
这里特别要注意的一点是端口问题，HTTP协议（默认端口8123）；TCP (Native)协议（默认端口号为9000），Python里的clickhouse_driver用的TCP端口9000，DBeaver使用的是HTTP端口。
如果端口错误包报错：UnexpectedPacketFromServerError: Code: 102. Unexpected packet from server 220.202.33.52:19100 (expected Hello or Exception, got Unknown packet)
