Skip to content

ESQL: pushdown starts_with , ends_with functions #123067

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.

Sign up for GitHub

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

Jump to bottom
Closed
costin opened this issue Feb 20, 2025 · 1 comment · Fixed by #123381
Closed

ESQL: pushdown starts_with , ends_with functions #123067

costin opened this issue Feb 20, 2025 · 1 comment · Fixed by #123381
Assignees
@ivancea
Labels
:Analytics/ES|QL AKA ESQL >enhancement Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)

Comments

@costin
Copy link
Member

costin commented Feb 20, 2025

Description

Starts_with and ends_with functions in WHERE clause can be translated to filters when dealing with constants (similar to like), resulting in much better performance.
@elasticsearchmachine elasticsearchmachine added the Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) label Feb 20, 2025
@elasticsearchmachine
Copy link
Collaborator

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

@ivancea ivancea self-assigned this Feb 25, 2025
@ivancea ivancea mentioned this issue Feb 25, 2025
Merged
ivancea added a commit to ivancea/elasticsearch that referenced this issue Mar 11, 2025
@ivancea
ESQL: Push down StartsWith and EndsWith functions to Lucene (elastic#…
677d0d7 
…123381)

Fixes elastic#123067

Just like WildcardLike and RLike, some functions can be converted to Lucene queries. Here it's those two, which are nearly identical to WildcardLike

This, like some other functions, needs a FoldContext. I'm using the static method for this here, but it's fixed in elastic#123398, which I kept separated as it changes many files
ivancea added a commit to ivancea/elasticsearch that referenced this issue Mar 11, 2025
@ivancea
ESQL: Push down StartsWith and EndsWith functions to Lucene (elastic#…
c88a2ab 
…123381)

Fixes elastic#123067

Just like WildcardLike and RLike, some functions can be converted to Lucene queries. Here it's those two, which are nearly identical to WildcardLike

This, like some other functions, needs a FoldContext. I'm using the static method for this here, but it's fixed in elastic#123398, which I kept separated as it changes many files
elasticsearchmachine pushed a commit that referenced this issue Mar 11, 2025
@ivancea
ESQL: Push down StartsWith and EndsWith functions to Lucene (#123381) (…
b9c61dc 
…#124583)

Fixes #123067

Just like WildcardLike and RLike, some functions can be converted to Lucene queries. Here it's those two, which are nearly identical to WildcardLike

This, like some other functions, needs a FoldContext. I'm using the static method for this here, but it's fixed in #123398, which I kept separated as it changes many files
elasticsearchmachine pushed a commit that referenced this issue Mar 11, 2025
@ivancea
ESQL: Push down StartsWith and EndsWith functions to Lucene (#123381) (…
151ea39 
…#124582)

Fixes #123067

Just like WildcardLike and RLike, some functions can be converted to Lucene queries. Here it's those two, which are nearly identical to WildcardLike

This, like some other functions, needs a FoldContext. I'm using the static method for this here, but it's fixed in #123398, which I kept separated as it changes many files
albertzaharovits pushed a commit to albertzaharovits/elasticsearch that referenced this issue Mar 13, 2025
@ivancea @albertzaharovits
ESQL: Push down StartsWith and EndsWith functions to Lucene (elastic#…
1cd043d 
…123381)

Fixes elastic#123067

Just like WildcardLike and RLike, some functions can be converted to Lucene queries. Here it's those two, which are nearly identical to WildcardLike

This, like some other functions, needs a FoldContext. I'm using the static method for this here, but it's fixed in elastic#123398, which I kept separated as it changes many files
jfreden pushed a commit to jfreden/elasticsearch that referenced this issue Mar 13, 2025
@ivancea @jfreden
ESQL: Push down StartsWith and EndsWith functions to Lucene (elastic#…
46416c7 
…123381)

Fixes elastic#123067

Just like WildcardLike and RLike, some functions can be converted to Lucene queries. Here it's those two, which are nearly identical to WildcardLike

This, like some other functions, needs a FoldContext. I'm using the static method for this here, but it's fixed in elastic#123398, which I kept separated as it changes many files
ivancea added a commit to ivancea/elasticsearch that referenced this issue Mar 14, 2025
@ivancea
ESQL: Push down StartsWith and EndsWith functions to Lucene (elastic#…
f01e19e 
…123381)

Fixes elastic#123067

Just like WildcardLike and RLike, some functions can be converted to Lucene queries. Here it's those two, which are nearly identical to WildcardLike

This, like some other functions, needs a FoldContext. I'm using the static method for this here, but it's fixed in elastic#123398, which I kept separated as it changes many files
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@ivancea ivancea

Labels
:Analytics/ES|QL AKA ESQL >enhancement Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

ESQL: Push down StartsWith and EndsWith functions to Lucene ivancea/elasticsearch
3 participants
@costin @ivancea @elasticsearchmachine