ClickHouse 24.10: A Powerful Upgrade

This podcast will explore the exciting new features and improvements introduced in ClickHouse version 24.10. This version boasts major enhancements in query flexibility, security, and performance.

• Enhanced JSON support: ClickHouse 24.10 introduces new settings for reading and writing JSON, including options for handling JSON as binary strings and serializing/deserializing JSON columns as single strings.
• Wildcard access grants: This version simplifies permission management by enabling wildcard-based access grants. This allows granting permissions to multiple tables with a single command.
• Progress table toggle: Users can now view a real-time progress table during query execution, providing detailed metrics for performance monitoring. This table can be toggled on or off using keyboard shortcuts.
• Caching for Object Storage: ClickHouse 24.10 enhances performance by caching files read from object storage, improving efficiency for frequently accessed data.
• New system table: The new system.query_metric_log table provides a historical record of memory and metric values for individual queries, offering insights into query performance trends.
• New functions: Several new functions, including arrayUnion, arrayElementOrNull, quantileExactWeightedInterpolated, and RIPEMD160, expand ClickHouse's analytical capabilities.
• Experimental features: This version introduces experimental features such as JSON handling as binary strings, refreshable materialized views, and support for executing functions on Dynamic types.
• Performance improvements: ClickHouse 24.10 boasts significant performance enhancements, including optimized object storage performance, faster Parquet reading with Bloom filter support, lock-free parts renaming, and optimized thread creation.
• Bug fixes: This version addresses several bugs, including settings configuration issues, JOIN optimization problems, materialized view issues, and parallel replicas fixes, ensuring improved stability and reliability.

This podcast will provide an in-depth look at these features, discussing their benefits and how they can be leveraged to optimize ClickHouse deployments. Listeners will gain a deeper understanding of the power and versatility of ClickHouse 24.10 and how it empowers users to manage and analyze data more effectively.