使用python连接clickhouse数据库

使用前需先pip install clickhouse_driver ,python使用的是UDP,默认端口是9000,当前系统修改为55666

以下是登录数据库中创建表信息:

from clickhouse_driver import Client
client = Client(
    host='192.168.50.94',
    database='default',
    port=55666,
    user='default',
    password='bjdv2020'
)

client.execute("CREATE TABLE default.cluster_metrics8("
               "`id` String,"
               "`time_stamp` String,"
               "`cluster_name` String,"
               "`service_name` String,"
               "`entity_name` String,"
               "`chart_name` String,"
               "`metric_name` String,"
               "`metric_value` String,"
               "`create_at` DateTime)"
               "ENGINE = MergeTree "
               "ORDER BY create_at "
               "SETTINGS index_granularity = 8192")