Altinity Software Releases

Releases for all Altinity products for the last six months are listed below, organized by Product and Release Date. Please select either the Product or the specific Release Note to be view a summary of the release note.

For all Release Notes for a product, select the product from the navigation bar to the right.

• 2022-07-28 Altinity Backup for ClickHouse 1.5.0

• Altinity Stable for ClickHouse 22.3
• 2022-08-24 Altinity Stable for ClickHouse 22.3.10
• Altinity Stable for ClickHouse 21.8
• Altinity Stable for ClickHouse 21.3
• Altinity Stable for ClickHouse 21.1
• 2021-06-16 Altinity Stable for ClickHouse 21.1.10.3
• Altinity Stable for ClickHouse 20.8
• 2021-02-03 Altinity Stable for ClickHouse 20.8.12.2
• Altinity Stable for ClickHouse 20.3
• 2020-09-23 Altinity Stable for ClickHouse 20.3.19.4

• 2021-08-22 Altinity ODBC Driver for ClickHouse 1.1.10.0210822 Release Notes

Altinity Stable for ClickHouse

Altinity Stable for ClickHouse 22.3

Altinity Stable for ClickHouse 22.3.10

Released: 2022-08-24


Release Notes

Changes from ClickHouse v22.3.10.22-LTS

Changes Compared to Community Build v22.3.10.22-lts:

Bug Fixes

• Fix for exponential time decaying window functions. Now respecting boundaries of the window #36944 by @excitoon (via #164)
• Fixes for objects removal in S3ObjectStorage #37882 by @excitoon (via #164)
• Fixed Unknown identifier (aggregate-function) exception #39762 by @quickhouse (via #189)
• Fixed point of origin for exponential decay window functions #39593 by @quickhouse (via #190)
• Reverted ‘Fix seeking while reading from encrypted disk’ https://github.com/ClickHouse/ClickHouse/pull/39687, known to cause issues in 22.3 (via #https://github.com/Altinity/ClickHouse/pull/193)
• Reverted: ‘Enable using constants from with and select in aggregate function parameters.’ https://github.com/ClickHouse/ClickHouse/pull/27531, causes problems on 22.3 (via #194)

Improvements

• Improvement: Optimized processing of ORDER BY in window functions #34632 by @excitoon (via #164)
• Improvement: Support batch_delete capability for GCS #37659 by @frew (via #164)

Build/Testing/Packaging Improvements

• Build/Testing/Packaging Improvement: Allow Github workflows to run on Altinity’s infrastructure

Changes from v22.3.8.39-lts to v22.3.10.22-lts

Bug Fixes

• ‘Fix CANNOT_READ_ALL_DATA with pread_threadpool.’. #39800 (Anton Popov).
• ‘Fix seeking while reading from encrypted disk’. #39687 (Vitaly Baranov).
• ‘Fix bug with maxsplit in the splitByChar’. #39552 (filimonov).
• ‘Fix data race and possible heap-buffer-overflow in Avro format’. #39498 (Kruglov Pavel).
• ‘Fix incorrect postgresql query which fetches tables list’. #39283 (Kseniia Sumarokova).
• ‘Fix segfault in materialised postgresql’. #39272 (Kseniia Sumarokova).
• ‘removed default queue arguments’. #39259 (rnbondarenko).
• ‘Fix reading of sparse columns from s3’ #37978 via #39206 (robot-ch-test-poll).
• ‘Fix reading from s3 in some corner cases’ #38239. via #39206 (robot-ch-test-poll).
• ‘prewhere action should preserve sorting columns’. #39157 (Yakov Olkhovskiy).
• ‘Fix insert into MV with enabled extremes.’. #39125 (Nikolai Kochetov).
• ‘Fix for fs cache’. #39070 (Kseniia Sumarokova).
• ‘Remove logging from OvercommitTracker to avoid deadlocks’. #39030 (Dmitry Novik).
• ‘Fix reading of sparse columns from s3’. #37978 (Anton Popov).
• ‘Fix some issues with low cardinality and async reads from remote fs’. #36763 (Kseniia Sumarokova).
• ‘Fix performance regression of scalar query’. #35986 (Amos Bird).

Other

• ‘Change mysql-odbc url’. #39702 (Mikhail f. Shiryaev).
• ‘Replace MemoryTrackerBlockerInThread to LockMemoryExceptionInThread’. #39619 (Nikolai Kochetov).
• ‘Add docker_server.py running to backport and release CIs’. #39011 (Mikhail f. Shiryaev).
• ‘Retry docker buildx commands with progressive sleep in between’. #38898 (Mikhail f. Shiryaev).

Full list of changes

Available at:

• Tested binaries: https://builds.altinity.cloud/
• Docker: https://hub.docker.com/r/altinity/clickhouse-server
• Brew: https://github.com/Altinity/homebrew-clickhouse

 

Return to the top.


Altinity Stable for ClickHouse 21.8

Altinity Stable for ClickHouse 21.3

Altinity Stable for ClickHouse 21.1

Altinity Stable for ClickHouse 21.1.10.3

Released: 2021-06-16


Changes between 21.1.10.3 and 21.1.9.41

• background_fetches_pool_size is set to 8. This is better for production usage with frequent small insertions or slow ZooKeeper clusters.
• Fixed the error ‘Cannot find column in ActionsDAG result', which may happen if subquery uses untuple. https://github.com/ClickHouse/ClickHouse/issues/22290
• Fixed quantile(s)TDigest that could produce non-accurate results in some edge cases: https://github.com/ClickHouse/ClickHouse/issues/22408
• Fixed a bug with accessing S3 buckets when the object URL contained ‘+’ sign: https://github.com/clickHouse/clickHouse/pull/23822

