What’s New in ClickHouse 22.1

The new ClickHouse release 22.1 includes several significant features, including schema inference, which automatically detects the data format of a file without requiring manual specification. This feature works for various formats such as Native, Avro, Parquet, and CSVWithNamesAndTypes. Additionally, ClickHouse now supports "schema on demand" queries, allowing users to refine the types in their query with the :: operator. The release also introduces real-time resource usage visualization in clickhouse-client, parallel query processing on replicas, service discovery, sparse encoding for columns, a diagnostic tool for ClickHouse, new integrations, and statistical functions for calculating Cramer's V and Theil's U coefficients. These features enhance the scalability, performance, and user experience of ClickHouse, making it an attractive choice for developers and data analysts.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.