如何使用python连接clickhouse数据库

背景

python作为一种脚本语言，简单易用，有时需要使用python连接数据库获取数据。本文主要介绍如何在python中连接clickhouse数据库。

clickhouse简介

参考：Clickhouse简介

python连接clickhouse数据库方法

from clickhouse_driver import Client

def connectToClickhouse(userAccount, password)：
	connectConf = {}
    connectConf['host'] = '.....' # domain name or ip
    connectConf['port'] = '9000' # 
    connectConf['user'] = userAccount
    connectConf['password'] = password
    conn = Client(**connectConf)
	sqlSentence = 'select * from ... where ... limit 100'
	rows = conn.execute_iter(sqlSentence)
	print(rows) # <type 'generator'>,迭代器
	for row in rows:
		print(type(row)) # <type 'tuple'>，每一列分别为元组的每个元素