v.19.16New Feature

Support Bloom Filter Indexes on Array Columns

Support Bloom filter indexes on Array columns. #6984 (achimbab)
Added support for Bloom filter indexes on Array columns in ClickHouse.

Why it matters

This feature enables the use of Bloom filter indexes to efficiently filter queries on Array columns, improving query performance by quickly excluding rows that do not match the filter criteria. It enhances index capabilities for complex data types like arrays.

How to use it

To use Bloom filter indexes on Array columns, create a BLOOM_FILTER index on the desired Array column in your table schema. Queries involving these columns can then benefit from faster filtering based on the Bloom filter index.