v.22.9Improvement
Add DELETE and UPDATE support for EmbeddedRocksDB storage
Add support forDELETEandUPDATEforEmbeddedRocksDBstorage. #40853 (Antonio Andelic).
Why it matters
This feature enables users to performDELETE and UPDATE statements on tables using the EmbeddedRocksDB engine, which previously did not support these operations. It enhances data manipulation capabilities and provides more flexibility for working with real-time mutable datasets within ClickHouse.How to use it
Users can now executeDELETE and UPDATE SQL queries directly on tables created with the EmbeddedRocksDB storage engine, without requiring additional workarounds or manual data management.