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.

• 2022-07-28 Altinity Backup for ClickHouse 1.5.0
• 2022-07-26 Altinity Backup for ClickHouse 1.4.8
• 2022-07-26 Altinity Backup for ClickHouse 1.4.9
• 2022-07-25 Altinity Backup for ClickHouse 1.4.7
• 2022-07-04 Altinity Backup for ClickHouse 1.4.6
• 2022-06-23 Altinity Backup for ClickHouse 1.4.5
• 2022-06-20 Altinity Backup for ClickHouse 1.4.3
• 2022-06-20 Altinity Backup for ClickHouse 1.4.4
• 2022-06-08 Altinity Backup for ClickHouse 1.4.2
• 2022-05-31 Altinity Backup for ClickHouse 1.4.1
• 2022-05-25 Altinity Backup for ClickHouse 1.4.0
• 2022-04-18 Altinity Backup for ClickHouse 1.3.2

• 2022-06-24 Altinity Dashboard for Kubernetes 0.1.4 Release Notes
• 2022-05-05 Altinity Dashboard for Kubernetes 0.1.3 Release Notes

• 2022-07-15 Altinity Kubernetes Operator 0.19.0
• 2022-05-12 Altinity Kubernetes Operator 0.18.5
• 2022-04-13 Altinity Kubernetes Operator 0.18.4

• 2022-06-01 Altinity Grafana Plugin for ClickHouse 2.5.0

• Altinity Stable for ClickHouse 22.3
• 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
• Altinity Stable for ClickHouse 21.8
• 2022-04-15 Altinity Stable for ClickHouse 21.8.15
• Altinity Stable for ClickHouse 21.3
• Altinity Stable for ClickHouse 21.1
• 2022-06-01 Altinity Stable for ClickHouse 21.1.11.3
• 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

• 2022-09-15 Altinity.Cloud 22.10.24
• 2022-08-15 Altinity.Cloud 22.9.21
• 2022-07-07 Altinity.Cloud 22.8.15
• 2022-06-03 Altinity.Cloud 22.7.13
• 2022-05-13 Altinity.Cloud 22.6.18
• 2022-04-25 Altinity.Cloud 22.5.15

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

Altinity Backup for ClickHouse

Altinity Backup for ClickHouse 1.5.0

Released: 2022-07-28


IMPROVEMENTS

• Try to improve implementation check_replicas_before_attach configuration to avoid concurrent ATTACH PART execution during restore command on multi-shard cluster, fix 474

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.5.0

 

Return to the top.


Altinity Backup for ClickHouse 1.4.8

Released: 2022-07-26


IMPROVEMENTS

• Add check_replicas_before_attach configuration to avoid concurrent ATTACH PART execution during restore command on multi-shard cluster, fix 474 allow backup list when clickhouse server offline, fix 476

BUG FIXES

• Resolve {uuid} macros during restore for ReplicatedMergeTree table and ClickHouse server 22.5+, fix 466

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.4.8

 

Return to the top.


Altinity Backup for ClickHouse 1.4.9

Released: 2022-07-26


BUG FIXES

Fix download behavior for parts which contains special characters in name, fix 462

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.4.9

 

Return to the top.


Altinity Backup for ClickHouse 1.4.7

Released: 2022-07-25


IMPROVEMENTS

• PROPERLY restore to default disk if disks not found on destination clickhouse server, fix 457

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.4.7

 

Return to the top.


Altinity Backup for ClickHouse 1.4.6

Released: 2022-07-04


BUG FIXES

• Fix infinite loop error can’t acquire semaphore during Download: context canceled, and error can’t acquire semaphore during Upload: context canceled all 1.4.x users recommends upgrade to 1.4.6

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.4.6

 

Return to the top.


Altinity Backup for ClickHouse 1.4.5

Released: 2022-06-23


IMPROVEMENTS

• Add CLICKHOUSE_FREEZE_BY_PART_WHERE option which allow freeze by part with WHERE condition, thanks @vahid-sohrabloo

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.4.5

 

Return to the top.


Altinity Backup for ClickHouse 1.4.3

Released: 2022-06-20


IMPROVEMENTS

• Add API_INTEGRATION_TABLES_HOST option to allow use DNS name in integration tables system.backup_list, system.backup_actions

BUG FIXES

• Fix upload_by_part: false max file size calculation, fix 454

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.4.3

 

Return to the top.


Altinity Backup for ClickHouse 1.4.4

Released: 2022-06-20


IMPROVEMENTS

• Download and restore to default disk if disks not found on destination clickhouse server, fix 457

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.4.4

 

Return to the top.


Altinity Backup for ClickHouse 1.4.2

Released: 2022-06-08


BUG FIXES

• Fix --partitions parameter parsing, fix 425

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.4.2

 

Return to the top.


Altinity Backup for ClickHouse 1.4.1

Released: 2022-05-31


BUG FIXES

• Fix upload data go routines waiting, expect the same upload speed as 1.3.2.

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.4.1

 

Return to the top.


Altinity Backup for ClickHouse 1.4.0

