JK

Julian Kiryakov

Principal Software Engineer II

Author's articles

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

December 2, 2025

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.

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