ContextQMD
Back to Flyway

Clickhouse Database

documentation/Reference/Database Driver Reference/Clickhouse Database.md

latest3.1 KB
Original Source
  • Verified Versions: N/A
  • Maintainer: {% include community-db.html %}

Supported Versions and Support Levels

{% include database-boilerplate.html %}

Driver

ItemDetails
URL format<code>jdbc:clickhouse://<i>host</i>:<i>port</i>/<i>database</i></code>
SSL supportNot tested
Ships with Flyway Command-lineNo
JDBC driver download for Command-lineClickhouse JDBC Drivers
Maven Central coordinatescom.clickhouse:clickhouse-jdbc
Supported versionsN/A
Default Java classcom.clickhouse.jdbc.ClickHouseDriver
Flyway Community implementationflyway-community-db-support

Whilst most databases Flyway supports have common configuration parameters, there are sometimes specific configurations available:

Java Usage

Clickhouse support is a separate dependency for Flyway and will need to be added to your Java project to access these features.

Maven

Open Source

xml

<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-database-clickhouse</artifactId>
</dependency>

Gradle

Open Source

groovy
buildscript {
    dependencies {
        implementation "org.flywaydb:flyway-database-clickhouse"
    }
}

Compression

By default, Clickhouse uses LZ4 compression. This requires lz4-java which needs to be added to the classpath. Alternatively, you can use a different algorithm by setting the compress_algorithm JDBC property, or disable it by setting compress to false.