v.25.12Improvement

Text index now works with ReplacingMergeTree tables

The text index now works with ReplacingMergeTree tables. #90908 (Elmi Ahmadov).
The text index feature is now supported on ReplacingMergeTree tables.

Why it matters

Previously, text indexes could not be used with ReplacingMergeTree engine tables, limiting full-text search capabilities on these tables. This feature enables efficient text indexing and search on ReplacingMergeTree tables, enhancing query performance and usability for text-based data.

How to use it

Create a text index on a ReplacingMergeTree table as usual using the ALTER TABLE ... ADD INDEX ... TYPE text() syntax. The text index will work seamlessly with the replacing merge tree engine for text search operations.