Hi Is there a way to get min, max, sum as Long typ...
# troubleshooting
a
Hi Is there a way to get min, max, sum as Long type? I am querying min and max values for Timestamp (Long) column in a table and the results are in Double
Copy code
select min("Timestamp"), max("Timestamp") from test
Looking at the source code min, max and sum only return Double
r
this is a limitation of aggregation in pinot, but there's an issue to change it
we also found recently that there would be a performance improvement from changing it to preserve
long
values
a
makes sense, found the issue https://github.com/apache/pinot/issues/7888 is there a way to upvote for this feature?
👍 1