The complete diff between Altinity and community versions can also be viewed at github:

https://github.com/ClickHouse/ClickHouse/compare/v21.1.9.41-stable…Altinity:v21.1.10.3-altinity+stable

Changes between ClickHouse Altinity Stable Release 21.1.9.41 and ClickHouse Altinity Stable Release 21.1.7.1

• Fixed a bug with distributed queries that could sometimes fail with ‘Unknown packet n from server’ error message: https://github.com/ClickHouse/ClickHouse/issues/21588

• Fixed several issues with mutations handling (e.g. https://github.com/ClickHouse/ClickHouse/issues/22013)

• Fix a rare bug when quorum insert with iinsert_quorum_parallel=1 is not really a “quorum” because of deduplication

• Fixed a possible buffer overflow in token bloom filter index: https://github.com/ClickHouse/ClickHouse/issues/19233

• Fixed a bug when nullable types sometimes could not be retrieved: https://github.com/ClickHouse/ClickHouse/issues/21116

• Fixed a bug with replicated tables metadata not properly cleaned from the non-primary ZooKeeper instance: https://github.com/ClickHouse/ClickHouse/issues/21054

• Added parseDateTimeBestEffortOrZero to allow for empty values, while parseDateTimeBestEffort will not work with empty values. For example:

  SELECT parseDateTimeBestEffort('')
  
  Query id: 1c60717e-116b-445f-b675-7b9cac35c262
  
  
  0 rows in set. Elapsed: 0.003 sec.
  
  Received exception from server (version 21.11.1):
  Code: 41. DB::Exception: Received from localhost:9000. DB::Exception: Cannot read DateTime: neither Date nor Time was parsed successfully: While processing parseDateTimeBestEffort(''). (CANNOT_PARSE_DATETIME)
  
  SELECT parseDateTimeBestEffortOrZero('')
  
  Query id: 484baec9-6d00-4c66-a792-85a270d6f2f2
  
  ┌─parseDateTimeBestEffortOrZero('')─┐
  │               1970-01-01 03:00:00 │
  └───────────────────────────────────┘
  

ClickHouse Altinity Stable packages for this release can be found at:

• Deb packages: https://packagecloud.io/Altinity/altinity-stable
• RPM packages: https://packagecloud.io/Altinity/altinity-stable
• Docker image: altinity/clickhouse-server:21.1.10.3.altinity_stable

 

Return to the top.


Altinity Stable for ClickHouse 20.8

Altinity Stable for ClickHouse 20.8.12.2

Released: 2021-02-03


Description

Bug fixes.

Bug Fixes

• Fixed a rare bug that may result in corrupted data when merging from wide to compact parts. We recommend upgrading to this release all 20.8 users who are using compact parts.

 

Return to the top.


Altinity Stable for ClickHouse 20.3

Altinity Stable for ClickHouse 20.3.19.4

Released: 2020-09-23


Description

The release includes several dozen bug fixes from the previous release.

Major New Features

• Server startup time has been reduced by parsing metadata in parallel.
• Improved performance of primary key analysis for LowCardinality columns. That was a performance regression introduced in 20.3.
• Improved performance of queries with large tuples and tuples used in primary key.

Bug Fixes

• Fixed a bug that prevented attaching Materialized Views to system tables.
• Fixed incorrect behavior of if function with NULLs.
• Fixed segfaults in rare cases.
• Fixed a bug that prevented predicate pushdown for queries using WITH clause.
• Fixed SIGSEGV in Kafka engine when broker is unavailable.
• Fixed a bug leading to block structure mismatch error for queries with UNION and JOIN.
• Fixed TTL processing logic to process all partitions in one run.
• Fixed a bug of parsing of row policies from configuration files that could result in missing policies sometimes.
• Fixed a bug with ALTER TABLE UPDATE could produce incorrect results when updating Nullable columns.
• Fixed a bug with codecs not working properly for MergeTree compact parts.

References

Updated RPM packages for Altinity Stable Release can be found in the Altinity Stable Repository. The ClickHouse repository can be used for DEB packages but check version numbers carefully.

 

Return to the top.


Altinity Backup for ClickHouse

Altinity Backup for ClickHouse 1.5.0

Released: 2022-07-28


IMPROVEMENTS

• Try to improve implementation check_replicas_before_attach configuration to avoid concurrent ATTACH PART execution during restore command on multi-shard cluster, fix 474

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.5.0

 

Return to the top.


Altinity Kubernetes Operator

Altinity.Cloud Release Notes

Altinity Dashboard for Kubernetes

Altinity Plugin Grafana for ClickHouse

Altinity Tableau Connector for ClickHouse

ODBC Driver for ClickHouse ReleaseNotes

Altinity ODBC Driver for ClickHouse 1.1.10.0210822 Release Notes

Released: 2021-08-22


WARNING: Before upgrading to a new version of the driver, make sure you read the release notes of all intermediate versions!

• Fixed compilation for recent versions of GCC/Clang/AppleClang (#356)
• Fixed handling of Null values and Nothing type (#356)
• Fixed DateTime type as String issues (#356)
• Implemented parametrized early connection/credential error detection (#356)
• Implemented parametrized big integer types handling as strings (#356)
• Various lesser fixes for ClickHouse ODBC-based Tableau connector

Download at: https://github.com/ClickHouse/clickhouse-odbc/releases/tag/v1.1.10.20210822

 

Return to the top.