I'm using Elasticsearch 6.7.1. From what I can tell in the documentation , what I want to do should be possible, but it's not working for me: Here's my query: SELECT location.country, COUNT(*) AS count FROM my_index GROUP BY location.country ORDER BY count DESC LIMIT 10 This returns: |location.c…

@Brian_Frantz this is a bug which has been fixed already and is (should) be available in the versions set as labels in this PR .

Problems with "Top N" SQL query

system (system) Closed October 10, 2019, 6:40am 3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Elasticsearch SQL LIMIT returns last 10 results instead of first 10 results Elasticsearch elastic-stack-sql	3	544	September 30, 2019
Essql LIMIT selecting at random Kibana	7	606	November 18, 2019
Slow elasticsearch sql query with aggregation to get Top-N results Elasticsearch elastic-stack-sql	6	1309	November 30, 2019
Limit removes items from the top Elasticsearch	2	351	July 6, 2017
How to sort and then apply a limit filter Elasticsearch	2	2411	July 6, 2017