Hello, does the command ROW_NUMBER() exist for ES SQL? When not, is there something equivalent to it? Can someone do an example, please? With best regards

ROW_NUMBER in ES SQL

Treki December 8, 2020, 12:07am 3

of course!
After performing the ES SQL query in a Canvas workspace, we want that the result of the search is getting displayed in the preview of a datatable with row numbers.

Topic		Replies	Views
ROW_NUMBER in Elasticsearch Elasticsearch	3	2336	August 8, 2018
How to use "SQL(ROW_NUMBER())" as same as for ElasticSearch Query using C#? Elasticsearch	4	3496	October 6, 2017
Specific sorting order using windowfunction row_number Elasticsearch	3	1265	July 5, 2017
Kibana canvas filter Kibana	3	310	September 14, 2021
Iterate by rows on an essql query Kibana canvas	4	1377	February 28, 2020

ROW_NUMBER in ES SQL

Related topics