You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2021/05/25 08:36:51 UTC

[GitHub] [incubator-pinot] syed72 opened a new issue #6970: Increase the latency of a query which has TIME as sorted column when ORDER BY TIME DESC is applied

syed72 opened a new issue #6970:
URL: https://github.com/apache/incubator-pinot/issues/6970


   Hi,
   There is usecase, where need to Increase the latency of a query which has ATIME as sorted column in a pinot table when ORDER BY ATIME DESC  limit 100 is applied.
   
   I've a select query which has ORDER BY ATIME ASC limit 100 is applied , then the the time taken for query is barely 15ms, (total rows - 450M, segments- 290, numOfDocsScanned - 318), where as for ORDER BY ATIME DESC limit 100 is taking around (timetaken -200ms, numDocsScanned - 5744955), which is very high, as it is reading whole segment.
   
   Please provide a support reading the segment from bottom in this case, which can reduce the timetaken and numOfDocsScanned...
   
   Thanks
   Akram Syed


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

[GitHub] [incubator-pinot] Jackie-Jiang edited a comment on issue #6970: Increase the latency of a query which has TIME as sorted column when ORDER BY TIME DESC is applied

Posted by GitBox <gi...@apache.org>.
Jackie-Jiang edited a comment on issue #6970:
URL: https://github.com/apache/incubator-pinot/issues/6970#issuecomment-848985817


   Thanks for reporting the issue. We should optimize the selection order-by operator to only scan the required docs when the first order by column is sorted


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

[GitHub] [incubator-pinot] Jackie-Jiang commented on issue #6970: Increase the latency of a query which has TIME as sorted column when ORDER BY TIME DESC is applied

Posted by GitBox <gi...@apache.org>.
Jackie-Jiang commented on issue #6970:
URL: https://github.com/apache/incubator-pinot/issues/6970#issuecomment-848985817


   We should optimize the selection order-by operator to only scan the required docs when the first order by column is sorted


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