v.25.6New Feature
Add mapContainsValuesLike/mapContainsValues/mapExtractValuesLike
AddmapContainsValuesLike/mapContainsValues/mapExtractValuesLikefunctions to filter on map values and their support in bloom filter based indexes. #78171 (UnamedRus).
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 functionsmapContainsValuesLike(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.