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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
