Alexander Spies

Alexander Spies

  • Joined Elastic in August 2023, worked on ES|QL since its early days.

  • Expert in query planning and optimization.

  • Moved to Switzerland in 2021, loves mountains as much as analytical query engines.

Subscribe
Articles by Alexander Spies
Taming PUNKs: How ES|QL queries Elasticsearch fields it was never told about
Elasticsearch Labs
ES|QLMappingsInside Elastic

Taming PUNKs: How ES|QL queries Elasticsearch fields it was never told about

In Elasticsearch 9.5, ES|QL can query unmapped fields. It reads them from _source or returns nulls, so a query keeps working when a field drops out of the mapping and you avoid a reindex that takes hours.

Alexander Spies