Clickhouse Jdbc Versions Save

Warning Please upgrade to v0.4.4 to resolve dependency issue.

This is a tiny release for bug fixing. Please upgrade if your work rely on text-based data format and/or R2DBC driver.

• 🐛 Bug Fix
  • unable to convert empty string to default value when using text-based data format
  • r2dbc driver does not support most client options - #1299
  • incorrect content from Lz4InputStream when using text-based data format - ClickHouse/ClickHouse#48446

This is a minor release with bug fixes and some new features.

• 💥 BREAKING CHANGES

  • Refactored SQL parser to support keywords compression, infile, and outfile

• 🐛 Bug Fix

  • remove duplicated socket options - #1263 by @JackyWoo
  • error while converting Nested values to Java maps
  • incorrect algorithm extracted from PEM - #1274
  • transaction failure introduced in 0.4.0
  • respect node-specific credentials - #1114
  • USE statement does nothing - #1160
  • executeBatch does not support on cluster anymore - #1261

• ✨ New Feature

  • Add credentials overload for Java client - #1265 by @rickysaltzer
  • centralized configuration for JDBC driver using custom server setting custom_jdbc_config - #1290
  • support BEGIN TRANSACTION, COMMIT, and ROLLBACK statements in JDBC driver
  • new options for JDBC driver
    • databaseTerm(catalog or schema, defaults to schema) - #1273
    • externalDatabase(boolean, defaults to true) to enable/disable external database metadata - #1245
    • localFile(boolean, defaults to false) to support INFILE and OUTFILE - #1291

• 🎨 Misc

  • move docs to ClickHouse website as well as bug template and contribution guide - by @mshustov
  • improved error messages for missing dependency
  • replaced default JDBC artifact with shaded jar and more dependencies in provided scope

This is a patch release mainly for bug fixing. It is highly recommended to upgrade if you're using v0.4.0.

• 💥 BREAKING CHANGES

  • changed option names - #1203
    • compress_alogrithm -> compress_algorithm
    • decompress_alogrithm -> decompress_algorithm

• 🐛 Bug Fix

  • incorrect nested array values - #1223
  • broken serde for Nested, which also impacted JSON - #1242
  • broken serde for bitmap64 - #1248
  • gRPC client may complete execution before closing response stream
  • throw StreamCorruptedException instead of generic IOException when deserialization failed (mostly due to server error)

• ✨ New Feature

  • added source in shaded jar for IDE friendly - #1217
  • iterable ClickHouseInputStream, which slightly improved performance of piping - #1238
  • ClickHouseOutputStream.transferBytes() is deprecated and it will be removed in 0.5
  • read() and write() methods in ClickHouseClient - connect() is deprecated and it will be removed in 0.5
  • make all dependencies of JDBC driver optional, along with configuration for building native binary - #1247

• 🎨 Misc

  • added PR template and changelog by @mshustov
  • renamed repository from clickhouse-jdbc to clickhouse-java, and branch from master to main by @mshustov
  • update outdated docs by removing yandex and correcting class names by @mzitnik and @alexey-milovidov

Happy Spring Festival everyone! Apologize for a minor release taking so long :p

This is a feature release with new features, performance improvement, bug fixes, and unfortunately breaking changes.

• 💥 BREAKING CHANGES

  • refactored JdbcTypeMapping to make it extensible - #1075
  • removed legacy driver ru.yandex.* - #1089 by @mzitnik
  • removed most deprecated methods and class members
  • refactored data processor(for serialization and deserialization) and added new classes for unsigned types - #1124
  • refactored ClickHouseRequest/ClickHouseInputStream/ClickHouseOutputStream to better support compression - #1174 & #1189
  • extracted clickhouse-data from clickhouse-client along with new packages - #1197

    com.clickhouse.config  // generic configuration
    com.clickhouse.data    // data processing utilities
    com.clickhouse.logging // generic logging utility
    

  • added jdk17 in pom and changed build instructions

    mvn -Dj8 clean install # for jdk8, it was 'mvn clean install'
    mvn clean install # for jdk17, it was 'mvn -Drelease clean install'
    

• 🐛 Bug Fix

  • not able to cancel query when there's session_id - #1035
  • overflow error when handling BigInteger and BigDecimal in ClickHouseLongValue - #1040 by @Blackmorse
  • not handling SimpleAggregateFunction properly - #1054
  • DELETE FROM was rewritten to ALTER TABLE DELETE even when lightweight deletion was enabled - #1063
  • forced headless format for inserting - #1073
  • missing the verb "be" in error messages - #1137 by @fabiencelier
  • write time field data loss precision - #1127 by @gaaraG
  • fixed a few copy-paste error causing problem handling Geo types

• ✨ New Feature

  • added R2DBC driver - #914 by @rernas35
  • enhanced ClickHouseClient for importing and exporting compressed file - #1004
  • added new option custom_settings - #1059
  • enhanced ClickHouseRequestManager to support query/session ID customization - #1074
  • added Apache HTTP Client 5 to support socket options - #1146 by @JackyWoo
  • enhanced clickhouse-grpc-client to support request chunking and compression
    • decompress_alogrithm(request compression): BROTLI[-1,11], BZ2, DEFLATE[0,9], GZIP[-1,9], LZ4[0,18], XZ[0,9], ZSTD[0,22]
    • compress_alogrithm(response decompression): DEFLATE, LZ4, ZSTD Note: typo will be fixed in v0.4.1.
  • enhanced clickhouse-http-client to support zstd compression for both request and response
    • decompress_alogrithm(request compression): LZ4[0,18], ZSTD[0,22]
    • compress_alogrithm(response decompression): BROTLI, BZ2, DEFLATE, GZIP, LZ4, XZ, ZSTD Note: typo will be fixed in v0.4.1.
  • added stream-based prepared statement - #1163
  • browser-like client name (select distinct http_user_agent from system.query_log) - #1182
  • enhanced ClickHouseRequest by treating input stream and ClickHouseWriter equally - #1200

