使用Python连接ClickHouse

pip install clickhouse-driver

from clickhouse_driver import Client

client = Client('localhost')
client.execute('SHOW DATABASES')

client.execute('CREATE DATABASE IF NOT EXISTS test')
client.execute('CREATE TABLE IF NOT EXISTS test.sample (id Int32, name String) ENGINE = Memory')

client.execute("INSERT INTO test.sample (id, name) values", [(1, 'Alice'), (2, 'Bob')])

data = client.execute("SELECT * FROM test.sample")
for row in data:
    print(row)

(1, 'Alice')
(2, 'Bob')