Skip to content

Enhance position of nulls inside composite aggs sorting #34221

@costin

Description

@costin

Currently, missing values are treated as nulls and appear either first by default (using ASC sorting) or last for DESC sorting.
It would be useful to further enhance the sorting similar to FieldSortBuilder to specify whether the missing values should appear last (_last) or first (_first). In SQL this would allow implementing NULLS FIRST/LAST functionality as well as offer the expected behavior (that NULLs have a fixed position regardless of ordering).

Metadata

Metadata

Assignees

Labels

>enhancementTeam:AnalyticsMeta label for analytical engine team (ESQL/Aggs/Geo)

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions