记一次StarRocks 创建外部ClickHouse数据源报错

创建数据源：

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"
);

查询成功