ClickHouse Using Bloom filter indexes for real-time text search in ClickHouse®️ 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.