v.21.11Improvements
Skip Indexes Enhancements: Support for Array and Map Data Types in tokenbf_v1 and ngrambf_v1
Skip indexestokenbf_v1andngrambf_v1: added support forArraydata type with key ofStringofFixedStringtype. #29280 (Maksim Kita). Skip indexestokenbf_v1andngrambf_v1added support forMapdata type with key ofStringofFixedStringtype. Author @lingtaolf. #29220 (Maksim Kita).
Why it matters
This feature allows users to improve query performance and indexing capabilities when working with complex data structures likeArray 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 indexestokenbf_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.