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-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org