Docs
  • Guides
  • APIs (opens in a new tab)
  • Products
    Elasticsearch Observability Security Elastic Cloud
  • Reference
  • Troubleshoot
  • Release notes
  1. Docs /
  2. Reference /
  3. Elasticsearch /
  4. Query languages /
  5. ES|QL /
  6. Syntax reference /
  7. Commands

ES|QL processing commands

ES|QL processing commands change an input table by adding, removing, or changing rows and columns.

A processing command changing an input table
× A processing command changing an input table

ES|QL supports these processing commands:

  • CHANGE_POINT
  • COMPLETION
  • DEDUP
  • DISSECT
  • DROP
  • ENRICH
  • EVAL
  • GROK
  • FORK
  • FUSE
  • KEEP
  • LIMIT
  • LOOKUP JOIN
  • METRICS_INFO
  • INLINE STATS
  • IP_LOCATION
  • MMR
  • MV_EXPAND
  • REGISTERED_DOMAIN
  • RENAME
  • RERANK
  • SAMPLE
  • SORT
  • STATS
  • TS_INFO
  • TS_COLLAPSE
  • USER_AGENT
  • URI_PARTS
  • WHERE
Previous
TS
Next
CHANGE_POINT
  • View as Markdown
  • Report a docs issue
  • Edit this page
  • Learn how to contribute
Get started free
  • 14-day free trial
  • All features included
  • No setup required
