harshinielath opened a new issue #5246: Pagination support for groupBy queries
URL: https://github.com/apache/incubator-pinot/issues/5246
 
 
   Right now, pagination only works with selection queries with order by
   
   SELECT foo, bar FROM myTable
     WHERE baz > 20
     ORDER BY bar DESC
     LIMIT 50, 100
    Paginate the selection results from the ‘a’ th results and return at most 
‘b’ results.
   
   The below query doesn't paginate the results
   
   SELECT count(*), foo, bar FROM myTable
     WHERE baz > 20
    GROUP BY foo
     ORDER BY bar DESC
     LIMIT 50, 100
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to