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
Mark Needham
12/05/2022, 1:39 PM
I’m not sure if I understand properly - do you want to write a query that groups by multiple fields? You can do that
Mark Needham
12/05/2022, 1:39 PM
but I dunno how you’d group by the combinations in the same query