ClickHouse JDBC Bridge/Funtion实现多种数据库之间数据迁移-联合-ClickHouse

鱼鱼不愚与

已于 2025-01-03 09:53:11 修改

阅读量1k

点赞数 26

文章标签：运维数据库 clickhouse mysql oracle

于 2024-06-26 16:54:02 首次发布

本文链接：https://blog.csdn.net/2301_79096508/article/details/139993501

版权

一、ClickHouse JDBC Bridge的使用

1.1 ClickHouse JDBC Bridge下载安装RPM包

[root@localhost clickhouse]# rpm -ivh clickhouse-jdbc-bridge-2.1.0-1.noarch.rpm 
error: Failed dependencies:
jre-headless >= 1.8 is needed by clickhouse-jdbc-bridge-2.1.0-1.noarch
#安装 JRE 头文件
yum install java-1.8.0-openjdk-headless
#安装 clickhouse-jdbc-bridge
rpm -ivh clickhouse-jdbc-bridge-2.1.0-1.noarch.rpm 



/etc/clickhouse-jdbc-bridge/config
/etc/clickhouse-jdbc-bridge/config/datasource.jschema
/etc/clickhouse-jdbc-bridge/config/datasources
/etc/clickhouse-jdbc-bridge/config/datasources/datasource.json.example
/etc/clickhouse-jdbc-bridge/config/datasources/script.json
/etc/clickhouse-jdbc-bridge/config/httpd.json
/etc/clickhouse-jdbc-bridge/config/queries
/etc/clickhouse-jdbc-bridge/config/queries/query.json.example
/etc/clickhouse-jdbc-bridge/config/query.jschema
/etc/clickhouse-jdbc-bridge/config/schema.jschema
/etc/clickhouse-jdbc-bridge/config/schemas
/etc/clickhouse-jdbc-bridge/config/schemas/schema.json.example
/etc/clickhouse-jdbc-bridge/config/server.json
/etc/clickhouse-jdbc-bridge/config/vertx.json
/etc/clickhouse-jdbc-bridge/logging.properties
/etc/clickhouse-jdbc-bridge/set-env.sh.example
/usr/local/bin
/usr/local/bin/clickhouse-jdbc-bridge
/usr/local/lib/java/clickhouse-jdbc-bridge-2.1.0-shaded.jar
/usr/local/lib/java/clickhouse-jdbc-bridge-shaded.jar

1.2 ClickHouse JDBC Bridge 配置

 #安装成功后自动生成配置路径
cd /etc/clickhouse-jdbc-bridge/config/datasources    

[root@localhost config]# ll
total 40
-rw-r--r-- 1 root root 17194 Apr 19  2022 datasource.jschema
drw-r--r-- 2 root root    56 May 30 09:57 datasources
-rw-r--r-- 1 root root    41 Apr 19  2022 httpd.json
drw-r--r-- 2 root root    32 May 30 09:57 queries
-rw-r--r-- 1 root root  4086 Apr 19  2022 query.jschema
-rw-r--r-- 1 root root  2192 Apr 19  2022 schema.jschema
drw-r--r-- 2 root root    33 May 30 09:57 schemas
-rw-r--r-- 1 root root   804 Apr 19  2022 server.json
-rw-r--r-- 1 root root   176 Apr 19  2022 vertx.json

#创建驱动目录
mkdir /etc/clickhouse-jdbc-bridge/drivers

clickhouse-jdbc-bridge

├── clickhouse-jdbc-bridge-2.1