ClickHouse Release 24.11

ClickHouse version 24.11 introduces nine new features, fifteen performance optimizations, and sixty-eight bug fixes. The parallel hash join algorithm is now the default join strategy, with a performance optimization using zero-copy instead of copying block columns each time. A STALENESS modifier for ORDER BY WITH FILL has been added to generate rows until the difference from the previous row exceeds a specified numeric expression. The HTTP interface can now reliably detect errors even after the result has been streamed to the client, and the mark cache can be pre-warmed using the mark_cache_prewarm_ratio setting. Additionally, the BFloat16 data type is available for AI and vector searches.