v.25.6New Feature

Add mapContainsValuesLike/mapContainsValues/mapExtractValuesLike

Add mapContainsValuesLike/mapContainsValues/mapExtractValuesLike functions to filter on map values and their support in bloom filter based indexes. #78171 (UnamedRus).
Added new functions mapContainsValuesLike, mapContainsValues, and mapExtractValuesLike to enable filtering based on values within map data structures, along with support for these functions in bloom filter based indexes.

Why it matters

These functions provide enhanced capabilities for querying and filtering data by examining values inside map columns, which was previously limited. Integrating these functions with bloom filter based indexes improves performance and efficiency for such queries, allowing users to quickly filter rows based on map values.

How to use it

Use the functions mapContainsValuesLike(map, pattern) to filter map values matching a pattern using LIKE semantics, mapContainsValues(map, value) to check for exact values in the map, and mapExtractValuesLike(map, pattern) to extract values matching a pattern from the map. These functions automatically benefit from bloom filter based indexes if such indexes exist on the map columns used.