[GitHub] [pinot] Jackie-Jiang commented on issue #10986: Count discrepancy among `in`/`=` and `<` queries using timestamp index

["Jackie-Jiang (via GitHub)" <gi...@apache.org>]

Jackie-Jiang commented on issue #10986:
URL: https://github.com/apache/pinot/issues/10986#issuecomment-1632957010

   @shwin As @richardstartin suggested, can you try using BETWEEN with same value and compare the result with EQ? Something like `where blockTimestamp_day between fromDateTime('2021-05-11', 'yyyy-MM-dd') and fromDateTime('2021-05-11', 'yyyy-MM-dd')`?
   You may also query `$segmentName`, `$docId` to find the record location, and see if `where blockTimestamp_day >= fromDateTime('2021-05-11', 'yyyy-MM-dd') and $segmentName = <matchingSegment> and $docId = <matchingDocId>` returns the record


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