[GitHub] [incubator-pinot] fx19880617 edited a comment on issue #6292: Support limiting sub-groups to top N

[GitBox <gi...@apache.org>]

fx19880617 edited a comment on issue #6292:
URL: https://github.com/apache/incubator-pinot/issues/6292#issuecomment-734026302


   > @fx19880617 - good question re output format. With Elasticsearch it's a nested JSON response. I don't know what the standard is for Pinot, the above seems reasonable. You get additional details in the Elastic response for things like maximum error (due to how the top results from each shard get combined, and that could result in not actually getting the top N), etc.
   
   I see.
   
   The output of `subBuckets(sum(billed_expenses), state, 10)` can be a map(JSON blob) if we need more info or stats per group.
   
   Also not sure if this is the case, but maybe we can just define the order by clause in the function and have syntactic sugar for TOP_N queries.
   ```
   subBuckets(<aggregation operation>, <sub-bucket column>, <order-by operation>, <max_values>)
   ``` 
   
   One example could be that I want to show metrics for 10 same states ordered alphabetically in each gender.
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org