Skip to content

ESQL: high count fields sorting removal #125417

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.

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

Open
bpintea opened this issue Mar 21, 2025 · 1 comment
Open

ESQL: high count fields sorting removal #125417

bpintea opened this issue Mar 21, 2025 · 1 comment
Labels
:Analytics/ES|QL AKA ESQL >enhancement Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)

Comments

@bpintea
Copy link
Contributor

bpintea commented Mar 21, 2025

Description

When analysing a query on thousands of fields, sorting these can take a significant chunk of time of the Analyzer (% goes up with fields count).
This is visible in simple queries already (FROM pattern).

The question of usability of a response containing Ks of fields aside, we could consider dropping sorting the fields, should the count be over a given threshold (1K) for improved responsiveness (the user can then still search through the list, by a pattern, in the UI).

Image
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/es-analytical-engine (Team:Analytics)

@elasticsearchmachine elasticsearchmachine added the Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) label Mar 21, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
:Analytics/ES|QL AKA ESQL >enhancement Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)
Projects
None yet
Development

No branches or pull requests

2 participants