[GitHub] [incubator-pinot] Jackie-Jiang commented on pull request #5661: Optimize selection order-by when not all selected expressions are ordered

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

Jackie-Jiang commented on pull request #5661:
URL: https://github.com/apache/incubator-pinot/pull/5661#issuecomment-655842051


   @pradeepgv42 We need to scan 2 columns, one is the order-by column (unavoidable for ordering purpose), the other is the virtual docId column (no actual scan as everything is in memory and fast).
   This is the best we can do for now. In order to solve this query, each server needs to scan ~450M records.


----------------------------------------------------------------
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:
users@infra.apache.org



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