Loading

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.

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*