clickhouse的python库:clickhouse-driver使用

安装

pip install clickhouse-driver

导入

from clickhouse_driver import Client

连接

import clickhouse_driver

client = clickhouse_driver.Client(host='localhost', port='9000', database='xxx', user='default', password='xxx')

创建表

client.execute('create table aaa(id Int8,name Stinrg) ENGINE = Memory')

查询

for id in client.execute('SELECT id,name FROM aaa limit 20'):
    print(id)

添加插入

client.execute("""insert into aaa (id,name) VALUES""", [(1, 'lwg')])

---

• github