• 🎨 Misc

  • dropped develop branch, which accidentally removed all open pull requests 😭
  • fixed some issues captured by SonarCloud and LGTM
  • added more tests but the coverage is still very low 🤣
  • enabled nightly build in CI - check out Sonatype OSSRH

    <repositories>
        <repository>
            <id>ossrh</id>
            <name>Sonatype OSSRH</name>
            <url>https://s01.oss.sonatype.org/content/repositories/snapshots/</url>
        </repository>
    </repositories>
    

This is a patch release for bug fixes and experimental features.

• Bug Fix

  • Bitmap64 deserilization error - #918
  • Incorrect update count - #947
  • Dependencies lost in pom.xml - #973
  • Error when executing empty batch using PreparedStatement - #977
  • Connection properties may lost - #978
  • ResultSet.getObject(int, Class) may return default value instead of null - #979
  • Redundant classes in shaded jar - #989
  • PreparedStatement.addBatch() timed out - #991
  • Set nullAsDefault to 2 may trigger IllegalArgumentException when handling timestamp with timezone - #999

• New Feature

  • ClickHouseRequestManager is added for customizing query ID and session ID - #870
  • PreparedStatement.getParameterMetaData() is implemented - #972
  • Experimental transaction support - #975
  • Direct file upload and download - #1001
  • Failover across protocols
  • Repeat the same query until timed out, only when session is locked on server - set repeat_on_session_lock to false to turn it off

This is a patch release for bug fixes and experimental features.

• Bug Fix

  • bump gRPC to 1.45.1 - #936
  • fix insert timeout error as mentioned in #943
  • fix issue of parsing slash in connection string - now you don't have to encode slash in query parameters
  • fix JDBC multi-value insert error - #920
  • fix JDBC metadata error on 21.6 and rename_response_column option no longer impact metadata queries - #938

• New Feature

  • clickhouse-cli-client, a wrapper of ClickHouse native command-line, was added mainly for testing
  • load balancing and failover support - #956
  • new JDBC option nullAsDefault for handling null value in both insert and query - see comment at here

This is a patch release mainly for fixing below issues:

• fix issue parsing Tuple with names - #889 (which was not fully fixed in previous release)
• fix unsupported format error when loading data in custom format - #909
• fix precision issue when converting Float and Double to BigDecimal - #921
• fix type conversion issue when dealing with nullable array elements - #924
• fix OOM issue when loading lots of data through http interface - as mentioned in #861
• fix broken query for retrieving client info properties

In addition, a few more changes(mainly for streaming) were merged from 0.3.3 branch, along with some new features:

• new option rename_response_column for removing column prefix
• new option request_chunk_size (defaults to 8192) for streaming - same option will be applied to gRPC client in the near future
• new options request_buffering and response_buffering for customizing buffering mode - more details will be covered in #928
  • Resource-Efficient the default mode which consumes less CPU and memory
  • Performance uses more CPU and much more memory for better performance
  • Custom allows you to customize options like buffer_size, max_buffer_queue, buffer_queue_variation, use_blocking_queue etc. to balance performance and resource utilization

This is a patch release mainly for fixing below issues:

• fix issue with null in legacy JDBC driver json response deserializer - #879
• fix issue set String as Enum value in new JDBC driver - #883
• fix issue when deserializing array of DateTime with timezone - #886 Note: for example Map(String,Array(Nullable(DateTime64(3,'Asia/Shanghai'))))
• fix key type when deserializing map objects - #887
• fix issue parsing Tuple with names - #889

In addition, more changes(mostly related to streaming) were merged from 0.3.3 branch along with some new features:

• TLS authentication support - #523
• support SimpleAggregateFunction data type
• initial support of experimental data type JSON/Object('JSON')

  select tuple(1,[2,3], map('4', 5))::Tuple(Int32, Array(Int32), Map(LowCardinality(String), Int32))
  select tuple(1,[2,3], map('4', 5))::Tuple(i1 Int32, a1 Array(Int32), m1 Map(LowCardinality(String), Int32))
  

If you're using Java client, please be aware of below changes which may or may not cause compiling errors:

• many methods changed to return ClickHouseInputStream/ClickHouseOutputStream instead of plain InputStream/OutputStream
• ClickHouseLZ4InputStream and ClickHouseLZ4OutputStream are removed

This is a patch release for fixing below issues in both Java client and JDBC driver.

• fix backward compatibility issue in legacy driver - #862
• fix rounding error when converting Float/Double value to BigDecimal - #864
• enable read-only support in JDBC driver - #866

In addition, there are a few more changes were merged from 0.3.3 branch:

• ResultSet.unwrap() now supports ClickHouseRecord(current row) in addition to ClickHouseResponse(whole results)
• ClickHouseColumn now provides estimated byte length, which can be used in read/write optimization
• synchronous methods ClickHouseClient.executeAndWait() and Mutation.sendAndWait() for ease of use

This is a patch release for fixing below issues in both Java client and JDBC driver.

• enhance Bool support - #848
• fix confusing error message metioned in #849
• fix issue of writing Date32 value in RowBinary format
• fix OffsetDateTime parsing error
• fix NumberFormatExcption when parsing primitive array with null value
• fix incorrect column type used in Connection.createArrayOf method
• enhance PreparedStatement by treating insert into table(col1,col2,col3) values(?,?,?) as insert into table(col1,col2,col3)