Company
Date Published
Author
The ClickHouse Team
Word count
2478
Language
English
Hacker News points
4

Summary

ClickHouse has released several exciting features in version 23.10, including 23 new features, 26 performance optimizations, and 60 bug fixes. One notable feature is the introduction of support for NumPy files, which allows users to load large datasets such as the LAION dataset into ClickHouse without having to write custom Python code. The largest triangle three buckets algorithm has also been added, which can be used to downsample data for easier visualization. Additionally, ClickHouse now supports a new array function called `arrayFold`, which provides a powerful way to process arrays in a concise and declarative manner. This feature is demonstrated through an example where it is used to reconstruct the "git blame" command. The LAION dataset has been successfully loaded into ClickHouse using this new feature, allowing users to easily query and analyze the data.