[ES|QL][Kibana request] Return _id by default about elasticsearch HOT 5 OPEN

_id is a stored field so it's not the most efficient thing to load, but we will only be loading it outside of stats so that'll help. We'd want to make sure we did it after a topn.

from elasticsearch.

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

from elasticsearch.

We want to use this _id to do an extra call (after user's request) to get this row. Is the _id enough or do we need the _index too?

from <source> | where _id === <value>

Also is this performant?

from elasticsearch.

Is the _id enough or do we need the _index too?
from <source> | where _id === <value>

The _id is index specific, so you'll probably want the _index too.

(Smth like PUT test1/_doc/1 and PUT test2/_doc/1 will get you the same _id==1 for a FROM test*.)

Also is this performant?

I think the loading of the fields should be OK. Filtering-wise we can push _index down, but we don't do it for_id. But maybe we can improve things if required.

from elasticsearch.

Thanx @bpintea ❤️

from elasticsearch.