Category: ES|QL

Articles tagged ES|QL

Filters

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

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

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

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

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

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

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

Carlos Delgado

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

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

Introducing Elasticsearch support in the Google MCP Toolbox for Databases

Explore how Elasticsearch support is now available in the Google MCP Toolbox for Databases and leverage ES|QL tools to securely integrate your index with any MCP client.

Enrico Zimuel

ES|QL in 9.2: Smart Lookup Joins and time-series support

Explore three separate updates to ES|QL in Elasticsearch 9.2: an enhanced LOOKUP JOIN for more expressive data correlation, the new TS command for time-series analysis, and the flexible INLINE STATS command for aggregation.

Tyler Perkins

Elasticsearch’s ES|QL Editor experience vs. OpenSearch’s PPL Event Analyzer

Discover how ES|QL Editor’s advanced features accelerate your workflow, directly contrasting OpenSearch’s PPL Event Analyzer’s manual approach.

Libby Lin

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.

Try it yourself