ClickHouse jdbc-bridge 搭建与使用

最新推荐文章于 2024-10-16 16:31:31 发布

租房请下载：房东直租APP

最新推荐文章于 2024-10-16 16:31:31 发布

阅读量142

点赞数 3

文章标签： clickhouse jdbc-bridge docker linux 数据迁移

本文链接：https://blog.csdn.net/ainuser/article/details/142482977

版权

mkdir -p /u01/db/clickhouse-jdbc-bridge/scripts
mkdir -p /u01/db/clickhouse-jdbc-bridge/config
mkdir -p /u01/db/clickhouse-jdbc-bridge/logs
mkdir -p /u01/db/clickhouse-jdbc-bridge/drivers

docker run -d --name ck-jdbc-bridge -p9019:9019 clickhouse/jdbc-bridge

docker cp 9b570e8c5237:/app/config /u01/db/clickhouse-jdbc-bridge
docker cp 9b570e8c5237:/app/scripts /u01/db/clickhouse-jdbc-bridge

拷贝驱动到文件到/u01/db/clickhouse-jdbc-bridge/drivers


docker run -d --name ck-jdbc-bridge --restart=always -p9019:9019 -v /u01/db/clickhouse-jdbc-bridge/scripts:/app/scripts -v /u01/db/clickhouse-jdbc-bridge/config:/app/config -v /u01/db/clickhouse-jdbc-bridge/drivers:/app/drivers -v /u01/db/clickhouse-jdbc-bridge/logs:/app/logs clickhouse/jdbc-bridge


配置datasource数据源
{
  "$schema": "/app/config/datasource.jschema",

  "ch-server": {
    "aliases": [
      "self"
    ],
    "driverUrls": [
      "/app/drivers/clickhouse-jdbc-0.4.6-http.jar"
    ],
    "driverClassName": "com.clickhouse.jdbc.ClickHouseDriver",
    "jdbcUrl": "jdbc:clickhouse://192.168.1.195:8123/test?compress=false",
    "username": "default",
    "password": "",
    "maximumPoolSize": 100
  },


"dm-server": {
    "aliases": [
      "dm"
    ],
    "timezone":"GTM+8",
     "converter": {
              "mappings": [{ "nativeType": "TIMESTAMP", "toType": "String" },
              { "nativeType": "DATE", "toType": "String" }]
                      },
    "driverUrls": [
      "/app/drivers/DmJdbcDriver18.jar"
    ],
    "driverClassName": "dm.jdbc.driver.DmDriver",
    "jdbcUrl": "jdbc:dm://192.168.1.195:5236",
    "username": "SYSDBA",
    "password": "SYSDBA",
    "maximumPoolSize": 100
  }
}


修改clickhosue-server 中的 <jdbc_bridge>配置，设置ip和端口

# 使用实例
select * from jdbc('aliases服务名', 'select * as 表名')