Released: 2022-05-25


IMPROVEMENTS

• Add S3_ALLOW_MULTIPART_DOWNLOAD to config, to improve download speed, fix 431.
• Add support backup/restore user defined functions, fix 420.
• Add clickhouse_backup_number_backups_remote, clickhouse_backup_number_backups_local, clickhouse_backup_number_backups_remote_expected,clickhouse_backup_number_backups_local_expected prometheus metric, fix 437.
• Add ability to apply system.macros values to path field in all types of remote_storage, fix 438.
• Use all disks for upload and download for mutli-disk volumes in parallel when upload_by_part: true fix 400.

BUG FIXES

• fix wrong warning for .gz, .bz2, .br archive extensions during download, fix 441.

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.4.0

 

Return to the top.


Altinity Backup for ClickHouse 1.3.2

Released: 2022-04-18


IMPROVEMENTS

• Add TLS certificates and TLS CA support for clickhouse connections, fix 410.
• Switch to go 1.18.
• Add clickhouse version 22.3 to integration tests.
• Add S3_MAX_PARTS_COUNT and AZBLOB_MAX_PARTS_COUNT for properly calculate buffer sizes during upload and download.
• Add multithreading GZIP implementation.

BUG FIXES

• fix 406, properly handle path for S3, GCS for case when it begins from “/”. fix 409, avoid delete partially uploaded backups via backups_keep_remote option. fix 422, avoid cache broken (partially uploaded) remote backup metadata. fix 404, properly calculate S3_PART_SIZE to avoid freeze after 10000 multi parts uploading, properly handle error when upload and download go-routine failed to avoid pipe stuck.

Download at: https://github.com/Altinity/clickhouse-backup/releases/tag/v1.3.2

 

Return to the top.


Altinity Dashboard for Kubernetes

Altinity Dashboard for Kubernetes 0.1.4 Release Notes

Released: 2022-06-24


What’s New

• Update clickhouse-operator to 0.19.0
• Node package security updates
• Update go-restful for CVE-2022-1996

Download from: https://github.com/Altinity/altinity-dashboard/releases/tag/v0.1.4.

 

Return to the top.


Altinity Dashboard for Kubernetes 0.1.3 Release Notes

Released: 2022-05-05


What’s New

• Update clickhouse-operator to 0.18.4
• Node package security updates

Download from: https://github.com/Altinity/altinity-dashboard/releases/tag/v0.1.3.

 

Return to the top.


Altinity Kubernetes Operator

Altinity Kubernetes Operator 0.19.0

Released: 2022-07-15


What’s Changed

• Now ‘clickhouse-operator’ user is restricted to an IP address of the pod where clickhouse-operator is running. It can not be used from anywhere else.

• In addition to hostRegexp, ‘default’ user is restricted to IP addresses of pods of the CHI. This fixes connectivity issues between shards in GKE.

• ClickHouse ‘interserver_http_host’ is set to the service name and matches ‘remote_servers’. It can be changed to full names with ‘replicasUseFQDN’ setting if needed. This fixes connectivity issues between replicas in GKE.

• Changed the way schema is propagated to new shards. It is currently controlled by two cluster level settings:

    schemaPolicy:
      replica: None | All (default)
      shard: None | All (default) | DistributedTablesOnly
  

  Previously, when adding shards only distributed tables and dependent objects were created (DistributedTablesOnly).

• Added support for adding custom CA for operator connection to ClickHouse by @SuzyWangIBMer in https://github.com/Altinity/clickhouse-operator/pull/930

• Fixed support of ‘{uuid}’ macro for Atomic databases. Closes https://github.com/Altinity/clickhouse-operator/issues/857

• Fixed a bug when replica sometimes was not removed from ZooKeeper when scaling down the cluster

• Set container-log on ubi instead of busybox by @SuzyWangIBMer in https://github.com/Altinity/clickhouse-operator/pull/940

• upgrade vertamedia-clickhouse-grafana to 2.5.0 in dashboard and grafana 7.5.16 by @Slach in https://github.com/Altinity/clickhouse-operator/pull/951

• Improve grafana dashboards by @Slach in https://github.com/Altinity/clickhouse-operator/pull/952

• Improve grafana-operator + prometheus-operator by @Slach in https://github.com/Altinity/clickhouse-operator/pull/953

New Contributors

• @roshanths made their first contribution in https://github.com/Altinity/clickhouse-operator/pull/936
• @SuzyWangIBMer made their first contribution in https://github.com/Altinity/clickhouse-operator/pull/940
• @meob made their first contribution in https://github.com/Altinity/clickhouse-operator/pull/949

Full Changelog: https://github.com/Altinity/clickhouse-operator/compare/0.18.5...release-0.19.0

Download at: https://github.com/Altinity/clickhouse-operator/releases/tag/release-0.19.0

 

Return to the top.


Altinity Kubernetes Operator 0.18.5

Released: 2022-05-12


What’s Changed

• Dependencies were updated to address CVE-2022-21698 and CVE-2021-38561 generate_chart.sh by @ganievs in #925

