matrixorigin / matrixorigin/matrixone

[Tech Request]: A Top_N/Bottom_N function like sample

Open
#12,643 1 comment 0 reactions 1 assignee Assigned to @iamlinjunhong View on GitHub
kind/feature kind/tech-request team/c2
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

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.