ClickHouse/clickhouse-jdbc v0.3.1

Release v0.3.1

on GitHub

This is a feature release with breaking changes and known issues(expected to be fixed in 0.3.2). It's NOT recommended to upgrade if you feel comfortable with 0.2.x. If your work relies on non-JDBC APIs, you may want to wait until we're done with the refactoring in 0.4.0.

• KNOWN ISSUES
  • Incorrect DateTime is sent to ClickHouse when server/column timezone is not UTC - #623
    Note: a workaround is to use unix timestamp for mutation.
  • Lost millisecond precision when inserting DateTime64 - #608
• BREAKING CHANGES
  • move query from url to request body
  • always parse SQL(use extended API to skip that)
  • remove keepAliveTimeout and useNewParser from ClickHouseProperties
  • exclude RoaringBitmap from shaded jar
• NEW FEATURES
  • add new connection setting useSharedCookieStore to achieve "read your writes" consistency
  • add new query parameters: allow_experimental_bigint_types, allow_experimental_map_type, and join_algorithm
  • add new format: CustomSeparated and RowBinaryWithNamesAndTypes
  • support batch processing with arbitrary query - update and delete are not recommended so there are warnings
  • support multi-statement sql - session will be used automatically and only the last result will be returned
• BUG FIXES
  • fix 400 bad request error when dealing with large query
  • fix parser issue when DESC statement contains alias