search

elastic / elasticsearch

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

ES|QL: sorting a counter field shouldn't be possible #111976

Open astefan opened 1 month ago

astefan commented 1 month ago

Description

counter fields are supported to a degree: when they are casted to their corresponding numerical data type, ie counter_long::long should be ok, but sort counter_long should.

Now, sort counter_long seems to work. We have a test for this but it's a false positive in 40_tsdb.yml:

from test | KEEP k8s.pod.network.tx | sort @k8s.pod.network.tx | limit 1 - this one has a typo and the error we throw is that we cannot find @k8s.pod.network.tx field, whereas we should have created an error saying the counter_long field is unsupported.

elasticsearchmachine commented 1 month ago

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