Hi team, does Pinot currently support pagination with group by using limit a,b; if not, is there any plan to support this?
m
Mayank
09/09/2021, 11:17 PM
Pinot does not support pagination in group by. No plan at the moment that I am aware of. Do you mind sharing the use case that requires pagination?
l
Luis Fernandez
09/10/2021, 2:58 PM
In our current product we show clicks and impression counts by products in the site and this is a table where we paginate over results, this can be group by different dimensions, so it could be could that we would be able to paginate
Luis Fernandez
09/10/2021, 3:25 PM
it doesn’t work if you put an
order by
?
c
Carl
09/10/2021, 3:36 PM
It’s returning the same result if we do group by and limit a,b
l
Luis Fernandez
11/01/2021, 7:46 PM
just bumping this, are there no plans to support pagination when group by?