Section
Reference
Docs Guides APIs (opens in a new tab)
Products
Elasticsearch Observability Security Elastic Cloud
Reference Troubleshoot Release notes
Version
Reference Elasticsearch
  • Query languages
    • Query DSL
      • Get started
      • Query and filter context
      • Compound queries
        • Boolean
        • Boosting
        • Constant score
        • Disjunction max
        • Function score
      • Full text queries
        • Intervals
        • Match
        • Match boolean prefix
        • Match phrase
        • Match phrase prefix
        • Combined fields
        • Multi-match
        • Query string
        • Simple query string
        • KQL
      • Geo queries
        • Geo-bounding box
        • Geo-distance
        • Geo-grid
        • Geo-polygon
        • Geoshape
      • Shape queries
        • Shape
      • Joining queries
        • Nested
        • Has child
        • Has parent
        • Parent ID
      • Match all
      • Span queries
        • Span containing
        • Span field masking
        • Span first
        • Span multi-term
        • Span near
        • Span not
        • Span or
        • Span term
        • Span within
      • Vector queries
        • Knn
        • Dense vector
        • Sparse vector
        • Semantic
        • Text expansion
        • Weighted tokens
      • Specialized queries
        • Distance feature
        • more_like_this
        • Percolate
        • Rank feature
        • Script
        • Script score
        • Wrapper
        • Pinned query
        • Rule
      • Term-level queries
        • Exists
        • Fuzzy
        • IDs
        • Prefix
        • Range
        • Regexp
        • Term
        • Terms
        • Terms set
        • Wildcard
      • minimum_should_match parameter
      • rewrite parameter
      • Regular expression syntax
    • ES|QL
      • Get started
      • Use cases
        • ES|QL for search
        • ES|QL for cybersecurity
      • REST API
      • Syntax reference
        • Basic syntax
        • Query directives
          • SET
        • Commands
          • Source commands
            • FROM
            • PROMQL
            • ROW
            • SHOW
            • TS
          • Processing commands
            • CHANGE_POINT
            • COMPLETION
            • DEDUP
            • DISSECT
            • DROP
            • ENRICH
            • EVAL
            • FORK
            • FUSE
            • GROK
            • INLINE STATS
            • IP_LOCATION
            • KEEP
            • LIMIT
            • LOOKUP JOIN
            • METRICS_INFO
            • MMR
            • MV_EXPAND
            • REGISTERED_DOMAIN
            • RENAME
            • RERANK
            • SAMPLE
            • SORT
            • STATS
            • TS_INFO
            • TS_COLLAPSE
            • USER_AGENT
            • URI_PARTS
            • WHERE
        • Functions and operators
          • Aggregation functions
            • ABSENT
            • AVG
            • COUNT
            • COUNT_DISTINCT
            • EARLIEST
            • FIRST
            • LAST
            • LATEST
            • MAX
            • MEDIAN
            • MEDIAN_ABSOLUTE_DEVIATION
            • MIN
            • PERCENTILE
            • PRESENT
            • SAMPLE
            • SPARKLINE
            • ST_CENTROID_AGG
            • ST_EXTENT_AGG
            • STD_DEV
            • SUM
            • TOP
            • VALUES
            • VARIANCE
            • WEIGHTED_AVG
          • Time series aggregation functions
            • ABSENT_OVER_TIME
            • AVG_OVER_TIME
            • COUNT_OVER_TIME
            • COUNT_DISTINCT_OVER_TIME
            • DELTA
            • DERIV
            • FIRST_OVER_TIME
            • IDELTA
            • INCREASE
            • IRATE
            • LAST_OVER_TIME
            • MAX_OVER_TIME
            • MIN_OVER_TIME
            • PERCENTILE_OVER_TIME
            • PRESENT_OVER_TIME
            • RATE
            • STDDEV_OVER_TIME
            • VARIANCE_OVER_TIME
            • SUM_OVER_TIME
          • Grouping functions
            • BUCKET
            • TBUCKET
            • CATEGORIZE
            • WITHOUT
          • Conditional functions and expressions
            • CASE
            • COALESCE
            • GREATEST
            • LEAST
            • CLAMP
            • CLAMP_MIN
            • CLAMP_MAX
          • Date-time functions
            • DATE_DIFF
            • DATE_EXTRACT
            • DATE_FORMAT
            • DATE_PARSE
            • DATE_TRUNC
            • DAY_NAME
            • MONTH_NAME
            • NOW
            • RANGE_MAX
            • RANGE_MIN
            • RANGE_WITHIN
            • RANGE_CONTAINS
            • RANGE_INTERSECTS
            • TRANGE
          • IP functions
            • CIDR_MATCH
            • IP_PREFIX
          • Math functions
            • ABS
            • ACOS
            • ACOSH
            • ASIN
            • ASINH
            • ATAN
            • ATAN2
            • ATANH
            • CBRT
            • CEIL
            • COPY_SIGN
            • COS
            • COSH
            • E
            • EXP
            • FLOOR
            • HYPOT
            • LOG
            • LOG10
            • PI
            • POW
            • ROUND
            • ROUND_TO
            • SCALB
            • SIGNUM
            • SIN
            • SINH
            • SQRT
            • TAN
            • TANH
            • TAU
          • Search functions
            • DECAY
            • KQL
            • MATCH
            • MATCH_PHRASE
            • QSTR
            • SCORE
            • TOP_SNIPPETS
          • Spatial functions
            • ST_DISTANCE
            • ST_INTERSECTS
            • ST_DISJOINT
            • ST_CONTAINS
            • ST_WITHIN
            • ST_X
            • ST_Y
            • ST_NPOINTS
            • ST_BUFFER
            • ST_SIMPLIFY
            • ST_SIMPLIFYPRESERVETOPOLOGY
            • ST_GEOMETRYTYPE
            • ST_DIMENSION
            • ST_ISEMPTY
            • ST_UNION
            • ST_INTERSECTION
            • ST_DIFFERENCE
            • ST_SYMDIFFERENCE
            • ST_ENVELOPE
            • ST_XMAX
            • ST_XMIN
            • ST_YMAX
            • ST_YMIN
            • ST_GEOTILE
            • ST_GEOHEX
            • ST_GEOHASH
          • String functions
            • BIT_LENGTH
            • BYTE_LENGTH
            • CHUNK
            • CONCAT
            • CONTAINS
            • ENDS_WITH
            • FIELD_EXTRACT
            • FROM_BASE64
            • HASH
            • JSON_EXTRACT
            • LEFT
            • LENGTH
            • LOCATE
            • LTRIM
            • MD5
            • REPEAT
            • REPLACE
            • REVERSE
            • RIGHT
            • RTRIM
            • SHA1
            • SHA256
            • SPACE
            • SPLIT
            • STARTS_WITH
            • SUBSTRING
            • TO_BASE64
            • TO_LOWER
            • TO_UPPER
            • TRIM
            • URL_ENCODE
            • URL_ENCODE_COMPONENT
            • URL_DECODE
          • Dense vector functions
            • EMBEDDING
            • KNN
            • TEXT_EMBEDDING
            • V_COSINE
            • V_DOT_PRODUCT
            • V_HAMMING
            • V_L1_NORM
            • V_L2_NORM
          • Type conversion functions
            • TO_AGGREGATE_METRIC_DOUBLE
            • TO_BOOLEAN
            • TO_CARTESIANPOINT
            • TO_CARTESIANSHAPE
            • TO_COUNTER
            • TO_DATEPERIOD
            • TO_DATETIME
            • TO_DATE_NANOS
            • TO_DATE_RANGE
            • TO_DEGREES
            • TO_DENSE_VECTOR
            • TO_DOUBLE
            • TO_DOUBLE_RANGE
            • TO_EXPONENTIAL_HISTOGRAM
            • TO_GAUGE
            • TO_GEOHASH
            • TO_GEOHEX
            • TO_GEOPOINT
            • TO_GEOSHAPE
            • TO_GEOTILE
            • TO_INTEGER
            • TO_IP
            • TO_LONG
            • TO_RADIANS
            • TO_RANGE
            • TO_STRING
            • TO_TDIGEST
            • TO_TEXT
            • TO_TIMEDURATION
            • TO_UNSIGNED_LONG
            • TO_VERSION
          • Multivalue functions
            • MV_APPEND
            • MV_AVG
            • MV_CONCAT
            • MV_CONTAINS
            • MV_COUNT
            • MV_DEDUPE
            • MV_DIFFERENCE
            • MV_FIRST
            • MV_IN_RANGE
            • MV_INTERSECTION
            • MV_INTERSECTS
            • MV_LAST
            • MV_LIKE
            • MV_MAX
            • MV_MEDIAN
            • MV_MEDIAN_ABSOLUTE_DEVIATION
            • MV_MIN
            • MV_PERCENTILE
            • MV_PSERIES_WEIGHTED_SUM
            • MV_RLIKE
            • MV_SLICE
            • MV_SORT
            • MV_SUM
            • MV_UNION
            • MV_ZIP
          • Operators
      • Optimize query performance
        • Approximate STATS queries
      • Query multiple sources
        • Query multiple indices
        • Query across clusters
        • Query across serverless projects
      • Combine and reuse queries
        • Subqueries
          • Subqueries with FROM
          • Subqueries with IN / NOT IN
        • Views
      • Data Federation
        • Quickstart
        • Connect data sources
          • AWS federated identity
          • AWS static credentials
        • Add datasets
        • Query datasets
        • Manage access
        • Cluster settings
      • Advanced workflows
        • Extract data with DISSECT and GROK
        • Combine data with ENRICH
        • Join data with LOOKUP JOIN
      • Types and fields
        • Implicit casting
        • Time spans
        • Flattened fields
        • Metadata fields
        • NULL values
        • Multivalued fields
        • Unmapped fields
      • Tutorials
        • ES|QL for search
        • ES|QL for threat hunting
      • Troubleshooting
        • Query log
        • List running queries
      • Limitations
    • PromQL
      • HTTP API
      • Functions
        • Range vector functions
        • Aggregation functions
        • Histogram functions
        • Math functions
        • Date and time functions
        • Conversion functions
      • Operators
        • Arithmetic operators
        • Comparison operators
        • Logical/set operators
        • Unary operators
        • Label matching operators
      • Prometheus data source in Grafana
      • Limitations
    • SQL
      • Getting started
      • Conventions
      • Security
      • SQL REST API
        • Overview
        • Response data formats
        • Paginating through a large response
        • Filtering using Elasticsearch Query DSL
        • Columnar results
        • Passing parameters to a query
        • Use runtime fields
        • Run an async SQL search
      • SQL Translate API
      • SQL CLI
      • SQL JDBC
        • API usage
      • SQL ODBC
        • Driver installation
        • Configuration
      • SQL client applications
        • DBeaver
        • DbVisualizer
        • Microsoft Excel
        • Microsoft Power BI Desktop
        • Microsoft PowerShell
        • MicroStrategy Desktop
        • Qlik Sense Desktop
        • SQuirreL SQL
        • SQL Workbench/J
        • Tableau Desktop
        • Tableau Server
      • SQL language
        • Lexical structure
        • SQL commands
        • DESCRIBE TABLE
        • SELECT
        • SHOW CATALOGS
        • SHOW COLUMNS
        • SHOW FUNCTIONS
        • SHOW TABLES
        • Data types
        • Index patterns
        • Frozen indices
      • Functions and operators
        • Comparison operators
        • Logical operators
        • Math operators
        • Cast operators
        • LIKE and RLIKE operators
        • Aggregate functions
        • Grouping functions
        • Date/time and interval functions and operators
        • Full-text search functions
        • Mathematical functions
        • String functions
        • Type conversion functions
        • Geo functions
        • Conditional functions and expressions
        • System functions
      • Reserved keywords
      • SQL limitations
    • EQL
      • Syntax reference
      • Function reference
      • Pipe reference
    • Kibana Query Language
Elastic logo
  • Trademarks
  • Terms of Use
  • Privacy
  • Sitemap

© 2026 Elasticsearch B.V. All Rights Reserved.

This content is available in different formats for convenience only. All original licensing terms apply.

Elasticsearch is a trademark of Elasticsearch B.V., registered in the U.S. and in other countries. Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.