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 Kubernetes Operator
  • Altinity ODBC Driver for ClickHouse™ Release Notes
  • Altinity Plugin Grafana for ClickHouse™
  • Altinity Stable for ClickHouse™
  • Altinity Tableau Connector for ClickHouse™
  • Altinity.Cloud Release Notes

      • Altinity Backup for ClickHouse™

      Altinity Backup for ClickHouse™ 1.3.1

      Released: 2022-02-17

      IMPROVEMENTS

      • fix 387, improve documentation related to memory and CPU usage

      BUG FIXES

      • fix 392, correct download for recursive sequence of diff backups when DOWNLOAD_BY_PART true
      • fix 390, respect skip_tables patterns during restore and skip all INFORMATION_SCHEMA related tables even skip_tables don’t contain INFORMATION_SCHEMA pattern
      • fix 388, improve restore ON CLUSTER for VIEW with TO clause
      • fix 385, properly handle multiple incremental backup sequences + BACKUPS_TO_KEEP_REMOTE

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

       

      Return to the top.

      Altinity Backup for ClickHouse™ 1.2.3

      Released: 2022-02-15

      HOT FIXES

      • fix 390, respect skip_tables patterns during restore and skip all INFORMATION_SCHEMA related tables even skip_tables don’t contain INFORMATION_SCHEMA pattern

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

       

      Return to the top.

      Altinity Backup for ClickHouse™ 1.3.0

      Released: 2022-02-08

      Improvements

      • Add API_ALLOW_PARALLEL to support multiple parallel execution calls for, WARNING, control command names don’t try to execute multiple same commands and be careful, it could allocate much memory during upload / download, fix #332
      • Add support for –partitions on create, upload, download, restore CLI commands and API endpoint fix #378 properly implementation of #356
      • Add implementation –diff-from-remote for upload command and properly handle required on download command, fix #289
      • Add print-config cli command fix #366
      • Add UPLOAD_BY_PART (default: true) option for improve upload/download concurrency fix #324
      • Add ARM support for Docker images and pre-compiled binary files, fix #312
      • KeepRemoteBackups should respect differential backups, fix #111
      • Add SFTP_DEBUG option, fix #335
      • Add ability to restore schema ON CLUSTER, fix #145
      • Add support encrypted disk (include s3 encrypted disks), fix #260
      • API Server optimization for speed of last_backup_size_remote metric calculation to make it async during REST API startup and after download/upload, fix #309
      • Improve list remote speed via local metadata cache in $TEMP/.Altinity Backup for ClickHouse.$REMOTE_STORAGE, fix #318
      • Add CLICKHOUSE_IGNORE_NOT_EXISTS_ERROR_DURING_FREEZE option, fix #319
      • Add support for PROJECTION, fix #320
      • Return clean cli command and API POST /backup/clean endpoint, fix #379

      Bug Fixes

      • fix #300, allow GCP properly work with empty GCP_PATH value
      • fix #340, properly handle errors on S3 during Walk() and delete old backup
      • fix #331, properly restore tables where have table name with the same name as database name
      • fix #311, properly run Altinity Backup for ClickHouse inside docker container via entrypoint
      • fix #317, properly upload large files to Azure Blob Storage
      • fix #220, properly handle total_bytes for uint64 type
      • fix #304, properly handle archive extension during download instead of use config settings
      • fix #375, properly REMOTE_STORAGE=none error handle
      • fix #379, will try to clean shadow if create fail during moveShadow
      • more precise calculation backup size during upload, for backups created with –partitions, fix bug after #356
      • fix restore –rm behavior for 20.12+ for tables which have dependent objects (like dictionary)
      • fix concurrency by FTP creation directories during upload, reduce connection pool usage properly handle –schema parameter for show local backup size after download
      • fix restore bug for WINDOW VIEW, thanks @zvonand

      Experimental

      • Try to add experimental support for backup MaterializedMySQL and MaterializedPostgeSQL tables, restore MySQL tables not impossible now without replace table_name.json to Engine=MergeTree, PostgreSQL not supported now, see ClickHouse/ClickHouse#32902

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

       

      Return to the top.

      Altinity Dashboard for Kubernetes

      Altinity Dashboard for Kubernetes 0.1.2 Release Notes

      Released: 2022-01-19

      What’s New

      • Documentation updates
      • Many NPM package updates
      • Restructured adash.go / server.go
      • Minor UI fixes
      • Warn if operator is not the latest version
      • Use local IP for openbrowser when bindhost=0.0.0.0
      • Check for nil values in k8s API results

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

       

      Return to the top.

      Altinity Dashboard for Kubernetes 0.1.1 Release Notes

      Released: 2021-12-14

      What’s Changed

      • Add loading skeletons
      • Ensure only one refresh in flight at once, and don’t refresh when not visible
      • Move addAlert to a Context and close mobile menu on click
      • Issue warnings for no or unbound storage

      Download at: https://github.com/Altinity/altinity-dashboard/releases/tag/v0.1.1

       

      Return to the top.

      Altinity Dashboard for Kubernetes 0.1.0 Release Notes

      Released: 2021-12-10

      Initial Release

      Download at: https://github.com/Altinity/altinity-dashboard/releases/tag/v0.1.0

       

      Return to the top.

      Altinity Kubernetes Operator

      Altinity Kubernetes Operator 0.18.3

      Released: 2022-03-02

      What’s Change

      • Fixed a bug that might result in broken CHI if operator has been restarted during the reconcile
      • Added ‘AGE’ to CHI status
      • Added ClickHouse Keeper examples

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

       

      Return to the top.

      Altinity Kubernetes Operator 0.18.2

      Released: 2022-02-14
      • Operator now correctly respects configuration settings to exclude annotations from managed objects. Fixes #859.
      • Make CHI status messages more human friendly

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

       

      Return to the top.

      Altinity Kubernetes Operator 0.18.1

      Released: 2022-02-02

      What’s Changed

      • fix non pointer mistake in metrics-exporter by @adu-bricks in #870
      • Helper files for operatorhub.io integration

      New Contributors

      • @adu-bricks made their first contribution in #870

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

       

      Return to the top.

      Altinity Kubernetes Operator 0.18.0

      Released: 2022-01-26

      New features

      • arm64 packages are published (closes #852)
      • ‘access_management’ can be specified when defining users in CHI.
      • k8s secrets can be referenced when defining user passwords. See 05-settings-01-overview.yaml.

      Changed

      • When CRD is deleted, operator keeps all dependent objects now (statefulsets, volumes). That prevents from incidental delete of a cluster.
      • When operator restarts it does not run a reconcile cycle anymore if CHI has not been changed. That prevents unneeded pod restarts. (Closes #855)
      • Operator configuration file format has been changed. See https://github.com/Altinity/clickhouse-operator/blob/0.18.0/config/config.yaml. Configuration in old format is supported for backwards compatibility.

      Fixed

      • Fixed a bug ‘unable to decode watch event: no kind “ClickHouseOperatorConfiguration” is registered’ that could appear in some k8s configurations.
      • Removed INFORMATION_SCHEMA from schema propagation. (closes #854)
      • Added a containerPort to metrics-exporter (#834)

      New Contributors

      • @johnhummelAltinity made their first contribution in #838
      • @jiangxinqi1995 made their first contribution in #846
      • @johnny made their first contribution in #834

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

       

      Return to the top.

      Altinity ODBC Driver for ClickHouse™ Release Notes

      Altinity ODBC Driver for ClickHouse™ 1.1.10.20210822 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 Stable for ClickHouse™

      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 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)
      • 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

      Test Results

      Packages

      https://builds.altinity.cloud/

       

      Return to the top.

      Altinity Stable for ClickHouse™ 21.8.13

      Released: 2022-01-05

      Release Notes

      ClickHouse release v21.8.13.1-altinitystable as compared to v21.8.12.29-altinitystable:

      Bug Fixes

      • Fixed Apache Avro Union type index out of boundary issue in Apache Avro binary format. #33022 (Harry Lee).

      • Quota limit was not reached, but the limit was exceeded. This PR fixes #31174. #31656 (sunny).

      • NO CL ENTRY: ‘fix json error after downgrade’. #33166 (bullet1337).

      • Integer overflow to resize the arrays causes heap corrupt. #33024 (varadarajkumar).

      • fix crash when used fuzzBits with multiply same FixedString, Close #32737. #32755 (SuperDJY).

      • Fix possible exception at RabbitMQ storage startup by delaying channel creation. #32584 (Kseniia Sumarokova).

      • Fixed crash with SIGFPE in aggregate function avgWeighted with Decimal argument. Fixes #32053. #32303 (tavplubix).

      • Some replication queue entries might hang for temporary_directories_lifetime (1 day by default) with Directory tmp_merge_<part_name> or Part ... (state Deleting) already exists, but it will be deleted soon or similar error. It’s fixed. Fixes #29616. #32201 (tavplubix).

      • XML dictionaries identifiers, used in table create query, can be qualified to default_database during upgrade to newer version. Closes #31963. #32187 (Maksim Kita).

      • Number of active replicas might be determined incorrectly when inserting with quorum if setting replicated_can_become_leader is disabled on some replicas. It’s fixed. #32157 (tavplubix).

      • Fixed Directory ... already exists and is not empty error when detaching part. #32063 (tavplubix).

      • Some GET_PART entry might hang in replication queue if part is lost on all replicas and there are no other parts in the same partition. It’s fixed in cases when partition key contains only columns of integer types or Date[Time]. Fixes #31485. #31887 (tavplubix).

      • Change configuration path from keeper_server.session_timeout_ms to keeper_server.coordination_settings.session_timeout_ms when constructing a KeeperTCPHandler - Same with operation_timeout. #31859 (JackyWoo).

      • Fix a bug about function transform with decimal args. #31839 (李帅).

      • Fix crash when function dictGet with type is used for dictionary attribute when type is Nullable. Fixes #30980. #31800 (Maksim Kita).

      • Fix crash with empty result on odbc query. Closes #31465. #31766 (Kseniia Sumarokova).

      • Fix possible crash (or incorrect result) in case of LowCardinality arguments of window function. Fixes #31114. #31888 (Nikolai Kochetov).

      Changes compared to the Community Build

      • Fix invalid cast of Nullable type when nullable primary key is used. (Nullable primary key is a discouraged feature - please do not use). This fixes #31075 #31823 Amos Bird).

      Test Reports

      Test Report for Altinity Stable Build v21.8.13.1.

       

      Return to the top.

      Altinity Stable for ClickHouse™ 21.8.12

      Released: 2021-12-10

      Release Notes

      ClickHouse release v21.8.12.29-altinitystable as compared to v21.8.11.1-altinitystable:

      Performance Improvements

      Bug Fixes

      • Quota limit was not reached, but the limit was exceeded. This PR fixes #31174. #31337 (sunny).

      Build/Testing/Packaging Improvements

      • Now all images for CI will be placed in the separate dockerhub repo. #28656 (alesapin).

      Bug Fixes (user-visible misbehaviour in official stable or prestable release)

      • Fixed functions empty and notEmpty with the arguments of UUID type. Fixes #31819. #31883 (Anton Popov).
      • Fixed possible assertion ../src/IO/ReadBuffer.h:58: bool DB::ReadBuffer::next(): Assertion '!hasPendingData()' failed. in TSKV format. #31804 (Kruglov Pavel).
      • Fixed usage of Buffer table engine with type Map. Fixes #30546. #31742 (Anton Popov).
      • Fixed race in JSONEachRowWithProgress output format when data and lines with progress are mixed in output. #31736 (Kruglov Pavel).
      • Fixed there are no such cluster here error on execution of ON CLUSTER query if specified cluster name is name of Replicated database. #31723 (tavplubix).
      • Settings input_format_allow_errors_num and input_format_allow_errors_ratio did not work for parsing of domain types, such as IPv4, it’s fixed. Fixes #31686. #31697 (tavplubix).
      • RENAME TABLE query worked incorrectly on attempt to rename an DDL dictionary in Ordinary database, it’s fixed. #31638 (tavplubix).
      • Fix invalid generated JSON when only column names contain invalid UTF-8 sequences. #31534 (Kevin Michel).
      • Resolve nullptr in STS credentials provider for S3. #31409 (Vladimir Chebotarev).
      • Remove not like function into RPNElement. #31169 (sundyli).
      • Fixed bug in Keeper which can lead to inability to start when some coordination logs was lost and we have more fresh snapshot than our latest log. #31150 (alesapin).
      • Fixed abort in debug server and DB::Exception: std::out_of_range: basic_string error in release server in case of bad hdfs url by adding additional check of hdfs url structure. #31042 (Kruglov Pavel).

       

      Return to the top.

      Altinity Stable for ClickHouse™ 21.8.11

      Released: 2021-11-19

      ClickHouse release v21.8.11.1-altinitystable FIXME as compared to v21.8.10.1-altinitystable

      New Features

      • CompiledExpressionCache limit elements size using compiled_expression_cache_elements_size setting. #30667 (Maksim Kita).

      Improvements

      Bug Fixes

      Bug Fixes (user-visible misbehaviour in official stable or prestable release)

      • Fixed StorageMerge with aliases and where (it did not work before at all). Closes #28802. #31044 (Kseniia Sumarokova).
      • Fixed JSONValue/Query with quoted identifiers. This allows to have spaces in json path. Closes #30971. #31003 (Kseniia Sumarokova).
      • Using formatRow function with not row formats led to segfault. Don’t allow to use this function with such formats (because it doesn’t make sense). #31001 (Kruglov Pavel).
      • Skip max_partition_size_to_drop check in case of ATTACH PARTITION ... FROM and MOVE PARTITION ... #30995 (Amr Alaa).
      • Fixed set index not used in AND/OR expressions when there are more than two operands. This fixes #30416 . #30887 (Amos Bird).
      • Fixed ambiguity when extracting auxiliary ZooKeeper name from ZooKeeper path in ReplicatedMergeTree. Previously server might fail to start with Unknown auxiliary ZooKeeper name if ZooKeeper path contains a colon. Fixes #29052. Also it was allowed to specify ZooKeeper path that does not start with slash, but now it’s deprecated and creation of new tables with such path is not allowed. Slashes and colons in auxiliary ZooKeeper names are not allowed too. #30822 (tavplubix).
      • Fixed a race condition between REPLACE/MOVE PARTITION and background merge in non-replicated MergeTree that might cause a part of moved/replaced data to remain in partition. Fixes #29327. #30717 (tavplubix).
      • Fixed PREWHERE with WHERE in case of always true PREWHERE. #30668 (Azat Khuzhin).
      • Functions for case-insensitive search in UTF8 strings like positionCaseInsensitiveUTF8 and countSubstringsCaseInsensitiveUTF8 might find substrings that actually does not match is fixed. #30663 (tavplubix).
      • Limit push down optimization could cause a error Cannot find column. Fixes #30438. #30562 (Nikolai Kochetov).
      • Fixed exception handling in parallel_view_processing. This resolves issues / prevents crashes in some rare corner cases when that feature is enabled and exception (like Memory limit exceeded ...) happened in the middle of materialized view processing. #30472 (filimonov).
      • Fixed segfault which might happen if session expired during execution of REPLACE PARTITION. #30432 (tavplubix).
      • Fixed ComplexKeyHashedDictionary, ComplexKeySparseHashedDictionary parsing preallocate option from layout config. #30246 (Maksim Kita).
      • Fixed [I]LIKE function. Closes #28661. #30244 (Nikolay Degterinsky).
      • Support nullable arguments in function initializeAggregation. #30177 (Anton Popov).
      • Fixed data-race between LogSink::writeMarks() and LogSource in StorageLog. #29946 (Azat Khuzhin).
      • Fixed hanging DDL queries on Replicated database while adding a new replica. #29328 (Kevin Michel).
      • Fixed bad optimizations of ORDER BY if it contains WITH FILL. This closes #28908. This closes #26049. #28910 (alexey-milovidov).
      • Fixed queries to external databases (i.e. MySQL) with multiple columns in IN ( i.e. (k,v) IN ((1, 2)) ) (but note that this has some backward incompatibility for the clickhouse-copier since it uses alias for tuple element). #28888 (Azat Khuzhin).
      • Fixed “Column is not under aggregate function and not in GROUP BY” with PREWHERE (Fixes: #28461). #28502 (Azat Khuzhin).
      • Fixed NOT-IN index optimization when not all key columns are used. This fixes #28120. #28315 (Amos Bird).

      Bug Fixes (user-visible misbehaviour in official stable or prestable release

      • Fixed ORDER BY ... WITH FILL with set TO and FROM and no rows in result set. #30888 (Anton Popov).

       

      Return to the top.

      Altinity Stable for ClickHouse™ 21.3

      Altinity Stable for ClickHouse™ 21.3.20.2

      Released: 2022-02-10

      Changes Compared to Altinity Stable 21.3.17.3

      Bug Fixes

      • Integer overflow to resize the arrays causes heap corrupt. #33024 (Rajkumar Varada).
      • fix crash when used fuzzBits with multiply same FixedString, Close #32737. #32755 (SuperDJY).
      • Number of active replicas might be determined incorrectly when inserting with quorum if setting replicated_can_become_leader is disabled on some replicas. It’s fixed. #32157 (tavplubix).
      • Fix possible assertion ../src/IO/ReadBuffer.h:58: bool DB::ReadBuffer::next(): Assertion '!hasPendingData()' failed. in TSKV format. #31804 (Kruglov Pavel).
      • Fix crash when function dictGet with type is used for dictionary attribute when type is Nullable. Fixes #30980. #31800 (Maksim Kita).
      • Fix usage of Buffer table engine with type Map. Fixes #30546. #31742 (Anton Popov).
      • Fix race in JSONEachRowWithProgress output format when data and lines with progress are mixed in output. #31736 (Kruglov Pavel).
      • Settings input_format_allow_errors_num and input_format_allow_errors_ratio did not work for parsing of domain types, such as IPv4, it’s fixed. Fixes #31686. #31697 (tavplubix).
      • Remove not like function into RPNElement. #31169 (sundyli).
      • Using formatRow function with not row formats led to segfault. Don’t allow to use this function with such formats (because it doesn’t make sense). #31001 (Kruglov Pavel).
      • Functions for case-insensitive search in UTF8 strings like positionCaseInsensitiveUTF8 and countSubstringsCaseInsensitiveUTF8 might find substrings that actually does not match, it’s fixed. #30663 (tavplubix).
      • Fixed segfault which might happen if session expired during execution of REPLACE PARTITION. #30432 (tavplubix).
      • Fix [I]LIKE function. Closes #28661. #30244 (Nikolay Degterinsky).
      • FlatDictionary, HashedDictionary fix bytes_allocated calculation for nullable attributes. #30238 (Maksim Kita).
      • Support nullable arguments in function initializeAggregation. #30177 (Anton Popov).
      • Fix crash of sample by tuple(), closes #30004. #30016 (flynn).
      • Fix concurrent access to LowCardinality during GROUP BY (leads to SIGSEGV). #29782 (Azat Khuzhin).
      • Condition in filter predicate could be lost after push-down optimisation. #29625 (Nikolai Kochetov).
      • Fix null deference for GROUP BY WITH TOTALS HAVING (when the column from HAVING wasn’t selected). #29553 (Azat Khuzhin).
      • Fix connection timeouts (send_timeout/receive_timeout). #29282 (Azat Khuzhin).
      • Fix possible Table columns structure in ZooKeeper is different from local table structure exception while recreating or creating new replicas of ReplicatedMergeTree, when one of table columns have default expressions with case-insensitive functions. #29266 (Anton Popov).
      • Fix segfault while inserting into column with type LowCardinality(Nullable) in Avro input format. #29132 (Kruglov Pavel).
      • Fix the number of threads used in GLOBAL IN subquery (it was executed in single threads since #19414 bugfix). #28997 (Nikolai Kochetov).
      • Fix invalid constant type conversion when nullable or lowcardinality primary key is used. #28636 (Amos Bird).
      • Fix ORDER BY ... WITH FILL with set TO and FROM and no rows in result set. #30888 (Anton Popov).
      • Fixed Apache Avro Union type index out of boundary issue in Apache Avro binary format. #33022 (Harry Lee).
      • Fix null pointer dereference in low cardinality data when deserializing LowCardinality data in the Native format. #33021 (Harry Lee).
      • Quota limit was not reached, but the limit was exceeded. This PR fixes #31174. #31656 (sunny).
      • Quota limit was not reached, but the limit was exceeded. This PR fixes #31174. #31337 (sunny).
      • Fix shutdown of AccessControlManager. Now there can’t be reloading of the configuration after AccessControlManager has been destroyed. This PR fixes the flaky test test_user_directories/test.py::test_relative_path. #29951 (Vitaly Baranov).

      Performance Improvements

      Other Improvements

      • Updated zoneinfo files to 2021c. #29925 (alexey-milovidov).
      • Use real tmp file instead of predefined “rows_sources” for vertical merges. This avoids generating garbage directories in tmp disks. #28299 (Amos Bird).
      • Use separate clickhouse-bridge group and user for bridge processes. Set oom_score_adj so the bridges will be first subjects for OOM killer. Set set maximum RSS to 1 GiB. Closes #23861. #25280 (Kseniia Sumarokova).

      Changes compared to Community Build 21.3.20.1-lts

      Test Results

       

      Return to the top.

      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

      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&hellip;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:

       

      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.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.Cloud 22.4.15

      Released: 2022-04-06

      Added

      • Breakdown by clusters on a billing page.
      • Initial support for user managed environments.
      • Environment connection status.

      Changed

      • Changed cluster wizard to make it easier to use.
      • Fractional disk sizes are not allowed anymore.
      • ‘Pay by Invoice’ option is disabled.

      Fixed

      • Fixed a bug with local backups not being deleted that might result in higher disk usage.
      • Fixed a possible backup failure on clusters with async_inserts=1.
      • Fixed a bug with ALTER TABLE did not work sometimes on clusters restored from a backup.
      • Fixed a bug with schema did not refresh sometimes.
      • Fixed a bug in incorrect retention of backups of sharded cluster.

       

      Return to the top.

      Altinity.Cloud 22.3.14

      Released: 2022-03-17

      Added

      • Allow to select a node type when launching a cluster from backup (available for Altinity staff only).

      Changed

      • DROP TABLE is executed now before restoring a table from the backup.
      • CPU is correctly displayed in cores on Environment page in this release.
      • clickhouse-operator has been upgraded to 0.18.3.
      • Fixed a bug that did not allow to enter ‘0’ in cluster settings.
      • Fixed a bug that might result in cluster not going online when using ClickHouse versions 22.2 and above.
      • Fixed a bug with incorrect display of billing data for GCP environments.
      • Fixed a bug with AWS NLB usage.
      • Fixed a bug with cluster metadata not being stored in backup sometimes.

       

      Return to the top.

      Altinity.Cloud 22.2.15

      Released: 2022-02-28

      Added

      • Notifications for cluster related events can be configured
      • Datadog integration
      • Option to force Auth0 authentication for organization
      • Dark UI theme
      • Cmd/Ctrl+Enter in Explorer can be used to run a query

      Changed

      • ZooKeeper is now stopped when cluster is stopped
      • Warning has been removed from volume rescale popup
      • Monitoring links have been moved to the top in order to make it easier to find
      • Max part size has been reduced to 50GB
      • Column compression tab is more compact now
      • When backup operation is in progress all operations that may incidentally restart the cluster are blocked now

      Fixed

      • Fixed a bug with list of databases sometimes could not be parsed in user dialog
      • Fixed a bug with replica cluster creation
      • Fixed latest backup timestamp display for stopped clusters
      • Fixed a bug with table restore from a backup that could download full cluster backup instead of a single table

       

      Return to the top.

      Altinity.Cloud 22.1.28

      Released: 2022-01-31

      Added

      • Restore cluster from an External backup (available for superadmins only)
      • Restore single table from a backup
      • New Grafana dashboard for logs

      Changed

      • UI facelifting on Cluster and Nodes dashboards
      • System tables are now hidden by default on Schema dashboard
      • Stronger security for Grafana monitoring dashboard
      • Better performance of Billing dashboard
      • Use ‘pd-ssd’ fast storage for ZooKeeper nodes in GCP
      • Cluster dashboard now shows a warning if backup utility is outdated
      • Backup line item is now correctly displayed for GCP clusters
      • Support plan is now displayed on a billing page
      • Error Log section is removed from ClickHouse logs page

      Fixed

      • Fixed ON CLUSTER switch behavior
      • Removed deprecated ClickHouse settings from default profile
      • Removed deprecated node annotations

       

      Return to the top.

      Altinity.Cloud 21.13.21

      Released: 2021-12-21

      Added

      • Expiration date for trials can be adjusted from UI (previously it could only be done with an API call)
      • Expiration date for notifications can be configured
      • Units to the billing usage page
      • Legend to the Columns tab that clarifies key flags

      Changed

      • UI has been refreshed with a new version of Clarity.Design library
      • When user VPC endpoint is configured Access Point URLs are switched to ‘internal’ now
      • AWS NLB is disabled by default. It can be enabled on Environment level if needed
      • Cron job logs are sent to centralized logging

      Fixed

      • Processes view is fixed for ClickHouse versions 21.8
      • Estimated costs for GCP are corrected
      • Trial notifications are not longer created for blocked organizations

       

      Return to the top.

      Altinity.Cloud 21.12.26

      Released: 2021-12-01

      Added

      • Post-trial workflow allows user to signup to the paid account
      • Column level compression tab in Schema popup
      • New billing user role in order to access billing only
      • Soft rolling restart of ClickHouse nodes is now available. The previous ‘hard’ restart can be used as well.
      • Background operation status is now displayed on the cluster dashboard
      • Billing integration for GCP
      • Backups for GCP

      Changed

      • ZooKeeper is updated to 3.7.0. It only affects new clusters.
      • ClickHouse Backup is updated to 1.2.2
      • User will receive notification when subscribes or unsubscribes from Clickhouse alerts
      • Billing company name can now be different from the organization name

      Fixed

      • Fixed ‘Refresh’ button on Processes tab that did not refresh the screen sometimes
      • Fixed an issue when sometimes schema was displayed as empty

       

      Return to the top.

      Altinity Plugin Grafana for ClickHouse™

      Altinity Plugin Grafana for ClickHouse™ 2.4.2

      Released: 2021-12-29

      Fixes

      • fix unified alerts interval #400

      Download at: https://github.com/Vertamedia/clickhouse-grafana/releases/tag/v2.4.2

       

      Return to the top.

      Altinity Tableau Connector for ClickHouse™

      Altinity Tableau Connector for ClickHouse™ 1.0.0 ODBC

      Released: 2022-01-01

      v1.0.0-odbc-unicode

      • Added compatibility with latest Tableau SDK.

      Download at: https://github.com/Altinity/clickhouse-tableau-connector-odbc/releases/tag/v1.0.0-odbc-unicode

       

      Return to the top.

      Altinity Tableau Connector for ClickHouse™ 1.0.0 JDBC Release Notes

      Released: 2021-12-06

      JDBC version of the connector.

      Download at: https://github.com/Altinity/clickhouse-tableau-connector-odbc/releases/tag/v1.0.0-jdbc

       

      Return to the top.
    Altinity Backup for ClickHouse™

    Altinity Backup for ClickHouse™ Release Notes

    Altinity Dashboard for Kubernetes

    Altinity Dashboard for Kubernetes Release Notes

    Altinity Kubernetes Operator

    clickhouse-operator Release Notes

    Altinity ODBC Driver for ClickHouse™ Release Notes

    Altinity ODBC Driver for ClickHouse™ Release Notes

    Altinity Stable for ClickHouse™

    Altinity Stable for ClickHouse Release Notes

    Altinity.Cloud Release Notes

    Altinity Plugin Grafana for ClickHouse™

    Altinity Plugin Grafana for ClickHouse™ Release Notes

    Altinity Tableau Connector for ClickHouse™

    Altinity Tableau Connector for ClickHouse™ Release Notes


    Last modified 2022.03.11: Updated with qa approved `20220311_steinsgate`.