Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL: Add GREATEST and LEAST functions #35878

Closed
matriv opened this issue Nov 25, 2018 · 1 comment
Closed

SQL: Add GREATEST and LEAST functions #35878

matriv opened this issue Nov 25, 2018 · 1 comment
Assignees
@matriv
Labels
:Analytics/SQL SQL querying >enhancement v6.6.0 v7.0.0-beta1

Comments

@matriv
Copy link
Contributor

matriv commented Nov 25, 2018 •
edited

Add GREATEST(expr1, expr2, ... exprN) and LEAST(expr, expr2,... exprN) functions.

The first one returns the argument with the largest value.
The second on returns the arguments with the smallest value.
Both skip any null arguments in their list and they return null if all arguments are null.

Relates to #34956
@matriv matriv self-assigned this Nov 25, 2018
@elasticmachine
Copy link
Collaborator

Pinging @elastic/es-search

matriv added a commit to matriv/elasticsearch that referenced this issue Nov 25, 2018
@matriv
SQL: Implement GREATEST and LEAST functions
aa402ce 
Add GREATEST(expr1, expr2, ... exprN) and LEAST(expr1, expr2, exprN)
functions which are in the family of CONDITIONAL functions.

Implementation follows PostgreSQL behaviour, so the functions return
`NULL` when all of their arguments evaluate to `NULL`.

Renamed `CoalescePipe` and `CoalesceProcessor` to `ConditionalPipe` and
`ConditionalProcessor` respectively, to be able to reuse them for
`Greatest` and `Least` evaluations. To achieve that `ConditionalOperation`
has been added to differentiate between the functionalities at execution
time.

Closes: elastic#35878
@matriv matriv mentioned this issue Nov 25, 2018
Merged
matriv added a commit that referenced this issue Nov 26, 2018
@matriv
SQL: Implement GREATEST and LEAST functions (#35879)
3f7cae3 
Add GREATEST(expr1, expr2, ... exprN) and LEAST(expr1, expr2, exprN)
functions which are in the family of CONDITIONAL functions.

Implementation follows PostgreSQL behaviour, so the functions return
`NULL` when all of their arguments evaluate to `NULL`.

Renamed `CoalescePipe` and `CoalesceProcessor` to `ConditionalPipe` and
`ConditionalProcessor` respectively, to be able to reuse them for
`Greatest` and `Least` evaluations. To achieve that `ConditionalOperation`
has been added to differentiate between the functionalities at execution
time.

Closes: #35878
matriv added a commit that referenced this issue Nov 26, 2018
@matriv
SQL: Implement GREATEST and LEAST functions (#35879)
44d6c74 
Add GREATEST(expr1, expr2, ... exprN) and LEAST(expr1, expr2, exprN)
functions which are in the family of CONDITIONAL functions.

Implementation follows PostgreSQL behaviour, so the functions return
`NULL` when all of their arguments evaluate to `NULL`.

Renamed `CoalescePipe` and `CoalesceProcessor` to `ConditionalPipe` and
`ConditionalProcessor` respectively, to be able to reuse them for
`Greatest` and `Least` evaluations. To achieve that `ConditionalOperation`
has been added to differentiate between the functionalities at execution
time.

Closes: #35878
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@matriv matriv

Labels
:Analytics/SQL SQL querying >enhancement v6.6.0 v7.0.0-beta1
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@colings86 @matriv @elasticmachine