-- 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