GitHub

group by query cannot support offset

I used elasticsearch 7.6.1 with SQL 1.6.0 I founded that the count(*) group by query cannot support offset argment. the query : "query": "select customer_id, count(*) as label_value from kibana_sample ...
GitHub

SQL: Pagination in ES SQL using "OFFSET {from} ROWS FETCH NEXT {size} ROWS ONLY"

GET /_sql?format=json { "query":"""SELECT * FROM process """, "fetch_size":"20" } With OFFSET {from} ROWS FETCH NEXT {size} ROWS ONLY we could paginate to backwards ...