matrixorigin / matrixorigin/matrixone
[Tech Request]: A Top_N/Bottom_N function like sample
- 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?
We will have a sample function sample(a, b, c, n rows) or sample(a, b, c, n percents), so it should be relatively easy to add a Top_N and Bottom_N functions.
### Describe the feature you'd like
select top_n(a, b, c, n rows), the semantics is the same as sample except it returns top n rows of a, b, c in dictionary order. So is bottom_n.
### Describe implementation you've considered
_No response_
### Documentation, Adoption, Use Case, Migration Strategy
_No response_
### Additional information
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.