bloom_index

README.md

Steps to reproduce

for v in 20.3 20.4 20.5 20.6 20.7 20.8 20.9 20.10 latest; do CLICKHOUSE_VERSION=$v bash -c "docker-compose down && docker-compose up -d clickhouse && sleep 1 && docker-compose exec clickhouse bash -c 'clickhouse-client -mn < /queries.sql | grep -i bloom'"; done

docker-compose.yaml

version: '3'
services:
  clickhouse:
    image: yandex/clickhouse-server:${CLICKHOUSE_VERSION:-latest}
    volumes:
      - ./queries.sql:/queries.sql

queries.sql

DROP TABLE IF EXISTS default.test_bloom_filter_025 ;
CREATE TABLE default.test_bloom_filter_025     (
     `timestamp` DateTime64(3,'UTC') DEFAULT now64(),
     `uid` String,
     INDEX bloom_filter_uid uid TYPE bloom_filter(0.025) GRANULARITY 5
) ENGINE = MergeTree() ORDER BY tuple(timestamp, uid);

INSERT INTO default.test_bloom_filter_025 SELECT * FROM generateRandom('timestamp DateTime64(3), string String', 1, 32, 2) LIMIT 1000000;

SET send_logs_level='trace';

SELECT * FROM default.test_bloom_filter_025 WHERE uid = 'no_existing_value';