Skip to content

ES|QL brute force dot_product vector function#131629

Merged
tteofili merged 10 commits intoelastic:mainfrom
tteofili:esql_bf_dot_product
Jul 22, 2025
Merged

ES|QL brute force dot_product vector function#131629
tteofili merged 10 commits intoelastic:mainfrom
tteofili:esql_bf_dot_product

Conversation

@tteofili
Copy link
Copy Markdown
Contributor

@tteofili tteofili commented Jul 21, 2025 •
edited
Loading

This introduces the v_dot_product vector function for brute force dense vector search in ES|QL.
e.g.,

FROM colors
 | EVAL similarity = V_DOT_PRODUCT(rgb_vector, [0, 255, 255]) 
 | SORT similarity DESC

fixes #131622.

I've also added a bunch of missing doc files for v_cosine.

@elasticsearchmachine elasticsearchmachine added the Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) label Jul 21, 2025
@elasticsearchmachine
Copy link
Copy Markdown
Collaborator

elasticsearchmachine commented Jul 21, 2025

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

@github-actions
Copy link
Copy Markdown
Contributor

github-actions bot commented Jul 21, 2025 •
edited
Loading

🔍 Preview links for changed docs

@tteofili tteofili added the test-release Trigger CI checks against release build label Jul 21, 2025
@tteofili tteofili added the :Search Relevance/Search Catch all for Search Relevance label Jul 21, 2025
@elasticsearchmachine
Copy link
Copy Markdown
Collaborator

elasticsearchmachine commented Jul 21, 2025

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

@elasticsearchmachine elasticsearchmachine added the Team:Search Relevance Meta label for the Search Relevance team in Elasticsearch label Jul 21, 2025
carlosdelest
carlosdelest approved these changes Jul 21, 2025
View reviewed changes
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.

LGTM 👏

Small comments about CSV tests and some capability checks missing

tteofili and others added 8 commits July 21, 2025 18:07
@tteofili
Merge branch 'main' of github.com:elastic/elasticsearch into esql_bf_…
857333b 
…dot_product
@tteofili @carlosdelest
Update x-pack/plugin/esql/qa/testFixtures/src/main/resources/vector-d…
f7a2370 
…ot-product.csv-spec

Co-authored-by: Carlos Delgado <6339205+carlosdelest@users.noreply.github.com>
@tteofili @carlosdelest
Update x-pack/plugin/esql/qa/testFixtures/src/main/resources/vector-d…
ba41a32 
…ot-product.csv-spec

Co-authored-by: Carlos Delgado <6339205+carlosdelest@users.noreply.github.com>
@tteofili @carlosdelest
Update x-pack/plugin/esql/qa/testFixtures/src/main/resources/vector-d…
c5d8911 
…ot-product.csv-spec

Co-authored-by: Carlos Delgado <6339205+carlosdelest@users.noreply.github.com>
@tteofili
Merge branch 'main' of github.com:elastic/elasticsearch into esql_bf_…
d43dd50 
…dot_product
@tteofili
add missing capability check
4b96f2a
@tteofili
csv test fix
5efa25b
@tteofili
csv test fix
25ed279
@tteofili tteofili merged commit cc68b17 into elastic:main Jul 22, 2025
34 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@carlosdelest carlosdelest carlosdelest approved these changes

@afoucret afoucret Awaiting requested review from afoucret

@ChrisHegarty ChrisHegarty Awaiting requested review from ChrisHegarty

Assignees

No one assigned

Labels

:Analytics/ES|QL AKA ESQL >non-issue :Search Relevance/Search Catch all for Search Relevance Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) Team:Search Relevance Meta label for the Search Relevance team in Elasticsearch test-release Trigger CI checks against release build v9.2.0

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

V_DOT_PRODUCT – calculates dot product

3 participants

@tteofili @elasticsearchmachine @carlosdelest