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

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

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

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.