Background: Pagination is the task of dividing the query result into pages and retrieving the required pages one by one on demand.
[Example is google search. It displays results in pages] In the database domain, we use offset and limit to achieve it.
Now If carbondata is used to create an image dataset for model training for ML. User wants to display the dataset on the web (which needs pagination support)
Example: If the table has 500 rows and user needs 10 rows from 400 to 410. offset = 400, limit = 10
But carbondata doesn't support it now as it is iterative based read.
Details of solution and implementation is mentioned in the document attached and in JIRA.
Thanks,
Ajantha