Altinity Software Releases
List of releases of Altinity Software.
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.
Altinity Backup for ClickHouse
Altinity Dashboard for Kubernetes
Altinity Grafana Plugin for ClickHouse
Altinity Kubernetes Operator
Altinity Stable for ClickHouse
Altinity Tableau Connector for ClickHouse
Altinity.Cloud Release Notes
ODBC Driver for ClickHouse ReleaseNotes
defaults:
storageManagement:
provisioner: Operator
Fixed
New Contributors
Full Changelog : https://github.com/Altinity/clickhouse-operator/compare/release-0.19.3...release-0.20.0
Download at: https://github.com/Altinity/clickhouse-operator/releases/tag/release-0.20.0
Return to the top.
Released: 2022-08-24
What’s Changed
Full Changelog : https://github.com/Altinity/clickhouse-operator/compare/0.19.0...release-0.19.1
Download at: https://github.com/Altinity/clickhouse-operator/releases/tag/release-0.19.1
Return to the top.
Released: 2022-12-29
Release Notes
Based on upstream/v22.3.15.33-lts
Bug fix
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
Improvement
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:
Return to the top.
Released: 2022-10-06
Release Notes
Based on upstream/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:
Return to the top.
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
Other
Full list of changes
Available at:
Return to the top.
Released: 2021-06-16
Changes between 21.1.10.3 and 21.1.9.41
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 : 1 c60717e - 116 b - 445 f - b675 - 7 b9cac35c262
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 : 484 baec9 - 6 d00 - 4 c66 - a792 - 85 a270d6f2f2
┌─ parseDateTimeBestEffortOrZero ( '' ) ─┐
│ 1970 - 01 - 01 03 : 00 : 00 │
└───────────────────────────────────┘
ClickHouse Altinity Stable packages for this release can be found at:
Return to the top.
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.
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.
Released: 2022-12-27
Added
User is notified with a warning sign when backups are not configured
User is notified with a popup message when data migration is completed or failed
‘Delete table’ action is added to Data Consistency tab
List of databases granted to ClickHouse user are displayed
Quick filter was added in order to see unhealthy nodes on a Dashboard page
Cluster tags for GCP environments in order to split costs by clusters
Changed
‘Environment Settings’ was renamed to ‘Environment Variables’ on the cluster page
DBA tools UI was made more intuitive
Improved new Anywhere environment setup process
Improved ‘Data Rebalance’ function that could sometimes move too much data
Backup configuration is moved to a separate resource instead of being bundled with ClickHouse configuration. This change requires restart.
Backup stability improvements, upgrade clickhouse-backup to 2.1.3 version
Upgraded clickhouse-operator to 0.20.1
n2d-standard-64 is now available by default for GCP clusters
Fixed
Fixed a bug when node status was not updated for a few minutes after ClickHouse cluster is up an running
Fixed a bug with backup being restored from AWS to GCP environments or vice versa could fail due to mismatching node types
Fixed a bug when Rescale ignored auto publishing being turned off
Fixed a bug when ‘Run DDL ON CLUSTER’ did switch off automatically when specific node is selected
Fixed a bug with rescaling GCP clusters in old tenants
Fixed a bug when profile settings could not be changed on a cluster that can not start
Fixed Data Migration tool that did not work in Anywhere environments due to hard-coded tolerations
Fixed a bug with backup compression format was not respected for GCP clusters
Fixed a bug with memory and volume graphs displaying incorrect data
Return to the top.
Released: 2022-11-14
Added
Used/available quota is now displayed when starting a cluster
New System Metrics Grafana dashboard
Reset Anywhere action in order to disconnect from the Anywhere environment
Rebalance data across storage volumes
Tracking customer credits when invoicing
Changed
In the list of accounts, environments for a particular account are now displayed
Anywhere connection wizard has been improved
Sensitive environment settings are back to readonly for non-Anywhere clusters
Multiple improvements to backup functionality
Multiple improvements to Copy Data between Clusters feature
Log storage has been migrated to Grafana Loki
Fixed
Fixed latest backup timestamp that has not been updated sometimes
StatusCheck now works for Anywhere environments
Billing estimates are now correct for Anywhere clusters
MaterializedView tables are now correctly restored when using Consistency check tool
Fixed a UI bug with ClickHouse version was not displayed when one of cluster nodes was down
Fixed Kafka Connection tool generated XML that was sometimes incorrect
Fixed Environment Variable settings page that did not allow to specify non-secret settings
Fixed a bug that did not allow to restore GCP backup to AWS or vice versa to an automatically created cluster due to incorrect node specifications
Billing reports are now displayed correctly for Anywhere clusters
Return to the top.
Released: 2022-09-15
Added
New ‘Errors’ tab under DBA tools
New ‘Cluster Consistency’ tab under DBA tools
Allow to restrict access to cluster management for Altinity stuff
Setup and initial configuration of Anywhere environments
Dashboard is enabled for env and org admins
Copy Data feature is enabled for env and org admins
Logging into Loki for Anywhere tenants
Option to turn on ClickHouse SQL access management for users
Pod status in the Node view
Environment variables from a k8s secret
Changed
Processes tab have been improved
Multi-statements now can be executed in Explorer
When ClickHouse cluster is upgraded to the new version, the UI now allows to easily pick Altinity.Stable and Community versions
ClickHouse version upgrade recommendations have been improved
When user returns with a direct cluster link, cluster Environment is automatically selected as a current one
Fixed
Fixed sort order in a list of nodes dropdown in Explorer
Fixed backup restore scenarios between different environments and clusters
Fixed a bug with detached parts could not be deleted for ‘.inner.’ tables
Fixed Kafka connection tool in GCP environments
Return to the top.
Released: 2022-08-15
Added
Added a feature to convert from non-replicated to replicated MergeTree (available for Altinity staff only)
Data Migration Tool to copy data between clusters (available for Altinity staff only)
New ‘Launch from Backup’ wizard that allows to pick any backup source, including outside of Altinity.Cloud
Replication status in Workload
Alert cluster owners when Altinity access level is changed
Backlink button to the Environment page
Proxy connection mode for Anywhere clusters
Changed
Workload tab was refactored to show 3 panels: Queries, Replication and Processes
Workload is sorted in descending order by default
Table creation hints were updated in Explorer
Improved loading test datasets feature
User is automatically redirected to the last visited page on re-login
Fixed
Fixed restoring a backup in sharded and replicated cluster with tables replicated to every shard
Fixed sorting order in dashboard
Last insert timestamp now displays timestamp for Kafka inserts correctly now
Fixed SELECT ALL IGNORED for detached parts
Return to the top.
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.
Altinity Backup for ClickHouse Release Notes
Altinity Dashboard for Kubernetes Release Notes
clickhouse-operator Release Notes
Altinity Stable for ClickHouse Release Notes
Altinity Grafana Plugin for ClickHouse Release Notes
ODBC Driver for ClickHouse ReleaseNotes
Altinity Tableau Connector for ClickHouse Release Notes
Feedback
Was this page helpful?
Yes
No
Glad to hear it!
Sorry to hear that. We'll track this issue and see how we can improve.
Last modified 2022.03.11: Updated with qa approved `20220311_steinsgate`.