Skip to content

DOCAPI-7430: MergeTree INDEX bloom filter docs.#5992

Merged
BayoNet merged 5 commits intoClickHouse:masterfrom
BayoNet:en-docs/DOCAPI-7430-bloom
Aug 16, 2019
Merged

DOCAPI-7430: MergeTree INDEX bloom filter docs.#5992
BayoNet merged 5 commits intoClickHouse:masterfrom
BayoNet:en-docs/DOCAPI-7430-bloom

Conversation

@BayoNet
Copy link
Copy Markdown
Contributor

@BayoNet BayoNet commented Jul 12, 2019

I hereby agree to the terms of the CLA available at: https://yandex.ru/legal/cla/?lang=en

Category (leave one):

@BayoNet BayoNet added comp-documentation Documentation (docs, examples, READMEs). pr-documentation Documentation PRs for the specific code PR labels Jul 12, 2019

The same as `ngrambf_v1`, but instead of ngrams stores tokens, which are sequences separated by non-alphanumeric characters.

- `bloom_filter` — Stores [bloom filter](https://en.wikipedia.org/wiki/Bloom_filter) for the specified columns.
Copy link
Copy Markdown
Contributor

@zhang2014 zhang2014 Jul 15, 2019

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

It actually accepts an optional parameter: false positives(default, 0.025)

Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@zhang2014 Does this optional parameter is a probability of false positive response?

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Yes, it should be a float between 0 and 1.

@BayoNet
Copy link
Copy Markdown
Contributor Author

BayoNet commented Jul 31, 2019

@blinkov Do you have any comments?

Copy link
Copy Markdown
Contributor

@blinkov blinkov left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

and some merge conflicts

For a description of request parameters, see [request description](../../query_language/create.md).
For a description of parameters, see the [CREATE query description](../../query_language/create.md).

!!!note "Note"
Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

  • lost space after !!! ?
  • needs link/mention of feature flag to enable it

Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

There is the Data Skipping Indexes section. I think its enough.

@BayoNet BayoNet merged commit 4b91e02 into ClickHouse:master Aug 16, 2019
@BayoNet BayoNet deleted the en-docs/DOCAPI-7430-bloom branch August 16, 2019 15:32
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

comp-documentation Documentation (docs, examples, READMEs). pr-documentation Documentation PRs for the specific code PR

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants