v.20.11New Feature

Added Support for Big Integers and UUID in MergeTree BloomFilter Index

Added big integers (UInt256, Int128, Int256) and UUID data types support for MergeTree BloomFilter index. Big integers is an experimental feature. #16642 (Maksim Kita).
Added support for big integer types (UInt256, Int128, Int256) and UUID data types in the MergeTree BloomFilter index.

Why it matters

This feature enables the use of BloomFilter indices on large integer and UUID columns in MergeTree tables, improving query performance for these data types. Big integers support is experimental, allowing users to leverage approximate membership checks on high-precision integer keys.

How to use it

Create or modify a MergeTree table to include a BloomFilter index on columns of type UInt256, Int128, Int256, or UUID. The BloomFilter index will then accelerate filtering operations on these columns during query execution.