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.

• Altinity Stable for ClickHouse 22.8
• 2023-04-14 Altinity Stable for ClickHouse 22.8.15
• 2023-02-13 Altinity Stable for ClickHouse 22.8.13
• Altinity Stable for ClickHouse 22.3
• 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

• 2023-04-11 Altinity.Cloud 23.2.33
• 2023-02-21 Altinity.Cloud 23.1.22
• 2022-12-27 Altinity.Cloud 22.12.27

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

Altinity Stable for ClickHouse

Altinity Stable for ClickHouse 22.8

Altinity Stable for ClickHouse 22.8.15

Released: 2023-04-14
For more details, see the full release notes.

 

Return to the top.


Altinity Stable for ClickHouse 22.8.13

Released: 2023-02-13
A few months ago, we certified the ClickHouse 22.3 release. It was delivered together with the Altinity Stable build for ClickHouse. Since then many things have happened to ClickHouse. On the Altinity side we continued to put in features but really focused on build process and testing. We started testing the new ClickHouse LTS release 22.8 as soon as it was out in late August. It took us several months to confirm 22.8 is ready for production use and to make sure upgrades go smoothly. As of 22.8.13 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 22.3

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.Cloud Release Notes

Altinity.Cloud 23.2.33

Released: 2023-04-11


Added

• The Backup configuration is now available on a cluster level
  • Different clusters can now have different backup settings
• New volume performance guidelines when starting a cluster
• Users are now alerted that profile setting is used instead of a server setting
• New resource limit for total number of nodes
• Can now exclude an individual node from a load balancer
• Users can now add custom Grafana dashboards
• Support for using alternate cluster names
• Changes for Altinity staff only:
  • Added New Altinity Support role
  • Discounts management

Changed

• The SHARE button has been renamed to INVITE
• The Rescale screen now shows storage units
• “Kafka Connection Check” has been moved to the Cluster page
• Notifications now include FQDN for cluster names
• Environment dashboard improvements
• Changes to environment backup settings are now automatically applied to clusters
• Additional DataDog regions now available

Fixed

• Fixed “Copy Data between Clusters” for Anywhere environments with custom node taints
• Fixed a bug in Node View where they were not available for offline nodes
• Rebalance is back and available for envadmins

 

Return to the top.


Altinity.Cloud 23.1.22

Released: 2023-02-21


Added

• Clone database feature that allows to clone database w/o data copy on same host
• Force restart of an individual node
• Show pod events in a node view
• Current quota usage is now displayed on an environment screen
• User role can be specified when inviting user to an environment
• Progress bar when applying changes to a cluster
• Operator managed persistence is now default for new environments, and can be turned on for existing ones. It allows to re-scale volumes w/o downtime
• Re-publish ZK clusters

Changed

• Backup configuration is currently always deployed, even if schedule is disabled
• ClickHouse version recommendations were improved
• IAM-managed access to backup bucket is now allowed
• Data rebalance UI has been improved
• Cluster are now sorted alphabetically
• Asynchronous metrics log frequency is reduced for new clusters
• Changed some ‘default’ profile settings (part of operator release):
  • Enabled ‘do_not_merge_across_partitions_select_final’
  • Set ’load_balancing’ to ’nearest_hostname’
  • Set niceness (‘os_thread_priority’) to 2.

Fixed

• Fixed data consistency checks for 3 replica clusters
• Improved loading speed for Accounts screen
• Copy Data wizard can now work with non-Altinity.Cloud ClickHouse
• Fixed Auth0 integration with Okta

Fixed in 23.1.23 2022-03-10

• Fixed a bug with version upgrades for ClickHouse 23.1 and above that might result in cluster not going online after restart
• Fixed a bug with “Workload->Replication” screen did not display any results
• Fixed a bug with “Copy Data Between Clusters” tool that did not work correctly in a replicated cluster with non-partitioned tables in some cases
• Display an error message if “Schema Consistency -> Create table on all nodes” fails with an error

 

Return to the top.


Altinity.Cloud 22.12.27

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.


Altinity Backup for ClickHouse

Altinity Kubernetes Operator

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.