Company
Date Published
Author
The ClickHouse Team
Word count
2207
Language
English
Hacker News points
None

Summary

The latest release of ClickHouse, version 23.8, brings a significant number of exciting features and improvements to the popular open-source database management system. The new release includes 29 new features, 19 performance optimizations, and 63 bug fixes, making it an excellent update for users looking to enhance their data analysis capabilities. One of the most notable features is the improved support for streaming consumption from S3, which simplifies incremental loads from Amazon's object storage service. This feature allows users to set up simple incremental pipelines with no additional code, making it easier to manage large datasets. Additionally, ClickHouse now supports archives, including zip and tar files, which can contain multiple files. The release also includes a new `S3Queue` table engine, which enables the streaming consumption of data from S3. Furthermore, the release introduces a new virtual column `_file`, which allows users to query all files in an archive using a single query. Overall, the latest release of ClickHouse is an excellent update for users looking to improve their data analysis capabilities and streamline their workflows.