August 2022 Summaries

This post explores how to load data into ClickHouse efficiently, leveraging schema inference for initial exploration and defining an optimal schema for improved performance. It demonstrates loading datasets from local CSV files and remote URLs, as well as handling various file formats such as Parquet and JSON. The author showcases the use of `clickhouse-client` and `url` function to load data directly into ClickHouse, highlighting its ability to handle large datasets and optimize query performance with schema optimization. The post also touches on advanced topics like tokenization and primary keys, providing a comprehensive overview of getting data into ClickHouse for users looking to improve their data loading and querying capabilities.

At ClickHouse, in-person meetups are back, although they can coincide with hot weather, and the company has a new webpage that's snazzier than the old one. The latest release of ClickHouse 22.7 includes several features such as positional arguments, deprecation of Ordinary Only database engine, support for expressions in window functions, two new join algorithms, and a MongoDB table function to query MongoDB from ClickHouse. Additionally, there are updates on performance, including the launch of ClickBench, a benchmark for analytical databases. The company is also highlighting its Query of the Month feature, where it analyzed airline flight delays and found that planes often catch up with their schedule over time. The newsletter includes reading suggestions and mentions new adopters of ClickHouse.