Category: ES|QL
Articles tagged ES|QL
Using ES|QL COMPLETION + an LLM to write a Chuck Norris fact generator in 5 minutes
Discover how to use the ES|QL COMPLETION command to turn your Elasticsearch data into creative output using an LLM in just a few lines of code.
Unify your data: Cross-cluster search with ES|QL is now generally available!
Cross-Cluster search with ES|QL is now GA! Query data across multiple clusters with a single, elegant query. Learn about its performance, resilience, and syntax.
Introducing a more powerful, resilient, and observable ES|QL in Elasticsearch 8.19 & 9.1
Exploring ES|QL enhancements in Elasticsearch 8.19 & 9.1, including built-in resilience to failures, new monitoring and observability capabilities, and more.
Geospatial distance search with ES|QL
Explore geospatial distance search in Elasticsearch Query Language (ES|QL), one of the most desired and useful features for improved ease of use and Open Geospatial Consortium (OGC) familiarity.
ES|QL in JavaScript: Leveraging Apache Arrow helpers
Learn how to use ES|QL with JavaScript Apache Arrow client helpers to analyze large data sets efficiently.
How we rebuilt autocomplete for ES|QL
Discover how we rearchitected an autocomplete engine for ES|QL to support language evolution instead of resisting it.
Native joins available in Elasticsearch 8.18
Exploring LOOKUP JOIN, a new ES|QL command available in tech preview in Elasticsearch 8.18.
ES|QL Joins Are Here! Yes, Joins!
Elasticsearch 8.18 includes ES|QL’s LOOKUP JOIN command, our first SQL-style JOIN.
Filtering in ES|QL using full text search
MATCH, QSTR, and KQL functions in ES|QL can be used to perform full text filtering. This article describes what they do, how they can be used, the difference with the existing text filtering methods, current limitations and future improvements.
Improving the ES|QL editor experience in Kibana
With the new ES|QL language becoming GA, a new editor experience has been developed in Kibana to help users write faster and better queries. Features like live validation, improved autocomplete and quick fixes will streamline the ES|QL experience.
Ingest geospatial data into Elasticsearch with Kibana for use in ES|QL
How to use Kibana and the csv ingest processor to ingest geospatial data into Elasticsearch for use with search in Elasticsearch Query Language (ES|QL). Elasticsearch has powerful geospatial search features, which are now coming to ES|QL for dramatically improved ease of use and OGC familiarity. But to use these features, we need Geospatial data.