-
Notifications
You must be signed in to change notification settings - Fork 25k
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
Synthetic source should not load fields that are not required #94001
Labels
Comments
elasticsearchmachine
added
the
Team:Analytics
Meta label for analytical engine team (ESQL/Aggs/Geo)
label
Feb 22, 2023
Pinging @elastic/es-analytics-geo (Team:Analytics) |
Note that the source is completely synthesized if source filtering is active. For example in this case:
Ideally only fields that match with the source filtering should be loaded. |
wchaparro
removed
the
Team:Analytics
Meta label for analytical engine team (ESQL/Aggs/Geo)
label
Jun 21, 2024
Pinging @elastic/es-storage-engine (Team:StorageEngine) |
3 tasks
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
The current implementation synthesise the full document regardless if the value is required on the final response doing unnecessary work that can be very expensive on slow disk.
Consider the following example:
The query is not asking for source and only requesting the value of one of the fields. Still in this case we synthesise source with all the fields, accessing 4 doc values. We should be able to read just the requested value in this case.
The text was updated successfully, but these errors were encountered: