Hey Team, We’re currently observing an inconsistency with the formatting of DOUBLE values in the results of simple aggregation queries using Apache Pinot version 1.0. Details: Use Case: Running a simple aggregation query (e.g., SELECT SUM(metric) FROM table). Data Type: The metric column is of type DOUBLE. Query Type: Single-stage Observation: For the same underlying value (e.g., SUM(metric) = 1.0), the result sometimes appears as 1.000000 and other times as 1.00000000000000. Note: The issue is intermittent and seems to happen randomly, without a consistent pattern. We’re trying to understand whether: This is an expected behavior? It relates to the default float/double precision settings? There’s a recommended way to consistently format or round the DOUBLE results in responses?

That release is two years old, can you reproduce with the latest release?

any known bug you aware of? related to this

Not that I am aware of