fx19880617 commented 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>) ``` ---------------------------------------------------------------- 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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
