Category: ES|QL

Articles tagged ES|QL

Subscribe
Filters
30x faster than Prometheus: How we rebuilt Elasticsearch as a leading columnar metrics datastore
Elasticsearch Labs

30x faster than Prometheus: How we rebuilt Elasticsearch as a leading columnar metrics datastore

Elasticsearch now stores OTel metrics at 3.75 bytes per data point and queries them up to 30x faster than Prometheus. Here's how we rebuilt TSDS and ES|QL.

Kostas Krikellas
Three indices walk into a FROM clause: ES|QL subqueries in Elasticsearch
Elasticsearch Labs

Three indices walk into a FROM clause: ES|QL subqueries in Elasticsearch

ES|QL subqueries give each data source its own pipeline and filters, eliminating CASE chains, restoring predicate pushdown, and making multi-index queries extensible by design.

Tyler Perkins
Elasticsearch ES|QL views: One query to rule twelve dashboards
Elasticsearch Labs

Elasticsearch ES|QL views: One query to rule twelve dashboards

With ES|QL views, you only need one query for multiple dashboards. Define it once and let Elasticsearch keep everything in sync.

Tyler Perkins
Elasticsearch ES|QL query builder for JavaScript and TypeScript: Fluent, type-safe query construction
Elasticsearch Labs

Elasticsearch ES|QL query builder for JavaScript and TypeScript: Fluent, type-safe query construction

Exploring the Elasticsearch ES|QL query builder for JavaScript and TypeScript and explaining how to build ES|QL queries with practical examples.

Margaret Gu
Your Elasticsearch field mappings are lying to you — METRICS_INFO and TS_INFO tell the truth
Elasticsearch Labs

Your Elasticsearch field mappings are lying to you — METRICS_INFO and TS_INFO tell the truth

Two new Elasticsearch ES|QL commands that turn time series discovery into a single-line query: METRICS_INFO and TS_INFO tell you which metrics and series actually exist in your data, not just what the mapping declares.

Dmitry Leontyev
Fast approximate Elasticsearch ES|QL - part II
Elasticsearch Labs

Fast approximate Elasticsearch ES|QL - part II

Explaining the approach we use to obtain fast approximate Elasticsearch ES|QL queries and the testing we did of error estimation.

Thomas Veasey
Fast approximate Elasticsearch ES|QL - part I
Elasticsearch Labs

Fast approximate Elasticsearch ES|QL - part I

Introducing the work we've done on a fast approximate querying mode for Elasticsearch ES|QL. In many cases, it allows us to achieve orders of magnitude latency reductions while providing accurate estimates.

Jan Kuipers
New Elasticsearch ES|QL plugin for IntelliJ IDEA
Elasticsearch Labs

New Elasticsearch ES|QL plugin for IntelliJ IDEA

Build and run Elasticsearch ES|QL queries in your IDE with the new plugin for IntelliJ IDEA.

Laura Trotta
LINQ to Elasticsearch ES|QL: Write C#, query Elasticsearch
Elasticsearch Labs

LINQ to Elasticsearch ES|QL: Write C#, query Elasticsearch

Exploring the new LINQ to Elasticsearch ES|QL provider in the Elasticsearch .NET client, which allows you to write C# code that’s automatically translated to ES|QL queries.

Florian Bernd
ES|QL dense vector search support
Elasticsearch Labs

ES|QL dense vector search support

Using ES|QL for vector search on your dense_vector data.

Carlos Delgado
Faster ES|QL stats with Swiss-style hash tables
Elasticsearch Labs

Faster ES|QL stats with Swiss-style hash tables

How Swiss-inspired hashing and SIMD-friendly design deliver consistent, measurable speedups in Elasticsearch Query Language (ES|QL).

Chris Hegarty
Hybrid search and multistage retrieval in ES|QL
Elasticsearch Labs

Hybrid search and multistage retrieval in ES|QL

Explore the multistage retrieval capabilities of ES|QL, using FORK and FUSE commands to integrate hybrid search with semantic reranking and native LLM completions.

Ioana Tagirta

Ready to build state of the art search experiences?

Sufficiently advanced search isn’t achieved with the efforts of one. Elasticsearch is powered by data scientists, ML ops, engineers, and many more who are just as passionate about search as you are. Let’s connect and work together to build the magical search experience that will get you the results you want.