New Contributors

• @ganievs made their first contribution in #925

Full Changelog: 0.18.4-0.18.5

Download at: https://github.com/Altinity/clickhouse-operator/releases/tag/0.18.5

 

Return to the top.


Altinity Kubernetes Operator 0.18.4

Released: 2022-04-13


What’s Changed

• Base image has been updated to address https://access.redhat.com/errata/RHSA-2022:0896 (closes #913).
• Https support for health checks by @bkuschel in #912
• Fixed number of SERVERS from 1 to 3 for a 3 node clickhouse-keeper deployment by @a-dot in #902
• clickhouse-keeper and ZooKeeper manifests were updated by @Slach in #911 and #916

New Contributors

• @a-dot made their first contribution in #902
• @bkuschel made their first contribution in #912 Full Changelog: 0.18.3-0.18.4

Download at: https://github.com/Altinity/clickhouse-operator/releases/tag/0.18.4

 

Return to the top.


Altinity Stable for ClickHouse

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.


Altinity.Cloud Release Notes

Altinity.Cloud 22.10.24

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.


Altinity.Cloud 22.9.21

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.


Altinity.Cloud 22.8.15

Released: 2022-07-07


Added

• New tool to review and remove detached parts
• New tool to test connectivity to Kafka broker
• New tool to import test datasets – available for 22.3 ClickHouse version and above

Changed

• Default log level for new clusters is set to ‘information’. Users can edit log level using ’logger/level’ cluster setting
• Storage size is displayed as ‘Pending’ if rescale has not been complete
• Improved version upgrade recommendations
• Improved Schema and Workload tabs

Fixed

• Fixed a bug with uptime schedule that could unexpectidly stop clusters sometimes
• Fixed a bug with memory configuration settings if cluster is resumed to the different node size

 

Return to the top.


Altinity.Cloud 22.7.13

Released: 2022-06-03


Added

• User role is now displayed on Account page
• A warning is displayed on ClickHouse version upgrade is available
• Sorting has been added to the Schema tab
• A tool to convert a table from MergeTree to ReplicatedMergeTree (available for superadmins only)
• VPC Endpoint status is displayed on Connections popup
• Custom tolerations can be specified for node types

Changed

• User is automatically authenticated as ClickHouse admin when starting a new cluster
• Schedule icon opens a Schedule popup now
• When rescaling a volume, minimum rescale ratio is 20% of the volume size
• Org admin can access Environment details now (previously it was only possible with Env admin)

Fixed

• ClickHouse use authentication fixes
• List of backups was sometimes not properly sorted
• Fixed a possible race condition in backup and restore of replicated clusters

 

Return to the top.


Altinity.Cloud 22.6.18

Released: 2022-05-13


Added

• Explorer now requires user authorization using ClickHouse user/password
• Altinity staff does not have an access to the data by default. Multiple levels of access can be granted by a customer – that enables ‘altinity’ user to work with the data.
• New ‘Workload’ tab in Explorer to analyze typical queries
• Copy to Clipboard buttons in Connection Details

Changed

• DataDog metrics are labeled with environment and cluster
• clickhouse-operator user is restricted to Altinity network only
• Brute force protection is enabled for password recovery form

 

Return to the top.


Altinity.Cloud 22.5.15

Released: 2022-04-25


Added

• Cluster Uptime feature that allows stopping the cluster automatically when inactive or by schedule.
• Reset to defaults is available on ClickHouse settings and profile settings pages.
• Email notification is sent to the user when trial is extended.
• Connection to Remote environment via Altinity Connector.

Changed

• Display a warning when downgrading ClickHouse major version
• Display a warning when non-replicated MergeTree table is created on replicated cluster
• Cluster Dashboard now shows LB type and storage type

Fixed

• Fixed UI slowness when a long query is being executed.
• Fixed Schema tab that may be not displaying tables when databases contains hundreds of those.
• Small UI fixes in different places.

 

Return to the top.


Altinity Plugin Grafana for ClickHouse

Altinity Grafana Plugin for ClickHouse 2.5.0

Released: 2022-06-01


Enhancements

• Add support for Logs visualization, fix #331, thanks @Fiery-Fenix and @pixelsquared
• Add $conditionalTest to editor auto-complete
• Add support $__searchFilter to template variable queries, fix #354
• Add allow sub-seconds time resolution with $timeSeriesMs and $timeFilterMs support, fix #344, fix #398
• Expand template variable values when open context menu Explore, fix #346

Fixes

• Remove legacy binaries in dist folder, fix #419
• Allow Nullable types in alert label name in backend part, fix #405
• Remove INFORMATION_SCHEMA from adhoc control, fix #426
• Legacy binaries in dist folder after 2.4.4 release plugin name changed, fix #419
• Resolve corner case for SELECT x IN (SELECT …), fix #421
• Tested textbox variables with ${variable:sqlstring} format, fix #125

Download at: https://github.com/Altinity/clickhouse-grafana/releases/tag/v2.5.0

 

Return to the top.


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.


Altinity Tableau Connector for ClickHouse