Tyler Perkins

Tyler Perkins

Principal Product Manager I

Articles by Tyler Perkins

Elasticsearch ES|QL: Now with Views, Subqueries, and Schema-on-Read

Query fields you never mapped, combine indices with different schemas in one pipeline, and reuse query logic as named views. ES|QL's most significant data access expansion yet.

Tyler Perkins

Elasticsearch ES|QL “schema on read”: Your unmapped fields were there all along

ES|QL's new unmapped fields feature makes any never-mapped field queryable against historical data (no reindexing needed).

Tyler Perkins

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

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

Tyler Perkins

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

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.

Tyler Perkins

ES|QL Joins Are Here! Yes, Joins!

Elasticsearch 8.18 includes ES|QL’s LOOKUP JOIN command, our first SQL-style JOIN.

Tyler Perkins