使用 JDBC/ODBC 将 ClickHouse 连接到外部数据源

• 实验目标:实现通过jdbc在clickhose上实现创建ES的外表并进行查询
• 安装并启用jdbc-bridge#安装

#安装

yum install -y wget

wget https://github.com/ClickHouse/clickhouse-jdbc-bridge/releases/download/v2.1.0/clickhouse-jdbc-bridge-2.1.0-1.noarch.rpm

yum localinstall -y clickhouse-jdbc-bridge-2.1.0-1.noarch.rpm

#启动

clickhouse-jdbc-bridge

您现在可以将以下配置复制并粘贴到文件中/etc/clickhouse-jdbc-bridge/config/datasources/mysql8.json：

{

 "mysql8": {

 "driverUrls": [

  "https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.28/mysql-connector-java-8.0.28.jar"

  ],

 "jdbcUrl": "jdbc:mysql://<host>:<port>",

 "username": "<username>",

 "password": "<password>"

  }

}