[GitHub] [pinot] richardstartin opened a new issue #8410: Optimise filtered count queries when an inverted index is present

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

richardstartin opened a new issue #8410:
URL: https://github.com/apache/pinot/issues/8410


   ```sql
   select count(*) from table where invertedIndexCol = 'foo'
   ```
   
   can be computed by counting the bits in the bitmap for 'foo'
   
   ```sql
   select count(*) from table where invertedIndexCol != 'foo'
   ```
   
   can be computed by counting the bits in the bitmap for 'foo' and subtracting it from the segment total count
   
   ```sql
   select count(*) from table where invertedIndexCol in ['foo', 'bar']
   ```
   
   can be computed by counting the bits in the union of the bitmaps 'foo' and 'bar'
   
   ```sql
   select count(*) from table where invertedIndexCol = 'foo' and anotherInvertedIndexCol = 'bar'
   ```
   
   can be computed by computing the cardinality of the intersection between bitmaps 'foo' of the first inverted index and 'bar' of the second one.


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

[GitHub] [pinot] richardstartin closed issue #8410: Optimise filtered count queries when an inverted index is present

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

richardstartin closed issue #8410:
URL: https://github.com/apache/pinot/issues/8410


   


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