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.
Description
Full text functions can't yet be used on ES|QL lookup join commands. The following query is not supported:
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.