This page describes configuring the bloom filter for Apache Pinot
The bloom filter prunes segments that do not contain any record matching an EQUALITY predicate.
This is useful for a query like the following:
WHERE playerID = 12345
There are 3 parameters to configure the bloom filter:
fpp: False positive probability of the bloom filter (from
0.05by default). The lower the
fpp, the higher accuracy the bloom filter has, but it will also increase the size of the bloom filter.
maxSizeInBytes: Maximum size of the bloom filter (unlimited by default). If a
fppsetting generates a bloom filter larger than this size, using this setting will increase the
fppto keep the bloom filter size within this limit.
loadOnHeap: Whether to load the bloom filter using heap memory or off-heap memory (
- Default settings
- Customized parameters