What's new in Clickhouse 24.10

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.

There are no comments yet.

Please log in to write the first comment.