huang1st opened a new issue, #9305: URL: https://github.com/apache/pinot/issues/9305
Hi, pinot team, when I ran a query with condition `value > 0` but got results with `value = 0` Is this an issue or should I make some special configuration to avoid this? The query is: ```sql select clock, value from application_metrics where metric = 'successCount' and statistic='duration' and value > 0 limit 10 ``` clock is a time column with TIMESTAMP type and value is a metric column with DOUBLE type, the others are dimension columns. The pinot version is 0.11.0-SNAPSHOT and built form source with last commit hash `561e471a86278e0e486cd9e602f8499fc8f8517c` I also ran this query with the broker query api, and also got the wrong results. Screenshots from the pinot UI and rest api tool are attached.   -- 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]
