What is new ClickHouse 22.2

Posted on March 13, 2022

ClickHouse 22.2 New Features 

ClickHouse Development Group is very active (https://clickhouse.com/docs/en/whats-new/changelog/), We at ChistaDATA carefully evaluate new features to recommend customers for adoption (whenever appropriate). Our Support team is committed to providing maximum value for ChistaDATA customers for building optimal, scalable and reliable ClickHouse infrastructure operations. In this blog post we have explained what is new with ClickHouse 22.2:

  • allow_experimental_projection_optimization is set by default – Yes, Projections are ready for ClickHouse Production Infrastructure
  • You now have the option to create new files on INSERT for File/S3/HDFS engines. You can overwrite a file in HDFS. Throw an exception in an attempt to overwrite a file S3 by default. Throw an exception in an attempt to append data to file in formats that have a suffix (and thus don’t support appends, like Parquet, ORC)
  • You can now configure ClickHouse for a full autonomous deduplication feature for data stored on MergeTree/ReplicatedMergeTree. This is possible only if it’s used instead of data digest to generate block ID
  • Default keyword support for INSERT statements
  • MOVE TTL rules (IF EXISTS clause for TTL expr TO [DISK|VOLUME] [IF EXISTS] ‘xxx’ feature) are accepted only if it (parts will be moved to disks/volumes) exists on replica
  • You can now set the default table engine to create tables without explicitly mentioning the engine
  • Support Table function. Example: format(format_name,data)
  • You can add Schema interference for values in table function
  • You can dynamically reload ClickHouse Server TLS certificates on-demand