创建数据源:
create external resource ck_jdbc
properties (
"type"="jdbc",
"user"="default",
"password"="db",
"jdbc_uri"="jdbc:clickhouse://xx.xx.xx.xx:8123/db",
"driver_url"="https://repo1.maven.org/maven2/com/clickhouse/clickhouse-jdbc/0.4.6/clickhouse-jdbc-0.4.6.jar",
"driver_class"="com.clickhouse.jdbc.ClickHouseDriver"
);
创建表查询时候报错
LZ4 is not supported. Please disable compression(compress=0), modify the algorithm(e.g. compress_algorithm=gzip), or add the missing libraries to the classpath
查询资料修改jdbc链接串 重新创建外部表
create external resource ck_jdbc
properties (
"type"="jdbc",
"user"="default",
"password"="db",
"jdbc_uri"="jdbc:clickhouse://xx.xx.xx.xx:8123/db?compress_algorithm=gzip",
"driver_url"="https://repo1.maven.org/maven2/com/clickhouse/clickhouse-jdbc/0.4.6/clickhouse-jdbc-0.4.6.jar",
"driver_class"="com.clickhouse.jdbc.ClickHouseDriver"
);
查询成功