Tracked in https://github.com/elastic/elasticsearch/issues/123043 This meta issue tracks the progress on MATCH features for ES|QL. ## In progress - https://github.com/elastic/elasticsearch/issues/125481 ## Backlog - Before GA ## Backlog - Post GA - https://github.com/elastic/elasticsearch/issues/127415 - https://github.com/elastic/elasticsearch/issues/129153 - Add fuzziness for match operator - Add boosting for match function and operator (prerequirement: https://github.com/elastic/elasticsearch/pull/113120) - #115297 - EVAL between match functions with scoring enabled - Allow match after `STATS .. BY` when push down filters past stats is allowed (https://github.com/elastic/elasticsearch/issues/115311) - https://github.com/elastic/elasticsearch/issues/125012 - https://github.com/elastic/elasticsearch/issues/125482 - Add `zero_terms_query` parameter support - Use MATCH after EVAL: https://github.com/elastic/elasticsearch/issues/130567 ## Done - https://github.com/elastic/elasticsearch/pull/113374 - https://github.com/elastic/elasticsearch/pull/114831 - #115353 - https://github.com/elastic/elasticsearch/pull/116819 - Improve type compatibility for match - Add boolean, number, date, IP...- - https://github.com/elastic/elasticsearch/pull/117555 - https://github.com/elastic/elasticsearch/pull/118544 - ~Avoid failing on indices that don't have the field (when querying multiple indices)~ - This was checked and works correctly - [Allow additional options for match function](https://github.com/elastic/elasticsearch/pull/120360) - Allow disjunctions to work for match function and operator - [Design doc](https://docs.google.com/document/d/1g6ocs-T03cm5RRqwW7s1mHEV1lRoZWhrWrM54XvLKtk/edit? - https://github.com/elastic/elasticsearch/pull/120291 - https://github.com/elastic/elasticsearch/pull/121793 - https://github.com/elastic/elasticsearch/pull/124540 - https://github.com/elastic/elasticsearch/issues/124649 - Stress test for full text functions - Benchmarking done in [this doc](https://docs.google.com/document/d/1YhH-CNpj83U5sbZRBYf3NiCi19AUpxY_PtXsi64U93Q/edit?tab=t.0#heading=h.70abqz370o3z)
Tracked in #123043
This meta issue tracks the progress on MATCH features for ES|QL.
In progress
Backlog - Before GA
Backlog - Post GA
STATS .. BYwhen push down filters past stats is allowed (ESQL: push down filters past STATS #115311)zero_terms_queryparameter supportDone
MATCHfollowingMV_EXPANDwill produce an invalid plan #115353Avoid failing on indices that don't have the field (when querying multiple indices)- This was checked and works correctly