ClickHouse version 24.7 introduces new features and optimizations to improve performance and fix bugs. The release includes 18 new features, 12 performance optimizations, and 76 bug fixes. Notable improvements include optimizations for reading in order, faster parallel hash join, ASOF JOIN with the full sorting merge join algorithm, percent_rank function, and automatic named tuples. The update also welcomes several new contributors to the ClickHouse community.