pip install clickhouse pip install clickhouse_driver
from clickhouse_driver import Client
clickhouse_user = 'name' clickhouse_pwd = 'pass' clickhouse_host_sq = 'ip' clickhouse_database = 'db' begin_time='2019-05-06' end_time='2019-05-12' client = Client(host=clickhouse_host_sq,user=clickhouse_user , database=clickhouse_database, password=clickhouse_pwd) api_interface_sql = "select accountName,count(*) as count,sum(backendTime) as sum from logs " "where date>='{}' and date<='{}' and appName = 'service_si_new' and backendName != '' group by accountName order by count desc limit 0,10" .format(begin_time,end_time) try: a=client.execute(api_interface_sql) print(a) except Exception as e: print(e)