limit 100,2 can not be used correctly

[aitanjupt]

If i use "limit 100,2", I want to get results pagely, but I found this doesnt work well. "limit 100,2" 'result = "limit 2". How can I do Paging well?
"SELECT *,COUNT(1),SUM(orderTotalAmount) FROM myIndex where (id=110820) GROUP BY tId ORDER BY rId DESC LIMIT 0,5"
This is my sql. I found using "GROUP BY" causes this issue.
And I found "GROUP BY date_histogram()" even causes "limit 2" does not work.

[eliranmoyal]

I don't think you can page on elastic when using aggregations.
see elastic/elasticsearch#7956 for term agg

and for date histogram
elastic/elasticsearch#7103

[aitanjupt]

yes, its elasticsearch's issue. thank you for your information.