Description

#109583 will add support for INLINESTATS, a command to run a STATS and then merge the results into the stream of results. This issue tracks follow up work:

• ESQL: Enable multiple INLINESTATS + remaining tests #124715
• ESQL: Ensure good docs coverage for INLINESTATS #124718
• Run logical plan optimization before splitting the phases. See ESQL: INLINESTATS #109583 (comment)
• Allow functions in the grouping position (+union types test with conversion in the grouping position // TODO once inlinestats supports expressions in groups we'll likely need the same sort of extraction here)
• Address left over comments on ESQL: Support INLINESTATS grouped on expressions #111690 stale
• ESQL: INLINESTATS with union types #124731
• Add all phases to the result of profile
• ESQL: For INLINEJOIN, push down INLINEJOIN to data nodes when it makes sense #124743
• ESQL: Make INLINESTATS properly track memory of data passed between phases #124744
• ESQL: Keep readers open for second phase of INLINESTATS' execution #124747
• Fix the test labeled brokenWhy-Ignore, byConstant-Ignored -> ESQL: Enable multiple INLINESTATS + remaining tests #124715
• More shadowing tests -> ESQL: Increase test coverage for INLINESTATS #124719
• Fix INLINESTATS x=MAX(a), x=MIN(a) - shadowingInternal-Ignored -> ESQL: Enable multiple INLINESTATS + remaining tests #124715
• Fix shadowingSelfBySelf -> ESQL: Enable multiple INLINESTATS + remaining tests #124715
• Fix INLINESTATS in CCS. This includes ensure that the two phase execution model interacts properly with the newly CCS execution info metadata that is gathered. ESQL: Make INLINESTATS work in CCQ #124748
• Once we have the above - we should look into pushing the Phased stuff further into physical planning. It'd be nice to, for example, and a SubqueryExec plan that runs like Phased does here. Not sure if physical or logical - but physical feels better. We're doing logical now though. Obsolete, the Phased interface is gone, the whole thing is modeled via InlineJoin now.
• Test with the BUCKET function. Sounds like it doesn't work at the moment. -> ESQL: Increase test coverage for INLINESTATS #124719
• More than one INLINESTATS. see. Note that this might have to do with multiple lookups - that's tracked in ESQL: LOOKUP followups #109353 -> ESQL: Enable multiple INLINESTATS + remaining tests #124715
• This query fails (if you remove the last pipe it works

FROM kibana_sample_data_logs
| EVAL timestamp=DATE_TRUNC(5 minute, @timestamp) | INLINESTATS results = count(*) by timestamp | keep results, timestamp

with message

Plan [EsqlProject[[results{r}#16680, timestamp{r}#16678]]] optimized incorrectly due to missing references [results{r}#16680]

-> #124715

• Fix FROM idx | EVAL ip = to_ip(host), x = to_string(host), y = to_string(host) | INLINESTATS max(id) and re-enable the corresponding telemetry test case muted here -> ESQL: Enable multiple INLINESTATS + remaining tests #124715.

Evantually

• Some ESQL: LOOKUP followups #109353 stale
• ESQL: INLINESTATS with per-agg WHERE #124741