Fix for exponential time decaying window functions. Now respecting boundaries of the window. #36944 by @excitoon
Fixes for objects removal in S3ObjectStorage #37882 by @excitoon
Fixed Unknown identifier (aggregate-function) exception #39762 by @quickhouse
Fixed point of origin for exponential decay window functions #39593 by @quickhouse
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
Fix ArrowColumn dictionary conversion to LowCardinality strings. #40037 by #arthurpassos

Improvement

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

Changes in upstream from `v22.3.12.19-lts` to `v22.3.15.33-lts`

New Feature

Add setting to disable limit on kafka_num_consumers. Closes #40331. #40670 (Kruglov Pavel).

Improvement

Update tzdata to 2022f. Mexico will no longer observe DST except near the US border: https://www.timeanddate.com/news/time/mexico-abolishes-dst-2022.html. Chihuahua moves to year-round UTC-6 on 2022-10-30. Fiji no longer observes DST. See https://github.com/google/cctz/pull/235 and https://bugs.launchpad.net/ubuntu/+source/tzdata/+bug/1995209. #42796 (Alexey Milovidov).
Fix issue with passing MySQL timeouts for MySQL database engine and MySQL table function. Closes #34168. #40751 (Kseniia Sumarokova).
Now ALTER MODIFY COLUMN DataType to Nullable(DataType) doesn’t require mutation. #27787 (victorgao).

Bug fix

Fixed primary key analysis with conditions involving toString(enum). #43596 (Nikita Taranov).
Fixed queries with SAMPLE BY with prewhere optimization on tables using Merge engine. #43315 (Antonio Andelic).
This closes #42453. #42573 (Alexey Milovidov).
Choose correct aggregation method for LowCardinality with BigInt. #42342 (Duc Canh Le).
Fix a bug with projections and the aggregate_functions_null_for_empty setting. This bug is very rare and appears only if you enable the aggregate_functions_null_for_empty setting in the server’s config. This closes #41647. #42198 (Alexey Milovidov).
Fix possible crash in SELECT from Merge table with enabled optimize_monotonous_functions_in_order_by setting. Fixes #41269. #41740 (Nikolai Kochetov).
Fix possible pipeline stuck exception for queries with OFFSET. The error was found with enable_optimize_predicate_expression = 0 and always false condition in WHERE. Fixes #41383. #41588 (Nikolai Kochetov).
Writing data in Apache ORC format might lead to a buffer overrun. #41458 (Alexey Milovidov).
The aggregate function categorialInformationValue was having incorrectly defined properties, which might cause a null pointer dereferencing at runtime. This closes #41443. #41449 (Alexey Milovidov).
Malicious data in Native format might cause a crash. #41441 (Alexey Milovidov).
Add column type check before UUID insertion in MsgPack format. #41309 (Kruglov Pavel).
Queries with OFFSET clause in subquery and WHERE clause in outer query might return incorrect result, it’s fixed. Fixes #40416. #41280 (Alexander Tokmakov).
Fix possible segfaults, use-heap-after-free and memory leak in aggregate function combinators. Closes #40848. #41083 (Kruglov Pavel).
Fix memory leak while pushing to MVs w/o query context (from Kafka/…). #40732 (Azat Khuzhin).
Fix potential dataloss due to a bug in AWS SDK (https://github.com/aws/aws-sdk-cpp/issues/658). Bug can be triggered only when clickhouse is used over S3. #40506 (alesapin).
Proxy resolver stop on first successful request to endpoint. #40353 (Maksim Kita).
Fix rare bug with column TTL for MergeTree engines family: In case of repeated vertical merge the error Cannot unlink file ColumnName.bin ... No such file or directory. could happen. #40346 (alesapin).
Fix potential deadlock in WriteBufferFromS3 during task scheduling failure. #40070 (Maksim Kita).
Update simdjson. This fixes #38621. #38838 (Alexey Milovidov).
Fix cast lowcard of nullable in JoinSwitcher, close #37385. #37453 (Vladimir C).

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.12

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

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

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.