Similar issue to some things listed in #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"
}
Similar issue to some things listed in #110923
When trying to run the following ESQL query on OOTB sample data:
I get the below error:
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: