elastic / elastic/roadmap

ES|QL: Lookup Join on wildcard match

Open
#224 0 comments 0 reactions 1 assignee Claimed by @tylerperk View on GitHub
Component: Elasticsearch product-area:observability product-area:search product-area:security
Dominant language
No language data
Stars
6
Forks
1
PR merge metrics
No merged PRs in 30d

Description

**Value Proposition**

Lookup Join introduced the ability to do SQL-style LEFT OUTER JOINs in ES|QL. The initial release of Lookup Join relies on a common field name between the left index (from the source command) and the right index (the lookup index), and an exact match of the field values. This satisfies many use cases but more flexibility is needed for other use cases. Some users need to match on wildcards.

**Expected outcome**

ES|QL joins can satisfy a broader set of use cases by offering more expressive join predicates including wildcards. This can also reduce the need for altering the data schema or using workarounds.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.