文章来源:https://www.toymoban.com/news/detail-738219.html
文章来源地址https://www.toymoban.com/news/detail-738219.html
'''
Author: tkhywang 2810248865@qq.com
Date: 2023-11-01 11:28:58
LastEditors: tkhywang 2810248865@qq.com
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 Client
client = Client(
host = '192.168.56.16',
port = '9000', # 或 9000
user = 'acai',
password = '123456@abc.COM',
database = 'default'
)
def test():
global client
sql = 'show tables' # show databases;
res = client.execute(sql)
print(res)
if __name__ == '__main__':
test()
到了这里,关于python连接clickhouse (CK)的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!