Hi Team, Need some clarity over how pagination is...
# troubleshooting
a
Hi Team, Need some clarity over how pagination is currently working with SELECTION (https://docs.pinot.apache.org/users/user-guide-query/querying-pinot#pagination-on-selection). Pagination happens on Broker , after bringing whole data from servers?
j
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
So we bring First m +n rows from Pinot Servers to Brokers ? or broker returns m+n rows ?