opensearch-project / opensearch-project/sql
[FEATURE] `isnotempty` function
Open
@lucacavenaghi97 is already working on this.
Since Mar 2, 2026.
enhancement
good first issue
PPL
- Dominant language
- Java
- Stars
- 176
- Forks
- 229
- Avg merge
- 2d 21h
- Merged PRs (30d)
- 43
Description
Is your feature request related to a problem?
We have an isempty PPL function. Arguably more useful is its counterpart, non-emptiness. This currently is done with not isempty.
What solution would you like?
An isnotempty function. This would follow the same pattern as e.g. isnotnull.
What alternatives have you considered?
N/A
Do you have any additional context?
You could probably make the same case for ispresent/isnotpresent and isblank/isnotblank.
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.