matrixorigin / matrixorigin/matrixone

[Feature Request]: Allow to build bloom filter on leading columns of cluster key

Open
#18,871 0 comments 0 reactions 1 assignee Assigned to @gouhongshen View on GitHub
ai-heavy area/performance kind/tech-request priority/p0
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

### Is there an existing issue for the same feature request?

- [X] I have checked the existing issues.

### Is your feature request related to a problem?

```Markdown
Allow user to create bloom filter on the leading column, or columns of clustering key. So that we can have better performance for lookups.

The bloom filter could put a burden on meta data size, but, we should be able to lazy load the bloom filter.
```

### Describe the feature you'd like

CREATE TABLE T ... CLUSTER BY (a, b, c) WITH BLOOMFILTER ON (a, b)

Or some similar syntax.

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

_No response_

### Additional information

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.