- -- clickhouse表对应的DDL
- CREATE TABLE tb1
- (
- `f1` Float64,
- `f2` UInt64
- )
- ENGINE = MergeTree
- PARTITION BY toDate(fromUnixTimestamp64Milli(toInt64(f2)))
- ORDER BY (f1)
- SETTINGS index_granularity = 8192 ;
-
- -- starrocks中创建资源
- create external resource resource_ck5
- properties (
- "type"="jdbc",
- "user"="root",
- "password"="passwd1",
- "jdbc_uri"="jdbc:clickhouse://2.2.2.2:8123/db1?allowPublicKeyRetrieval=false",
- "driver_url"="http://node1/clickhouse-jdbc-0.4.6-all.jar", -- 驱动的url 官网可以下载
- "driver_class"="com.clickhouse.jdbc.ClickHouseDriver"
- -- "driver_class"="ru.yandex.clickhouse.ClickHouseDriver" -- 老版本驱动主类
- );
-
- use test_db;
- -- 在starrocks中新建外表 绑定clickhouse
- CREATE EXTERNAL TABLE `tb_ck1` (
- `f1` String
- ,`f2` BIGINT NULL
- ) ENGINE=JDB