v.25.10Improvement

Add text index

Official CH changelog text
Add text index support for Array and Map (mapKeys and mapValues) values. The supported functions are mapContainsKey and has. #87602 (Elmi Ahmadov).
Added support for full-text search indexes on Array and Map data types, including indexing of mapKeys and mapValues.

Why it matters

This feature enables efficient text search queries on array and map columns in ClickHouse by allowing the creation of text indexes on their elements and keys/values. It enhances query performance for functions like mapContainsKey and has, which previously did not benefit from text indexes on these data structures.

How to use it

Users can create text indexes on Array or Map columns using the usual text index syntax in ClickHouse. These indexes will support the mapContainsKey and has functions for efficient filtering. For example, create a text index on a Map column and then use mapContainsKey in the WHERE clause to utilize the index.

Related resources

PreviousNext