Pagination can be applied to selection with order by only. If a query has OFFSET m LIMIT n, Pinot will get the first m+n results, then return n results from offset m
a
Anish Nair
08/01/2022, 6:51 AM
So we bring First m +n rows from Pinot Servers to Brokers ? or broker returns m+n rows ?