Fetch_size parameter

The fetch_size parameter is working on SQL with OpenDistro?
I need return only a range of rows and do pagination, how do I do it?