Error when using INLINESTATS on snapshot build

[3kt]

Similar issue to some things listed in https://github.com/elastic/elasticsearch/issues/110923

When trying to run the following ESQL query on OOTB sample data:

FROM kibana_sample_data_logs
| EVAL gb = bytes/1024/1024/1024
| SORT gb DESC
| INLINESTATS traffic_total=SUM(gb), count=COUNT(*) BY clientip
| WHERE host == "www.elastic.co"

I get the below error:

[esql] > Unexpected error from Elasticsearch: esql_illegal_argument_exception - unknown physical plan node [OrderExec]

I have activated ESQL module debug logs, and you will find the full trace for the query (as csv) here: es_debug_logs.csv

The snapshot cluster has the below characteristics:

{
  "name": "es01",
  "cluster_name": "esesql",
  "cluster_uuid": "spT9H_fjRp2lvOCKGaGbGQ",
  "version": {
    "number": "8.16.0-SNAPSHOT",
    "build_flavor": "default",
    "build_type": "docker",
    "build_hash": "186cc62d5129bfc0c9aeda4410f92ab78e564f17",
    "build_date": "2024-09-27T12:54:50.441412003Z",
    "build_snapshot": true,
    "lucene_version": "9.11.1",
    "minimum_wire_compatibility_version": "7.17.0",
    "minimum_index_compatibility_version": "7.0.0"
  },
  "tagline": "You Know, for Search"
}

[elasticsearchmachine]

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

[nik9000]

Thanks! So long as this is linked to https://github.com/elastic/elasticsearch/issues/110923 we'll get there!