ClickHouse Native JDBC

# ClickHouse Native JDBC

A Native JDBC library for accessing ClickHouse (opens new window) in Java, also provide a library for integrating with Apache Spark (opens new window).

Supported by JetBrains Open Source License (opens new window) 2020-2021.

# JDBC Driver

# Differences from yandex/clickhouse-jdbc (opens new window)

  • Data is organized and compressed by columns.
  • Implemented in the TCP Protocol, with higher performance than HTTP, here is the benchmark report.

# Limitations

  • Not support insert complex values expression, like INSERT INTO test_table VALUES(toDate(123456)), but query is ok.
  • Not support insert non-values format, like TSV.
  • Not support more compression method, like ZSTD.

# Spark Integration

Currently，the implementation based on Spark JDBC API, support data type mapping, auto create table, truncate table, write, read, etc.

# License

This project is distributed under the terms of the Apache License (Version 2.0). See LICENSE (opens new window) for details.

JDBC Driver →