v.21.11Improvements

Skip Indexes Enhancements: Support for Array and Map Data Types in tokenbf_v1 and ngrambf_v1

Skip indexes tokenbf_v1 and ngrambf_v1: added support for Array data type with key of String of FixedString type. #29280 (Maksim Kita). Skip indexes tokenbf_v1 and ngrambf_v1 added support for Map data type with key of String of FixedString type. Author @lingtaolf. #29220 (Maksim Kita).
Added support for Array and Map data types with keys of String of FixedString type in skip indexes tokenbf_v1 and ngrambf_v1.

Why it matters

This feature allows users to improve query performance and indexing capabilities when working with complex data structures like Array and Map that use FixedString-typed String keys. It enhances the flexibility and applicability of skip indexes to support more data types, enabling more efficient data skipping and faster query execution.

How to use it

When creating skip indexes tokenbf_v1 or ngrambf_v1 on columns of type Array or Map with String keys of FixedString type, the support is automatically available. Users should define the appropriate skip index using CREATE INDEX statements on such columns to benefit from this enhancement.