Hello 👋 Does anyone have feedback on Pinot performance when retrieving a large mount of rows? like a 1-year data for a given statistic for +5000 users ! (day granularity or hourly at the worst case) Does Pinot have a decent performance there and the mains problems can only come from the network?

It depends.. I did not believe on benchmarks published. You may like test it yourself. It is easy to setup and generate load test. Curious about your use case. Is it user facing analytics?

Yes, it's customer facing

This is from my proof of concept (I know, these stats are useless for you) I got ‘14807383’ records in my table.

"select histogram(value, 0, 200, 100) as histogram from metric"

it also depending on how wide the columns are and what date types you would the results to contain. could you share more on your use case?