opensearch-project / opensearch-project/sql
[FEATURE] Enhance `dedup` PPL command with `sortby` option
Open
@ykmr1224 is already working on this.
Since Aug 18, 2025.
calcite
enhancement
PPL
Priority-Low
- Dominant language
- Java
- Stars
- 176
- Forks
- 229
- Avg merge
- 2d 21h
- Merged PRs (30d)
- 43
Description
Add sortby option to dedup PPL command to make it easy to sort the result.
When sortby option is specified, the input rows should be sorted before dedup. (equivalent to put sort command before dedup command)
Syntax:
dedup ...(other params) <sort-by-clause>
<sort-by-clause>
Syntax: sortby ( - | + ) <sort-field> [(- | +) <sort_field> ...]
Example:
dedup user sortby -_time
Priority: Low (Expecting lower usage and can be done with separate sort command)
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.