Hi team,
We want to paginate over a table but the ...
# generalm
Mourad DLIA
03/24/2022, 5:27 PMHi team,
We want to paginate over a table but the offset keep changing due to new coming events. Is there a way to ignore new events during pagination?
r
Rong R
03/24/2022, 5:29 PMyou have to do so by adding in a reasonable timecolumn filter E.g. something like`WHERE timeColumn <= NOW() - 10s`
Rong R
03/24/2022, 5:30 PMthe -10s is to avoid late arrival kafka messages affect the result coming back. also you could ask questions in #C011C9JHN7R channel, which will expose to more developers.
m
Mourad DLIA
03/24/2022, 5:56 PMOk thanks for you response.
r
Rong R
03/24/2022, 6:10 PMFYI Also noted that if you issue multiple queries against Pinot it doesnt guarantee the result set is in the same order. You will also have to issue an order by Clause (I assumed you are already doing so but just in case you weren't)