Altinity Stable for ClickHouse

Most recent releases organized by major release and release date:

• 2022-10-06 Altinity Stable for ClickHouse 22.3.12
• 2022-08-24 Altinity Stable for ClickHouse 22.3.10
• 2022-07-21 Altinity Stable for ClickHouse 22.3.8

• 2022-04-15 Altinity Stable for ClickHouse 21.8.15

• 2022-06-01 Altinity Stable for ClickHouse 21.1.11.3
• 2021-06-16 Altinity Stable for ClickHouse 21.1.10.3

• 2021-02-03 Altinity Stable for ClickHouse 20.8.12.2

• 2020-09-23 Altinity Stable for ClickHouse 20.3.19.4

Altinity Stable for ClickHouse 22.3

Altinity Stable for ClickHouse 22.3.12

Released: 2022-10-06


Release Notes

Based on upstream/v22.3.12.19-lts

Changes Compared to Community Build v22.3.12.19-lts

Bug fix

• 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)
• Fix unused unknown columns introduced by WITH statement #39131 by @amosbird
• Fix memory leak while pushing to MVs w/o query context (from Kafka/…) by @azat

Improvement

• Optimized processing of ORDER BY in window functions #34632 by @excitoon (via #164)
• Support batch_delete capability for GCS #37659 by @frew (via #164)
• Add support for extended (chunked) arrays for Parquet format #40485 by @arthurpassos

Build/Testing/Packaging Improvement

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

Changes in upstream from v22.3.10.22-lts to v22.3.12.19-lts

Bug fix

• Fix clickhouse-server doinst.sh. #40681 by @Felixoid.
• fix heap buffer overflow by limiting http chunk size. #40292 by @CheSema.
• Fix possible segfault in CapnProto input format’. #40241 by @Avogar.
• Fix insufficient argument check for encryption functions’. #40194 by @alexey-milovidov.
• Fix HashMethodOneNumber with const column. #40020 by @canhld94.
• Fix seeking while reading from encrypted disk. #39687 by @vitlibar.
• Fix number of threads for pushing to views’. #39253 by @azat.

Other

• collectFilesToSkip() in MutateTask now supports new index file extension .idx2 for MinMax. #40122 by @robot-ch-test-poll2.
• Clean out clickhouse-server.service from /etc. #39323 by @Felixoid.

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 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 22.3.8

Released: 2022-07-21
A few months ago we certified 21.8 as an Altinity Stable release. It was delivered together with the Altinity Stable build for ClickHouse. Since then many things have happened to ClickHouse. In Altinity we continued to work on newer releases and run them in-house. We completed several new features, and many more have been added by community contributors. We started testing the new ClickHouse LTS release 22.3 as soon as it was out in late March. It took us more than three months to confirm 22.3 is ready for production use and to make sure upgrades go smoothly. As of 22.3.8 we are confident in certifying 22.3 as an Altinity Stable release. For more details, see the full release notes.

 

Return to the top.


Altinity Stable for ClickHouse 21.8

Altinity Stable for ClickHouse 21.8.15

Released: 2022-04-15


Release Notes

Based on upstream/v21.8.15.7-lts.

ClickHouse release v21.8.15.7-altinitystable as compared to community ClickHouse v21.8.15.7:

Changes compared to the Community Build

Bug Fixes

• Bug Fix: Fixed issue with merging configs that have and root XML tags. (backport of ClickHouse@213ecae) (via #114).
• Bug Fix: Backport of ClickHouse#31823 to 21.8: Fix invalid cast of nullable type when nullable primary key is used (via #110)

Features

• Build/Testing/Packaging Improvement: Various macOS compilation and packaging fixes/backporting (via #108)
• Build/Testing/Packaging Improvement: Minor test improvements (via afb4a0a, 4c35386)

Changes compared to Altinity Stable 21.8.13.1

Bug Fixes

• Fix segfault while parsing ORC file with corrupted footer. Closes ClickHouse#33797 via ClickHouse#33984 Kruglov Pavel.
• Fix usage of functions array and tuple with literal arguments in distributed queries. Previously it could lead to Not found columns exception. ClickHouse#33938 (Anton Popov).
• Fix s3 table function reading empty file. Closes ClickHouse#33008 via ClickHouse#33037 (Kseniia Sumarokova).
• Fix hdfs url check that didn’t allow using HA namenode address. Bug was introduced in ClickHouse#31042. ClickHouse#32976 (Kruglov Pavel).
• Server might fail to start if database with MySQL engine cannot connect to MySQL server, it’s fixed. Fixes ClickHouse#14441 via ClickHouse#32802 (tavplubix).

Test Results

• QA Software Build Report
• Altinity Test Reports for v21.8.15.15 x86_64

Packages

• Deb/RPMs: https://builds.altinity.cloud/
• Docker image: altinity/clickhouse-server:21.8.15.15.altinitystable
• Homebrew formula: clickhouse@21.8-altinity-stable-21.8.15.15

 

Return to the top.


Altinity Stable for ClickHouse 21.3

Altinity Stable for ClickHouse 21.1

Altinity Stable for ClickHouse 21.1.11.3

Released: 2022-06-01


This is a security update to 21.1.10.3 release. It backports fixes for several CVEs into 21.1 version:

• CVE-2021-43304
• CVE-2021-43305
• CVE-2021-42387
• CVE-2021-42388
• CVE-2021-42389
• CVE-2021-42390
• CVE-2021-42391

As we discussed in a recent Altinity Blog article, JFrog discovered these CVEs and reported them to the Yandex team in 2021. The CVEs have been already included in 21.3.19 and 21.8.11 and Altinity.Stable and ClickHouse builds and all ClickHouse builds after 21.10.

We have now backported the fixes to 21.1 as part of our long-term maintenance policy for Altinity Stable builds. We recommend all users running ClickHouse 21.1 upgrade to this new release.

• Deb/RPMs: https://builds.altinity.cloud
• Docker Image: altinity/clickhouse-server:21.1.11.3.altinitystable

 

Return to the top.


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.