v.22.9Improvement

Add DELETE and UPDATE support for EmbeddedRocksDB storage

Add support for DELETE and UPDATE for EmbeddedRocksDB storage. #40853 (Antonio Andelic).
Added support for DELETE and UPDATE operations on EmbeddedRocksDB storage engine in ClickHouse.

Why it matters

This feature enables users to perform DELETE 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 execute DELETE and UPDATE SQL queries directly on tables created with the EmbeddedRocksDB storage engine, without requiring additional workarounds or manual data management.