﻿---
title: ES|QL multivalue functions
description: ES|QL supports these multivalue functions: 
url: https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions
products:
  - Elasticsearch
applies_to:
  - Elastic Cloud Serverless: Generally available
  - Elastic Stack: Generally available
---

# ES|QL multivalue functions
ES|QL supports these multivalue functions:
- [`MV_APPEND`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_append)
- [`MV_AVG`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_avg)
- [`MV_CONCAT`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_concat)
- [`MV_CONTAINS`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_contains) <applies-to>Elastic Stack: Preview since 9.2</applies-to> <applies-to>Elastic Cloud Serverless: Preview</applies-to>
- [`MV_COUNT`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_count)
- [`MV_DEDUPE`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_dedupe)
- [`MV_FIRST`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_first)
- [`MV_INTERSECTION`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_intersection) <applies-to>Elastic Stack: Preview since 9.3</applies-to> <applies-to>Elastic Cloud Serverless: Preview</applies-to>
- [`MV_INTERSECTS`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_intersects) <applies-to>Elastic Stack: Preview since 9.3</applies-to> <applies-to>Elastic Cloud Serverless: Preview</applies-to>
- [`MV_LAST`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_last)
- [`MV_MAX`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_max)
- [`MV_MEDIAN`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_median)
- [`MV_MEDIAN_ABSOLUTE_DEVIATION`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_median_absolute_deviation)
- [`MV_MIN`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_min)
- [`MV_PERCENTILE`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_percentile)
- [`MV_PSERIES_WEIGHTED_SUM`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_pseries_weighted_sum)
- [`MV_SORT`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_sort)
- [`MV_SLICE`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_slice)
- [`MV_SUM`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_sum)
- [`MV_UNION`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_union) <applies-to>Elastic Stack: Planned</applies-to> <applies-to>Elastic Cloud Serverless: Preview</applies-to>
- [`MV_ZIP`](https://www.elastic.co/elastic/docs-builder/docs/3002/reference/query-languages/esql/functions-operators/mv-functions/mv_zip)