yashmayya opened a new issue, #14486: URL: https://github.com/apache/pinot/issues/14486
- This issue was detected by a failing generated query test in https://github.com/apache/pinot/actions/runs/11855532843/job/33039942428?pr=14466 - ``` Error: org.apache.pinot.integration.tests.MultiStageEngineIntegrationTest.testGeneratedQueries -- Time elapsed: 0.285 s <<< FAILURE! java.lang.AssertionError: Caught exception while testing query! Pinot query: SELECT COUNT("DaysSinceEpoch") FROM mytable WHERE "DestCityMarketID" = 30918 OR "Origin" BETWEEN 'ALB' AND 'LMT' OR "DayofMonth" <> 2 H2 query: SELECT COUNT(`DaysSinceEpoch`) FROM mytable WHERE `DestCityMarketID` = 30918 OR `Origin` BETWEEN 'ALB' AND 'LMT' OR `DayofMonth` <> 2 ... Caused by: java.lang.RuntimeException: Value: 0 does not match, expected: 113798, got broker value: 112378, got client value:112378, explain plan: ... ``` - This issue is reproducible with both the single-stage and multi-stage query engine using the query - `SELECT COUNT(*) FROM mytable WHERE Origin BETWEEN 'ALB' AND 'LMT' OR DayofMonth <> 2`. The test passes if we disable the range index on column `Origin`, or if we update the method `canProduceBitmaps` to return `false` in either `RangeIndexBasedFilterOperator` or `SortedIndexBasedFilterOperator` (so as to not use `FastFilteredCountOperator`). - The issue was isolated to the `FastFilteredCountOperator` because out of the 11 segments created in the integration test, 1 doesn't have a sorted index on `DayofMonth` and this is the only segment for which the correct count value was being computed (`FastFilteredCountOperator` can't be used with `ScanBasedFilterOperator`). -- 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.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
