ES|QL DROP command
The DROP processing command removes one or more columns.
DROP columns
columns- A comma-separated list of columns to remove. Supports wildcards.
Note
A wildcard pattern that matches no columns causes the query to fail with an error such as No matches found for pattern [columns*]. The exception is when SET unmapped_fields is set to "nullify" or "load": in that case, a pattern that matches no columns is ignored.
The following examples show how to remove columns by name and by pattern.
FROM employees
| DROP height
Rather than specify each column by name, you can use wildcards to drop all columns with a name that matches a pattern:
FROM employees
| DROP height*