[GitHub] [pinot] gortiz commented on issue #8837: `order by DESC limit N` queries are not optimised at segment level

[GitBox <gi...@apache.org>]

gortiz commented on issue #8837:
URL: https://github.com/apache/pinot/issues/8837#issuecomment-1163143093

   I think we need to invest some time optimizing sorted by, as there are too many cases where the optimizations can be applied but they are not. One example:
   
   ```
   SELECT *
   FROM table
   WHERE filter
   ORDER BY sorted_col ASC, any_other_thing
   LIMIT 10;
   ```
   
   Where `any_other_thing` may be a column, an operation or even a literal!


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org