Skip to content

ES|QL - Full text functions should work with LOOKUP JOIN #129153

@carlosdelest

Description

@carlosdelest

Description

Full text functions can't yet be used on ES|QL lookup join commands. The following query is not supported:

FROM employees
| EVAL language_code = languages
| LOOKUP JOIN languages_lookup ON language_code
| WHERE MATCH(language_name, "Spanish") 

This issue will track enhancing the compute engine to support Full Text Functions, especially Full Text Functions that cannot be pushed on the left side or right side of a lookup join. The more corner case of supporting Full Text Function on the right side of the lookup join will be handled in #135621.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions