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

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 using the broker query api, and also got the wrong results. Screenshots from the pinot UI and rest api tool are attached. Thank you very much!

Hmm this seems unexpected. Is the data type double? If so can you try > 0.0? cc : @Jackie

@Mayank thank you for your quick reply, yes the data type is double and the results are the same with

0.0

Does the issue exist in the official release as well? Can you file a GH issue?

I didn’t test it in the official release… Sure, I can file an issue.

Thanks @saurabh dubey is looking at it

@Ethan Huang Could you share your schema and tableConfig? I was unable to reproduce this with sample table and schema configs. Maybe you have some indexes on the columns I might need to look at

@Ethan Huang ^^