Altinity Stable for ClickHouse 21.1.10.3

Changes between 21.1.10.3 and 21.1.9.41

• background_fetches_pool_size is set to 8. This is better for production usage with frequent small insertions or slow ZooKeeper clusters.
• Fixed the error ‘Cannot find column in ActionsDAG result', which may happen if subquery uses untuple. https://github.com/ClickHouse/ClickHouse/issues/22290
• Fixed quantile(s)TDigest that could produce non-accurate results in some edge cases: https://github.com/ClickHouse/ClickHouse/issues/22408
• Fixed a bug with accessing S3 buckets when the object URL contained ‘+’ sign: https://github.com/clickHouse/clickHouse/pull/23822

The complete diff between Altinity and community versions can also be viewed at github:

https://github.com/ClickHouse/ClickHouse/compare/v21.1.9.41-stable…Altinity:v21.1.10.3-altinity+stable

Changes between ClickHouse Altinity Stable Release 21.1.9.41 and ClickHouse Altinity Stable Release 21.1.7.1

• Fixed a bug with distributed queries that could sometimes fail with ‘Unknown packet n from server’ error message: https://github.com/ClickHouse/ClickHouse/issues/21588

• Fixed several issues with mutations handling (e.g. https://github.com/ClickHouse/ClickHouse/issues/22013)

• Fix a rare bug when quorum insert with iinsert_quorum_parallel=1 is not really a “quorum” because of deduplication

• Fixed a possible buffer overflow in token bloom filter index: https://github.com/ClickHouse/ClickHouse/issues/19233

• Fixed a bug when nullable types sometimes could not be retrieved: https://github.com/ClickHouse/ClickHouse/issues/21116

• Fixed a bug with replicated tables metadata not properly cleaned from the non-primary ZooKeeper instance: https://github.com/ClickHouse/ClickHouse/issues/21054

• Added parseDateTimeBestEffortOrZero to allow for empty values, while parseDateTimeBestEffort will not work with empty values. For example:

  SELECT parseDateTimeBestEffort('')
  
  Query id: 1c60717e-116b-445f-b675-7b9cac35c262
  
  
  0 rows in set. Elapsed: 0.003 sec.
  
  Received exception from server (version 21.11.1):
  Code: 41. DB::Exception: Received from localhost:9000. DB::Exception: Cannot read DateTime: neither Date nor Time was parsed successfully: While processing parseDateTimeBestEffort(''). (CANNOT_PARSE_DATETIME)
  
  SELECT parseDateTimeBestEffortOrZero('')
  
  Query id: 484baec9-6d00-4c66-a792-85a270d6f2f2
  
  ┌─parseDateTimeBestEffortOrZero('')─┐
  │               1970-01-01 03:00:00 │
  └───────────────────────────────────┘
  

ClickHouse Altinity Stable packages for this release can be found at:

• Deb packages: https://packagecloud.io/Altinity/altinity-stable
• RPM packages: https://packagecloud.io/Altinity/altinity-stable
• Docker image: altinity/clickhouse-server:21.1.10.3.altinity_stable