Using Bloom filter indexes for real-time text search in ClickHouse

1 · Tinybird.co · June 22, 2023, midnight
A customer of ours had text-based log data and they wanted to be able to search over the text (quickly). However, in ClickHouse, text search without any special measures involves a full scan, period. And we know that full scans are not efficient. Enter ClickHouse's "Data Skipping Indexes,” which are based on Bloom filters....