python连接clickhouse （CK）

 

'''
Author: tkhywang [e-mail]
Date: 2023-11-01 11:28:58
LastEditors: tkhywang [e-mail]
LastEditTime: 2023-11-01 11:36:25
FilePath: \PythonProject02\Python读取clickhouse2 数据库数据.py
Description: 这是默认设置,请设置`customMade`, 打开koroFileHeader查看配置 进行设置: https://github.com/OBKoro1/koro1FileHeader/wiki/%E9%85%8D%E7%BD%AE
'''# 注意代码中是clickhouse_driver，而pip安装包是clickhouse-driver。因为python代码习惯用下划线
from clickhouse_driver import Clientclient = Client(host = '192.168.56.16',port = '9000', # 或 9000user = 'acai',password = '[e-mail]',database = 'default'
)
def test():global clientsql = 'show tables' # show databases;res = client.execute(sql)print(res)if __name__ == '__main__':test()