LOOKUP ON expression - Githubissues

elastic / elasticsearch

Free and Open Source, Distributed, RESTful Search Engine

https://www.elastic.co/products/elasticsearch

Other

1.19k stars 24.85k forks source link

LOOKUP ON expression #109389

Open astefan opened 5 months ago

astefan commented 5 months ago

Description

As a follow up for https://github.com/elastic/elasticsearch/pull/107987/files#r1626767875, allow specifying an expression for ON. I find as a first very useful use case (combined with union types support) queries of the form from test* | LOOKUP int_number_names ON int::integer.

elasticsearchmachine commented 5 months ago

Pinging @elastic/es-analytical-engine (Team:Analytics)

elasticsearchmachine commented 5 months ago

Pinging @elastic/kibana-esql (ES|QL-ui)

nik9000 commented 5 months ago

LOOKUP int_number_names ON int::integer

And ON foo == bar and on from_table == CONCAT(from_stream_a, from_stream_b) and CONCAT(from_stream_a, from_stream_b) == from_table CONCAT(from_table_b, from_table_a) == from_stream.

dgieselaar commented 1 month ago

this would be an amazing feature!