Package org.elasticsearch.xpack.esql.action

Enum Class EsqlCapabilities.Cap

java.lang.Object

java.lang.Enum<EsqlCapabilities.Cap>

org.elasticsearch.xpack.esql.action.EsqlCapabilities.Cap

All Implemented Interfaces:

Serializable, Comparable<EsqlCapabilities.Cap>, Constable

Enclosing class:

EsqlCapabilities

public static enum EsqlCapabilities.Cap
extends Enum<EsqlCapabilities.Cap>

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
ACOSH_FUNCTION	Support for the ACOSH function.
ADD_LIMIT_INSIDE_MV_EXPAND	Fix pushdown of LIMIT past MV_EXPAND
ADD_SUB_OPERATOR_TIMEZONE_SUPPORT	Support timezones in + and - operators.
AGG_MAX_MIN_BOOLEAN_SUPPORT	Support for booleans in aggregations MAX and MIN.
AGG_MAX_MIN_IP_SUPPORT	Support for ips in aggregations MAX and MIN.
AGG_MAX_MIN_STRING_SUPPORT	Support for strings in aggregations MAX and MIN.
AGG_MAX_MIN_UNSIGNED_LONG	Accept unsigned longs on MAX and MIN aggregations.
AGG_SAMPLE	Support for the SAMPLE aggregation function
AGG_TOP	Support for aggregation function TOP.
AGG_TOP_BOOLEAN_SUPPORT	Support for booleans in TOP aggregation.
AGG_TOP_IP_SUPPORT	Support for ips in TOP aggregation.
AGG_TOP_STRING_SUPPORT	Support for keyword and text fields in TOP aggregation.
AGG_TOP_WITH_OPTIONAL_ORDER_FIELD	Make optional the order field in the TOP agg command, and default it to "ASC".
AGG_TOP_WITH_OUTPUT_FIELD	Support for the extra "map" field in TOP aggregation.
AGG_VALUES	The introduction of the VALUES agg.
AGG_VALUES_SAMPLE_UNSIGNED_LONG	Accept unsigned longs on VALUES and SAMPLE aggregations.
AGG_VALUES_SPATIAL	Expand the VALUES agg to cover spatial types.
AGG_WEIGHTED_AVG	Support for WEIGHTED_AVG function.
AGGREGATE_METRIC_DOUBLE_AVG_AS_DEFAULT_METRIC	Support avg as a possible default metric for aggregate_metric_double
AGGREGATE_METRIC_DOUBLE_BINARY_OPERATORS	Support binary operators for aggregate_metric_double
AGGREGATE_METRIC_DOUBLE_DEFAULT_METRIC	Support running all aggregations on aggregate_metric_double using the default metric
AGGREGATE_METRIC_DOUBLE_NO_ROWS_COUNT_0	Return 0 (instead of null) for count on AMD when there are no rows
AGGREGATE_METRIC_DOUBLE_V0	Enable aggregate_metric_double in non-snapshot builds
ALLOW_CASTING_IN_DEFAULT_TS_AGGS	Fix for 140670, this allows for type conversion functions with no further computation to be evaluated inside default wrapping _over_time functions.
APPROXIMATION_V6	Support query approximation.
ASINH_FUNCTION	Support for the ASINH function.
ASYNC_OPERATOR_WARNINGS_FIX	Fix for async operator sometimes completing the driver without emitting the stored warnings
ASYNC_QUERY	Does ESQL support async queries.
ASYNC_QUERY_STATUS_HEADERS	Support sending HTTP headers about the status of an async query.
ASYNC_QUERY_STATUS_HEADERS_FIX	Fix async headers not being sent on "get" requests
ATANH_FUNCTION	Support for the ATANH function.
ATTRIBUTE_EQUALS_RESPECTS_NAME_ID	Fix attribute equality to respect the name id of the attribute.
AUTO_PARTITION_DOCS_THRESHOLD	Added PlannerSettings.DOC_THRESHOLD_AUTO_PARTITIONING
BASE_CONVERSION	Support for base conversion in TO_LONG and TO_INTEGER
BASE64_DECODE_ENCODE	Base64 encoding and decoding functions.
BUCKET_INCLUSIVE_UPPER_BOUND	Consider the upper bound when computing the interval in BUCKET auto mode.
BUCKET_WHOLE_NUMBER_AS_SPAN	Support for the whole number spans in BUCKET function.
CASE_FOLD_TEMPORAL_AMOUNT	CASE folding with DATE_PERIOD and TIME_DURATION return types.
CASE_MV	CASE properly handling multivalue conditions.
CASE_SUPPORT_FOR_SUMMARY_FIELDS	Adds the ability for the Case to return values of type TDIGEST, type HISTOGRAM, and type AGGREGATE_METRIC_DOUBLE.
CAST_STRING_LITERAL_TO_TEMPORAL_AMOUNT	Support explicit casting from string literal to DATE_PERIOD or TIME_DURATION.
CASTING_OPERATOR	Support for the :: casting operator
CASTING_OPERATOR_FOR_DATE	Support for the ::date casting operator
CASTING_OPERATOR_FOR_HISTOGRAM_TYPES	Support for the ::tdigest and ::exponential_histogram casting operators.
CATEGORIZE_MULTIPLE_GROUPINGS	Support for multiple groupings in "CATEGORIZE".
CATEGORIZE_OPTIONS	Support for the options field of CATEGORIZE.
CATEGORIZE_V6	Supported the text categorization function "CATEGORIZE".
CHANGE_POINT	Support change point detection "CHANGE_POINT".
CHANGE_POINT_ARGS_ANY_ORDER	Support CHANGE_POINT arguments in any order
CHANGE_POINT_SUPPORT_NULL_COLUMN	Support the null column type for the CHANGE_POINT command
CHUNK_FUNCTION_V2	Chunk function.
CHUNK_MV	Does CHUNK process all field values?
CLAMP_FUNCTIONS
COALESCE_DENSE_VECTOR	COALESCE function support for dense_vector type.
COMBINE_BINARY_COMPARISONS	Add CombineBinaryComparisons rule.
COMBINE_DISJUNCTIVE_CIDRMATCHES	Support CIDRMatch in CombineDisjunctions rule.
COMPLETION	Support for COMPLETION command
CONDITIONAL_BLOCK_LOADER_FOR_TEXT_FIELDS	Adds a conditional block loader for text fields that prefers using the sub-keyword field whenever possible.
COPY_SIGN	Support for the COPY_SIGN function.
CORRECT_SKIPPED_SHARDS_COUNT	Support correct counting of skipped shards.
COSINE_VECTOR_SIMILARITY_FUNCTION	Cosine vector similarity function
COUNT_OF_HISTOGRAM_TYPES	Support for running the Count aggregation on t-digest and exponential histogram types
COUNTER_TYPES	Support metrics counter types
DATE_DIFF_TIMEZONE_SUPPORT	Support timezones in DATE_DIFF.
DATE_DIFF_YEAR_CALENDARIAL	Compute year differences in full calendar years.
DATE_FORMAT_DATE_PARSE_TIMEZONE_SUPPORT	Support timezones in DATE_FORMAT and DATE_PARSE.
DATE_NANOS_ADD_SUBTRACT	Support add and subtract on date nanos
DATE_NANOS_AGGREGATIONS	support aggregations on date nanos
DATE_NANOS_BINARY_COMPARISON	Support for date nanos type in binary comparisons
DATE_NANOS_BUCKET	Support date nanos values as the field argument to bucket
DATE_NANOS_COMPARE_TO_MILLIS	Support for mixed comparisons between nanosecond and millisecond dates
DATE_NANOS_DATE_DIFF	support date diff function on date nanos type, and mixed nanos/millis
DATE_NANOS_DATE_EXTRACT	support date extract function for date nanos
DATE_NANOS_DATE_FORMAT	Support running date format function on nanosecond dates
DATE_NANOS_IMPLICIT_CASTING	Support implicit casting of strings to date nanos
DATE_NANOS_IN_OPERATOR	Support the In operator for date nanos
DATE_NANOS_LOOKUP_JOIN	Support for date nanos in lookup join.
DATE_NANOS_TYPE	Support for nanosecond dates as a data type
DATE_PARSE_OPTIONS	Optional options argument for DATE_PARSE
DATE_PARSE_TZ	DATE_PARSE supports reading timezones
DATE_RANGE_FIELD_TYPE	Support for the DATE_RANGE field type.
DATE_TIME_EXCEPTIONS_HANDLED	Exceptions parsing date-times are thrown as IllegalArgumentException
DATE_TRUNC_DATE_NANOS	Support for date_trunc function on date nanos type
DATE_TRUNC_TIMEZONE_SUPPORT	Support timezones in DATE_TRUNC and dependent functions.
DATE_TRUNC_WITH_ARBITRARY_INTERVALS	Enhanced DATE_TRUNC with arbitrary month and year intervals.
DECAY_FUNCTION	Decay function for custom scoring.
DECAY_FUNCTION_PARAMETER_CONVERSION	Fix conversions for parameters for DECAY.
DELAY_DEBUG_FN
DELTA_TS_AGG
DENSE_VECTOR_AGG_FUNCTIONS	Dense_vector aggregation functions
DENSE_VECTOR_AGG_METRIC_DOUBLE_IF_FNS
DENSE_VECTOR_AGG_METRIC_DOUBLE_IF_VERSION
DENSE_VECTOR_ARITHMETIC	Support for dense_vector arithmetic operations (+, -, *, /)
DENSE_VECTOR_EQUALITY	Support for dense_vector equality and inequality operators (==, !=).
DENSE_VECTOR_FIELD_TYPE_BIT_ELEMENTS	Bit elements dense vector field type support.
DENSE_VECTOR_FIELD_TYPE_BYTE_ELEMENTS	Byte elements dense vector field type support.
DENSE_VECTOR_FIELD_TYPE_RELEASED	Dense vector field type support
DENSE_VECTOR_SCALAR_ARITHMETIC	Support for arithmetic operations (+, -, *, /) between dense_vector and scalar values
DENSE_VECTOR_SUM_FUNCTION	Dense_vector SUM aggregation function
DISABLE_NULLABLE_OPTS	When we disabled some broken optimizations around nullable.
DOCUMENTS_FOUND_AND_VALUES_LOADED	Are the documents_found and values_loaded fields available in the response and profile?
DOT_PRODUCT_VECTOR_SIMILARITY_FUNCTION	Dot product vector similarity function
DOTS_IN_FUSE	Support for dots in FUSE attributes
DOUBLE_PARAMETER_MARKERS_FOR_IDENTIFIERS	Use double parameter markers to represent field or function names.
DOUBLE_QUOTES_SOURCE_ENCLOSING	Support for quoting index sources in double quotes.
DROP_AGAIN_WITH_WILDCARD_AFTER_EVAL	Support for keeping `DROP` attributes when resolving field names.
DROP_WITH_WILDCARD_AFTER_LOOKUP_JOIN	Correctly ask for all fields from lookup indices even when there is e.g.
EARLIEST_LATEST_AGGS	Alias for calling FIRST (or LAST) and only passing the search field.
ENABLE_FORK_FOR_REMOTE_INDICES_V2	FORK with remote indices
ENABLE_LOOKUP_JOIN_ON_ALIASES	Enable support for index aliases in lookup joins
ENABLE_LOOKUP_JOIN_ON_REMOTE	Enable support for cross-cluster lookup joins.
ENABLE_REDUCE_NODE_LATE_MATERIALIZATION	Enables late materialization on node reduce.
ENRICH_DENSE_VECTOR_BUGFIX	Enrich works with dense_vector fields
ENRICH_LOAD	Support for loading values over enrich.
ENRICH_STRICT_RANGE_TYPES	Enforce strict type checking on ENRICH range types, and warnings for KEYWORD parsing at runtime.
ESQL_LIMIT_BY	Enables the feature LIMIT n BY expr1, expr2 for retaining at most n docs per group.
ESQL_TOPN_BY	Enables the SORT | LIMIT n BY expr1, expr2 support, see ESQL_LIMIT_BY for more context
ESQL_WITHOUT_GROUPING	Support for`WITHOUT` grouping function that excludes specific dimensions from time-series grouping.
EXPLAIN	(Re)Added EXPLAIN command
EXPLAIN_WITH_REMOTE_PLANS	EXPLAIN command with remote plans (5 columns: cluster, node, role, type, plan)
EXPONENTIAL_HISTOGRAM_TECH_PREVIEW	Support for exponential_histogram fields in the state of when it first was released into tech preview.
EXTERNAL_COMMAND	Support for the EXTERNAL command (datasource access).
EXTERNAL_CSV_IP_SUPPORT	Support for the EXTERNAL command (datasource access).
FIELD_ALIAS_SUPPORT	Support for field aliases in mappings.
FILTER_IN_CONVERTED_NULL	Support for filter in converted null.
FIRST_AGG_WITH_NULL_AND_MV_SUPPORT	Make FIRST agg work with null and multi-value fields.
FIRST_LAST_AGG_ON_INTS	Support aggregating on integers in FIRST/LAST.
FIRST_LAST_AGG_WITH_DATES	Allow FIRST/LAST aggs to accept DATE/DATE_NANOS in the search field https://github.com/elastic/elasticsearch/issues/142137
FIRST_LAST_OVER_TIME_COUNTER_SUPPORT	Add support for counter doubles, ints, and longs in first_ and last_over_time
FIX_AGG_FIRST_LAST_FOLDABLES_IN_SORT_FIELD	Support passing constants and null in the second parameter of FIRST/LAST aggs.
FIX_AGG_ON_NULL_BY_REPLACING_WITH_EVAL	ReplaceStatsFilteredOrNullAggWithEval now replaces an AggregateFunction with null value with an Eval.
FIX_AGG_TOP_WITH_OUTPUT_FIELD_SURROGATE	Fix for a bug when surrogating a TOP with limit 1 and output field.
FIX_AGGREGATION_FRAMEWORK_CHANNELS	Fix for an ArrayIndexOutOfBoundsException in the aggregation framework when the same field is passed twice.
FIX_ALIAS_ID_WHEN_DROP_ALL_AGGREGATES
FIX_COUNT_DISTINCT_SOURCE_ERROR	Fix the status code returned when trying to run count_distinct on the _source type (which is not supported).
FIX_COUNT_PUSHDOWN_FOR_UNION_TYPES	When pushing down STATS count(field::type) for a union type field, we wrongly used a synthetic attribute name in the query instead of the actual field name.
FIX_DATE_NANOS_LUCENE_PUSHDOWN_BUG	Indicates that https://github.com/elastic/elasticsearch/issues/125439 (incorrect lucene push down for date nanos) is fixed
FIX_DATE_NANOS_MIXED_RANGE_PUSHDOWN_BUG	Fixes a bug where dates are incorrectly formatted if a where clause compares nanoseconds to both milliseconds and nanoseconds, e.g.
FIX_DISPLAYING_TS_DIMENSIONS_IN_METRICS_GROUP_BY_ALL	Fix for not including metadata _doc_count in the _timeseries column https://github.com/elastic/elasticsearch/issues/143464
FIX_DIV_ERROR_MESSAGE
FIX_DOUBLY_RELEASED_NULL_BLOCKS_IN_VALUESOURCEREADER	When creating constant null blocks in ValuesSourceReaderOperator, we also handed off the ownership of that block - but didn't account for the fact that the caller might close it, leading to double releases in some union type queries.
FIX_ENRICH_ALIAS_CYCLE_IN_DEDUPLICATE_AGGS	Fix for circular reference in alias chains during PushDownEnrich and aggregate deduplication.
FIX_FILTER_ORDINALS	Create new block when filtering OrdinalBytesRefBlock
FIX_FILTER_PUSHDOWN_PAST_STATS	Fix for an optimization that caused wrong results https://github.com/elastic/elasticsearch/issues/115281
FIX_FOLD_COALESCE	Fix folding of coalesce function https://github.com/elastic/elasticsearch/issues/139344
FIX_FORK_UNMAPPED_NULLIFY	Fixes an analysis bug in FORK with unmapped_fields="nullify".
FIX_FULL_TEXT_FUNCTIONS_ON_CONSTANT_KEYWORD	Fix for full-text functions (MATCH, MATCH_PHRASE, :) on constant_keyword fields.
FIX_FULL_TEXT_FUNCTIONS_ON_RENAMED_FIELDS	Fix for full-text functions failing on renamed fields.
FIX_INLINE_STATS_GROUP_BY_NULL	Fix for INLINE STATS GROUP BY null being incorrectly pruned by PruneLeftJoinOnNullMatchingField.
FIX_INLINE_STATS_INCORRECT_PRUNNING	https://github.com/elastic/elasticsearch/issues/138283
FIX_JOIN_MASKING_EVAL	During resolution (pre-analysis) we have to consider that joins or enriches can override EVALuated values https://github.com/elastic/elasticsearch/issues/126419
FIX_JOIN_MASKING_REGEX_EXTRACT	During resolution (pre-analysis) we have to consider that joins can override regex extracted values see ES|QL: pruning of JOINs leads to missing fields #127467
FIX_JOIN_OUTPUT_MERGING	Allow the merging of the children to use Aliases, instead of just ReferenceAttributes.
FIX_LIMIT_TRUNCATION_WITH_ZERO_COLUMNS	Fix LimitOperator truncation with zero columns https://github.com/elastic/elasticsearch/issues/142473
FIX_LIMIT_ZERO_IN_STATS_BY_ALL	Fix for the STATS BY ALL with LIMIT 0.
FIX_MV_CONSTANT_COMPARISON_FIELD
FIX_MV_CONSTANT_EQUALS_FIELD
FIX_MV_EXPAND_INCONSISTENT_COLUMN_ORDER	Support for the mv_expand target attribute should be retained in its original position.
FIX_NESTED_FIELDS_NAME_CLASH_IN_INDEXRESOLVER	Fix for https://github.com/elastic/elasticsearch/issues/117054
FIX_NO_COLUMNS	Fix management of plans with no columns https://github.com/elastic/elasticsearch/issues/120272
FIX_NULL_COMPARISON_TYPE_CHECK	Fix null comparison type check in binary comparisons.
FIX_PARSING_LARGE_NEGATIVE_NUMBERS	Fix a parsing issue where numbers below Long.MIN_VALUE threw an exception instead of parsing as doubles.
FIX_PASSTHROUGH_FIELD_CAPS_OBJECT_PARENT	Fix field caps incorrectly synthesizing object parents under subobjects:false (passthrough) mappers, causing false type conflicts in ES|QL when querying across indices.
FIX_PERCENTILE_PRECISION
FIX_PRECISION_OF_SCALED_FLOAT_FIELDS	Fix precision of scaled_float field values retrieved from stored source see Slight inconsistency in ESQL using scaled_float field #122547
FIX_PRESENT_AND_ABSENT_ON_STATS_WITH_FALSE_FILTER	ReplaceStatsFilteredOrNullAggWithEval replaced a stats with false filter with null with Present or Absent
FIX_REPLACE_ALIASING_EVAL_WITH_PROJECT_SHADOWING	ReplaceAliasingEvalWithProject did not fully account for shadowing.
FIX_REPLACE_MISSING_FIELD_WITH_NULL_DUPLICATE_NAME_ID_IN_LAYOUT	Supercedes MAKE_NUMBER_OF_CHANNELS_CONSISTENT_WITH_LAYOUT.
FIX_SAMPLE_AFTER_KQL_OR_QSTR	Fix full-text functions being rejected after SAMPLE.
FIX_SCORE_OPERATOR_PLANNING	Create a ScoreOperator only when shard contexts are available
FIX_STATS_BY_FOLDABLE_EXPRESSION	Fix for https://github.com/elastic/elasticsearch/issues/114714
FIX_STATS_BY_FOLDABLE_EXPRESSION_2	Fix for https://github.com/elastic/elasticsearch/issues/114714, again
FIX_STATS_CLASSCAST_EXCEPTION	Fix for ClassCastException in STATS https://github.com/elastic/elasticsearch/issues/133992 https://github.com/elastic/elasticsearch/issues/136598
FIX_STATS_MV_CONSTANT_FOLD	Fix for multi-value constant propagation after GROUP BY.
FIX_SUM_AGG_LONG_OVERFLOW	Makes SUM(long) agg return null+warning instead of a 500 overflow.
FIX_SUM_OF_NULL_OPTIMIZATION	Fix for SUM(null) producing a type mismatch after surrogate expansion.
FIX_TBUCKET_TARGET_COUNT_WINDOW_VALIDATION	Fix window validation in time-series aggregations when TBUCKET uses a numeric target bucket count.
FIX_TO_IP_LEADING_ZEROS_OCTAL	Fix for 141627, TO_IP with leading_zeros=octal generates proper warning and returns null when given invalid input.
FIX_UNMAPPED_FIELDS_IN_ESRELATION	Fix for KQL/QSTR functions failing when used with unmapped fields in NULLIFY mode.
FIXED_PROFILE_SERIALIZATION	Fixed some profile serialization issues
FIXED_PUSHDOWN_PAST_PROJECT	Make attributes of GROK/DISSECT adjustable and fix a shadowing bug when pushing them down past PROJECT.
FIXED_PUSHDOWN_PAST_PROJECT_WITH_ATTRIBUTES_RESOLUTION	When resolving renames, consider all Attributes in the plan, not just the ReferenceAttributes.
FIXED_REGEX_FOLD	Fix for regex folding with case-insensitive pattern https://github.com/elastic/elasticsearch/issues/118371
FIXED_WRONG_IS_NOT_NULL_CHECK_ON_CASE	Don't optimize CASE IS NOT NULL function by not requiring the fields to be not null as well.
FN_MV_CONTAINS_V1	support for MV_CONTAINS function Add MV_CONTAINS function #133099
FORBID_LIMIT_BEFORE_INLINE_STATS	Temporarily forbid the use of an explicit or implicit LIMIT before INLINE STATS.
FORK_UNION_TYPES	Support for union types in FORK
FORK_V9	Support for FORK out of snapshot
FROM_OPTIONS	Deprecated.
FULL_TEXT_FUNCTIONS_ACCEPT_NULL_FIELD
FULL_TEXT_FUNCTIONS_DISJUNCTIONS	Full text functions can be used in disjunctions
FULL_TEXT_FUNCTIONS_DISJUNCTIONS_COMPUTE_ENGINE	Full text functions can be used in disjunctions as they are implemented in compute engine
FULL_TEXT_FUNCTIONS_DISJUNCTIONS_SCORE	Full text functions can be scored when being part of a disjunction
FULL_TEXT_FUNCTIONS_IN_STATS_WHERE	Full text functions in STATS
FUNCTION_STATS	Adding stats for functions (stack telemetry)
FUNCTIONS_NEVER_EMIT_TEXT	All functions that take TEXT should never emit TEXT, only KEYWORD.
FUNCTIONS_SOURCE_SERIALIZATION_WARNINGS	Fixes for multiple functions not serializing their source, and emitting warnings with wrong line number and text.
FUSE_L2_NORM	FUSE L2_NORM score normalization support
FUSE_V6	FUSE command
GENERIC_VECTOR_FORMAT	Support directIO rescoring and `bfloat16` for `bbq_hnsw` and `bbq_disk`, and `bfloat16` for `hnsw` ans `bbq_flat` index types.
GEO_NULL_LITERALS_FOLDING	Fold in spatial functions should return null for null input.
GEO_VALIDATION	Do validation check on geo_point and geo_shape fields.
GLOBAL_TIMEZONE_PARAMETER_WITH_OUTPUT	"time_zone" parameter in request body and in SET time_zone="x".
GROK_DISSECT_MASKING	Fix to GROK and DISSECT that allows extracting attributes with the same name as the input https://github.com/elastic/elasticsearch/issues/110184
GROK_MULTI_PATTERN	Allow multiple patterns for GROK command
GROK_VALIDATION	Fix to GROK validation in case of multiple fields with same name and different types https://github.com/elastic/elasticsearch/issues/110533
HAMMING_VECTOR_SIMILARITY_FUNCTION	Support for vector Hamming distance.
HANDLE_DETERMINIZATION_COMPLEXITY	Catch-and-rethrow determinization complexity errors as 400s rather than 500s
HASH_FUNCTION	Hash function
HASH_FUNCTION_ALIASES_V1	Hash function aliases such as MD5
HISTOGRAM_RELEASE_VERSION	Histogram field integration
IMPLICIT_CASTING_DATE_AND_DATE_NANOS	Support implicit casting for union typed fields that are mixed with date and date_nanos type.
IMPLICIT_CASTING_STRING_LITERAL_TO_TEMPORAL_AMOUNT	Support implicit casting from string literal to DATE_PERIOD or TIME_DURATION.
INCREASE	Support for INCREASE, DELTA timeseries aggregations.
INDEX_COMPONENT_SELECTORS	Index component selector syntax (my-data-stream-name::failures)
INDEX_METADATA_FIELD	Support specifically for *just* the _index METADATA field.
INLINE_STATS	Renamed `INLINESTATS` to `INLINE STATS`.
INLINE_STATS_DOUBLE_RELEASE_FIX	Fix double release in inline stats when LocalRelation is reused
INLINE_STATS_DROP_GROUPINGS_FIX	Fixes https://github.com/elastic/elasticsearch/issues/139359
INLINE_STATS_FIX_OPTIMIZED_AS_LOCAL_RELATION
INLINE_STATS_FIX_PRUNING_NULL_FILTER	INLINE STATS fix incorrect prunning of null filtering https://github.com/elastic/elasticsearch/pull/135011
INLINE_STATS_PRECEEDED_BY_SORT	Added support for having INLINE STATS preceded by a SORT clause, now executable in certain cases.
INLINE_STATS_PRUNE_COLUMN_FIX	Fix pruning of columns when shadowed in INLINE STATS
INLINE_STATS_SUPPORTS_REMOTE	INLINE STATS supports remote indices
INLINE_STATS_WITH_CONSTANTS	https://github.com/elastic/elasticsearch/issues/142219
INLINE_STATS_WITH_NO_COLUMNS	https://github.com/elastic/elasticsearch/issues/136851
INLINE_STATS_WITH_UNION_TYPES_IN_STUB_RELATION
INLINESTATS	Support for the INLINESTATS syntax.
INLINESTATS_V11	Fixes a series of issues with inlinestats which had an incomplete implementation after lookup and inlinestats were refactored.
INLINESTATS_V2	Support for the expressions in grouping in INLINESTATS syntax.
JOIN_LOOKUP_FIX_LIMIT_PUSHDOWN	Fix pushing down LIMIT past LOOKUP JOIN in case of multiple matching join keys.
JOIN_LOOKUP_SKIP_MV_WARNINGS	LOOKUP JOIN skipping MVs and sending warnings (https://github.com/elastic/elasticsearch/issues/118780)
JOIN_LOOKUP_V12	LOOKUP JOIN
JOIN_PLANNING_V1	WIP on Join planning - Introduce BinaryPlan and co - Refactor INLINESTATS and LOOKUP as a JOIN block
KEEP_REGEX_EXTRACT_ATTRIBUTES	Avid GROK and DISSECT attributes being removed when resolving fields.
KEYWORDS_MV_COUNT_AS_SINGLE_VALUE_FIX
KNN_FUNCTION_OPTIONS_K_VISIT_PERCENTAGE	KNN function adds support for k and visit_percentage options
KNN_FUNCTION_V5	Support knn function
KQL_FUNCTION	KQL function
KQL_FUNCTION_OPTIONS	Support for optional parameters in KQL function (case_insensitive, time_zone, default_field, boost).
KQL_QSTR_TIMEZONE_SUPPORT	Support timezones in KQL and QSTR.
L1_NORM_VECTOR_SIMILARITY_FUNCTION	l1 norm vector similarity function
L2_NORM_VECTOR_SIMILARITY_FUNCTION	l2 norm vector similarity function
LAST_AGG_WITH_NULL_AND_MV_SUPPORT	Make LAST agg work with null and multi-value fields.
LEAST_GREATEST_FOR_DATENANOS	Support Least and Greatest functions on Date Nanos type
LEAST_GREATEST_FOR_DATES	Support for datetime in least and greatest functions
LIKE_LIST_ON_INDEX_FIELDS
LIKE_ON_INDEX_FIELDS	Support improved behavior for LIKE operator when used with index fields.
LIKE_PARAMETER_SUPPORT	Support like/rlike parameters https://github.com/elastic/elasticsearch/issues/131356
LIKE_WITH_LIST_OF_PATTERNS	Support for the LIKE operator with a list of wildcards.
LIMIT_BY_ENRICH_FIX	Corrects a bug with ENRICH when a shard does not contain an index field and we use LIMIT BY on top
LOAD_FLATTENED_FIELD	Test-only capability since loading a value from a flattened field is possible using the unmapped field infrastructure, but is only supported by full integration tests.
LOADING_NON_INDEXED_IP_FIELDS	Support loading of ip fields if they are not indexed.
LOOKUP_JOIN_NO_ALIASES	Disabled support for index aliases in lookup joins
LOOKUP_JOIN_ON_BOOLEAN_EXPRESSION	Allow lookup join on boolean expressions
LOOKUP_JOIN_ON_MIXED_NUMERIC_FIELDS	Allow lookup join on mixed numeric fields, among byte, short, int, long, half_float, scaled_float, float and double.
LOOKUP_JOIN_ON_MULTIPLE_FIELDS	Support for lookup join on multiple fields.
LOOKUP_JOIN_SEMANTIC_FILTER_DEDUP	Fix for lookup join filter pushdown not using semantic equality.
LOOKUP_JOIN_SORT_WARNING	Warning when SORT is followed by LOOKUP JOIN which does not preserve order.
LOOKUP_JOIN_TEXT	LOOKUP JOIN with TEXT fields on the right (right side of the join) (#119473)
LOOKUP_JOIN_WITH_FULL_TEXT_FUNCTION	Lookup join with Full Text Function or other Lucene Pushable condition to be applied to the lookup index used
LOOKUP_JOIN_WITH_FULL_TEXT_FUNCTION_BUGFIX	Bugfix for lookup join with Full Text Function
LOOKUP_V4	LOOKUP command with - tables using syntax "tables": {"type": [<values>]} - fixed variable shadowing - fixed Join.references(), requiring breaking change to Join serialization
LUCENE_QUERY_EVALUATOR_QUERY_REWRITE	LuceneQueryEvaluator rewrites the query before executing it in Lucene.
MAGNITUDE_SCALAR_VECTOR_FUNCTION
MAKE_NUMBER_OF_CHANNELS_CONSISTENT_WITH_LAYOUT	Make numberOfChannels consistent with layout in DefaultLayout by removing duplicated ChannelSet.
MATCH_ADDITIONAL_TYPES	Additional types for match function and operator
MATCH_FUNCTION	MATCH function
MATCH_FUNCTION_OPTIONS	Support match options in match function
MATCH_FUNCTION_ZERO_TERMS_QUERY	Support for the zero_terms_query option in the match function.
MATCH_OPERATOR_COLON	Support for match operator as a colon.
MATCH_PHRASE_FUNCTION	MATCH PHRASE function
METADATA_FIELDS	Support for metadata fields.
METADATA_FIELDS_REMOTE_TEST	Capability for remote metadata test
METADATA_IGNORED_FIELD	Support for requesting the "_ignored" metadata field.
METADATA_SCORE	Support the "METADATA _score" directive to enable _score column.
METADATA_SIZE_FIELD	Support for requesting the "_size" metadata field when the mapper-size plugin is enabled.
METADATA_TIER_FIELD	Support for requesting the "_tier" metadata field.
METADATA_TSID_FIELD	Support for requesting the "_tsid" metadata field.
METADATA_WILDCARDS	Allow wildcards in FROM METADATA, eg FROM idx METADATA _ind*
METRICS_COMMAND	Deprecated.
METRICS_COUNTER_FIELDS	Support for metrics counter fields
METRICS_GROUP_BY_ALL	Enables automatically grouping by all dimension fields in TS mode queries
METRICS_GROUP_BY_ALL_WITH_TS_DIMENSIONS	Enables automatically grouping by all dimension fields in TS mode queries and outputs the _timeseries column with all the dimensions.
METRICS_INFO_COMMAND	Support for the METRICS_INFO command.
MIXED_NUMERIC_TYPES_IN_CASE_GREATEST_LEAST	Allow mixed numeric types in conditional functions - case, greatest and least
MIXED_NUMERIC_TYPES_IN_COALESCE	Allow mixed numeric types in coalesce
MMR_FOLDABLE_QUERY_VECTOR_FIX	MMR fixes for constant folding
MMR_V2	Support for the MMR result diversification command
MV_ORDERING_SORTED_ASCENDING	Blocks can be labelled with Block.MvOrdering.SORTED_ASCENDING for optimizations.
MV_PSERIES_WEIGHTED_SUM	Adds the MV_PSERIES_WEIGHTED_SUM function for converting sorted lists of numbers into a bounded score.
MV_SORT	Introduction of MV_SORT, MV_SLICE, and MV_ZIP.
NAME_QUALIFIERS	Allow qualifiers in attribute names.
NAMED_PARAMETER_FOR_FIELD_AND_FUNCTION_NAMES_SIMPLIFIED_SYNTAX	Support simplified syntax for named parameters for field and function names.
NAMED_POSITIONAL_PARAMETER	Support for named or positional parameters in EsqlQueryRequest.
NETWORK_DIRECTION	Network direction function.
NO_BRACKETS_IN_UNQUOTED_INDEX_NAMES	Forbid usage of brackets in unquoted index and enrich policy names https://github.com/elastic/elasticsearch/issues/130378
NO_META	Removing support for the META keyword.
NO_PLAIN_STRINGS_IN_LITERALS	From now, Literal only accepts strings as BytesRefs.
NON_FULL_TEXT_FUNCTIONS_SCORING	Non full text functions do not contribute to score
NON_SNAPSHOT_TEST_FOR_TELEMETRY_V2	This enables 60_usage.yml "Basic ESQL usage....non-snapshot" version test.
NORMALIZED_LIMIT_ERROR_MESSAGE	Changed and normalized the LIMIT error message.
OPTIONAL_FIELDS_DETECT_UNMAPPED_FIELDS_IN_AGG_FILTERS	Nullify unmapped fields in agg filters like STATS agg_fun(field) WHERE field..., even when Analyzer.ResolveRefs marks the field as unresolvable with a custom error message.
OPTIONAL_FIELDS_FIX_UNMAPPED_FIELD_DETECTION	Fix incorrect detection of unmapped fields in nullify/load mode when unresolved attributes match fields already present in the children's output.
OPTIONAL_FIELDS_FIX_UNMAPPED_LOAD_MULTI_INDEX_PATTERN	Fix for 500 error when querying multiple indices with unmapped_fields="load".
OPTIONAL_FIELDS_NULLIFY_SKIP_GROUP_ALIASES	Don't nullify aliases for Aggregate groupings.
OPTIONAL_FIELDS_NULLIFY_TECH_PREVIEW	Support for optional fields (might or might not be present in the mappings) using DEFAULT/NULLIFY only.
OPTIONAL_FIELDS_V5	Support for optional fields (might or might not be present in the mappings) using DEFAULT/NULLIFY/LOAD.
OPTIONAL_NAMED_ARGUMENT_MAP_FOR_FUNCTION	Support named argument for function in map format.
PACK_DIMENSIONS_IN_TS	Pack dimension values in TS command
PARAMETER_FOR_LIMIT	Support parameters for LIMIT command.
PARAMETER_FOR_SAMPLE	Support parameters for SAMPLE command.
PARQUET_ORC_STARTS_WITH_PUSHDOWN	Parquet and ORC filter pushdown for StartsWith (prefix range predicates).
PER_AGG_FILTERING	Allow filter per individual aggregation.
PER_AGG_FILTERING_ORDS	Fix PER_AGG_FILTERING grouped by ordinals.
PERCENTILE_OVER_TIME	Percentile over time and other ts-aggregations
PERIODIC_EMIT_PARTIAL_AGGREGATION_RESULTS	Periodically emit partial aggregation results when the number of groups exceeds the threshold.
PROMQL_BINARY_COMPARISON_V0	Initial support for simple binary comparisons in PromQL.
PROMQL_BUCKETS_PARAMETER	Support for deriving PromQL time buckets from [start, end, buckets] when [step] is omitted.
PROMQL_COMMAND_V0	PromQL support in ESQL, in the state it was when first available in non-snapshot builds.
PROMQL_IMPLICIT_RANGE_SELECTOR	Support implicit conversion from an instant selector to a range selector for range-vector functions.
PROMQL_MATH_V0	Bundle flag for PromQL math functions.
PROMQL_NESTED_AGGREGATES	Support for nested across-series aggregates in PromQL.
PROMQL_POST_PROCESSING_STATS	Support post-processing STATS commands after PROMQL source commands.
PROMQL_SCALAR	PromQL scalar() function support.
PROMQL_TIME	Support for PromQL time() function.
PROMQL_UNMAPPED_FIELDS_FILTER_NULLS	Queries for unmapped fields return no data instead of an error.
PROMQL_WITHOUT_GROUPING	Support for PromQL without grouping.
PROPAGATE_EMPTY_RELATION_PAST_JOINS
PUSHING_DOWN_EVAL_WITH_SCORE	Support for pushing down EVAL with SCORE https://github.com/elastic/elasticsearch/issues/133462
QSTR_FUNCTION	QSTR function
QSTR_FUNCTION_BOOST_FIX	Guards a fix for the boost parameter in QueryString queries
QUERY_MONITORING	Listing queries and getting information on a specific query.
QUERY_PARAMS_MULTI_VALUES	Multivalued query parameters
QUERY_STRING_FUNCTION_OPTIONS	Support options in the query string function.
RANGEQUERY_FOR_DATETIME	Use RangeQuery for BinaryComparison on DateTime fields.
RATE_FIX_RESETS_MULTIPLE_SEGMENTS	Fixes reset calculation in rates where partitioning data into multiple slices can lead to incorrect results.
RATE_WITH_INTERPOLATION	Rate and increase calculations use interpolation at the boundaries between time buckets
RATE_WITH_INTERPOLATION_V2
RATE_WITH_INTERPOLATION_V3	V3 fixes a bug on how we handle single-value time buckets for INCREASE with the sole value falling onto the bucket boundary.
REGISTERED_DOMAIN_COMMAND	Supports the REGISTERED_DOMAIN command.
REMOTE_ENRICH_AFTER_LOOKUP_JOIN	Fix the planning of | ENRICH _remote:policy when there's a preceding | LOOKUP JOIN, see java.lang.ClassCastException when combining LOOKUP JOIN and remote ENRICH
REMOVE_EMPTY_ATTRIBUTE_IN_MERGING_OUTPUT	Support for removing empty attribute in merging output.
REMOVE_REDUNDANT_SORT	Fix for https://github.com/elastic/elasticsearch/issues/120817 and https://github.com/elastic/elasticsearch/issues/120803 Support for queries that have multiple SORTs that cannot become TopN
RENAME_ALLOW_ASSIGNMENT	Support for assignment in RENAME, besides the use of `AS` keyword.
RENAME_SEQUENTIAL_PROCESSING	Execute `RENAME` operations sequentially from left to right, see ESQL: Align RENAME behavior with EVAL for sequential processing #122250
REPEAT	Support for requesting the "REPEAT" command.
REPORT_ORIGINAL_TYPES	The _query API now reports the original types.
RERANK	Support for RERANK command
RESOLVE_GROUPINGS_BEFORE_RESOLVING_REFERENCES_TO_GROUPINGS_IN_AGGREGATIONS	Resolve groupings before resolving references to groupings in the aggregations.
RETAIN_AGGREGATE_WHEN_GROUPING	Support for retain aggregate when grouping.
RLIKE_WITH_EMPTY_LANGUAGE_PATTERN	Allows RLIKE to correctly handle the "empty language" flag, `#`.
RLIKE_WITH_LIST_OF_PATTERNS	Support for the RLIKE operator with a list of regexes.
ROUND_TO	The ROUND_TO function.
ROUTING_FUNCTION_UPDATE	Marks the move to the hash(doc) % shard_count routing function.
ROW_FIELD_RESOLUTION	Support for intra-row field references in ROW command.
SAMPLE_V3	Support for the SAMPLE command
SCORE_FUNCTION	score function
SEMANTIC_TEXT_FIELD_CAPS	Change field caps response for semantic_text fields to be reported as text
SET_COMMAND	Support for the SET command.
SHORT_ERROR_MESSAGES_FOR_UNSUPPORTED_FIELDS	Changed error messages for fields with conflicting types in different indices.
SNAPSHOT_TEST_FOR_TELEMETRY_V2	This enables 60_usage.yml "Basic ESQL usage....snapshot" version test.
SORT_RETURNING_SOURCE_OK	Fix SORT when the _source field is not a sort key but is being returned.
SORTING_ON_SOURCE_AND_COUNTERS_FORBIDDEN	Fix sorting not allowed on _source and counters.
SOURCE_FIELD_MAPPING	_source field mapping directives: https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-source-field.html
SPACE	Support for requesting the "SPACE" function.
SPATIAL_AGGS_FILTERING	Fix to bug with spatial aggregations not properly supporting the WHERE clause.
SPATIAL_CENTROID_NO_RECORDS	Fix for spatial centroid when no records are found.
SPATIAL_DISTANCE_PUSHDOWN_ENHANCEMENTS	Support a number of fixes and enhancements to spatial distance pushdown.
SPATIAL_DISTANCE_SUPPORTS_MULTIVALUES	Enable spatial distance function to support multi-values.
SPATIAL_FUNCTIONS_FIX_CRSTYPE_FOLDING	Fix determination of CRS types in spatial functions when folding.
SPATIAL_GRID	Support ST_GEOHASH, ST_GEOTILE and ST_GEOHEX functions
SPATIAL_GRID_INTERSECTS	Support geohash, geotile and geohex in ST_INTERSECTS and ST_DISJOINT.
SPATIAL_GRID_TYPES	Support geohash, geotile and geohex data types.
SPATIAL_POINTS_FROM_SOURCE	Changed precision of geo_point and cartesian_point fields, by loading from source into WKB.
SPATIAL_PREDICATES_SUPPORT_MULTIVALUES	Enable spatial predicate functions to support multi-values.
SPATIAL_SHAPES	Support for loading geo_shape and cartesian_shape fields.
ST_CENTROID_AGG	Support for spatial aggregation ST_CENTROID.
ST_CENTROID_AGG_OPTIMIZED	Optimization for ST_CENTROID changed some results in cartesian data.
ST_CENTROID_AGG_SHAPES	Support for ST_CENTROID_AGG aggregation on geo_shape and cartesian_shape fields.
ST_CENTROID_AGG_SHAPES_DOC_VALUES	Support for ST_CENTROID_AGG aggregation on shapes from doc-values.
ST_CONTAINS_WITHIN	Support for spatial aggregation ST_CONTAINS and ST_WITHIN.
ST_DISJOINT	Support for spatial aggregation ST_DISJOINT.
ST_DISTANCE	Support for function ST_DISTANCE.
ST_ENVELOPE	Support ST_ENVELOPE function (and related ST_XMIN, etc.).
ST_ENVELOPE_MV_FIX	Fix ST_ENVELOPE to support multi-values and doc-values.
ST_EXTENT_AGG	Support for function ST_EXTENT_AGG.
ST_EXTENT_AGG_DOCVALUES	Optimization of ST_EXTENT_AGG with doc-values as IntBlock.
ST_EXTENT_AGG_NULL_SUPPORT	Allow ST_EXTENT_AGG to gracefully handle missing spatial shapes
ST_INTERSECTS	Support for spatial aggregation ST_INTERSECTS.
ST_NPOINTS	Support ST_NPOINTS function.
ST_SIMPLIFY	Support for spatial simplification ST_SIMPLIFY
ST_X_Y	Introduction of ST_X and ST_Y.
ST_X_Y_QUANTIZED	Quantize results of ST_X and ST_Y and related functions
STARTS_WITH_ENDS_WITH_LUCENE_PUSHDOWN	Lucene query pushdown to StartsWith and EndsWith functions.
STATS_ALIAS_COLLISION_WARNINGS	Send warnings on STATS alias collision https://github.com/elastic/elasticsearch/issues/114970
STATS_WITH_FILTERED_SURROGATE_FIXED	Bugfix for STATS {{expression}} WHERE {{condition}} when the expression is replaced by something else on planning e.g.
STD_DEV	Support for STD_DEV aggregation.
STR_COMMANDS_ACCEPT_NULL	The GROK, DISSECT, URI_PARTS, and REGISTERED_DOMAIN commands accept null typed parameters and produce null results.
STRING_LITERAL_AUTO_CASTING	Cast string literals to a desired data type.
STRING_LITERAL_AUTO_CASTING_EXTENDED	Cast string literals to a desired data type for IN predicate and more types for BinaryComparison.
STRING_LITERAL_AUTO_CASTING_TO_DATETIME_ADD_SUB	Cast string literals to datetime in addition and subtraction when the other side is a date or time interval.
SUBQUERY_IN_FROM_COMMAND	Support non-correlated subqueries in the FROM clause.
SUBQUERY_IN_FROM_COMMAND_APPEND_IMPLICIT_LIMIT_TO_UNBOUNDED_SORT_IN_SUBQUERY	Append an implicit limit to unbounded sorts in subqueries in the FROM clause.
SUBQUERY_IN_FROM_COMMAND_PRUNE_NO_FIELDS	Prune no-fields in subquery project.
SUBQUERY_IN_FROM_COMMAND_UNION_TYPES_CONFLICT_RESOLUTION	Fix for union types when fields have conflicting types between subqueries.
SUBQUERY_IN_FROM_COMMAND_WITHOUT_IMPLICIT_LIMIT	Support non-correlated subqueries in the FROM clause without implicit limit.
SUGGESTED_CAST	The _query API now gives a cast recommendation if multiple types are found in certain instances.
SUPPORT_PARTIAL_RESULTS	Support partial_results
TBUCKET	Support for tbucket function
TBUCKET_FROM_TO	Support for TBUCKET with numeric bucket count and optional from/to parameters.
TDIGEST_FIRST_LAST_OVER_TIME	Support for FIRST_OVER_TIME and LAST_OVER_TIME on tdigest type fields.
TDIGEST_MEDIAN	Support for MEDIAN aggregation on tdigest type fields.
TDIGEST_PERCENTILES_USE_MERGING_DIGEST	A bugfix we applied to the HISTOGRAM_PERCENTILE algorithm on the tdigest type.
TDIGEST_TECH_PREVIEW	Support for the T-Digest elasticsearch field mapper and ES|QL type when they were released into tech preview.
TDIGEST_TIME_SERIES_METRIC	Support for configuring T-Digest elasticsearch field as a time series metric.
TEMPORAL_AMOUNT_M	Support for the literal m suffix as an alias for minute in temporal amounts.
TEXT_EMBEDDING_FUNCTION	Support for the TEXT_EMBEDDING function for generating dense vector embeddings.
TIME_SERIES_WINDOW_NON_MULTIPLE	Support window durations that are larger than but not exact multiples of the time bucket for time-series aggregations (e.g., rate(counter, 7 minutes) with TBUCKET(5 minutes)).
TIME_SERIES_WINDOW_SMALLER_THAN_BUCKET	Supporting grouping window in time-series where the window is smaller than the time bucket
TIME_SERIES_WINDOW_V1	Support grouping window in time-series for example: rate(counter, "1m") or avg_over_time(field, "5m")
TIMESPAN_ABBREVIATIONS	Support for timespan units abbreviations
TO_DATE_NANOS	Support for to_date_nanos function
TO_DENSE_VECTOR_FUNCTION	TO_DENSE_VECTOR function.
TO_EXPONENTIAL_HISTOGRAM	Support for the TO_EXPONENTIAL_HISTOGRAM conversion function.
TO_IP_LEADING_ZEROS	Support for the leading_zeros named parameter.
TO_LOWER_EMPTY_STRING	Guards a bug fix matching TO_LOWER(f) == "".
TO_LOWER_MV	Do TO_LOWER and TO_UPPER process all field values?
TO_TDIGEST_FROM_EXPONENTIAL_HISTOGRAM	Support for converting exponential_histogram fields via TO_TDIGEST.
TOP_SNIPPETS_FOLDABLE_QUERY_CHECK	TOP_SNIPPETS checks that the query is foldable
TOP_SNIPPETS_FUNCTION	Returns the top snippets for given text content and associated query.
TOP_SNIPPETS_FUNCTION_STRING_CONFIG	A fix allowing the TOP_SNIPPETS function to process string config parameters like the other functions.
TOP_SNIPPETS_MV	Does TOP_SNIPPETS process all field values?
TS_COMMAND_GROUP_ON_ALIASES	Fix bug with TS command where you can't group on aliases (i.e.
TS_COMMAND_V0	Support TS command in non-snapshot builds
TS_DERIV_DATENANOS
TS_IMPLICIT_TIMESTAMP_SORT	Implicit SORT @timestamp DESC for TS queries without STATS or explicit SORT.
TS_INFO_COMMAND	Support for the TS_INFO command — per-time-series granularity variant of METRICS_INFO.
TS_LINREG_DERIVATIVE
TS_ORIGINAL_TYPES_BUG_FIXED	Fix for a bug where if you queried multiple TS indices with a field mapped to different types, the original types/suggested cast sections of the return result would be empty.
TS_PERMIT_TEXT_BECOMING_KEYWORD_WHEN_GROUPED_ON	Permit the data type of a field changing from TEXT to KEYWORD when being grouped on in aggregations on the TS command.
TS_RATE_DATENANOS
TS_RATE_DATENANOS_2
TS_RENAME_TIMESTAMP_ERROR_MESSAGE	Custom error for renamed timestamp
TS_STATS_BINARY_OPS	Adds support for binary operations (such as addition, subtraction, etc.) to the TS|STATS command.
TYPE_CONVERSION_TIMEZONE_SUPPORT	Support timezones in the conversion utils and functions, like TO_STRING.
UNION_TYPES	Support multiple field mappings if appropriate conversion function is used (union types)
UNION_TYPES_AGG_CAST	Fix for union-types when aggregating over an inline conversion with casting operator.
UNION_TYPES_FIX_RENAME_RESOLUTION	Fix for union-types when renaming unrelated columns.
UNION_TYPES_INLINE_FIX	Fix for union-types when aggregating over an inline conversion with conversion function.
UNION_TYPES_MISSING_FIELD	Fix for union-types when some indexes are missing the required field.
UNION_TYPES_NUMERIC_WIDENING	Fix for widening of short numeric types in union-types.
UNION_TYPES_REMOVE_FIELDS	Fix for union-types when sorting a type-casted field.
UNION_TYPES_RESOLVE_PAST_PROJECTIONS	Fix for resolving union type casts past projections (KEEP) and MV_EXPAND operations.
UNIQUE_NAMES	Fix for non-unique attribute names in ROW and logical plans.
UNMAPPED_FIELDS	Support unmapped using the INSIST keyword.
UNMAPPED_FIELDS_DEFAULT_SETTING_RENAME	Rename the unmapped_fields default setting from "fail" to "default".
UPDATE_LOOKUP_JOIN_ERROR_MESSAGES	Lookup error messages were updated to make them a bit easier to understand.
URI_PARTS_COMMAND	Supports the URI_PARTS) command.
URL_DECODE	URL decoding function.
URL_ENCODE	URL encoding function.
URL_ENCODE_COMPONENT	URL component encoding function.
USAGE_CONTAINS_TOOK	Does the usage information for ESQL contain a histogram of took values?
USER_AGENT_COMMAND	Supports the USER_AGENT command.
VARIANCE_STDDEV_OVER_TIME
VECTOR_SIMILARITY_FUNCTIONS_PUSHDOWN	Support for vector similarity functions pushdown
VECTOR_SIMILARITY_FUNCTIONS_SUPPORT_NULL	Support null elements on vector similarity functions
VIEWS_CRUD_AS_INDEX_ACTIONS	Views crud actions as index actions
VIEWS_DEDUPLICATION_BUGFIX	Fixed a bug where views are incorrectly de-duplicated.
VIEWS_IN_CLUSTER_STATE	Support for views in cluster state (and REST API).
VIEWS_TELEMETRY	Added telemetry for views
VIEWS_WITH_BRANCHING	Views with branching (requires subqueries/FORK).
VIEWS_WITH_NO_BRANCHING	Basic Views with no branching (do not need subqueries or FORK).

Method Summary

Modifier and Type	Method	Description
String	capabilityName()
boolean	isEnabled()
static EsqlCapabilities.Cap	valueOf(String name)	Returns the enum constant of this class with the specified name.
static EsqlCapabilities.Cap[]	values()	Returns an array containing the constants of this enum class, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

MV_SORT

public static final EsqlCapabilities.Cap MV_SORT

Introduction of MV_SORT, MV_SLICE, and MV_ZIP. Added in #106095.

DISABLE_NULLABLE_OPTS

public static final EsqlCapabilities.Cap DISABLE_NULLABLE_OPTS

When we disabled some broken optimizations around nullable. Fixed in #105691.

ST_X_Y

public static final EsqlCapabilities.Cap ST_X_Y

Introduction of ST_X and ST_Y. Added in #105768.

ST_X_Y_QUANTIZED

public static final EsqlCapabilities.Cap ST_X_Y_QUANTIZED

Quantize results of ST_X and ST_Y and related functions

SPATIAL_POINTS_FROM_SOURCE

public static final EsqlCapabilities.Cap SPATIAL_POINTS_FROM_SOURCE

Changed precision of geo_point and cartesian_point fields, by loading from source into WKB. Done in #103691.

SPATIAL_SHAPES

public static final EsqlCapabilities.Cap SPATIAL_SHAPES

Support for loading geo_shape and cartesian_shape fields. Done in #104269.

GEO_VALIDATION

public static final EsqlCapabilities.Cap GEO_VALIDATION

Do validation check on geo_point and geo_shape fields. Done in #128259.

GEO_NULL_LITERALS_FOLDING

public static final EsqlCapabilities.Cap GEO_NULL_LITERALS_FOLDING

Fold in spatial functions should return null for null input.

ST_CENTROID_AGG

public static final EsqlCapabilities.Cap ST_CENTROID_AGG

Support for spatial aggregation ST_CENTROID. Done in #104269.

ST_INTERSECTS

public static final EsqlCapabilities.Cap ST_INTERSECTS

Support for spatial aggregation ST_INTERSECTS. Done in #104907.

ST_CONTAINS_WITHIN

public static final EsqlCapabilities.Cap ST_CONTAINS_WITHIN

Support for spatial aggregation ST_CONTAINS and ST_WITHIN. Done in #106503.

ST_DISJOINT

public static final EsqlCapabilities.Cap ST_DISJOINT

Support for spatial aggregation ST_DISJOINT. Done in #107007.

ST_SIMPLIFY

public static final EsqlCapabilities.Cap ST_SIMPLIFY

Support for spatial simplification ST_SIMPLIFY

AGG_VALUES

public static final EsqlCapabilities.Cap AGG_VALUES

The introduction of the VALUES agg.

AGG_VALUES_SPATIAL

public static final EsqlCapabilities.Cap AGG_VALUES_SPATIAL

Expand the VALUES agg to cover spatial types.

AGG_MAX_MIN_UNSIGNED_LONG

public static final EsqlCapabilities.Cap AGG_MAX_MIN_UNSIGNED_LONG

Accept unsigned longs on MAX and MIN aggregations.

AGG_VALUES_SAMPLE_UNSIGNED_LONG

public static final EsqlCapabilities.Cap AGG_VALUES_SAMPLE_UNSIGNED_LONG

Accept unsigned longs on VALUES and SAMPLE aggregations.

ASYNC_QUERY

public static final EsqlCapabilities.Cap ASYNC_QUERY

Does ESQL support async queries.

FROM_OPTIONS

@Deprecated
public static final EsqlCapabilities.Cap FROM_OPTIONS

Deprecated.

Does ESQL support FROM OPTIONS?

STRING_LITERAL_AUTO_CASTING

public static final EsqlCapabilities.Cap STRING_LITERAL_AUTO_CASTING

Cast string literals to a desired data type.

BASE64_DECODE_ENCODE

public static final EsqlCapabilities.Cap BASE64_DECODE_ENCODE

Base64 encoding and decoding functions.

CASTING_OPERATOR

public static final EsqlCapabilities.Cap CASTING_OPERATOR

Support for the :: casting operator

CASTING_OPERATOR_FOR_DATE

public static final EsqlCapabilities.Cap CASTING_OPERATOR_FOR_DATE

Support for the ::date casting operator

CASTING_OPERATOR_FOR_HISTOGRAM_TYPES

public static final EsqlCapabilities.Cap CASTING_OPERATOR_FOR_HISTOGRAM_TYPES

Support for the ::tdigest and ::exponential_histogram casting operators.

MV_ORDERING_SORTED_ASCENDING

public static final EsqlCapabilities.Cap MV_ORDERING_SORTED_ASCENDING

Blocks can be labelled with Block.MvOrdering.SORTED_ASCENDING for optimizations.

METRICS_COUNTER_FIELDS

public static final EsqlCapabilities.Cap METRICS_COUNTER_FIELDS

Support for metrics counter fields

STRING_LITERAL_AUTO_CASTING_EXTENDED

public static final EsqlCapabilities.Cap STRING_LITERAL_AUTO_CASTING_EXTENDED

Cast string literals to a desired data type for IN predicate and more types for BinaryComparison.

METADATA_FIELDS

public static final EsqlCapabilities.Cap METADATA_FIELDS

Support for metadata fields.

OPTIONAL_FIELDS_NULLIFY_TECH_PREVIEW

public static final EsqlCapabilities.Cap OPTIONAL_FIELDS_NULLIFY_TECH_PREVIEW

Support for optional fields (might or might not be present in the mappings) using DEFAULT/NULLIFY only. Compared to OPTIONAL_FIELDS_V5, this does not enable support for LOAD.

OPTIONAL_FIELDS_FIX_UNMAPPED_FIELD_DETECTION

public static final EsqlCapabilities.Cap OPTIONAL_FIELDS_FIX_UNMAPPED_FIELD_DETECTION

Fix incorrect detection of unmapped fields in nullify/load mode when unresolved attributes match fields already present in the children's output.

OPTIONAL_FIELDS_NULLIFY_SKIP_GROUP_ALIASES

public static final EsqlCapabilities.Cap OPTIONAL_FIELDS_NULLIFY_SKIP_GROUP_ALIASES

Don't nullify aliases for Aggregate groupings.

OPTIONAL_FIELDS_DETECT_UNMAPPED_FIELDS_IN_AGG_FILTERS

public static final EsqlCapabilities.Cap OPTIONAL_FIELDS_DETECT_UNMAPPED_FIELDS_IN_AGG_FILTERS

Nullify unmapped fields in agg filters like STATS agg_fun(field) WHERE field..., even when Analyzer.ResolveRefs marks the field as unresolvable with a custom error message.

OPTIONAL_FIELDS_FIX_UNMAPPED_LOAD_MULTI_INDEX_PATTERN

public static final EsqlCapabilities.Cap OPTIONAL_FIELDS_FIX_UNMAPPED_LOAD_MULTI_INDEX_PATTERN

Fix for 500 error when querying multiple indices with unmapped_fields="load". See https://github.com/elastic/elasticsearch/issues/145555

OPTIONAL_FIELDS_V5

public static final EsqlCapabilities.Cap OPTIONAL_FIELDS_V5

Support for optional fields (might or might not be present in the mappings) using DEFAULT/NULLIFY/LOAD. V2: Prevent pushing down filters and sorts to Lucene of potentially unmapped fields. V3: Fix synthetic _source numeric load bug (#143916) V4: Support for union type like resolution for load. V5: Support for rejecting partially unmapped non-keywords unless cast or projected Support for rejecting loading subfields of flattened fields

INDEX_METADATA_FIELD

public static final EsqlCapabilities.Cap INDEX_METADATA_FIELD

Support specifically for *just* the _index METADATA field. Used by CsvTests, since that is the only metadata field currently supported.

TIMESPAN_ABBREVIATIONS

public static final EsqlCapabilities.Cap TIMESPAN_ABBREVIATIONS

Support for timespan units abbreviations

COUNTER_TYPES

public static final EsqlCapabilities.Cap COUNTER_TYPES

Support metrics counter types

FN_MV_CONTAINS_V1

public static final EsqlCapabilities.Cap FN_MV_CONTAINS_V1

support for MV_CONTAINS function Add MV_CONTAINS function #133099

FUNCTIONS_SOURCE_SERIALIZATION_WARNINGS

public static final EsqlCapabilities.Cap FUNCTIONS_SOURCE_SERIALIZATION_WARNINGS

Fixes for multiple functions not serializing their source, and emitting warnings with wrong line number and text.

FUNCTIONS_NEVER_EMIT_TEXT

public static final EsqlCapabilities.Cap FUNCTIONS_NEVER_EMIT_TEXT

All functions that take TEXT should never emit TEXT, only KEYWORD. #114334

INLINESTATS

public static final EsqlCapabilities.Cap INLINESTATS

Support for the INLINESTATS syntax.

INLINESTATS_V2

public static final EsqlCapabilities.Cap INLINESTATS_V2

Support for the expressions in grouping in INLINESTATS syntax.

AGG_TOP

public static final EsqlCapabilities.Cap AGG_TOP

Support for aggregation function TOP.

AGG_MAX_MIN_BOOLEAN_SUPPORT

public static final EsqlCapabilities.Cap AGG_MAX_MIN_BOOLEAN_SUPPORT

Support for booleans in aggregations MAX and MIN.

AGG_MAX_MIN_IP_SUPPORT

public static final EsqlCapabilities.Cap AGG_MAX_MIN_IP_SUPPORT

Support for ips in aggregations MAX and MIN.

AGG_MAX_MIN_STRING_SUPPORT

public static final EsqlCapabilities.Cap AGG_MAX_MIN_STRING_SUPPORT

Support for strings in aggregations MAX and MIN.

AGG_TOP_BOOLEAN_SUPPORT

public static final EsqlCapabilities.Cap AGG_TOP_BOOLEAN_SUPPORT

Support for booleans in TOP aggregation.

AGG_TOP_IP_SUPPORT

public static final EsqlCapabilities.Cap AGG_TOP_IP_SUPPORT

Support for ips in TOP aggregation.

AGG_TOP_STRING_SUPPORT

public static final EsqlCapabilities.Cap AGG_TOP_STRING_SUPPORT

Support for keyword and text fields in TOP aggregation.

AGG_TOP_WITH_OPTIONAL_ORDER_FIELD

public static final EsqlCapabilities.Cap AGG_TOP_WITH_OPTIONAL_ORDER_FIELD

Make optional the order field in the TOP agg command, and default it to "ASC".

AGG_TOP_WITH_OUTPUT_FIELD

public static final EsqlCapabilities.Cap AGG_TOP_WITH_OUTPUT_FIELD

Support for the extra "map" field in TOP aggregation.

FIX_AGG_TOP_WITH_OUTPUT_FIELD_SURROGATE

public static final EsqlCapabilities.Cap FIX_AGG_TOP_WITH_OUTPUT_FIELD_SURROGATE

Fix for a bug when surrogating a TOP with limit 1 and output field.

CASE_MV

public static final EsqlCapabilities.Cap CASE_MV

CASE properly handling multivalue conditions.

CASE_FOLD_TEMPORAL_AMOUNT

public static final EsqlCapabilities.Cap CASE_FOLD_TEMPORAL_AMOUNT

CASE folding with DATE_PERIOD and TIME_DURATION return types.

ENRICH_LOAD

public static final EsqlCapabilities.Cap ENRICH_LOAD

Support for loading values over enrich. This is supported by all versions of ESQL but not the unit test CsvTests.

LOAD_FLATTENED_FIELD

public static final EsqlCapabilities.Cap LOAD_FLATTENED_FIELD

Test-only capability since loading a value from a flattened field is possible using the unmapped field infrastructure, but is only supported by full integration tests. So this capability is used to disable some tests in CsvTests.

ST_CENTROID_AGG_OPTIMIZED

public static final EsqlCapabilities.Cap ST_CENTROID_AGG_OPTIMIZED

Optimization for ST_CENTROID changed some results in cartesian data. #108713

METADATA_IGNORED_FIELD

public static final EsqlCapabilities.Cap METADATA_IGNORED_FIELD

Support for requesting the "_ignored" metadata field.

LOOKUP_V4

public static final EsqlCapabilities.Cap LOOKUP_V4

LOOKUP command with - tables using syntax "tables": {"type": [<values>]} - fixed variable shadowing - fixed Join.references(), requiring breaking change to Join serialization

REPEAT

public static final EsqlCapabilities.Cap REPEAT

Support for requesting the "REPEAT" command.

STRING_LITERAL_AUTO_CASTING_TO_DATETIME_ADD_SUB

public static final EsqlCapabilities.Cap STRING_LITERAL_AUTO_CASTING_TO_DATETIME_ADD_SUB

Cast string literals to datetime in addition and subtraction when the other side is a date or time interval.

IMPLICIT_CASTING_DATE_AND_DATE_NANOS

public static final EsqlCapabilities.Cap IMPLICIT_CASTING_DATE_AND_DATE_NANOS

Support implicit casting for union typed fields that are mixed with date and date_nanos type.

NAMED_POSITIONAL_PARAMETER

public static final EsqlCapabilities.Cap NAMED_POSITIONAL_PARAMETER

Support for named or positional parameters in EsqlQueryRequest.

UNION_TYPES

public static final EsqlCapabilities.Cap UNION_TYPES

Support multiple field mappings if appropriate conversion function is used (union types)

UNMAPPED_FIELDS

public static final EsqlCapabilities.Cap UNMAPPED_FIELDS

Support unmapped using the INSIST keyword.

ST_DISTANCE

public static final EsqlCapabilities.Cap ST_DISTANCE

Support for function ST_DISTANCE. Done in #108764.

ST_EXTENT_AGG

public static final EsqlCapabilities.Cap ST_EXTENT_AGG

Support for function ST_EXTENT_AGG.

ST_EXTENT_AGG_DOCVALUES

public static final EsqlCapabilities.Cap ST_EXTENT_AGG_DOCVALUES

Optimization of ST_EXTENT_AGG with doc-values as IntBlock.

SPATIAL_AGGS_FILTERING

public static final EsqlCapabilities.Cap SPATIAL_AGGS_FILTERING

Fix to bug with spatial aggregations not properly supporting the WHERE clause. Fixes #142329.

SPATIAL_FUNCTIONS_FIX_CRSTYPE_FOLDING

public static final EsqlCapabilities.Cap SPATIAL_FUNCTIONS_FIX_CRSTYPE_FOLDING

Fix determination of CRS types in spatial functions when folding.

SPATIAL_PREDICATES_SUPPORT_MULTIVALUES

public static final EsqlCapabilities.Cap SPATIAL_PREDICATES_SUPPORT_MULTIVALUES

Enable spatial predicate functions to support multi-values. Done in #112063.

SPATIAL_DISTANCE_SUPPORTS_MULTIVALUES

public static final EsqlCapabilities.Cap SPATIAL_DISTANCE_SUPPORTS_MULTIVALUES

Enable spatial distance function to support multi-values. Done in #114836.

SPATIAL_DISTANCE_PUSHDOWN_ENHANCEMENTS

public static final EsqlCapabilities.Cap SPATIAL_DISTANCE_PUSHDOWN_ENHANCEMENTS

Support a number of fixes and enhancements to spatial distance pushdown. Done in #112938.

SPATIAL_CENTROID_NO_RECORDS

public static final EsqlCapabilities.Cap SPATIAL_CENTROID_NO_RECORDS

Fix for spatial centroid when no records are found.

ST_CENTROID_AGG_SHAPES

public static final EsqlCapabilities.Cap ST_CENTROID_AGG_SHAPES

Support for ST_CENTROID_AGG aggregation on geo_shape and cartesian_shape fields.

ST_CENTROID_AGG_SHAPES_DOC_VALUES

public static final EsqlCapabilities.Cap ST_CENTROID_AGG_SHAPES_DOC_VALUES

Support for ST_CENTROID_AGG aggregation on shapes from doc-values.

ST_ENVELOPE

public static final EsqlCapabilities.Cap ST_ENVELOPE

Support ST_ENVELOPE function (and related ST_XMIN, etc.).

ST_ENVELOPE_MV_FIX

public static final EsqlCapabilities.Cap ST_ENVELOPE_MV_FIX

Fix ST_ENVELOPE to support multi-values and doc-values.

ST_NPOINTS

public static final EsqlCapabilities.Cap ST_NPOINTS

Support ST_NPOINTS function.

SPATIAL_GRID

public static final EsqlCapabilities.Cap SPATIAL_GRID

Support ST_GEOHASH, ST_GEOTILE and ST_GEOHEX functions

SPATIAL_GRID_TYPES

public static final EsqlCapabilities.Cap SPATIAL_GRID_TYPES

Support geohash, geotile and geohex data types. Done in #129581

SPATIAL_GRID_INTERSECTS

public static final EsqlCapabilities.Cap SPATIAL_GRID_INTERSECTS

Support geohash, geotile and geohex in ST_INTERSECTS and ST_DISJOINT. Done in #133546

GROK_DISSECT_MASKING

public static final EsqlCapabilities.Cap GROK_DISSECT_MASKING

Fix to GROK and DISSECT that allows extracting attributes with the same name as the input https://github.com/elastic/elasticsearch/issues/110184

DOUBLE_QUOTES_SOURCE_ENCLOSING

public static final EsqlCapabilities.Cap DOUBLE_QUOTES_SOURCE_ENCLOSING

Support for quoting index sources in double quotes.

AGG_WEIGHTED_AVG

public static final EsqlCapabilities.Cap AGG_WEIGHTED_AVG

Support for WEIGHTED_AVG function.

UNION_TYPES_AGG_CAST

public static final EsqlCapabilities.Cap UNION_TYPES_AGG_CAST

Fix for union-types when aggregating over an inline conversion with casting operator. Done in #110476.

FIX_COUNT_PUSHDOWN_FOR_UNION_TYPES

public static final EsqlCapabilities.Cap FIX_COUNT_PUSHDOWN_FOR_UNION_TYPES

When pushing down STATS count(field::type) for a union type field, we wrongly used a synthetic attribute name in the query instead of the actual field name. This led to 0 counts instead of the correct result.

GROK_VALIDATION

public static final EsqlCapabilities.Cap GROK_VALIDATION

Fix to GROK validation in case of multiple fields with same name and different types https://github.com/elastic/elasticsearch/issues/110533

UNION_TYPES_INLINE_FIX

public static final EsqlCapabilities.Cap UNION_TYPES_INLINE_FIX

Fix for union-types when aggregating over an inline conversion with conversion function. Done in #110652.

UNION_TYPES_REMOVE_FIELDS

public static final EsqlCapabilities.Cap UNION_TYPES_REMOVE_FIELDS

Fix for union-types when sorting a type-casted field. We changed how we remove synthetic union-types fields.

UNION_TYPES_FIX_RENAME_RESOLUTION

public static final EsqlCapabilities.Cap UNION_TYPES_FIX_RENAME_RESOLUTION

Fix for union-types when renaming unrelated columns. https://github.com/elastic/elasticsearch/issues/111452

RENAME_SEQUENTIAL_PROCESSING

public static final EsqlCapabilities.Cap RENAME_SEQUENTIAL_PROCESSING

Execute `RENAME` operations sequentially from left to right, see ESQL: Align RENAME behavior with EVAL for sequential processing #122250

RENAME_ALLOW_ASSIGNMENT

public static final EsqlCapabilities.Cap RENAME_ALLOW_ASSIGNMENT

Support for assignment in RENAME, besides the use of `AS` keyword.

REMOVE_EMPTY_ATTRIBUTE_IN_MERGING_OUTPUT

public static final EsqlCapabilities.Cap REMOVE_EMPTY_ATTRIBUTE_IN_MERGING_OUTPUT

Support for removing empty attribute in merging output. See ESQL: EVAL after STATS produces an empty column #126392

RETAIN_AGGREGATE_WHEN_GROUPING

public static final EsqlCapabilities.Cap RETAIN_AGGREGATE_WHEN_GROUPING

Support for retain aggregate when grouping. See ES|QL: columns not projected away despite KEEP #126026

UNION_TYPES_MISSING_FIELD

public static final EsqlCapabilities.Cap UNION_TYPES_MISSING_FIELD

Fix for union-types when some indexes are missing the required field. Done in #111932.

UNION_TYPES_NUMERIC_WIDENING

public static final EsqlCapabilities.Cap UNION_TYPES_NUMERIC_WIDENING

Fix for widening of short numeric types in union-types. Done in #112610

UNION_TYPES_RESOLVE_PAST_PROJECTIONS

public static final EsqlCapabilities.Cap UNION_TYPES_RESOLVE_PAST_PROJECTIONS

Fix for resolving union type casts past projections (KEEP) and MV_EXPAND operations. Ensures that casting a union type field works correctly when the field has been projected and expanded through MV_EXPAND. See #137923

FIX_PARSING_LARGE_NEGATIVE_NUMBERS

public static final EsqlCapabilities.Cap FIX_PARSING_LARGE_NEGATIVE_NUMBERS

Fix a parsing issue where numbers below Long.MIN_VALUE threw an exception instead of parsing as doubles. see Parsing large numbers is inconsistent #104323

FIX_PRECISION_OF_SCALED_FLOAT_FIELDS

public static final EsqlCapabilities.Cap FIX_PRECISION_OF_SCALED_FLOAT_FIELDS

Fix precision of scaled_float field values retrieved from stored source see Slight inconsistency in ESQL using scaled_float field #122547

FIX_COUNT_DISTINCT_SOURCE_ERROR

public static final EsqlCapabilities.Cap FIX_COUNT_DISTINCT_SOURCE_ERROR

Fix the status code returned when trying to run count_distinct on the _source type (which is not supported). see count_distinct(_source) returns a 500 response

RANGEQUERY_FOR_DATETIME

public static final EsqlCapabilities.Cap RANGEQUERY_FOR_DATETIME

Use RangeQuery for BinaryComparison on DateTime fields.

ENRICH_STRICT_RANGE_TYPES

public static final EsqlCapabilities.Cap ENRICH_STRICT_RANGE_TYPES

Enforce strict type checking on ENRICH range types, and warnings for KEYWORD parsing at runtime. Done in #115091.

UNIQUE_NAMES

public static final EsqlCapabilities.Cap UNIQUE_NAMES

Fix for non-unique attribute names in ROW and logical plans. https://github.com/elastic/elasticsearch/issues/110541

FIXED_PUSHDOWN_PAST_PROJECT

public static final EsqlCapabilities.Cap FIXED_PUSHDOWN_PAST_PROJECT

Make attributes of GROK/DISSECT adjustable and fix a shadowing bug when pushing them down past PROJECT. https://github.com/elastic/elasticsearch/issues/108008

FIXED_PUSHDOWN_PAST_PROJECT_WITH_ATTRIBUTES_RESOLUTION

public static final EsqlCapabilities.Cap FIXED_PUSHDOWN_PAST_PROJECT_WITH_ATTRIBUTES_RESOLUTION

When resolving renames, consider all Attributes in the plan, not just the ReferenceAttributes.

MV_PSERIES_WEIGHTED_SUM

public static final EsqlCapabilities.Cap MV_PSERIES_WEIGHTED_SUM

Adds the MV_PSERIES_WEIGHTED_SUM function for converting sorted lists of numbers into a bounded score. This is a generalization of the riemann zeta function but we don't name it that because we don't support complex numbers and don't want to make folks think of mystical number theory things. This is just a weighted sum that is adjacent to magic.

MATCH_OPERATOR_COLON

public static final EsqlCapabilities.Cap MATCH_OPERATOR_COLON

Support for match operator as a colon. Previous support for match operator as MATCH has been removed

NO_META

public static final EsqlCapabilities.Cap NO_META

Removing support for the META keyword.

COMBINE_BINARY_COMPARISONS

public static final EsqlCapabilities.Cap COMBINE_BINARY_COMPARISONS

Add CombineBinaryComparisons rule.

DATE_NANOS_TYPE

public static final EsqlCapabilities.Cap DATE_NANOS_TYPE

Support for nanosecond dates as a data type

TO_DATE_NANOS

public static final EsqlCapabilities.Cap TO_DATE_NANOS

Support for to_date_nanos function

DATE_NANOS_BINARY_COMPARISON

public static final EsqlCapabilities.Cap DATE_NANOS_BINARY_COMPARISON

Support for date nanos type in binary comparisons

DATE_NANOS_COMPARE_TO_MILLIS

public static final EsqlCapabilities.Cap DATE_NANOS_COMPARE_TO_MILLIS

Support for mixed comparisons between nanosecond and millisecond dates

DATE_NANOS_IMPLICIT_CASTING

public static final EsqlCapabilities.Cap DATE_NANOS_IMPLICIT_CASTING

Support implicit casting of strings to date nanos

LEAST_GREATEST_FOR_DATENANOS

public static final EsqlCapabilities.Cap LEAST_GREATEST_FOR_DATENANOS

Support Least and Greatest functions on Date Nanos type

DATE_NANOS_DATE_EXTRACT

public static final EsqlCapabilities.Cap DATE_NANOS_DATE_EXTRACT

support date extract function for date nanos

DATE_NANOS_ADD_SUBTRACT

public static final EsqlCapabilities.Cap DATE_NANOS_ADD_SUBTRACT

Support add and subtract on date nanos

DATE_TRUNC_DATE_NANOS

public static final EsqlCapabilities.Cap DATE_TRUNC_DATE_NANOS

Support for date_trunc function on date nanos type

DATE_NANOS_BUCKET

public static final EsqlCapabilities.Cap DATE_NANOS_BUCKET

Support date nanos values as the field argument to bucket

DATE_NANOS_AGGREGATIONS

public static final EsqlCapabilities.Cap DATE_NANOS_AGGREGATIONS

support aggregations on date nanos

DATE_NANOS_IN_OPERATOR

public static final EsqlCapabilities.Cap DATE_NANOS_IN_OPERATOR

Support the In operator for date nanos

DATE_NANOS_DATE_FORMAT

public static final EsqlCapabilities.Cap DATE_NANOS_DATE_FORMAT

Support running date format function on nanosecond dates

DATE_NANOS_DATE_DIFF

public static final EsqlCapabilities.Cap DATE_NANOS_DATE_DIFF

support date diff function on date nanos type, and mixed nanos/millis

FIX_DATE_NANOS_LUCENE_PUSHDOWN_BUG

public static final EsqlCapabilities.Cap FIX_DATE_NANOS_LUCENE_PUSHDOWN_BUG

Indicates that https://github.com/elastic/elasticsearch/issues/125439 (incorrect lucene push down for date nanos) is fixed

FIX_DATE_NANOS_MIXED_RANGE_PUSHDOWN_BUG

public static final EsqlCapabilities.Cap FIX_DATE_NANOS_MIXED_RANGE_PUSHDOWN_BUG

Fixes a bug where dates are incorrectly formatted if a where clause compares nanoseconds to both milliseconds and nanoseconds, e.g. WHERE millis > to_datenanos("2023-10-23T12:15:03.360103847") AND millis < to_datetime("2023-10-23T13:53:55.832")

DATE_NANOS_LOOKUP_JOIN

public static final EsqlCapabilities.Cap DATE_NANOS_LOOKUP_JOIN

Support for date nanos in lookup join. Done in #127962

DATE_PARSE_TZ

public static final EsqlCapabilities.Cap DATE_PARSE_TZ

DATE_PARSE supports reading timezones

LEAST_GREATEST_FOR_DATES

public static final EsqlCapabilities.Cap LEAST_GREATEST_FOR_DATES

Support for datetime in least and greatest functions

COMBINE_DISJUNCTIVE_CIDRMATCHES

public static final EsqlCapabilities.Cap COMBINE_DISJUNCTIVE_CIDRMATCHES

Support CIDRMatch in CombineDisjunctions rule.

ASYNC_QUERY_STATUS_HEADERS

public static final EsqlCapabilities.Cap ASYNC_QUERY_STATUS_HEADERS

Support sending HTTP headers about the status of an async query.

ASYNC_QUERY_STATUS_HEADERS_FIX

public static final EsqlCapabilities.Cap ASYNC_QUERY_STATUS_HEADERS_FIX

Fix async headers not being sent on "get" requests

BUCKET_INCLUSIVE_UPPER_BOUND

public static final EsqlCapabilities.Cap BUCKET_INCLUSIVE_UPPER_BOUND

Consider the upper bound when computing the interval in BUCKET auto mode.

DATE_TRUNC_WITH_ARBITRARY_INTERVALS

public static final EsqlCapabilities.Cap DATE_TRUNC_WITH_ARBITRARY_INTERVALS

Enhanced DATE_TRUNC with arbitrary month and year intervals. (#120302)

SHORT_ERROR_MESSAGES_FOR_UNSUPPORTED_FIELDS

public static final EsqlCapabilities.Cap SHORT_ERROR_MESSAGES_FOR_UNSUPPORTED_FIELDS

Changed error messages for fields with conflicting types in different indices.

BUCKET_WHOLE_NUMBER_AS_SPAN

public static final EsqlCapabilities.Cap BUCKET_WHOLE_NUMBER_AS_SPAN

Support for the whole number spans in BUCKET function.

MIXED_NUMERIC_TYPES_IN_COALESCE

public static final EsqlCapabilities.Cap MIXED_NUMERIC_TYPES_IN_COALESCE

Allow mixed numeric types in coalesce

SPACE

public static final EsqlCapabilities.Cap SPACE

Support for requesting the "SPACE" function.

CAST_STRING_LITERAL_TO_TEMPORAL_AMOUNT

public static final EsqlCapabilities.Cap CAST_STRING_LITERAL_TO_TEMPORAL_AMOUNT

Support explicit casting from string literal to DATE_PERIOD or TIME_DURATION.

CATEGORIZE_V6

public static final EsqlCapabilities.Cap CATEGORIZE_V6

Supported the text categorization function "CATEGORIZE".

CATEGORIZE_MULTIPLE_GROUPINGS

public static final EsqlCapabilities.Cap CATEGORIZE_MULTIPLE_GROUPINGS

Support for multiple groupings in "CATEGORIZE".

QSTR_FUNCTION

public static final EsqlCapabilities.Cap QSTR_FUNCTION

QSTR function

QSTR_FUNCTION_BOOST_FIX

public static final EsqlCapabilities.Cap QSTR_FUNCTION_BOOST_FIX

Guards a fix for the boost parameter in QueryString queries

MATCH_FUNCTION

public static final EsqlCapabilities.Cap MATCH_FUNCTION

MATCH function

KQL_FUNCTION

public static final EsqlCapabilities.Cap KQL_FUNCTION

KQL function

KQL_FUNCTION_OPTIONS

public static final EsqlCapabilities.Cap KQL_FUNCTION_OPTIONS

Support for optional parameters in KQL function (case_insensitive, time_zone, default_field, boost).

HASH_FUNCTION

public static final EsqlCapabilities.Cap HASH_FUNCTION

Hash function

HASH_FUNCTION_ALIASES_V1

public static final EsqlCapabilities.Cap HASH_FUNCTION_ALIASES_V1

Hash function aliases such as MD5

FIXED_WRONG_IS_NOT_NULL_CHECK_ON_CASE

public static final EsqlCapabilities.Cap FIXED_WRONG_IS_NOT_NULL_CHECK_ON_CASE

Don't optimize CASE IS NOT NULL function by not requiring the fields to be not null as well. https://github.com/elastic/elasticsearch/issues/112704

DATE_DIFF_YEAR_CALENDARIAL

public static final EsqlCapabilities.Cap DATE_DIFF_YEAR_CALENDARIAL

Compute year differences in full calendar years.

SORTING_ON_SOURCE_AND_COUNTERS_FORBIDDEN

public static final EsqlCapabilities.Cap SORTING_ON_SOURCE_AND_COUNTERS_FORBIDDEN

Fix sorting not allowed on _source and counters.

SORT_RETURNING_SOURCE_OK

public static final EsqlCapabilities.Cap SORT_RETURNING_SOURCE_OK

Fix SORT when the _source field is not a sort key but is being returned.

SOURCE_FIELD_MAPPING

public static final EsqlCapabilities.Cap SOURCE_FIELD_MAPPING

_source field mapping directives: https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-source-field.html

FIELD_ALIAS_SUPPORT

public static final EsqlCapabilities.Cap FIELD_ALIAS_SUPPORT

Support for field aliases in mappings. Used by tests, since this was feature wasn't always supported by CsvTests.

PER_AGG_FILTERING

public static final EsqlCapabilities.Cap PER_AGG_FILTERING

Allow filter per individual aggregation.

PER_AGG_FILTERING_ORDS

public static final EsqlCapabilities.Cap PER_AGG_FILTERING_ORDS

Fix PER_AGG_FILTERING grouped by ordinals.

STD_DEV

public static final EsqlCapabilities.Cap STD_DEV

Support for STD_DEV aggregation.

FIX_STATS_BY_FOLDABLE_EXPRESSION

public static final EsqlCapabilities.Cap FIX_STATS_BY_FOLDABLE_EXPRESSION

Fix for https://github.com/elastic/elasticsearch/issues/114714

FUNCTION_STATS

public static final EsqlCapabilities.Cap FUNCTION_STATS

Adding stats for functions (stack telemetry)

FIX_FILTER_PUSHDOWN_PAST_STATS

public static final EsqlCapabilities.Cap FIX_FILTER_PUSHDOWN_PAST_STATS

Fix for an optimization that caused wrong results https://github.com/elastic/elasticsearch/issues/115281

STATS_ALIAS_COLLISION_WARNINGS

public static final EsqlCapabilities.Cap STATS_ALIAS_COLLISION_WARNINGS

Send warnings on STATS alias collision https://github.com/elastic/elasticsearch/issues/114970

SNAPSHOT_TEST_FOR_TELEMETRY_V2

public static final EsqlCapabilities.Cap SNAPSHOT_TEST_FOR_TELEMETRY_V2

This enables 60_usage.yml "Basic ESQL usage....snapshot" version test. See also the next capability.

NON_SNAPSHOT_TEST_FOR_TELEMETRY_V2

public static final EsqlCapabilities.Cap NON_SNAPSHOT_TEST_FOR_TELEMETRY_V2

This enables 60_usage.yml "Basic ESQL usage....non-snapshot" version test. See also the previous capability.

NAMED_PARAMETER_FOR_FIELD_AND_FUNCTION_NAMES_SIMPLIFIED_SYNTAX

public static final EsqlCapabilities.Cap NAMED_PARAMETER_FOR_FIELD_AND_FUNCTION_NAMES_SIMPLIFIED_SYNTAX

Support simplified syntax for named parameters for field and function names.

ADD_LIMIT_INSIDE_MV_EXPAND

public static final EsqlCapabilities.Cap ADD_LIMIT_INSIDE_MV_EXPAND

Fix pushdown of LIMIT past MV_EXPAND

DELAY_DEBUG_FN

public static final EsqlCapabilities.Cap DELAY_DEBUG_FN

METADATA_FIELDS_REMOTE_TEST

public static final EsqlCapabilities.Cap METADATA_FIELDS_REMOTE_TEST

Capability for remote metadata test

JOIN_PLANNING_V1

public static final EsqlCapabilities.Cap JOIN_PLANNING_V1

WIP on Join planning - Introduce BinaryPlan and co - Refactor INLINESTATS and LOOKUP as a JOIN block

IMPLICIT_CASTING_STRING_LITERAL_TO_TEMPORAL_AMOUNT

public static final EsqlCapabilities.Cap IMPLICIT_CASTING_STRING_LITERAL_TO_TEMPORAL_AMOUNT

Support implicit casting from string literal to DATE_PERIOD or TIME_DURATION.

JOIN_LOOKUP_V12

public static final EsqlCapabilities.Cap JOIN_LOOKUP_V12

LOOKUP JOIN

LOOKUP_JOIN_TEXT

public static final EsqlCapabilities.Cap LOOKUP_JOIN_TEXT

LOOKUP JOIN with TEXT fields on the right (right side of the join) (#119473)

JOIN_LOOKUP_SKIP_MV_WARNINGS

public static final EsqlCapabilities.Cap JOIN_LOOKUP_SKIP_MV_WARNINGS

LOOKUP JOIN skipping MVs and sending warnings (https://github.com/elastic/elasticsearch/issues/118780)

ASYNC_OPERATOR_WARNINGS_FIX

public static final EsqlCapabilities.Cap ASYNC_OPERATOR_WARNINGS_FIX

Fix for async operator sometimes completing the driver without emitting the stored warnings

JOIN_LOOKUP_FIX_LIMIT_PUSHDOWN

public static final EsqlCapabilities.Cap JOIN_LOOKUP_FIX_LIMIT_PUSHDOWN

Fix pushing down LIMIT past LOOKUP JOIN in case of multiple matching join keys.

FIX_NESTED_FIELDS_NAME_CLASH_IN_INDEXRESOLVER

public static final EsqlCapabilities.Cap FIX_NESTED_FIELDS_NAME_CLASH_IN_INDEXRESOLVER

Fix for https://github.com/elastic/elasticsearch/issues/117054

FIX_STATS_BY_FOLDABLE_EXPRESSION_2

public static final EsqlCapabilities.Cap FIX_STATS_BY_FOLDABLE_EXPRESSION_2

Fix for https://github.com/elastic/elasticsearch/issues/114714, again

METADATA_SCORE

public static final EsqlCapabilities.Cap METADATA_SCORE

Support the "METADATA _score" directive to enable _score column.

MATCH_ADDITIONAL_TYPES

public static final EsqlCapabilities.Cap MATCH_ADDITIONAL_TYPES

Additional types for match function and operator

FIXED_REGEX_FOLD

public static final EsqlCapabilities.Cap FIXED_REGEX_FOLD

Fix for regex folding with case-insensitive pattern https://github.com/elastic/elasticsearch/issues/118371

FULL_TEXT_FUNCTIONS_DISJUNCTIONS

public static final EsqlCapabilities.Cap FULL_TEXT_FUNCTIONS_DISJUNCTIONS

Full text functions can be used in disjunctions

SEMANTIC_TEXT_FIELD_CAPS

public static final EsqlCapabilities.Cap SEMANTIC_TEXT_FIELD_CAPS

Change field caps response for semantic_text fields to be reported as text

OPTIONAL_NAMED_ARGUMENT_MAP_FOR_FUNCTION

public static final EsqlCapabilities.Cap OPTIONAL_NAMED_ARGUMENT_MAP_FOR_FUNCTION

Support named argument for function in map format.

LOOKUP_JOIN_NO_ALIASES

public static final EsqlCapabilities.Cap LOOKUP_JOIN_NO_ALIASES

Disabled support for index aliases in lookup joins

FULL_TEXT_FUNCTIONS_DISJUNCTIONS_COMPUTE_ENGINE

public static final EsqlCapabilities.Cap FULL_TEXT_FUNCTIONS_DISJUNCTIONS_COMPUTE_ENGINE

Full text functions can be used in disjunctions as they are implemented in compute engine

MATCH_FUNCTION_OPTIONS

public static final EsqlCapabilities.Cap MATCH_FUNCTION_OPTIONS

Support match options in match function

QUERY_STRING_FUNCTION_OPTIONS

public static final EsqlCapabilities.Cap QUERY_STRING_FUNCTION_OPTIONS

Support options in the query string function.

AGGREGATE_METRIC_DOUBLE_V0

public static final EsqlCapabilities.Cap AGGREGATE_METRIC_DOUBLE_V0

Enable aggregate_metric_double in non-snapshot builds

AGGREGATE_METRIC_DOUBLE_DEFAULT_METRIC

public static final EsqlCapabilities.Cap AGGREGATE_METRIC_DOUBLE_DEFAULT_METRIC

Support running all aggregations on aggregate_metric_double using the default metric

AGGREGATE_METRIC_DOUBLE_AVG_AS_DEFAULT_METRIC

public static final EsqlCapabilities.Cap AGGREGATE_METRIC_DOUBLE_AVG_AS_DEFAULT_METRIC

Support avg as a possible default metric for aggregate_metric_double

AGGREGATE_METRIC_DOUBLE_NO_ROWS_COUNT_0

public static final EsqlCapabilities.Cap AGGREGATE_METRIC_DOUBLE_NO_ROWS_COUNT_0

Return 0 (instead of null) for count on AMD when there are no rows

AGGREGATE_METRIC_DOUBLE_BINARY_OPERATORS

public static final EsqlCapabilities.Cap AGGREGATE_METRIC_DOUBLE_BINARY_OPERATORS

Support binary operators for aggregate_metric_double

CHANGE_POINT

public static final EsqlCapabilities.Cap CHANGE_POINT

Support change point detection "CHANGE_POINT".

REMOVE_REDUNDANT_SORT

public static final EsqlCapabilities.Cap REMOVE_REDUNDANT_SORT

Fix for https://github.com/elastic/elasticsearch/issues/120817 and https://github.com/elastic/elasticsearch/issues/120803 Support for queries that have multiple SORTs that cannot become TopN

INLINESTATS_V11

public static final EsqlCapabilities.Cap INLINESTATS_V11

Fixes a series of issues with inlinestats which had an incomplete implementation after lookup and inlinestats were refactored.

INLINE_STATS

public static final EsqlCapabilities.Cap INLINE_STATS

Renamed `INLINESTATS` to `INLINE STATS`.

INLINE_STATS_PRECEEDED_BY_SORT

public static final EsqlCapabilities.Cap INLINE_STATS_PRECEEDED_BY_SORT

Added support for having INLINE STATS preceded by a SORT clause, now executable in certain cases.

SUPPORT_PARTIAL_RESULTS

public static final EsqlCapabilities.Cap SUPPORT_PARTIAL_RESULTS

Support partial_results

RERANK

public static final EsqlCapabilities.Cap RERANK

Support for RERANK command

COMPLETION

public static final EsqlCapabilities.Cap COMPLETION

Support for COMPLETION command

MIXED_NUMERIC_TYPES_IN_CASE_GREATEST_LEAST

public static final EsqlCapabilities.Cap MIXED_NUMERIC_TYPES_IN_CASE_GREATEST_LEAST

Allow mixed numeric types in conditional functions - case, greatest and least

STARTS_WITH_ENDS_WITH_LUCENE_PUSHDOWN

public static final EsqlCapabilities.Cap STARTS_WITH_ENDS_WITH_LUCENE_PUSHDOWN

Lucene query pushdown to StartsWith and EndsWith functions. This capability was created to avoid receiving wrong warnings from old nodes in mixed clusters

FULL_TEXT_FUNCTIONS_DISJUNCTIONS_SCORE

public static final EsqlCapabilities.Cap FULL_TEXT_FUNCTIONS_DISJUNCTIONS_SCORE

Full text functions can be scored when being part of a disjunction

TO_LOWER_MV

public static final EsqlCapabilities.Cap TO_LOWER_MV

Do TO_LOWER and TO_UPPER process all field values?

CHUNK_MV

public static final EsqlCapabilities.Cap CHUNK_MV

Does CHUNK process all field values?

DOUBLE_PARAMETER_MARKERS_FOR_IDENTIFIERS

public static final EsqlCapabilities.Cap DOUBLE_PARAMETER_MARKERS_FOR_IDENTIFIERS

Use double parameter markers to represent field or function names.

NON_FULL_TEXT_FUNCTIONS_SCORING

public static final EsqlCapabilities.Cap NON_FULL_TEXT_FUNCTIONS_SCORING

Non full text functions do not contribute to score

REPORT_ORIGINAL_TYPES

public static final EsqlCapabilities.Cap REPORT_ORIGINAL_TYPES

The _query API now reports the original types.

METRICS_COMMAND

@Deprecated
public static final EsqlCapabilities.Cap METRICS_COMMAND

Deprecated.

The metrics command

METRICS_GROUP_BY_ALL

public static final EsqlCapabilities.Cap METRICS_GROUP_BY_ALL

Enables automatically grouping by all dimension fields in TS mode queries

DOCUMENTS_FOUND_AND_VALUES_LOADED

public static final EsqlCapabilities.Cap DOCUMENTS_FOUND_AND_VALUES_LOADED

Are the documents_found and values_loaded fields available in the response and profile?

INDEX_COMPONENT_SELECTORS

public static final EsqlCapabilities.Cap INDEX_COMPONENT_SELECTORS

Index component selector syntax (my-data-stream-name::failures)

MAKE_NUMBER_OF_CHANNELS_CONSISTENT_WITH_LAYOUT

public static final EsqlCapabilities.Cap MAKE_NUMBER_OF_CHANNELS_CONSISTENT_WITH_LAYOUT

Make numberOfChannels consistent with layout in DefaultLayout by removing duplicated ChannelSet.

FIX_REPLACE_MISSING_FIELD_WITH_NULL_DUPLICATE_NAME_ID_IN_LAYOUT

public static final EsqlCapabilities.Cap FIX_REPLACE_MISSING_FIELD_WITH_NULL_DUPLICATE_NAME_ID_IN_LAYOUT

Supercedes MAKE_NUMBER_OF_CHANNELS_CONSISTENT_WITH_LAYOUT.

FILTER_IN_CONVERTED_NULL

public static final EsqlCapabilities.Cap FILTER_IN_CONVERTED_NULL

Support for filter in converted null. See ESQL: Fix `NULL` handling in `IN` clause #125832

FIX_DOUBLY_RELEASED_NULL_BLOCKS_IN_VALUESOURCEREADER

public static final EsqlCapabilities.Cap FIX_DOUBLY_RELEASED_NULL_BLOCKS_IN_VALUESOURCEREADER

When creating constant null blocks in ValuesSourceReaderOperator, we also handed off the ownership of that block - but didn't account for the fact that the caller might close it, leading to double releases in some union type queries. C.f. https://github.com/elastic/elasticsearch/issues/125850

QUERY_MONITORING

public static final EsqlCapabilities.Cap QUERY_MONITORING

Listing queries and getting information on a specific query.

FORK_V9

public static final EsqlCapabilities.Cap FORK_V9

Support for FORK out of snapshot

FORK_UNION_TYPES

public static final EsqlCapabilities.Cap FORK_UNION_TYPES

Support for union types in FORK

SUBQUERY_IN_FROM_COMMAND

public static final EsqlCapabilities.Cap SUBQUERY_IN_FROM_COMMAND

Support non-correlated subqueries in the FROM clause.

SUBQUERY_IN_FROM_COMMAND_WITHOUT_IMPLICIT_LIMIT

public static final EsqlCapabilities.Cap SUBQUERY_IN_FROM_COMMAND_WITHOUT_IMPLICIT_LIMIT

Support non-correlated subqueries in the FROM clause without implicit limit.

SUBQUERY_IN_FROM_COMMAND_APPEND_IMPLICIT_LIMIT_TO_UNBOUNDED_SORT_IN_SUBQUERY

public static final EsqlCapabilities.Cap SUBQUERY_IN_FROM_COMMAND_APPEND_IMPLICIT_LIMIT_TO_UNBOUNDED_SORT_IN_SUBQUERY

Append an implicit limit to unbounded sorts in subqueries in the FROM clause.

SUBQUERY_IN_FROM_COMMAND_PRUNE_NO_FIELDS

public static final EsqlCapabilities.Cap SUBQUERY_IN_FROM_COMMAND_PRUNE_NO_FIELDS

Prune no-fields in subquery project.

SUBQUERY_IN_FROM_COMMAND_UNION_TYPES_CONFLICT_RESOLUTION

public static final EsqlCapabilities.Cap SUBQUERY_IN_FROM_COMMAND_UNION_TYPES_CONFLICT_RESOLUTION

Fix for union types when fields have conflicting types between subqueries. https://github.com/elastic/elasticsearch/issues/142499

VIEWS_IN_CLUSTER_STATE

public static final EsqlCapabilities.Cap VIEWS_IN_CLUSTER_STATE

Support for views in cluster state (and REST API).

VIEWS_WITH_NO_BRANCHING

public static final EsqlCapabilities.Cap VIEWS_WITH_NO_BRANCHING

Basic Views with no branching (do not need subqueries or FORK).

VIEWS_CRUD_AS_INDEX_ACTIONS

public static final EsqlCapabilities.Cap VIEWS_CRUD_AS_INDEX_ACTIONS

Views crud actions as index actions

VIEWS_WITH_BRANCHING

public static final EsqlCapabilities.Cap VIEWS_WITH_BRANCHING

Views with branching (requires subqueries/FORK).

VIEWS_TELEMETRY

public static final EsqlCapabilities.Cap VIEWS_TELEMETRY

Added telemetry for views

VIEWS_DEDUPLICATION_BUGFIX

public static final EsqlCapabilities.Cap VIEWS_DEDUPLICATION_BUGFIX

Fixed a bug where views are incorrectly de-duplicated.

TO_IP_LEADING_ZEROS

public static final EsqlCapabilities.Cap TO_IP_LEADING_ZEROS

Support for the leading_zeros named parameter.

USAGE_CONTAINS_TOOK

public static final EsqlCapabilities.Cap USAGE_CONTAINS_TOOK

Does the usage information for ESQL contain a histogram of took values?

LOADING_NON_INDEXED_IP_FIELDS

public static final EsqlCapabilities.Cap LOADING_NON_INDEXED_IP_FIELDS

Support loading of ip fields if they are not indexed.

FIX_JOIN_MASKING_EVAL

public static final EsqlCapabilities.Cap FIX_JOIN_MASKING_EVAL

During resolution (pre-analysis) we have to consider that joins or enriches can override EVALuated values https://github.com/elastic/elasticsearch/issues/126419

DROP_AGAIN_WITH_WILDCARD_AFTER_EVAL

public static final EsqlCapabilities.Cap DROP_AGAIN_WITH_WILDCARD_AFTER_EVAL

Support for keeping `DROP` attributes when resolving field names. see ES|QL: no matches for pattern #126418

DROP_WITH_WILDCARD_AFTER_LOOKUP_JOIN

public static final EsqlCapabilities.Cap DROP_WITH_WILDCARD_AFTER_LOOKUP_JOIN

Correctly ask for all fields from lookup indices even when there is e.g. a DROP *field after. See ES|QL: missing columns for wildcard drop after lookup join #129561

SCORE_FUNCTION

public static final EsqlCapabilities.Cap SCORE_FUNCTION

score function

SAMPLE_V3

public static final EsqlCapabilities.Cap SAMPLE_V3

Support for the SAMPLE command

SUGGESTED_CAST

public static final EsqlCapabilities.Cap SUGGESTED_CAST

The _query API now gives a cast recommendation if multiple types are found in certain instances.

TO_LOWER_EMPTY_STRING

public static final EsqlCapabilities.Cap TO_LOWER_EMPTY_STRING

Guards a bug fix matching TO_LOWER(f) == "".

INCREASE

public static final EsqlCapabilities.Cap INCREASE

Support for INCREASE, DELTA timeseries aggregations.

DELTA_TS_AGG

public static final EsqlCapabilities.Cap DELTA_TS_AGG

CLAMP_FUNCTIONS

public static final EsqlCapabilities.Cap CLAMP_FUNCTIONS

RESOLVE_GROUPINGS_BEFORE_RESOLVING_REFERENCES_TO_GROUPINGS_IN_AGGREGATIONS

public static final EsqlCapabilities.Cap RESOLVE_GROUPINGS_BEFORE_RESOLVING_REFERENCES_TO_GROUPINGS_IN_AGGREGATIONS

Resolve groupings before resolving references to groupings in the aggregations.

AGG_SAMPLE

public static final EsqlCapabilities.Cap AGG_SAMPLE

Support for the SAMPLE aggregation function

FULL_TEXT_FUNCTIONS_IN_STATS_WHERE

public static final EsqlCapabilities.Cap FULL_TEXT_FUNCTIONS_IN_STATS_WHERE

Full text functions in STATS

FIX_JOIN_MASKING_REGEX_EXTRACT

public static final EsqlCapabilities.Cap FIX_JOIN_MASKING_REGEX_EXTRACT

During resolution (pre-analysis) we have to consider that joins can override regex extracted values see ES|QL: pruning of JOINs leads to missing fields #127467

FIX_JOIN_OUTPUT_MERGING

public static final EsqlCapabilities.Cap FIX_JOIN_OUTPUT_MERGING

Allow the merging of the children to use Aliases, instead of just ReferenceAttributes.

KEEP_REGEX_EXTRACT_ATTRIBUTES

public static final EsqlCapabilities.Cap KEEP_REGEX_EXTRACT_ATTRIBUTES

Avid GROK and DISSECT attributes being removed when resolving fields. see ES|QL: Grok only supports KEYWORD or TEXT values, found expression [type] type [INTEGER] #127468

ROUND_TO

public static final EsqlCapabilities.Cap ROUND_TO

The ROUND_TO function.

COPY_SIGN

public static final EsqlCapabilities.Cap COPY_SIGN

Support for the COPY_SIGN function.

LOOKUP_JOIN_ON_MIXED_NUMERIC_FIELDS

public static final EsqlCapabilities.Cap LOOKUP_JOIN_ON_MIXED_NUMERIC_FIELDS

Allow lookup join on mixed numeric fields, among byte, short, int, long, half_float, scaled_float, float and double.

LUCENE_QUERY_EVALUATOR_QUERY_REWRITE

public static final EsqlCapabilities.Cap LUCENE_QUERY_EVALUATOR_QUERY_REWRITE

LuceneQueryEvaluator rewrites the query before executing it in Lucene. This provides support for KQL in a STATS ... BY command that uses a KQL query for filter, for example.

PARAMETER_FOR_LIMIT

public static final EsqlCapabilities.Cap PARAMETER_FOR_LIMIT

Support parameters for LIMIT command.

NORMALIZED_LIMIT_ERROR_MESSAGE

public static final EsqlCapabilities.Cap NORMALIZED_LIMIT_ERROR_MESSAGE

Changed and normalized the LIMIT error message.

DENSE_VECTOR_FIELD_TYPE_RELEASED

public static final EsqlCapabilities.Cap DENSE_VECTOR_FIELD_TYPE_RELEASED

Dense vector field type support

ENABLE_LOOKUP_JOIN_ON_ALIASES

public static final EsqlCapabilities.Cap ENABLE_LOOKUP_JOIN_ON_ALIASES

Enable support for index aliases in lookup joins

UPDATE_LOOKUP_JOIN_ERROR_MESSAGES

public static final EsqlCapabilities.Cap UPDATE_LOOKUP_JOIN_ERROR_MESSAGES

Lookup error messages were updated to make them a bit easier to understand.

RLIKE_WITH_EMPTY_LANGUAGE_PATTERN

public static final EsqlCapabilities.Cap RLIKE_WITH_EMPTY_LANGUAGE_PATTERN

Allows RLIKE to correctly handle the "empty language" flag, `#`.

ENABLE_LOOKUP_JOIN_ON_REMOTE

public static final EsqlCapabilities.Cap ENABLE_LOOKUP_JOIN_ON_REMOTE

Enable support for cross-cluster lookup joins.

REMOTE_ENRICH_AFTER_LOOKUP_JOIN

public static final EsqlCapabilities.Cap REMOTE_ENRICH_AFTER_LOOKUP_JOIN

Fix the planning of | ENRICH _remote:policy when there's a preceding | LOOKUP JOIN, see java.lang.ClassCastException when combining LOOKUP JOIN and remote ENRICH

MATCH_PHRASE_FUNCTION

public static final EsqlCapabilities.Cap MATCH_PHRASE_FUNCTION

MATCH PHRASE function

KNN_FUNCTION_V5

public static final EsqlCapabilities.Cap KNN_FUNCTION_V5

Support knn function

TEXT_EMBEDDING_FUNCTION

public static final EsqlCapabilities.Cap TEXT_EMBEDDING_FUNCTION

Support for the TEXT_EMBEDDING function for generating dense vector embeddings.

LIKE_WITH_LIST_OF_PATTERNS

public static final EsqlCapabilities.Cap LIKE_WITH_LIST_OF_PATTERNS

Support for the LIKE operator with a list of wildcards.

LIKE_LIST_ON_INDEX_FIELDS

public static final EsqlCapabilities.Cap LIKE_LIST_ON_INDEX_FIELDS

PARAMETER_FOR_SAMPLE

public static final EsqlCapabilities.Cap PARAMETER_FOR_SAMPLE

Support parameters for SAMPLE command.

NO_PLAIN_STRINGS_IN_LITERALS

public static final EsqlCapabilities.Cap NO_PLAIN_STRINGS_IN_LITERALS

From now, Literal only accepts strings as BytesRefs. No java.lang.String anymore. https://github.com/elastic/elasticsearch/issues/129322

FIX_MV_EXPAND_INCONSISTENT_COLUMN_ORDER

public static final EsqlCapabilities.Cap FIX_MV_EXPAND_INCONSISTENT_COLUMN_ORDER

Support for the mv_expand target attribute should be retained in its original position. see ES|QL: inconsistent column order #129000

SET_COMMAND

public static final EsqlCapabilities.Cap SET_COMMAND

Support for the SET command.

DATE_TRUNC_TIMEZONE_SUPPORT

public static final EsqlCapabilities.Cap DATE_TRUNC_TIMEZONE_SUPPORT

Support timezones in DATE_TRUNC and dependent functions.

DATE_DIFF_TIMEZONE_SUPPORT

public static final EsqlCapabilities.Cap DATE_DIFF_TIMEZONE_SUPPORT

Support timezones in DATE_DIFF.

KQL_QSTR_TIMEZONE_SUPPORT

public static final EsqlCapabilities.Cap KQL_QSTR_TIMEZONE_SUPPORT

Support timezones in KQL and QSTR.

TYPE_CONVERSION_TIMEZONE_SUPPORT

public static final EsqlCapabilities.Cap TYPE_CONVERSION_TIMEZONE_SUPPORT

Support timezones in the conversion utils and functions, like TO_STRING.

DATE_FORMAT_DATE_PARSE_TIMEZONE_SUPPORT

public static final EsqlCapabilities.Cap DATE_FORMAT_DATE_PARSE_TIMEZONE_SUPPORT

Support timezones in DATE_FORMAT and DATE_PARSE.

ADD_SUB_OPERATOR_TIMEZONE_SUPPORT

public static final EsqlCapabilities.Cap ADD_SUB_OPERATOR_TIMEZONE_SUPPORT

Support timezones in + and - operators.

EXPLAIN

public static final EsqlCapabilities.Cap EXPLAIN

(Re)Added EXPLAIN command

EXPLAIN_WITH_REMOTE_PLANS

public static final EsqlCapabilities.Cap EXPLAIN_WITH_REMOTE_PLANS

EXPLAIN command with remote plans (5 columns: cluster, node, role, type, plan)

RLIKE_WITH_LIST_OF_PATTERNS

public static final EsqlCapabilities.Cap RLIKE_WITH_LIST_OF_PATTERNS

Support for the RLIKE operator with a list of regexes.

FUSE_V6

public static final EsqlCapabilities.Cap FUSE_V6

FUSE command

LIKE_ON_INDEX_FIELDS

public static final EsqlCapabilities.Cap LIKE_ON_INDEX_FIELDS

Support improved behavior for LIKE operator when used with index fields.

NO_BRACKETS_IN_UNQUOTED_INDEX_NAMES

public static final EsqlCapabilities.Cap NO_BRACKETS_IN_UNQUOTED_INDEX_NAMES

Forbid usage of brackets in unquoted index and enrich policy names https://github.com/elastic/elasticsearch/issues/130378

COSINE_VECTOR_SIMILARITY_FUNCTION

public static final EsqlCapabilities.Cap COSINE_VECTOR_SIMILARITY_FUNCTION

Cosine vector similarity function

FIXED_PROFILE_SERIALIZATION

public static final EsqlCapabilities.Cap FIXED_PROFILE_SERIALIZATION

Fixed some profile serialization issues

LOOKUP_JOIN_ON_MULTIPLE_FIELDS

public static final EsqlCapabilities.Cap LOOKUP_JOIN_ON_MULTIPLE_FIELDS

Support for lookup join on multiple fields.

DOT_PRODUCT_VECTOR_SIMILARITY_FUNCTION

public static final EsqlCapabilities.Cap DOT_PRODUCT_VECTOR_SIMILARITY_FUNCTION

Dot product vector similarity function

L1_NORM_VECTOR_SIMILARITY_FUNCTION

public static final EsqlCapabilities.Cap L1_NORM_VECTOR_SIMILARITY_FUNCTION

l1 norm vector similarity function

L2_NORM_VECTOR_SIMILARITY_FUNCTION

public static final EsqlCapabilities.Cap L2_NORM_VECTOR_SIMILARITY_FUNCTION

l2 norm vector similarity function

CATEGORIZE_OPTIONS

public static final EsqlCapabilities.Cap CATEGORIZE_OPTIONS

Support for the options field of CATEGORIZE.

DECAY_FUNCTION

public static final EsqlCapabilities.Cap DECAY_FUNCTION

Decay function for custom scoring.

DECAY_FUNCTION_PARAMETER_CONVERSION

public static final EsqlCapabilities.Cap DECAY_FUNCTION_PARAMETER_CONVERSION

Fix conversions for parameters for DECAY.

CORRECT_SKIPPED_SHARDS_COUNT

public static final EsqlCapabilities.Cap CORRECT_SKIPPED_SHARDS_COUNT

Support correct counting of skipped shards.

MAGNITUDE_SCALAR_VECTOR_FUNCTION

public static final EsqlCapabilities.Cap MAGNITUDE_SCALAR_VECTOR_FUNCTION

DENSE_VECTOR_FIELD_TYPE_BYTE_ELEMENTS

public static final EsqlCapabilities.Cap DENSE_VECTOR_FIELD_TYPE_BYTE_ELEMENTS

Byte elements dense vector field type support.

DENSE_VECTOR_FIELD_TYPE_BIT_ELEMENTS

public static final EsqlCapabilities.Cap DENSE_VECTOR_FIELD_TYPE_BIT_ELEMENTS

Bit elements dense vector field type support.

GENERIC_VECTOR_FORMAT

public static final EsqlCapabilities.Cap GENERIC_VECTOR_FORMAT

Support directIO rescoring and `bfloat16` for `bbq_hnsw` and `bbq_disk`, and `bfloat16` for `hnsw` ans `bbq_flat` index types.

VECTOR_SIMILARITY_FUNCTIONS_SUPPORT_NULL

public static final EsqlCapabilities.Cap VECTOR_SIMILARITY_FUNCTIONS_SUPPORT_NULL

Support null elements on vector similarity functions

HAMMING_VECTOR_SIMILARITY_FUNCTION

public static final EsqlCapabilities.Cap HAMMING_VECTOR_SIMILARITY_FUNCTION

Support for vector Hamming distance.

TBUCKET

public static final EsqlCapabilities.Cap TBUCKET

Support for tbucket function

NAME_QUALIFIERS

public static final EsqlCapabilities.Cap NAME_QUALIFIERS

Allow qualifiers in attribute names.

URL_ENCODE

public static final EsqlCapabilities.Cap URL_ENCODE

URL encoding function.

URL_ENCODE_COMPONENT

public static final EsqlCapabilities.Cap URL_ENCODE_COMPONENT

URL component encoding function.

URL_DECODE

public static final EsqlCapabilities.Cap URL_DECODE

URL decoding function.

LOOKUP_JOIN_ON_BOOLEAN_EXPRESSION

public static final EsqlCapabilities.Cap LOOKUP_JOIN_ON_BOOLEAN_EXPRESSION

Allow lookup join on boolean expressions

LOOKUP_JOIN_WITH_FULL_TEXT_FUNCTION

public static final EsqlCapabilities.Cap LOOKUP_JOIN_WITH_FULL_TEXT_FUNCTION

Lookup join with Full Text Function or other Lucene Pushable condition to be applied to the lookup index used

LOOKUP_JOIN_WITH_FULL_TEXT_FUNCTION_BUGFIX

public static final EsqlCapabilities.Cap LOOKUP_JOIN_WITH_FULL_TEXT_FUNCTION_BUGFIX

Bugfix for lookup join with Full Text Function

ENABLE_FORK_FOR_REMOTE_INDICES_V2

public static final EsqlCapabilities.Cap ENABLE_FORK_FOR_REMOTE_INDICES_V2

FORK with remote indices

STATS_WITH_FILTERED_SURROGATE_FIXED

public static final EsqlCapabilities.Cap STATS_WITH_FILTERED_SURROGATE_FIXED

Bugfix for STATS {{expression}} WHERE {{condition}} when the expression is replaced by something else on planning e.g. STATS SUM(1) WHERE x==3 is replaced by STATS MV_SUM(const)*COUNT(*) WHERE x == 3.

TO_DENSE_VECTOR_FUNCTION

public static final EsqlCapabilities.Cap TO_DENSE_VECTOR_FUNCTION

TO_DENSE_VECTOR function.

COALESCE_DENSE_VECTOR

public static final EsqlCapabilities.Cap COALESCE_DENSE_VECTOR

COALESCE function support for dense_vector type.

QUERY_PARAMS_MULTI_VALUES

public static final EsqlCapabilities.Cap QUERY_PARAMS_MULTI_VALUES

Multivalued query parameters

FIX_PERCENTILE_PRECISION

public static final EsqlCapabilities.Cap FIX_PERCENTILE_PRECISION

INLINE_STATS_SUPPORTS_REMOTE

public static final EsqlCapabilities.Cap INLINE_STATS_SUPPORTS_REMOTE

INLINE STATS supports remote indices

INLINE_STATS_WITH_UNION_TYPES_IN_STUB_RELATION

public static final EsqlCapabilities.Cap INLINE_STATS_WITH_UNION_TYPES_IN_STUB_RELATION

TS_COMMAND_V0

public static final EsqlCapabilities.Cap TS_COMMAND_V0

Support TS command in non-snapshot builds

TS_RENAME_TIMESTAMP_ERROR_MESSAGE

public static final EsqlCapabilities.Cap TS_RENAME_TIMESTAMP_ERROR_MESSAGE

Custom error for renamed timestamp

FIRST_LAST_OVER_TIME_COUNTER_SUPPORT

public static final EsqlCapabilities.Cap FIRST_LAST_OVER_TIME_COUNTER_SUPPORT

Add support for counter doubles, ints, and longs in first_ and last_over_time

FIX_ALIAS_ID_WHEN_DROP_ALL_AGGREGATES

public static final EsqlCapabilities.Cap FIX_ALIAS_ID_WHEN_DROP_ALL_AGGREGATES

PERCENTILE_OVER_TIME

public static final EsqlCapabilities.Cap PERCENTILE_OVER_TIME

Percentile over time and other ts-aggregations

VARIANCE_STDDEV_OVER_TIME

public static final EsqlCapabilities.Cap VARIANCE_STDDEV_OVER_TIME

TS_LINREG_DERIVATIVE

public static final EsqlCapabilities.Cap TS_LINREG_DERIVATIVE

TS_RATE_DATENANOS

public static final EsqlCapabilities.Cap TS_RATE_DATENANOS

TS_RATE_DATENANOS_2

public static final EsqlCapabilities.Cap TS_RATE_DATENANOS_2

TS_DERIV_DATENANOS

public static final EsqlCapabilities.Cap TS_DERIV_DATENANOS

RATE_WITH_INTERPOLATION

public static final EsqlCapabilities.Cap RATE_WITH_INTERPOLATION

Rate and increase calculations use interpolation at the boundaries between time buckets

RATE_WITH_INTERPOLATION_V2

public static final EsqlCapabilities.Cap RATE_WITH_INTERPOLATION_V2

RATE_WITH_INTERPOLATION_V3

public static final EsqlCapabilities.Cap RATE_WITH_INTERPOLATION_V3

V3 fixes a bug on how we handle single-value time buckets for INCREASE with the sole value falling onto the bucket boundary.

INLINE_STATS_FIX_PRUNING_NULL_FILTER

public static final EsqlCapabilities.Cap INLINE_STATS_FIX_PRUNING_NULL_FILTER

INLINE STATS fix incorrect prunning of null filtering https://github.com/elastic/elasticsearch/pull/135011

INLINE_STATS_FIX_OPTIMIZED_AS_LOCAL_RELATION

public static final EsqlCapabilities.Cap INLINE_STATS_FIX_OPTIMIZED_AS_LOCAL_RELATION

DENSE_VECTOR_AGG_METRIC_DOUBLE_IF_FNS

public static final EsqlCapabilities.Cap DENSE_VECTOR_AGG_METRIC_DOUBLE_IF_FNS

DENSE_VECTOR_AGG_METRIC_DOUBLE_IF_VERSION

public static final EsqlCapabilities.Cap DENSE_VECTOR_AGG_METRIC_DOUBLE_IF_VERSION

FUSE_L2_NORM

public static final EsqlCapabilities.Cap FUSE_L2_NORM

FUSE L2_NORM score normalization support

METADATA_TSID_FIELD

public static final EsqlCapabilities.Cap METADATA_TSID_FIELD

Support for requesting the "_tsid" metadata field.

TS_PERMIT_TEXT_BECOMING_KEYWORD_WHEN_GROUPED_ON

public static final EsqlCapabilities.Cap TS_PERMIT_TEXT_BECOMING_KEYWORD_WHEN_GROUPED_ON

Permit the data type of a field changing from TEXT to KEYWORD when being grouped on in aggregations on the TS command.

TS_ORIGINAL_TYPES_BUG_FIXED

public static final EsqlCapabilities.Cap TS_ORIGINAL_TYPES_BUG_FIXED

Fix for a bug where if you queried multiple TS indices with a field mapped to different types, the original types/suggested cast sections of the return result would be empty.

FIX_NO_COLUMNS

public static final EsqlCapabilities.Cap FIX_NO_COLUMNS

Fix management of plans with no columns https://github.com/elastic/elasticsearch/issues/120272

FIX_LIMIT_TRUNCATION_WITH_ZERO_COLUMNS

public static final EsqlCapabilities.Cap FIX_LIMIT_TRUNCATION_WITH_ZERO_COLUMNS

Fix LimitOperator truncation with zero columns https://github.com/elastic/elasticsearch/issues/142473

DOTS_IN_FUSE

public static final EsqlCapabilities.Cap DOTS_IN_FUSE

Support for dots in FUSE attributes

DATE_RANGE_FIELD_TYPE

public static final EsqlCapabilities.Cap DATE_RANGE_FIELD_TYPE

Support for the DATE_RANGE field type.

NETWORK_DIRECTION

public static final EsqlCapabilities.Cap NETWORK_DIRECTION

Network direction function.

TEMPORAL_AMOUNT_M

public static final EsqlCapabilities.Cap TEMPORAL_AMOUNT_M

Support for the literal m suffix as an alias for minute in temporal amounts.

PACK_DIMENSIONS_IN_TS

public static final EsqlCapabilities.Cap PACK_DIMENSIONS_IN_TS

Pack dimension values in TS command

EXPONENTIAL_HISTOGRAM_TECH_PREVIEW

public static final EsqlCapabilities.Cap EXPONENTIAL_HISTOGRAM_TECH_PREVIEW

Support for exponential_histogram fields in the state of when it first was released into tech preview.

TDIGEST_TECH_PREVIEW

public static final EsqlCapabilities.Cap TDIGEST_TECH_PREVIEW

Support for the T-Digest elasticsearch field mapper and ES|QL type when they were released into tech preview.

CASE_SUPPORT_FOR_SUMMARY_FIELDS

public static final EsqlCapabilities.Cap CASE_SUPPORT_FOR_SUMMARY_FIELDS

Adds the ability for the Case to return values of type TDIGEST, type HISTOGRAM, and type AGGREGATE_METRIC_DOUBLE.

HISTOGRAM_RELEASE_VERSION

public static final EsqlCapabilities.Cap HISTOGRAM_RELEASE_VERSION

Histogram field integration

COUNT_OF_HISTOGRAM_TYPES

public static final EsqlCapabilities.Cap COUNT_OF_HISTOGRAM_TYPES

Support for running the Count aggregation on t-digest and exponential histogram types

ALLOW_CASTING_IN_DEFAULT_TS_AGGS

public static final EsqlCapabilities.Cap ALLOW_CASTING_IN_DEFAULT_TS_AGGS

Fix for 140670, this allows for type conversion functions with no further computation to be evaluated inside default wrapping _over_time functions.

FIX_FILTER_ORDINALS

public static final EsqlCapabilities.Cap FIX_FILTER_ORDINALS

Create new block when filtering OrdinalBytesRefBlock

GLOBAL_TIMEZONE_PARAMETER_WITH_OUTPUT

public static final EsqlCapabilities.Cap GLOBAL_TIMEZONE_PARAMETER_WITH_OUTPUT

"time_zone" parameter in request body and in SET time_zone="x".

Originally `GLOBAL_TIMEZONE_PARAMETER`, but changed to "_WITH_OUTPUT" so tests don't fail after formatting the _query output.

DATE_PARSE_OPTIONS

public static final EsqlCapabilities.Cap DATE_PARSE_OPTIONS

Optional options argument for DATE_PARSE

GROK_MULTI_PATTERN

public static final EsqlCapabilities.Cap GROK_MULTI_PATTERN

Allow multiple patterns for GROK command

INLINE_STATS_PRUNE_COLUMN_FIX

public static final EsqlCapabilities.Cap INLINE_STATS_PRUNE_COLUMN_FIX

Fix pruning of columns when shadowed in INLINE STATS

INLINE_STATS_DOUBLE_RELEASE_FIX

public static final EsqlCapabilities.Cap INLINE_STATS_DOUBLE_RELEASE_FIX

Fix double release in inline stats when LocalRelation is reused

PUSHING_DOWN_EVAL_WITH_SCORE

public static final EsqlCapabilities.Cap PUSHING_DOWN_EVAL_WITH_SCORE

Support for pushing down EVAL with SCORE https://github.com/elastic/elasticsearch/issues/133462

FIX_STATS_CLASSCAST_EXCEPTION

public static final EsqlCapabilities.Cap FIX_STATS_CLASSCAST_EXCEPTION

Fix for ClassCastException in STATS https://github.com/elastic/elasticsearch/issues/133992 https://github.com/elastic/elasticsearch/issues/136598

ATTRIBUTE_EQUALS_RESPECTS_NAME_ID

public static final EsqlCapabilities.Cap ATTRIBUTE_EQUALS_RESPECTS_NAME_ID

Fix attribute equality to respect the name id of the attribute.

LOOKUP_JOIN_SEMANTIC_FILTER_DEDUP

public static final EsqlCapabilities.Cap LOOKUP_JOIN_SEMANTIC_FILTER_DEDUP

Fix for lookup join filter pushdown not using semantic equality. This prevents duplicate filters from being pushed down when they are semantically equivalent, causing an infinite loop where BooleanSimplification will simplify the original and duplicate filters, so they'll be pushed down again...

LOOKUP_JOIN_SORT_WARNING

public static final EsqlCapabilities.Cap LOOKUP_JOIN_SORT_WARNING

Warning when SORT is followed by LOOKUP JOIN which does not preserve order.

FORBID_LIMIT_BEFORE_INLINE_STATS

public static final EsqlCapabilities.Cap FORBID_LIMIT_BEFORE_INLINE_STATS

Temporarily forbid the use of an explicit or implicit LIMIT before INLINE STATS.

HANDLE_DETERMINIZATION_COMPLEXITY

public static final EsqlCapabilities.Cap HANDLE_DETERMINIZATION_COMPLEXITY

Catch-and-rethrow determinization complexity errors as 400s rather than 500s

INLINE_STATS_WITH_NO_COLUMNS

public static final EsqlCapabilities.Cap INLINE_STATS_WITH_NO_COLUMNS

https://github.com/elastic/elasticsearch/issues/136851

FIX_MV_CONSTANT_EQUALS_FIELD

public static final EsqlCapabilities.Cap FIX_MV_CONSTANT_EQUALS_FIELD

BASE_CONVERSION

public static final EsqlCapabilities.Cap BASE_CONVERSION

Support for base conversion in TO_LONG and TO_INTEGER

FIX_REPLACE_ALIASING_EVAL_WITH_PROJECT_SHADOWING

public static final EsqlCapabilities.Cap FIX_REPLACE_ALIASING_EVAL_WITH_PROJECT_SHADOWING

ReplaceAliasingEvalWithProject did not fully account for shadowing. https://github.com/elastic/elasticsearch/issues/137019.

CHUNK_FUNCTION_V2

public static final EsqlCapabilities.Cap CHUNK_FUNCTION_V2

Chunk function.

VECTOR_SIMILARITY_FUNCTIONS_PUSHDOWN

public static final EsqlCapabilities.Cap VECTOR_SIMILARITY_FUNCTIONS_PUSHDOWN

Support for vector similarity functions pushdown

FIX_MV_CONSTANT_COMPARISON_FIELD

public static final EsqlCapabilities.Cap FIX_MV_CONSTANT_COMPARISON_FIELD

FULL_TEXT_FUNCTIONS_ACCEPT_NULL_FIELD

public static final EsqlCapabilities.Cap FULL_TEXT_FUNCTIONS_ACCEPT_NULL_FIELD

FIRST_AGG_WITH_NULL_AND_MV_SUPPORT

public static final EsqlCapabilities.Cap FIRST_AGG_WITH_NULL_AND_MV_SUPPORT

Make FIRST agg work with null and multi-value fields.

LAST_AGG_WITH_NULL_AND_MV_SUPPORT

public static final EsqlCapabilities.Cap LAST_AGG_WITH_NULL_AND_MV_SUPPORT

Make LAST agg work with null and multi-value fields.

FIRST_LAST_AGG_WITH_DATES

public static final EsqlCapabilities.Cap FIRST_LAST_AGG_WITH_DATES

Allow FIRST/LAST aggs to accept DATE/DATE_NANOS in the search field https://github.com/elastic/elasticsearch/issues/142137

ST_EXTENT_AGG_NULL_SUPPORT

public static final EsqlCapabilities.Cap ST_EXTENT_AGG_NULL_SUPPORT

Allow ST_EXTENT_AGG to gracefully handle missing spatial shapes

TIME_SERIES_WINDOW_V1

public static final EsqlCapabilities.Cap TIME_SERIES_WINDOW_V1

Support grouping window in time-series for example: rate(counter, "1m") or avg_over_time(field, "5m")

TIME_SERIES_WINDOW_SMALLER_THAN_BUCKET

public static final EsqlCapabilities.Cap TIME_SERIES_WINDOW_SMALLER_THAN_BUCKET

Supporting grouping window in time-series where the window is smaller than the time bucket

LIKE_PARAMETER_SUPPORT

public static final EsqlCapabilities.Cap LIKE_PARAMETER_SUPPORT

Support like/rlike parameters https://github.com/elastic/elasticsearch/issues/131356

PROMQL_COMMAND_V0

public static final EsqlCapabilities.Cap PROMQL_COMMAND_V0

PromQL support in ESQL, in the state it was when first available in non-snapshot builds.

PROMQL_MATH_V0

public static final EsqlCapabilities.Cap PROMQL_MATH_V0

Bundle flag for PromQL math functions.

ACOSH_FUNCTION

public static final EsqlCapabilities.Cap ACOSH_FUNCTION

Support for the ACOSH function.

ASINH_FUNCTION

public static final EsqlCapabilities.Cap ASINH_FUNCTION

Support for the ASINH function.

ATANH_FUNCTION

public static final EsqlCapabilities.Cap ATANH_FUNCTION

Support for the ATANH function.

PROMQL_BINARY_COMPARISON_V0

public static final EsqlCapabilities.Cap PROMQL_BINARY_COMPARISON_V0

Initial support for simple binary comparisons in PromQL. Only top-level comparisons are supported where the right-hand side is a scalar.

PROMQL_TIME

public static final EsqlCapabilities.Cap PROMQL_TIME

Support for PromQL time() function.

PROMQL_BUCKETS_PARAMETER

public static final EsqlCapabilities.Cap PROMQL_BUCKETS_PARAMETER

Support for deriving PromQL time buckets from [start, end, buckets] when [step] is omitted.

PROMQL_UNMAPPED_FIELDS_FILTER_NULLS

public static final EsqlCapabilities.Cap PROMQL_UNMAPPED_FIELDS_FILTER_NULLS

Queries for unmapped fields return no data instead of an error. Also filters out nulls from results.

PROMQL_NESTED_AGGREGATES

public static final EsqlCapabilities.Cap PROMQL_NESTED_AGGREGATES

Support for nested across-series aggregates in PromQL. E.g., avg(sum by (cluster) (rate(foo[5m])))

PROMQL_POST_PROCESSING_STATS

public static final EsqlCapabilities.Cap PROMQL_POST_PROCESSING_STATS

Support post-processing STATS commands after PROMQL source commands.

PROMQL_SCALAR

public static final EsqlCapabilities.Cap PROMQL_SCALAR

PromQL scalar() function support.

PROMQL_IMPLICIT_RANGE_SELECTOR

public static final EsqlCapabilities.Cap PROMQL_IMPLICIT_RANGE_SELECTOR

Support implicit conversion from an instant selector to a range selector for range-vector functions. For example, `rate(metric)` is interpreted as `rate(metric[step])`.

PROMQL_WITHOUT_GROUPING

public static final EsqlCapabilities.Cap PROMQL_WITHOUT_GROUPING

Support for PromQL without grouping.

ESQL_WITHOUT_GROUPING

public static final EsqlCapabilities.Cap ESQL_WITHOUT_GROUPING

Support for`WITHOUT` grouping function that excludes specific dimensions from time-series grouping.

KNN_FUNCTION_OPTIONS_K_VISIT_PERCENTAGE

public static final EsqlCapabilities.Cap KNN_FUNCTION_OPTIONS_K_VISIT_PERCENTAGE

KNN function adds support for k and visit_percentage options

METRICS_GROUP_BY_ALL_WITH_TS_DIMENSIONS

public static final EsqlCapabilities.Cap METRICS_GROUP_BY_ALL_WITH_TS_DIMENSIONS

Enables automatically grouping by all dimension fields in TS mode queries and outputs the _timeseries column with all the dimensions.

FIX_ENRICH_ALIAS_CYCLE_IN_DEDUPLICATE_AGGS

public static final EsqlCapabilities.Cap FIX_ENRICH_ALIAS_CYCLE_IN_DEDUPLICATE_AGGS

Fix for circular reference in alias chains during PushDownEnrich and aggregate deduplication. Prevents "Potential cycle detected" errors when aliases reference each other. https://github.com/elastic/elasticsearch/issues/138346

TOP_SNIPPETS_FUNCTION

public static final EsqlCapabilities.Cap TOP_SNIPPETS_FUNCTION

Returns the top snippets for given text content and associated query.

TOP_SNIPPETS_FUNCTION_STRING_CONFIG

public static final EsqlCapabilities.Cap TOP_SNIPPETS_FUNCTION_STRING_CONFIG

A fix allowing the TOP_SNIPPETS function to process string config parameters like the other functions.

TOP_SNIPPETS_MV

public static final EsqlCapabilities.Cap TOP_SNIPPETS_MV

Does TOP_SNIPPETS process all field values?

FIX_STATS_MV_CONSTANT_FOLD

public static final EsqlCapabilities.Cap FIX_STATS_MV_CONSTANT_FOLD

Fix for multi-value constant propagation after GROUP BY. When a multi-value constant (e.g., [1, 2]) is used as GROUP BY key, the aggregation explodes it into single values. Propagating the original multi-value literal after the Aggregate would incorrectly treat the field as still being multi-valued. https://github.com/elastic/elasticsearch/issues/135926

FIX_INLINE_STATS_INCORRECT_PRUNNING

public static final EsqlCapabilities.Cap FIX_INLINE_STATS_INCORRECT_PRUNNING

https://github.com/elastic/elasticsearch/issues/138283

FIX_PRESENT_AND_ABSENT_ON_STATS_WITH_FALSE_FILTER

public static final EsqlCapabilities.Cap FIX_PRESENT_AND_ABSENT_ON_STATS_WITH_FALSE_FILTER

ReplaceStatsFilteredOrNullAggWithEval replaced a stats with false filter with null with Present or Absent

ENABLE_REDUCE_NODE_LATE_MATERIALIZATION

public static final EsqlCapabilities.Cap ENABLE_REDUCE_NODE_LATE_MATERIALIZATION

Enables late materialization on node reduce. See also QueryPragmas.NODE_LEVEL_REDUCTION

FIX_AGG_ON_NULL_BY_REPLACING_WITH_EVAL

public static final EsqlCapabilities.Cap FIX_AGG_ON_NULL_BY_REPLACING_WITH_EVAL

ReplaceStatsFilteredOrNullAggWithEval now replaces an AggregateFunction with null value with an Eval. https://github.com/elastic/elasticsearch/issues/137544

FIX_SUM_AGG_LONG_OVERFLOW

public static final EsqlCapabilities.Cap FIX_SUM_AGG_LONG_OVERFLOW

Makes SUM(long) agg return null+warning instead of a 500 overflow.

METADATA_TIER_FIELD

public static final EsqlCapabilities.Cap METADATA_TIER_FIELD

Support for requesting the "_tier" metadata field.

FIX_FOLD_COALESCE

public static final EsqlCapabilities.Cap FIX_FOLD_COALESCE

Fix folding of coalesce function https://github.com/elastic/elasticsearch/issues/139344

DATE_TIME_EXCEPTIONS_HANDLED

public static final EsqlCapabilities.Cap DATE_TIME_EXCEPTIONS_HANDLED

Exceptions parsing date-times are thrown as IllegalArgumentException

ENRICH_DENSE_VECTOR_BUGFIX

public static final EsqlCapabilities.Cap ENRICH_DENSE_VECTOR_BUGFIX

Enrich works with dense_vector fields

DENSE_VECTOR_ARITHMETIC

public static final EsqlCapabilities.Cap DENSE_VECTOR_ARITHMETIC

Support for dense_vector arithmetic operations (+, -, *, /)

DENSE_VECTOR_SCALAR_ARITHMETIC

public static final EsqlCapabilities.Cap DENSE_VECTOR_SCALAR_ARITHMETIC

Support for arithmetic operations (+, -, *, /) between dense_vector and scalar values

DENSE_VECTOR_AGG_FUNCTIONS

public static final EsqlCapabilities.Cap DENSE_VECTOR_AGG_FUNCTIONS

Dense_vector aggregation functions

ROUTING_FUNCTION_UPDATE

public static final EsqlCapabilities.Cap ROUTING_FUNCTION_UPDATE

Marks the move to the hash(doc) % shard_count routing function. Added in #137062.

TS_STATS_BINARY_OPS

public static final EsqlCapabilities.Cap TS_STATS_BINARY_OPS

Adds support for binary operations (such as addition, subtraction, etc.) to the TS|STATS command.

FIX_INLINE_STATS_GROUP_BY_NULL

public static final EsqlCapabilities.Cap FIX_INLINE_STATS_GROUP_BY_NULL

Fix for INLINE STATS GROUP BY null being incorrectly pruned by PruneLeftJoinOnNullMatchingField. For INLINE STATS, the right side of the join can be Aggregate or LocalRelation (when optimized). The join key is always the grouping, and since STATS supports GROUP BY null, pruning the join when the join key (grouping) is null would incorrectly change the query results. This fix ensures PruneLeftJoinOnNullMatchingField only applies to LOOKUP JOIN (where right side is EsRelation). https://github.com/elastic/elasticsearch/issues/139887

FIX_NULL_COMPARISON_TYPE_CHECK

public static final EsqlCapabilities.Cap FIX_NULL_COMPARISON_TYPE_CHECK

Fix null comparison type check in binary comparisons. Null should be compatible with any type in binary comparisons. https://github.com/elastic/elasticsearch/issues/140460

CONDITIONAL_BLOCK_LOADER_FOR_TEXT_FIELDS

public static final EsqlCapabilities.Cap CONDITIONAL_BLOCK_LOADER_FOR_TEXT_FIELDS

Adds a conditional block loader for text fields that prefers using the sub-keyword field whenever possible.

METADATA_WILDCARDS

public static final EsqlCapabilities.Cap METADATA_WILDCARDS

Allow wildcards in FROM METADATA, eg FROM idx METADATA _ind*

RATE_FIX_RESETS_MULTIPLE_SEGMENTS

public static final EsqlCapabilities.Cap RATE_FIX_RESETS_MULTIPLE_SEGMENTS

Fixes reset calculation in rates where partitioning data into multiple slices can lead to incorrect results.

APPROXIMATION_V6

public static final EsqlCapabilities.Cap APPROXIMATION_V6

Support query approximation.

FIX_SCORE_OPERATOR_PLANNING

public static final EsqlCapabilities.Cap FIX_SCORE_OPERATOR_PLANNING

Create a ScoreOperator only when shard contexts are available

PERIODIC_EMIT_PARTIAL_AGGREGATION_RESULTS

public static final EsqlCapabilities.Cap PERIODIC_EMIT_PARTIAL_AGGREGATION_RESULTS

Periodically emit partial aggregation results when the number of groups exceeds the threshold.

METADATA_SIZE_FIELD

public static final EsqlCapabilities.Cap METADATA_SIZE_FIELD

Support for requesting the "_size" metadata field when the mapper-size plugin is enabled.

FIX_TO_IP_LEADING_ZEROS_OCTAL

public static final EsqlCapabilities.Cap FIX_TO_IP_LEADING_ZEROS_OCTAL

Fix for 141627, TO_IP with leading_zeros=octal generates proper warning and returns null when given invalid input.

TDIGEST_TIME_SERIES_METRIC

public static final EsqlCapabilities.Cap TDIGEST_TIME_SERIES_METRIC

Support for configuring T-Digest elasticsearch field as a time series metric.

TO_EXPONENTIAL_HISTOGRAM

public static final EsqlCapabilities.Cap TO_EXPONENTIAL_HISTOGRAM

Support for the TO_EXPONENTIAL_HISTOGRAM conversion function.

TO_TDIGEST_FROM_EXPONENTIAL_HISTOGRAM

public static final EsqlCapabilities.Cap TO_TDIGEST_FROM_EXPONENTIAL_HISTOGRAM

Support for converting exponential_histogram fields via TO_TDIGEST.

TDIGEST_MEDIAN

public static final EsqlCapabilities.Cap TDIGEST_MEDIAN

Support for MEDIAN aggregation on tdigest type fields.

TDIGEST_FIRST_LAST_OVER_TIME

public static final EsqlCapabilities.Cap TDIGEST_FIRST_LAST_OVER_TIME

Support for FIRST_OVER_TIME and LAST_OVER_TIME on tdigest type fields.

TDIGEST_PERCENTILES_USE_MERGING_DIGEST

public static final EsqlCapabilities.Cap TDIGEST_PERCENTILES_USE_MERGING_DIGEST

A bugfix we applied to the HISTOGRAM_PERCENTILE algorithm on the tdigest type. We previously were using hybrid-digests by accident and now use a merging digest.

TS_COMMAND_GROUP_ON_ALIASES

public static final EsqlCapabilities.Cap TS_COMMAND_GROUP_ON_ALIASES

Fix bug with TS command where you can't group on aliases (i.e. `by c = cluster`)

TS_IMPLICIT_TIMESTAMP_SORT

public static final EsqlCapabilities.Cap TS_IMPLICIT_TIMESTAMP_SORT

Implicit SORT @timestamp DESC for TS queries without STATS or explicit SORT.

INLINE_STATS_DROP_GROUPINGS_FIX

public static final EsqlCapabilities.Cap INLINE_STATS_DROP_GROUPINGS_FIX

Fixes https://github.com/elastic/elasticsearch/issues/139359

MMR_V2

public static final EsqlCapabilities.Cap MMR_V2

Support for the MMR result diversification command

URI_PARTS_COMMAND

public static final EsqlCapabilities.Cap URI_PARTS_COMMAND

Supports the URI_PARTS) command.

METRICS_INFO_COMMAND

public static final EsqlCapabilities.Cap METRICS_INFO_COMMAND

Support for the METRICS_INFO command.

TBUCKET_FROM_TO

public static final EsqlCapabilities.Cap TBUCKET_FROM_TO

Support for TBUCKET with numeric bucket count and optional from/to parameters.

REGISTERED_DOMAIN_COMMAND

public static final EsqlCapabilities.Cap REGISTERED_DOMAIN_COMMAND

Supports the REGISTERED_DOMAIN command.

STR_COMMANDS_ACCEPT_NULL

public static final EsqlCapabilities.Cap STR_COMMANDS_ACCEPT_NULL

The GROK, DISSECT, URI_PARTS, and REGISTERED_DOMAIN commands accept null typed parameters and produce null results.

EXTERNAL_COMMAND

public static final EsqlCapabilities.Cap EXTERNAL_COMMAND

Support for the EXTERNAL command (datasource access).

EXTERNAL_CSV_IP_SUPPORT

public static final EsqlCapabilities.Cap EXTERNAL_CSV_IP_SUPPORT

Support for the EXTERNAL command (datasource access).

INLINE_STATS_WITH_CONSTANTS

public static final EsqlCapabilities.Cap INLINE_STATS_WITH_CONSTANTS

https://github.com/elastic/elasticsearch/issues/142219

FIX_AGGREGATION_FRAMEWORK_CHANNELS

public static final EsqlCapabilities.Cap FIX_AGGREGATION_FRAMEWORK_CHANNELS

Fix for an ArrayIndexOutOfBoundsException in the aggregation framework when the same field is passed twice. https://github.com/elastic/elasticsearch/issues/142180

TS_INFO_COMMAND

public static final EsqlCapabilities.Cap TS_INFO_COMMAND

Support for the TS_INFO command — per-time-series granularity variant of METRICS_INFO.

DENSE_VECTOR_SUM_FUNCTION

public static final EsqlCapabilities.Cap DENSE_VECTOR_SUM_FUNCTION

Dense_vector SUM aggregation function

FIX_AGG_FIRST_LAST_FOLDABLES_IN_SORT_FIELD

public static final EsqlCapabilities.Cap FIX_AGG_FIRST_LAST_FOLDABLES_IN_SORT_FIELD

Support passing constants and null in the second parameter of FIRST/LAST aggs.

ROW_FIELD_RESOLUTION

public static final EsqlCapabilities.Cap ROW_FIELD_RESOLUTION

Support for intra-row field references in ROW command. https://github.com/elastic/elasticsearch/issues/140217

FIRST_LAST_AGG_ON_INTS

public static final EsqlCapabilities.Cap FIRST_LAST_AGG_ON_INTS

Support aggregating on integers in FIRST/LAST.

FIX_UNMAPPED_FIELDS_IN_ESRELATION

public static final EsqlCapabilities.Cap FIX_UNMAPPED_FIELDS_IN_ESRELATION

Fix for KQL/QSTR functions failing when used with unmapped fields in NULLIFY mode. Unmapped fields are now added directly to EsRelation output with NULL type instead of using Eval nodes. https://github.com/elastic/elasticsearch/issues/142968

DENSE_VECTOR_EQUALITY

public static final EsqlCapabilities.Cap DENSE_VECTOR_EQUALITY

Support for dense_vector equality and inequality operators (==, !=).

FIX_DISPLAYING_TS_DIMENSIONS_IN_METRICS_GROUP_BY_ALL

public static final EsqlCapabilities.Cap FIX_DISPLAYING_TS_DIMENSIONS_IN_METRICS_GROUP_BY_ALL

Fix for not including metadata _doc_count in the _timeseries column https://github.com/elastic/elasticsearch/issues/143464

MATCH_FUNCTION_ZERO_TERMS_QUERY

public static final EsqlCapabilities.Cap MATCH_FUNCTION_ZERO_TERMS_QUERY

Support for the zero_terms_query option in the match function. https://github.com/elastic/elasticsearch/issues/143070

FIX_FULL_TEXT_FUNCTIONS_ON_RENAMED_FIELDS

public static final EsqlCapabilities.Cap FIX_FULL_TEXT_FUNCTIONS_ON_RENAMED_FIELDS

Fix for full-text functions failing on renamed fields. https://github.com/elastic/elasticsearch/issues/143859

TOP_SNIPPETS_FOLDABLE_QUERY_CHECK

public static final EsqlCapabilities.Cap TOP_SNIPPETS_FOLDABLE_QUERY_CHECK

TOP_SNIPPETS checks that the query is foldable

FIX_FORK_UNMAPPED_NULLIFY

public static final EsqlCapabilities.Cap FIX_FORK_UNMAPPED_NULLIFY

Fixes an analysis bug in FORK with unmapped_fields="nullify". Preserve existing attribute NameIds so that references from upper plan nodes remain valid after sub-plans are updated. Only genuinely new attributes get fresh NameIds. Keeping the same attributes can have unintended side effects when applying optimizations like constant folding. https://github.com/elastic/elasticsearch/issues/142762

FIX_LIMIT_ZERO_IN_STATS_BY_ALL

public static final EsqlCapabilities.Cap FIX_LIMIT_ZERO_IN_STATS_BY_ALL

Fix for the STATS BY ALL with LIMIT 0. https://github.com/elastic/elasticsearch/issues/144024

FIX_PASSTHROUGH_FIELD_CAPS_OBJECT_PARENT

public static final EsqlCapabilities.Cap FIX_PASSTHROUGH_FIELD_CAPS_OBJECT_PARENT

Fix field caps incorrectly synthesizing object parents under subobjects:false (passthrough) mappers, causing false type conflicts in ES|QL when querying across indices. https://github.com/elastic/elasticsearch/issues/144179

ESQL_LIMIT_BY

public static final EsqlCapabilities.Cap ESQL_LIMIT_BY

Enables the feature LIMIT n BY expr1, expr2 for retaining at most n docs per group. The feature will not work if we had SORT | LIMIT n BY

ESQL_TOPN_BY

public static final EsqlCapabilities.Cap ESQL_TOPN_BY

Enables the SORT | LIMIT n BY expr1, expr2 support, see ESQL_LIMIT_BY for more context

LIMIT_BY_ENRICH_FIX

public static final EsqlCapabilities.Cap LIMIT_BY_ENRICH_FIX

Corrects a bug with ENRICH when a shard does not contain an index field and we use LIMIT BY on top

FIX_TBUCKET_TARGET_COUNT_WINDOW_VALIDATION

public static final EsqlCapabilities.Cap FIX_TBUCKET_TARGET_COUNT_WINDOW_VALIDATION

Fix window validation in time-series aggregations when TBUCKET uses a numeric target bucket count.

CHANGE_POINT_SUPPORT_NULL_COLUMN

public static final EsqlCapabilities.Cap CHANGE_POINT_SUPPORT_NULL_COLUMN

Support the null column type for the CHANGE_POINT command

MMR_FOLDABLE_QUERY_VECTOR_FIX

public static final EsqlCapabilities.Cap MMR_FOLDABLE_QUERY_VECTOR_FIX

MMR fixes for constant folding

CHANGE_POINT_ARGS_ANY_ORDER

public static final EsqlCapabilities.Cap CHANGE_POINT_ARGS_ANY_ORDER

Support CHANGE_POINT arguments in any order

FIX_DIV_ERROR_MESSAGE

public static final EsqlCapabilities.Cap FIX_DIV_ERROR_MESSAGE

AUTO_PARTITION_DOCS_THRESHOLD

public static final EsqlCapabilities.Cap AUTO_PARTITION_DOCS_THRESHOLD

Added PlannerSettings.DOC_THRESHOLD_AUTO_PARTITIONING

UNMAPPED_FIELDS_DEFAULT_SETTING_RENAME

public static final EsqlCapabilities.Cap UNMAPPED_FIELDS_DEFAULT_SETTING_RENAME

Rename the unmapped_fields default setting from "fail" to "default". See https://github.com/elastic/elasticsearch/issues/144833

TIME_SERIES_WINDOW_NON_MULTIPLE

public static final EsqlCapabilities.Cap TIME_SERIES_WINDOW_NON_MULTIPLE

Support window durations that are larger than but not exact multiples of the time bucket for time-series aggregations (e.g., rate(counter, 7 minutes) with TBUCKET(5 minutes)).

FIX_SUM_OF_NULL_OPTIMIZATION

public static final EsqlCapabilities.Cap FIX_SUM_OF_NULL_OPTIMIZATION

Fix for SUM(null) producing a type mismatch after surrogate expansion. See https://github.com/elastic/elasticsearch/issues/144914

PROPAGATE_EMPTY_RELATION_PAST_JOINS

public static final EsqlCapabilities.Cap PROPAGATE_EMPTY_RELATION_PAST_JOINS

USER_AGENT_COMMAND

public static final EsqlCapabilities.Cap USER_AGENT_COMMAND

Supports the USER_AGENT command.

FIX_SAMPLE_AFTER_KQL_OR_QSTR

public static final EsqlCapabilities.Cap FIX_SAMPLE_AFTER_KQL_OR_QSTR

Fix full-text functions being rejected after SAMPLE.

KEYWORDS_MV_COUNT_AS_SINGLE_VALUE_FIX

public static final EsqlCapabilities.Cap KEYWORDS_MV_COUNT_AS_SINGLE_VALUE_FIX

PARQUET_ORC_STARTS_WITH_PUSHDOWN

public static final EsqlCapabilities.Cap PARQUET_ORC_STARTS_WITH_PUSHDOWN

Parquet and ORC filter pushdown for StartsWith (prefix range predicates).

EARLIEST_LATEST_AGGS

public static final EsqlCapabilities.Cap EARLIEST_LATEST_AGGS

Alias for calling FIRST (or LAST) and only passing the search field. The sort field is implicitly set to @timestamp. These are not time series agg functions.

FIX_FULL_TEXT_FUNCTIONS_ON_CONSTANT_KEYWORD

public static final EsqlCapabilities.Cap FIX_FULL_TEXT_FUNCTIONS_ON_CONSTANT_KEYWORD

Fix for full-text functions (MATCH, MATCH_PHRASE, :) on constant_keyword fields. The optimizer no longer replaces their field arguments with literal constants. See https://github.com/elastic/elasticsearch/issues/145570

Method Details

values

public static EsqlCapabilities.Cap[] values()

Returns an array containing the constants of this enum class, in the order they are declared.

Returns:

an array containing the constants of this enum class, in the order they are declared

valueOf

public static EsqlCapabilities.Cap valueOf(String name)

Returns the enum constant of this class with the specified name. The string must match exactly an identifier used to declare an enum constant in this class. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum class has no constant with the specified name

NullPointerException - if the argument is null

isEnabled

public boolean isEnabled()

capabilityName

public String capabilityName()