search

elastic / elasticsearch

Free and Open Source, Distributed, RESTful Search Engine
https://www.elastic.co/products/elasticsearch
Other
1.12k stars 24.83k forks source link

ES|QL: adopt name qualifiers for ENRICH command #112015

Open astefan opened 2 months ago

astefan commented 2 months ago

Description

Similar to LOOKUP name qualifiers should be possible for ENRICH command as well. In the current implementation users have to use the WITH construct for every name collision. If there are just a few such fields, that's manageable, for more this becomes more tedious. Also, there is no support for making the user aware such an override has taken place. This means that a column in the results is not known to come from the from source command or from the enrich policies.

FROM A
| ENRICH a_policy ON x WITH new_y = y, new_w = w, etc..

This does come with something to dig into: backwards compatibility.

elasticsearchmachine commented 2 months ago

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