Spring Boot ClickHouse JDBC 报 LZ4 is not supported

错误详情

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., server ClickHouseNode

解决方法一

添加lz4-java依赖。

<dependency>
    <groupId>org.lz4</groupId>
    <artifactId>lz4-java</artifactId>
    <version>1.8.0</version>
</dependency>

解决方法二

使用gzip压缩，添加参数compress_algorithm。

spring:
  datasource:
    driver-class-name: com.clickhouse.jdbc.ClickHouseDriver
    url: jdbc:clickhouse://localhost:8123/mydb?compress_algorithm=gzip
    username:
    password:

GitHub Issue

https://github.com/ClickHouse/clickhouse-java/issues/1317

LZ4 介绍

Speeding up LZ4 in ClickHouse: https://clickhouse.com/blog/lz4-compression-in-clickhouse