github-mirrors/elasticsearch
1
0
Fork 0
mirror of https://github.com/elastic/elasticsearch.git synced 2025-06-29 09:54:06 -04:00
Code Issues Projects Releases Packages Wiki Activity
elasticsearch/docs/reference/query-languages/esql/images/functions
History
Exact
Kathleen DeRusso eee423aaa0
[ES|QL] Add MATCH_PHRASE (#127661) 
* Initial commit of match_phrase

* Add MatchPhraseQueryTests

* First pass at CSV specs

* Update docs/changelog/127661.yaml

* Refactor so MatchPhrase doesn't use all fulltext test cases, just text only

* Fix tests

* Add some CSV test cases

* Fix test

* Update changelog

* Update tests

* Comment out MATCH_PHRASE in search-functions Markdown

* Minor PR feedback

* PR feedback - refactor/consolidate code

* Add some more tests

* Fix some tests

* [CI] Auto commit changes from spotless

* Fix tests

* PR feedback - add tests, support boost and numeric data

* Revert "PR feedback - add tests, support boost and numeric data"

This reverts commit 4e7a699e3e.

* Apply testing/PR feedback outside numeric support only

* Regenerate docs

* Add negative test

* Update x-pack/plugin/esql/qa/testFixtures/src/main/resources/match-phrase-function.csv-spec

Co-authored-by: Carlos Delgado <6339205+carlosdelest@users.noreply.github.com>

* Update x-pack/plugin/esql/qa/testFixtures/src/main/resources/match-phrase-function.csv-spec

Co-authored-by: Carlos Delgado <6339205+carlosdelest@users.noreply.github.com>

* Update x-pack/plugin/esql/qa/testFixtures/src/main/resources/match-phrase-function.csv-spec

Co-authored-by: Carlos Delgado <6339205+carlosdelest@users.noreply.github.com>

* PR feedback

* Fix auto-commit error

* Regenerate docs

* Update x-pack/plugin/esql/src/main/java/org/elasticsearch/xpack/esql/expression/function/fulltext/MatchPhrase.java

Co-authored-by: Liam Thompson <32779855+leemthompo@users.noreply.github.com>

* Remove non text field types

* Fake test data

* Remove tests that no longer should pass without ip/date/version support

* Put real data in score tests now that I was able to engineer a failure

* Realized the scoring test might be flakey because how it was written, updated

* PR feedback

* PR feedback

* [CI] Auto commit changes from spotless

* Add check to MatchPhrase tests

* Fix merge errors

* [CI] Auto commit changes from spotless

* Test generated docs

* Add additional verifier tests

---------

Co-authored-by: elasticsearchmachine <infra-root+elasticsearchmachine@elastic.co>
Co-authored-by: Carlos Delgado <6339205+carlosdelest@users.noreply.github.com>
Co-authored-by: Liam Thompson <32779855+leemthompo@users.noreply.github.com>
2025-06-04 12:32:24 -04:00
..
abs.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
acos.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
asin.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
atan.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
atan2.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
avg.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
bit_length.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
bucket.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
byte_length.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
case.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
categorize.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
cbrt.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
ceil.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
cidr_match.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
coalesce.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
concat.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
cos.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
cosh.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
count.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
count_distinct.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
date_diff.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
date_extract.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
date_format.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
date_parse.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
date_trunc.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
e.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
ends_with.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
exp.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
floor.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
from_base64.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
greatest.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
hash.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
hypot.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
ip_prefix.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
kql.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
least.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
left.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
length.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
locate.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
log.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
log10.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
ltrim.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
match.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
match_phrase.svg [ES|QL] Add MATCH_PHRASE (#127661) 2025-06-04 12:32:24 -04:00
max.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
md5.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
median.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
median_absolute_deviation.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
min.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
multi_match.svg Add multi_match function #121525 (#125062) 2025-04-15 09:38:08 -04:00
mv_append.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_avg.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_concat.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_count.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_dedupe.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_first.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_last.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_max.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_median.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_median_absolute_deviation.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_min.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_percentile.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_pseries_weighted_sum.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_slice.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
mv_sort.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
mv_sum.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
mv_zip.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
now.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
percentile.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
pi.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
pow.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
qstr.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
repeat.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
replace.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
reverse.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
right.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
round.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
round_to.svg ESQL: ROUND_TO function (#128278) 2025-05-23 10:14:30 -04:00
rtrim.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
sample.svg ES|QL SAMPLE aggregation function (#127629) 2025-05-08 08:01:53 +02:00
scalb.svg Added esql scalb function. (#127696) 2025-05-22 10:47:44 +03:00
sha1.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
sha256.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
signum.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
sin.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
sinh.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
space.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
split.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
sqrt.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_centroid_agg.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_contains.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_disjoint.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_distance.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_envelope.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_extent_agg.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_geohash.svg ES|QL Support for ST_GEOHASH, ST_GEOTILE and ST_GEOHEX (#125143) 2025-06-03 11:49:34 +02:00
st_geohash_to_long.svg ES|QL Support for ST_GEOHASH, ST_GEOTILE and ST_GEOHEX (#125143) 2025-06-03 11:49:34 +02:00
st_geohash_to_string.svg ES|QL Support for ST_GEOHASH, ST_GEOTILE and ST_GEOHEX (#125143) 2025-06-03 11:49:34 +02:00
st_geohex.svg ES|QL Support for ST_GEOHASH, ST_GEOTILE and ST_GEOHEX (#125143) 2025-06-03 11:49:34 +02:00
st_geohex_to_long.svg ES|QL Support for ST_GEOHASH, ST_GEOTILE and ST_GEOHEX (#125143) 2025-06-03 11:49:34 +02:00
st_geohex_to_string.svg ES|QL Support for ST_GEOHASH, ST_GEOTILE and ST_GEOHEX (#125143) 2025-06-03 11:49:34 +02:00
st_geotile.svg ES|QL Support for ST_GEOHASH, ST_GEOTILE and ST_GEOHEX (#125143) 2025-06-03 11:49:34 +02:00
st_geotile_to_long.svg ES|QL Support for ST_GEOHASH, ST_GEOTILE and ST_GEOHEX (#125143) 2025-06-03 11:49:34 +02:00
st_geotile_to_string.svg ES|QL Support for ST_GEOHASH, ST_GEOTILE and ST_GEOHEX (#125143) 2025-06-03 11:49:34 +02:00
st_intersects.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_within.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_x.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_xmax.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_xmin.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_y.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_ymax.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
st_ymin.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
starts_with.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
std_dev.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
substring.svg Additional support for docs for ES|QL operators and version-specific differentiation (#125251) 2025-03-24 09:56:45 +01:00
sum.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
tan.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
tanh.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
tau.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
term.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_aggregate_metric_double.svg [ES|QL] ToAggregateMetricDouble function (#124595) 2025-03-18 11:39:27 -10:00
to_base64.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_boolean.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_cartesianpoint.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_cartesianshape.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_date_nanos.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_dateperiod.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_datetime.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_degrees.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_double.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_geopoint.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_geoshape.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_integer.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_ip.svg ESQL: TO_IP can handle leading zeros (#126532) 2025-04-11 19:45:14 +02:00
to_long.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_lower.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_radians.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_string.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_timeduration.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_unsigned_long.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_upper.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
to_version.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
top.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
trim.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
values.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00
weighted_avg.svg ESQL autogenerate docs v3 (#124312) 2025-03-13 14:16:46 +01:00