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 2020/07/30 07:27:39 UTC

[GitHub] [incubator-pinot] Jackie-Jiang opened a new issue #5771: Improve performance for DISTINCT queries

Jackie-Jiang opened a new issue #5771:
URL: https://github.com/apache/incubator-pinot/issues/5771


   Optimizations to consider:
   - Early-termination for DISTINCT without order-by (need to model DISTINCT as a new operator instead of aggregation function)
   - Store dictIds inner segment to reduce the unnecessary dictionary reads


----------------------------------------------------------------
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 #5771: Improve performance for DISTINCT queries

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


   - Use dictionary to solve query without filter
   - Specialize DISTINCT on single column (store Object instead of Object[] in the set)


----------------------------------------------------------------
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 #5771: Improve performance for DISTINCT queries

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


   @kishoreg Not yet


----------------------------------------------------------------
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] kishoreg commented on issue #5771: Improve performance for DISTINCT queries

Posted by GitBox <gi...@apache.org>.
kishoreg commented on issue #5771:
URL: https://github.com/apache/incubator-pinot/issues/5771#issuecomment-673888182


   This is done right?


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