Hi team, does Pinot support group by top n query? ...
# general
a
Hi team, does Pinot support group by top n query? Example query, query a,b,c from table group by f1,f2,f3. How can I get max n rows for each combination of f1 and f2?
m
I’m not sure if I understand properly - do you want to write a query that groups by multiple fields? You can do that
but I dunno how you’d group by the combinations in the same query
can you do that in postgres/mysql?