Skip to content

ES|QL: Better error messages when FUSE cannot find required columns#141592

Merged
ioanatia merged 4 commits intoelastic:mainfrom
ioanatia:better_fuse_error_message
Feb 4, 2026
Merged

ES|QL: Better error messages when FUSE cannot find required columns#141592
ioanatia merged 4 commits intoelastic:mainfrom
ioanatia:better_fuse_error_message

Conversation

@ioanatia
Copy link
Copy Markdown
Member

closes #141580

Adds custom error messages when we miss any of the columns that FUSE requires.
We need a custom error message, because for a query like:

FROM wikipedia
| FORK (WHERE title:"Europe")
       (WHERE content:"Europe")
| FUSE

we simply return back a validation error:

line 5:3: Unknown column [_id]
line 5:3: Unknown column [_index]
line 5:3: Unknown column [_score]

it is not immediately apparent that these are the column FUSE needs, since _id, _index and _score are not even referenced in the query.

@ioanatia ioanatia added >non-issue Team:Search Relevance Meta label for the Search Relevance team in Elasticsearch :Search Relevance/ES|QL Search functionality in ES|QL labels Jan 30, 2026
@ioanatia ioanatia marked this pull request as ready for review February 4, 2026 10:06
@elasticsearchmachine
Copy link
Copy Markdown
Collaborator

Pinging @elastic/es-search-relevance (Team:Search Relevance)

Copy link
Copy Markdown
Member

@carlosdelest carlosdelest left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Very nice! 👍

@ioanatia ioanatia merged commit a27881e into elastic:main Feb 4, 2026
35 checks passed
@ioanatia ioanatia deleted the better_fuse_error_message branch February 4, 2026 13:48
kosabogi pushed a commit to kosabogi/elasticsearch that referenced this pull request Feb 4, 2026
mamazzol pushed a commit to mamazzol/elasticsearch that referenced this pull request Feb 5, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

>non-issue :Search Relevance/ES|QL Search functionality in ES|QL Team:Search Relevance Meta label for the Search Relevance team in Elasticsearch v9.4.0

Projects

None yet

Development

Successfully merging this pull request may close these issues.

ES|QL: Better error messages for FUSE when required columns are missing

3 participants