python clickhouse访问

from clickhouse_driver import Client

import pandas as pd

client = Client(host='xxx', database='Pisces', port='9200', user, password)

sql = "select Components , Instance from Pisces.datasystem_metric final"

rows = client.execute(sql)

for row in rows:

        print(row[0])

注意这里是通过游标访问。