MrNeocore opened a new issue #7043: URL: https://github.com/apache/incubator-pinot/issues/7043
Following Slack discussion : https://apache-pinot.slack.com/archives/C011C9JHN7R/p1623346401028100 **Data** date | 01 | 02 | 03 entity1 | 1 | 2 | 3 entity2 | 3 | 4 | 5 **Goal** Aggregate data in "2 dimensions", first per entity (say, AVG), then per date (say, SUM) This use case appears to be solvable using generic nested queries or an improvement to the existing post-aggregation feature. **Nested query example** (not currently possible) `SELECT SUM(agg_value) FROM (SELECT dateString, AVG(value) as agg_value FROM table GROUP BY dateString)` @Jackie-Jiang @mayankshriv: Feel free to edit the title & content -- 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: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
