Back to Elasticsearch

Drop

docs/reference/query-languages/esql/_snippets/commands/layout/drop.md

9.4.0642 B
Original Source
yaml
serverless: ga
stack: ga

The DROP processing command removes one or more columns.

Syntax

esql
DROP columns

Parameters

columns : A comma-separated list of columns to remove. Supports wildcards.

Examples

The following examples show how to remove columns by name and by pattern.

Drop a column by name

:::{include} ../examples/drop.csv-spec/height.md :::

Drop columns matching a wildcard pattern

Rather than specify each column by name, you can use wildcards to drop all columns with a name that matches a pattern:

:::{include} ../examples/drop.csv-spec/heightWithWildcard.md :::