Awesome ClickHouse › Java

housepower/ClickHouse-Native-JDBC

⭐ 541 Java repository created 2018-05-14

The project "ClickHouse Native JDBC" by housepower is a native JDBC library designed for accessing ClickHouse, a columnar database management system, using Java. It provides a high-performance implementation of the ClickHouse native protocol over TCP, which offers better performance compared to HTTP-based communication. The library supports Java 8 and 11 and is tested primarily on these long-term support versions. It is also integrated with Apache Spark, allowing users to leverage ClickHouse within Spark environments for big data processing and analytics. The project includes a shaded version for easier dependency management and a normal version, both available via Maven and Gradle repositories. Key features include column-organized and compressed data handling, TCP protocol implementation for efficient communication, and integration support for Spark versions 2.4, 3.0, and 3.1 with Scala 2.11/2.12. However, there are some limitations such as lack of support for inserting complex value expressions, non-values format like TSV, and certain compression methods like ZSTD. The project is actively maintained with build status and code coverage badges visible, and it encourages community contributions for bug fixes, documentation improvements, and feature additions. The library is licensed under the Apache License 2.0 and supported by JetBrains Open Source License. It aims to provide a robust and efficient JDBC driver for ClickHouse users, enhancing the database's accessibility and performance in Java and Spark applications. The project also offers documentation and benchmarks to help users understand its advantages and usage scenarios.

https://github.com/housepower/ClickHouse-Native-JDBC

analyticsapache-licenseapache-sparkclickhouseclickhouse-clientcolumnar-databasedata-compressiondatabasehigh-performanceintegrationjavajdbcjetbrains-supportnative-protocolopen-sourcesparktcp-protocol