Discard empty/null values

paddington1 · March 20, 2025, 9:37am

Hi,

Is there a way to KEEP fields which are not null/empty with ES|QL?

I do not want to manually write KEEP for all of the fields which are not empty.

dadoonet · March 20, 2025, 3:33pm

Apparently the only way is by using drop_null_columns query param. But it's not available within the query itself.

Topic		Replies	Views
Exclude empty-string, null and non-existant Elasticsearch	2	21955	June 12, 2019
Elasticsearch declare field as null Elasticsearch	2	458	March 21, 2018
How to stop return of Null properties(fields) Elasticsearch	3	793	July 5, 2017
[ElasticSearch Query] Select all not null fields Elasticsearch	3	2707	August 29, 2019
Handling of null and [] (empty list) Elasticsearch elastic-stack-sql , eql-elastic-query-language	1	910	May 23, 2023