Enum Class EsqlCapabilities.Cap
- All Implemented Interfaces:
Serializable,Comparable<EsqlCapabilities.Cap>,Constable
- Enclosing class:
EsqlCapabilities
-
Nested Class Summary
Nested classes/interfaces inherited from class java.lang.Enum
Enum.EnumDesc<E extends Enum<E>> -
Enum Constant Summary
Enum ConstantsEnum ConstantDescriptionFix pushdown of LIMIT past MV_EXPANDSupport for booleans in aggregationsMAXandMIN.Support for ips in aggregationsMAXandMIN.Support for strings in aggregationsMAXandMIN.Support for the SAMPLE aggregation functionSupport for aggregation functionTOP.Support for booleans inTOPaggregation.Support for ips inTOPaggregation.Support forkeywordandtextfields inTOPaggregation.The introduction of theVALUESagg.Expand theVALUESagg to cover spatial types.Support for WEIGHTED_AVG function.Support for aggregate_metric_double typeSupport avg with aggregate metric doublesSupport for to_aggregate_metric_double functionStop erroring out when trying to apply MV_EXPAND on aggregate metric double.Support for partial subset of metrics in aggregate_metric_double typeSupport for rendering aggregate_metric_double typeSupport for sorting when aggregate_metric_doubles are presentFixes bug when aggregate metric double is encoded as a single nul value but decoded as AggregateMetricDoubleBlock (expecting 4 values) in TopN.Does ESQL support async queries.Support sending HTTP headers about the status of an async query.Support avg_over_time aggregation that gets evaluated per time-seriesBase64 encoding and decoding functions.Consider the upper bound when computing the interval in BUCKET auto mode.Support for the whole number spans in BUCKET function.CASEproperly handling multivalue conditions.Support explicit casting from string literal to DATE_PERIOD or TIME_DURATION.Support for the :: casting operatorSupport for the ::date casting operatorSupport for multiple groupings in "CATEGORIZE".Supported the text categorization function "CATEGORIZE".Support change point detection "CHANGE_POINT".Add CombineBinaryComparisons rule.Support CIDRMatch in CombineDisjunctions rule.Support for COMPLETION commandSupport for theCOPY_SIGNfunction.Support correct counting of skipped shards.Support for count_distinct_over_time aggregation that gets evaluated per time-seriesSupport count_over_time aggregation that gets evaluated per time-seriesSupport metrics counter typesCompute year differences in full calendar years.Support add and subtract on date nanossupport aggregations on date nanosSupport for date nanos type in binary comparisonsSupport date nanos values as the field argument to bucketSupport for mixed comparisons between nanosecond and millisecond datessupport date diff function on date nanos type, and mixed nanos/millissupport date extract function for date nanosSupport running date format function on nanosecond datesSupport implicit casting of strings to date nanosSupport theInoperator for date nanosSupport for date nanos in lookup join.Support for nanosecond dates as a data typeDATE_PARSE supports reading timezonesSupport for date_trunc function on date nanos typeEnhanced DATE_TRUNC with arbitrary month and year intervals.Dense vector field type supportWhen we disabled some broken optimizations aroundnullable.Are thedocuments_foundandvalues_loadedfields available in the response and profile?Use double parameter markers to represent field or function names.Support for quoting index sources in double quotes.Support for keeping `DROP` attributes when resolving field names.Correctly ask for all fields from lookup indices even when there is e.g.Enable support for index aliases in lookup joinsSupport for loading values over enrich.Enforce strict type checking on ENRICH range types, and warnings for KEYWORD parsing at runtime.(Re)Added EXPLAIN commandSupport for filter in converted null.Support first_over_time aggregation that gets evaluated per time-seriesFix the status code returned when trying to run count_distinct on the _source type (which is not supported).When pushing downSTATS count(field::type)for a union type field, we wrongly used a synthetic attribute name in the query instead of the actual field name.Indicates that https://github.com/elastic/elasticsearch/issues/125439 (incorrect lucene push down for date nanos) is fixedFixes a bug where dates are incorrectly formatted if a where clause compares nanoseconds to both milliseconds and nanoseconds, e.g.When creating constant null blocks inValuesSourceReaderOperator, 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 for an optimization that caused wrong results https://github.com/elastic/elasticsearch/issues/115281During resolution (pre-analysis) we have to consider that joins or enriches can override EVALuated values https://github.com/elastic/elasticsearch/issues/126419During resolution (pre-analysis) we have to consider that joins can override regex extracted values see ES|QL: pruning of JOINs leads to missing fields #127467Support for the mv_expand target attribute should be retained in its original position.Fix for https://github.com/elastic/elasticsearch/issues/117054Fix a parsing issue where numbers below Long.MIN_VALUE threw an exception instead of parsing as doubles.Fix precision of scaled_float field values retrieved from stored source see Slight inconsistency in ESQL using scaled_float field #122547SupercedesMAKE_NUMBER_OF_CHANNELS_CONSISTENT_WITH_LAYOUT.Fix for https://github.com/elastic/elasticsearch/issues/114714Fix for https://github.com/elastic/elasticsearch/issues/114714, againMake attributes of GROK/DISSECT adjustable and fix a shadowing bug when pushing them down past PROJECT.Fix for regex folding with case-insensitive pattern https://github.com/elastic/elasticsearch/issues/118371Don't optimize CASE IS NOT NULL function by not requiring the fields to be not null as well.Support for functionBIT_LENGTH.Support for functionBYTE_LENGTH.Support for functionCBRT.Support for functionHYPOT.Support for functionIP_PREFIX.Support forMV_APPENDfunction.Support forMV_MEDIAN_ABSOLUTE_DEVIATIONfunction.Support forMV_PERCENTILEfunction.Support for functionREVERSE.Support for reversing whole grapheme clusters.Fixes on functionROUNDthat avoid it throwing exceptions on runtime for unsigned long cases.Support for functionSCALB.Fix on functionSUBSTRINGthat makes it not return null on empty strings.Support for FORK out of snapshotDeprecated.Full text functions can be used in disjunctionsFull text functions can be used in disjunctions as they are implemented in compute engineFull text functions can be scored when being part of a disjunctionFull text functions in STATSAdding stats for functions (stack telemetry)All functions that take TEXT should never emit TEXT, only KEYWORD.Fixes for multiple functions not serializing their source, and emitting warnings with wrong line number and text.Do validation check on geo_point and geo_shape fields.Fix to GROK and DISSECT that allows extracting attributes with the same name as the input https://github.com/elastic/elasticsearch/issues/110184Fix to GROK validation in case of multiple fields with same name and different types https://github.com/elastic/elasticsearch/issues/110533Hash functionHash function aliases such as MD5Support implicit casting for union typed fields that are mixed with date and date_nanos type.Support implicit casting from string literal to DATE_PERIOD or TIME_DURATION.Index component selector syntax (my-data-stream-name::failures)Support specifically for *just* the _index METADATA field.Support for theINLINESTATSsyntax.Support for the expressions in grouping inINLINESTATSsyntax.Fixes a series of issues with inlinestats which had an incomplete implementation after lookup and inlinestats were refactored.Fix pushing down LIMIT past LOOKUP JOIN in case of multiple matching join keys.LOOKUP JOIN skipping MVs and sending warnings (https://github.com/elastic/elasticsearch/issues/118780)LOOKUP JOINWIP on Join planning - Introduce BinaryPlan and co - Refactor INLINESTATS and LOOKUP as a JOIN blockAvid GROK and DISSECT attributes being removed when resolving fields.Support knn functionKQL functionSupport last_over_time aggregation that gets evaluated per time-seriesSupport Least and Greatest functions on Date Nanos typeSupport for datetime in least and greatest functionsSupport improved behavior for LIKE operator when used with index fields.Support loading of ip fields if they are not indexed.Disabled support for index aliases in lookup joinsAllow lookup join on mixed numeric fields, among byte, short, int, long, half_float, scaled_float, float and double.LOOKUP JOIN with TEXT fields on the right (right side of the join) (#119473)LOOKUP command with - tables using syntax"tables": {"type": [<values>]}- fixed variable shadowing - fixed Join.references(), requiring breaking change to Join serializationLuceneQueryEvaluatorrewrites the query before executing it in Lucene.Make numberOfChannels consistent with layout in DefaultLayout by removing duplicated ChannelSet.Additional types for match function and operatorMATCH functionSupport match options in match functionSupport for match operator as a colon.MATCH PHRASE functionSupport max_over_time aggregation that gets evaluated per time-seriesSupport for metadata fields.Capability for remote metadata testSupport for requesting the "_ignored" metadata field.Support the "METADATA _score" directive to enable _score column.The metrics commandSupport for metrics counter fieldsSupport min_over_time aggregation that gets evaluated per time-seriesAllow mixed numeric types in conditional functions - case, greatest and leastAllow mixed numeric types in coalesceSupport for multi-match function.Blocks can be labelled withBlock.MvOrdering.SORTED_ASCENDINGfor optimizations.Adds theMV_PSERIES_WEIGHTED_SUMfunction for converting sorted lists of numbers into a bounded score.Introduction ofMV_SORT,MV_SLICE, andMV_ZIP.Support simplified syntax for named parameters for field and function names.Support for named or positional parameters in EsqlQueryRequest.Forbid usage of brackets in unquoted index and enrich policy names https://github.com/elastic/elasticsearch/issues/130378Removing support for theMETAkeyword.From now, Literal only accepts strings as BytesRefs.Non full text functions do not contribute to scoreThis enables 60_usage.yml "Basic ESQL usage....non-snapshot" version test.Changed and normalized the LIMIT error message.Support named argument for function in map format.Support parameters for LIMIT command.Support parameters for SAMPLE command.Allow filter per individual aggregation.FixPER_AGG_FILTERINGgrouped by ordinals.QSTR functionListing queries and getting information on a specific query.Support options in the query string function.Use RangeQuery for BinaryComparison on DateTime fields.Support for removing empty attribute in merging output.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 TopNSupport for assignment in RENAME, besides the use of `AS` keyword.Execute `RENAME` operations sequentially from left to right, see ESQL: Align RENAME behavior with EVAL for sequential processing #122250Support for requesting the "REPEAT" command.The_queryAPI now reports the original types.Support for RERANK commandResolve groupings before resolving references to groupings in the aggregations.Support for retain aggregate when grouping.Allows RLIKE to correctly handle the "empty language" flag, `#`.TheROUND_TOfunction.Support for RRF commandSupport for the SAMPLE commandChange field caps response for semantic_text fields to be reported as textChanged error messages for fields with conflicting types in different indices.This enables 60_usage.yml "Basic ESQL usage....snapshot" version test.FixSORTwhen the_sourcefield is not a sort key but is being returned.Fix sorting not allowed on _source and counters._source field mapping directives: https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-source-field.htmlSupport for requesting the "SPACE" function.Fix for spatial centroid when no records are found.Support a number of fixes and enhancements to spatial distance pushdown.Enable spatial distance function to support multi-values.Fix determination of CRS types in spatial functions when folding.Support ST_GEOHASH, ST_GEOTILE and ST_GEOHEX functionsChanged precision ofgeo_pointandcartesian_pointfields, by loading from source into WKB.Enable spatial predicate functions to support multi-values.Support for loadinggeo_shapeandcartesian_shapefields.Support for spatial aggregationST_CENTROID.Optimization for ST_CENTROID changed some results in cartesian data.Support for spatial aggregationST_CONTAINSandST_WITHIN.Support for spatial aggregationST_DISJOINT.Support for functionST_DISTANCE.Support ST_ENVELOPE function (and related ST_XMIN, etc.).Support for functionST_EXTENT_AGG.Optimization of ST_EXTENT_AGG with doc-values as IntBlock.Support for spatial aggregationST_INTERSECTS.Introduction ofST_XandST_Y.Lucene query pushdown to StartsWith and EndsWith functions.Send warnings on STATS alias collision https://github.com/elastic/elasticsearch/issues/114970Support forSTD_DEVaggregation.Cast string literals to a desired data type.Cast string literals to a desired data type for IN predicate and more types for BinaryComparison.Cast string literals to datetime in addition and subtraction when the other side is a date or time interval.The_queryAPI now gives a cast recommendation if multiple types are found in certain instances.Support sum_over_time aggregation that gets evaluated per time-seriesSupport partial_resultsTerm functionSupport for timespan units abbreviationsSupport for to_date_nanos functionSupport for theleading_zerosnamed parameter.Guards a bug fix matchingTO_LOWER(f) == "".DoTO_LOWERandTO_UPPERprocess all field values?Support multiple field mappings if appropriate conversion function is used (union types)Fix for union-types when aggregating over an inline conversion with casting operator.Fix for union-types when renaming unrelated columns.Fix for union-types when aggregating over an inline conversion with conversion function.Fix for union-types when some indexes are missing the required field.Fix for widening of short numeric types in union-types.Fix for union-types when sorting a type-casted field.Fix for non-unique attribute names in ROW and logical plans.Support unmapped using the INSIST keyword.Lookup error messages were updated to make them a bit easier to understand.Does the usage information for ESQL contain a histogram oftookvalues? -
Method Summary
Modifier and TypeMethodDescriptionbooleanstatic EsqlCapabilities.CapReturns 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.
-
Enum Constant Details
-
MV_SORT
Introduction ofMV_SORT,MV_SLICE, andMV_ZIP. Added in #106095. -
DISABLE_NULLABLE_OPTS
When we disabled some broken optimizations aroundnullable. Fixed in #105691. -
ST_X_Y
Introduction ofST_XandST_Y. Added in #105768. -
SPATIAL_POINTS_FROM_SOURCE
Changed precision ofgeo_pointandcartesian_pointfields, by loading from source into WKB. Done in #103691. -
SPATIAL_SHAPES
Support for loadinggeo_shapeandcartesian_shapefields. Done in #104269. -
GEO_VALIDATION
Do validation check on geo_point and geo_shape fields. Done in #128259. -
ST_CENTROID_AGG
Support for spatial aggregationST_CENTROID. Done in #104269. -
ST_INTERSECTS
Support for spatial aggregationST_INTERSECTS. Done in #104907. -
ST_CONTAINS_WITHIN
Support for spatial aggregationST_CONTAINSandST_WITHIN. Done in #106503. -
ST_DISJOINT
Support for spatial aggregationST_DISJOINT. Done in #107007. -
AGG_VALUES
The introduction of theVALUESagg. -
AGG_VALUES_SPATIAL
Expand theVALUESagg to cover spatial types. -
ASYNC_QUERY
Does ESQL support async queries. -
FROM_OPTIONS
Deprecated.Does ESQL support FROM OPTIONS? -
STRING_LITERAL_AUTO_CASTING
Cast string literals to a desired data type. -
BASE64_DECODE_ENCODE
Base64 encoding and decoding functions. -
CASTING_OPERATOR
Support for the :: casting operator -
CASTING_OPERATOR_FOR_DATE
Support for the ::date casting operator -
MV_ORDERING_SORTED_ASCENDING
Blocks can be labelled withBlock.MvOrdering.SORTED_ASCENDINGfor optimizations. -
METRICS_COUNTER_FIELDS
Support for metrics counter fields -
STRING_LITERAL_AUTO_CASTING_EXTENDED
Cast string literals to a desired data type for IN predicate and more types for BinaryComparison. -
METADATA_FIELDS
Support for metadata fields. -
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
Support for timespan units abbreviations -
COUNTER_TYPES
Support metrics counter types -
FN_BIT_LENGTH
Support for functionBIT_LENGTH. Done in #115792 -
FN_BYTE_LENGTH
Support for functionBYTE_LENGTH. -
FN_REVERSE
Support for functionREVERSE. -
FN_REVERSE_GRAPHEME_CLUSTERS
Support for reversing whole grapheme clusters. This is not supported on JDK versions less than 20 which are not supported in ES 9.0.0+ but this exists to keep the8.xbranch similar to themainbranch. -
FN_CBRT
Support for functionCBRT. Done in #108574. -
FN_HYPOT
Support for functionHYPOT. -
FN_MV_APPEND
Support forMV_APPENDfunction. #107001 -
FN_MV_MEDIAN_ABSOLUTE_DEVIATION
Support forMV_MEDIAN_ABSOLUTE_DEVIATIONfunction. -
FN_MV_PERCENTILE
Support forMV_PERCENTILEfunction. -
FN_IP_PREFIX
Support for functionIP_PREFIX. -
FN_SUBSTRING_EMPTY_NULL
Fix on functionSUBSTRINGthat makes it not return null on empty strings. -
FN_ROUND_UL_FIXES
Fixes on functionROUNDthat avoid it throwing exceptions on runtime for unsigned long cases. -
FN_SCALB
Support for functionSCALB. -
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
All functions that take TEXT should never emit TEXT, only KEYWORD. #114334 -
INLINESTATS
Support for theINLINESTATSsyntax. -
INLINESTATS_V2
Support for the expressions in grouping inINLINESTATSsyntax. -
AGG_TOP
Support for aggregation functionTOP. -
AGG_MAX_MIN_BOOLEAN_SUPPORT
Support for booleans in aggregationsMAXandMIN. -
AGG_MAX_MIN_IP_SUPPORT
Support for ips in aggregationsMAXandMIN. -
AGG_MAX_MIN_STRING_SUPPORT
Support for strings in aggregationsMAXandMIN. -
AGG_TOP_BOOLEAN_SUPPORT
Support for booleans inTOPaggregation. -
AGG_TOP_IP_SUPPORT
Support for ips inTOPaggregation. -
AGG_TOP_STRING_SUPPORT
Support forkeywordandtextfields inTOPaggregation. -
CASE_MV
CASEproperly handling multivalue conditions. -
ENRICH_LOAD
Support for loading values over enrich. This is supported by all versions of ESQL but not the unit test CsvTests. -
ST_CENTROID_AGG_OPTIMIZED
Optimization for ST_CENTROID changed some results in cartesian data. #108713 -
METADATA_IGNORED_FIELD
Support for requesting the "_ignored" metadata field. -
LOOKUP_V4
LOOKUP command with - tables using syntax"tables": {"type": [<values>]}- fixed variable shadowing - fixed Join.references(), requiring breaking change to Join serialization -
REPEAT
Support for requesting the "REPEAT" command. -
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
Support implicit casting for union typed fields that are mixed with date and date_nanos type. -
NAMED_POSITIONAL_PARAMETER
Support for named or positional parameters in EsqlQueryRequest. -
UNION_TYPES
Support multiple field mappings if appropriate conversion function is used (union types) -
UNMAPPED_FIELDS
Support unmapped using the INSIST keyword. -
ST_DISTANCE
Support for functionST_DISTANCE. Done in #108764. -
ST_EXTENT_AGG
Support for functionST_EXTENT_AGG. -
ST_EXTENT_AGG_DOCVALUES
Optimization of ST_EXTENT_AGG with doc-values as IntBlock. -
SPATIAL_FUNCTIONS_FIX_CRSTYPE_FOLDING
Fix determination of CRS types in spatial functions when folding. -
SPATIAL_PREDICATES_SUPPORT_MULTIVALUES
Enable spatial predicate functions to support multi-values. Done in #112063. -
SPATIAL_DISTANCE_SUPPORTS_MULTIVALUES
Enable spatial distance function to support multi-values. Done in #114836. -
SPATIAL_DISTANCE_PUSHDOWN_ENHANCEMENTS
Support a number of fixes and enhancements to spatial distance pushdown. Done in #112938. -
SPATIAL_CENTROID_NO_RECORDS
Fix for spatial centroid when no records are found. -
ST_ENVELOPE
Support ST_ENVELOPE function (and related ST_XMIN, etc.). -
SPATIAL_GRID
Support ST_GEOHASH, ST_GEOTILE and ST_GEOHEX functions -
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
Support for quoting index sources in double quotes. -
AGG_WEIGHTED_AVG
Support for WEIGHTED_AVG function. -
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
When pushing downSTATS 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
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
Fix for union-types when aggregating over an inline conversion with conversion function. Done in #110652. -
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
Fix for union-types when renaming unrelated columns. https://github.com/elastic/elasticsearch/issues/111452 -
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
Support for assignment in RENAME, besides the use of `AS` keyword. -
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
Support for retain aggregate when grouping. See ES|QL: columns not projected away despite KEEP #126026 -
UNION_TYPES_MISSING_FIELD
Fix for union-types when some indexes are missing the required field. Done in #111932. -
UNION_TYPES_NUMERIC_WIDENING
Fix for widening of short numeric types in union-types. Done in #112610 -
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
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
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
Use RangeQuery for BinaryComparison on DateTime fields. -
ENRICH_STRICT_RANGE_TYPES
Enforce strict type checking on ENRICH range types, and warnings for KEYWORD parsing at runtime. Done in #115091. -
UNIQUE_NAMES
Fix for non-unique attribute names in ROW and logical plans. https://github.com/elastic/elasticsearch/issues/110541 -
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 -
MV_PSERIES_WEIGHTED_SUM
Adds theMV_PSERIES_WEIGHTED_SUMfunction 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
Support for match operator as a colon. Previous support for match operator as MATCH has been removed -
NO_META
Removing support for theMETAkeyword. -
COMBINE_BINARY_COMPARISONS
Add CombineBinaryComparisons rule. -
DATE_NANOS_TYPE
Support for nanosecond dates as a data type -
TO_DATE_NANOS
Support for to_date_nanos function -
DATE_NANOS_BINARY_COMPARISON
Support for date nanos type in binary comparisons -
DATE_NANOS_COMPARE_TO_MILLIS
Support for mixed comparisons between nanosecond and millisecond dates -
DATE_NANOS_IMPLICIT_CASTING
Support implicit casting of strings to date nanos -
LEAST_GREATEST_FOR_DATENANOS
Support Least and Greatest functions on Date Nanos type -
DATE_NANOS_DATE_EXTRACT
support date extract function for date nanos -
DATE_NANOS_ADD_SUBTRACT
Support add and subtract on date nanos -
DATE_TRUNC_DATE_NANOS
Support for date_trunc function on date nanos type -
DATE_NANOS_BUCKET
Support date nanos values as the field argument to bucket -
DATE_NANOS_AGGREGATIONS
support aggregations on date nanos -
DATE_NANOS_IN_OPERATOR
Support theInoperator for date nanos -
DATE_NANOS_DATE_FORMAT
Support running date format function on nanosecond dates -
DATE_NANOS_DATE_DIFF
support date diff function on date nanos type, and mixed nanos/millis -
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.WHERE millis > to_datenanos("2023-10-23T12:15:03.360103847") AND millis < to_datetime("2023-10-23T13:53:55.832") -
DATE_NANOS_LOOKUP_JOIN
Support for date nanos in lookup join. Done in #127962 -
DATE_PARSE_TZ
DATE_PARSE supports reading timezones -
LEAST_GREATEST_FOR_DATES
Support for datetime in least and greatest functions -
COMBINE_DISJUNCTIVE_CIDRMATCHES
Support CIDRMatch in CombineDisjunctions rule. -
ASYNC_QUERY_STATUS_HEADERS
Support sending HTTP headers about the status of an async query. -
BUCKET_INCLUSIVE_UPPER_BOUND
Consider the upper bound when computing the interval in BUCKET auto mode. -
DATE_TRUNC_WITH_ARBITRARY_INTERVALS
Enhanced DATE_TRUNC with arbitrary month and year intervals. (#120302) -
SHORT_ERROR_MESSAGES_FOR_UNSUPPORTED_FIELDS
Changed error messages for fields with conflicting types in different indices. -
BUCKET_WHOLE_NUMBER_AS_SPAN
Support for the whole number spans in BUCKET function. -
MIXED_NUMERIC_TYPES_IN_COALESCE
Allow mixed numeric types in coalesce -
SPACE
Support for requesting the "SPACE" function. -
CAST_STRING_LITERAL_TO_TEMPORAL_AMOUNT
Support explicit casting from string literal to DATE_PERIOD or TIME_DURATION. -
CATEGORIZE_V6
Supported the text categorization function "CATEGORIZE". -
CATEGORIZE_MULTIPLE_GROUPINGS
Support for multiple groupings in "CATEGORIZE". -
QSTR_FUNCTION
QSTR function -
MATCH_FUNCTION
MATCH function -
KQL_FUNCTION
KQL function -
HASH_FUNCTION
Hash function -
HASH_FUNCTION_ALIASES_V1
Hash function aliases such as MD5 -
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
Compute year differences in full calendar years. -
SORTING_ON_SOURCE_AND_COUNTERS_FORBIDDEN
Fix sorting not allowed on _source and counters. -
SORT_RETURNING_SOURCE_OK
FixSORTwhen the_sourcefield is not a sort key but is being returned. -
SOURCE_FIELD_MAPPING
_source field mapping directives: https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-source-field.html -
PER_AGG_FILTERING
Allow filter per individual aggregation. -
PER_AGG_FILTERING_ORDS
FixPER_AGG_FILTERINGgrouped by ordinals. -
STD_DEV
Support forSTD_DEVaggregation. -
FIX_STATS_BY_FOLDABLE_EXPRESSION
Fix for https://github.com/elastic/elasticsearch/issues/114714 -
FUNCTION_STATS
Adding stats for functions (stack telemetry) -
FIX_FILTER_PUSHDOWN_PAST_STATS
Fix for an optimization that caused wrong results https://github.com/elastic/elasticsearch/issues/115281 -
STATS_ALIAS_COLLISION_WARNINGS
Send warnings on STATS alias collision https://github.com/elastic/elasticsearch/issues/114970 -
SNAPSHOT_TEST_FOR_TELEMETRY
This enables 60_usage.yml "Basic ESQL usage....snapshot" version test. See also the next capability. -
NON_SNAPSHOT_TEST_FOR_TELEMETRY
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_SYNTAXSupport simplified syntax for named parameters for field and function names. -
ADD_LIMIT_INSIDE_MV_EXPAND
Fix pushdown of LIMIT past MV_EXPAND -
DELAY_DEBUG_FN
-
METADATA_FIELDS_REMOTE_TEST
Capability for remote metadata test -
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
Support implicit casting from string literal to DATE_PERIOD or TIME_DURATION. -
JOIN_LOOKUP_V12
LOOKUP JOIN -
LOOKUP_JOIN_TEXT
LOOKUP JOIN with TEXT fields on the right (right side of the join) (#119473) -
JOIN_LOOKUP_SKIP_MV_WARNINGS
LOOKUP JOIN skipping MVs and sending warnings (https://github.com/elastic/elasticsearch/issues/118780) -
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
Fix for https://github.com/elastic/elasticsearch/issues/117054 -
FIX_STATS_BY_FOLDABLE_EXPRESSION_2
Fix for https://github.com/elastic/elasticsearch/issues/114714, again -
METADATA_SCORE
Support the "METADATA _score" directive to enable _score column. -
TERM_FUNCTION
Term function -
MATCH_ADDITIONAL_TYPES
Additional types for match function and operator -
FIXED_REGEX_FOLD
Fix for regex folding with case-insensitive pattern https://github.com/elastic/elasticsearch/issues/118371 -
FULL_TEXT_FUNCTIONS_DISJUNCTIONS
Full text functions can be used in disjunctions -
SEMANTIC_TEXT_FIELD_CAPS
Change field caps response for semantic_text fields to be reported as text -
OPTIONAL_NAMED_ARGUMENT_MAP_FOR_FUNCTION
Support named argument for function in map format. -
LOOKUP_JOIN_NO_ALIASES
Disabled support for index aliases in lookup joins -
FULL_TEXT_FUNCTIONS_DISJUNCTIONS_COMPUTE_ENGINE
Full text functions can be used in disjunctions as they are implemented in compute engine -
MATCH_FUNCTION_OPTIONS
Support match options in match function -
QUERY_STRING_FUNCTION_OPTIONS
Support options in the query string function. -
AGGREGATE_METRIC_DOUBLE
Support for aggregate_metric_double type -
AGGREGATE_METRIC_DOUBLE_PARTIAL_SUBMETRICS
Support for partial subset of metrics in aggregate_metric_double type -
AGGREGATE_METRIC_DOUBLE_RENDERING
Support for rendering aggregate_metric_double type -
AGGREGATE_METRIC_DOUBLE_CONVERT_TO
Support for to_aggregate_metric_double function -
AGGREGATE_METRIC_DOUBLE_SORTING
Support for sorting when aggregate_metric_doubles are present -
AGGREGATE_METRIC_DOUBLE_AVG
Support avg with aggregate metric doubles -
AGGREGATE_METRIC_DOUBLE_SORTING_FIXED
Fixes bug when aggregate metric double is encoded as a single nul value but decoded as AggregateMetricDoubleBlock (expecting 4 values) in TopN. -
AGGREGATE_METRIC_DOUBLE_MV_EXPAND
Stop erroring out when trying to apply MV_EXPAND on aggregate metric double. -
CHANGE_POINT
Support change point detection "CHANGE_POINT". -
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_V7
Fixes a series of issues with inlinestats which had an incomplete implementation after lookup and inlinestats were refactored. -
SUPPORT_PARTIAL_RESULTS
Support partial_results -
RERANK
Support for RERANK command -
COMPLETION
Support for COMPLETION command -
MIXED_NUMERIC_TYPES_IN_CASE_GREATEST_LEAST
Allow mixed numeric types in conditional functions - case, greatest and least -
RRF
Support for RRF command -
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
Full text functions can be scored when being part of a disjunction -
MULTI_MATCH_FUNCTION
Support for multi-match function. -
TO_LOWER_MV
DoTO_LOWERandTO_UPPERprocess all field values? -
DOUBLE_PARAMETER_MARKERS_FOR_IDENTIFIERS
Use double parameter markers to represent field or function names. -
NON_FULL_TEXT_FUNCTIONS_SCORING
Non full text functions do not contribute to score -
REPORT_ORIGINAL_TYPES
The_queryAPI now reports the original types. -
METRICS_COMMAND
The metrics command -
DOCUMENTS_FOUND_AND_VALUES_LOADED
Are thedocuments_foundandvalues_loadedfields available in the response and profile? -
INDEX_COMPONENT_SELECTORS
Index component selector syntax (my-data-stream-name::failures) -
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_LAYOUTSupercedesMAKE_NUMBER_OF_CHANNELS_CONSISTENT_WITH_LAYOUT. -
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
When creating constant null blocks inValuesSourceReaderOperator, 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
Listing queries and getting information on a specific query. -
MAX_OVER_TIME
Support max_over_time aggregation that gets evaluated per time-series -
FORK_V9
Support for FORK out of snapshot -
TO_IP_LEADING_ZEROS
Support for theleading_zerosnamed parameter. -
USAGE_CONTAINS_TOOK
Does the usage information for ESQL contain a histogram oftookvalues? -
AVG_OVER_TIME
Support avg_over_time aggregation that gets evaluated per time-series -
LOADING_NON_INDEXED_IP_FIELDS
Support loading of ip fields if they are not indexed. -
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
Support for keeping `DROP` attributes when resolving field names. see ES|QL: no matches for pattern #126418 -
DROP_WITH_WILDCARD_AFTER_LOOKUP_JOIN
Correctly ask for all fields from lookup indices even when there is e.g. aDROP *fieldafter. See ES|QL: missing columns for wildcard drop after lookup join #129561 -
LAST_OVER_TIME
Support last_over_time aggregation that gets evaluated per time-series -
SAMPLE_V3
Support for the SAMPLE command -
SUGGESTED_CAST
The_queryAPI now gives a cast recommendation if multiple types are found in certain instances. -
TO_LOWER_EMPTY_STRING
Guards a bug fix matchingTO_LOWER(f) == "". -
MIN_OVER_TIME
Support min_over_time aggregation that gets evaluated per time-series -
FIRST_OVER_TIME
Support first_over_time aggregation that gets evaluated per time-series -
SUM_OVER_TIME
Support sum_over_time aggregation that gets evaluated per time-series -
COUNT_OVER_TIME
Support count_over_time aggregation that gets evaluated per time-series -
COUNT_DISTINCT_OVER_TIME
Support for count_distinct_over_time aggregation that gets evaluated per time-series -
RESOLVE_GROUPINGS_BEFORE_RESOLVING_REFERENCES_TO_GROUPINGS_IN_AGGREGATIONS
public static final EsqlCapabilities.Cap RESOLVE_GROUPINGS_BEFORE_RESOLVING_REFERENCES_TO_GROUPINGS_IN_AGGREGATIONSResolve groupings before resolving references to groupings in the aggregations. -
AGG_SAMPLE
Support for the SAMPLE aggregation function -
FULL_TEXT_FUNCTIONS_IN_STATS_WHERE
Full text functions in STATS -
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 -
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
TheROUND_TOfunction. -
COPY_SIGN
Support for theCOPY_SIGNfunction. -
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
LuceneQueryEvaluatorrewrites 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
Support parameters for LIMIT command. -
NORMALIZED_LIMIT_ERROR_MESSAGE
Changed and normalized the LIMIT error message. -
DENSE_VECTOR_FIELD_TYPE
Dense vector field type support -
ENABLE_LOOKUP_JOIN_ON_ALIASES
Enable support for index aliases in lookup joins -
UPDATE_LOOKUP_JOIN_ERROR_MESSAGES
Lookup error messages were updated to make them a bit easier to understand. -
RLIKE_WITH_EMPTY_LANGUAGE_PATTERN
Allows RLIKE to correctly handle the "empty language" flag, `#`. -
MATCH_PHRASE_FUNCTION
MATCH PHRASE function -
KNN_FUNCTION
Support knn function -
LIKE_WITH_LIST_OF_PATTERNS
-
LIKE_LIST_ON_INDEX_FIELDS
-
PARAMETER_FOR_SAMPLE
Support parameters for SAMPLE command. -
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
Support for the mv_expand target attribute should be retained in its original position. see ES|QL: inconsistent column order #129000 -
EXPLAIN
(Re)Added EXPLAIN command -
LIKE_ON_INDEX_FIELDS
Support improved behavior for LIKE operator when used with index fields. -
NO_BRACKETS_IN_UNQUOTED_INDEX_NAMES
Forbid usage of brackets in unquoted index and enrich policy names https://github.com/elastic/elasticsearch/issues/130378 -
CORRECT_SKIPPED_SHARDS_COUNT
Support correct counting of skipped shards.
-
-
Method Details
-
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
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 nameNullPointerException- if the argument is null
-
isEnabled
public boolean isEnabled() -
capabilityName
-