Category: ES|QL
Articles tagged ES|QL

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.

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.

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.

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.

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).

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.

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.

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.

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.

Introducing the ES|QL query builder for the Elasticsearch Ruby Client
Learn how to use the recently released ES|QL query builder for the Elasticsearch Ruby Client. A tool to build ES|QL queries more easily with Ruby code.

